ARP_PROCESS_RCTS.post_query_logic
-- Created on 2013-8-2 by ADMINISTRATOR
declare
-- Local variables here
i integer;
v_cash_receipt_id number := 110152;
x_std_reversal_possible varchar2(30);
x_apps_exist_flag varchar2(30);
x_rec_moved_state_flag varchar2(30);
x_amount_applied number;
x_amount_unapplied number;
x_write_off_amount number;
x_cc_refund_amount number;
x_cc_chargeback_amount number;
x_chargeback_amount number;
x_amount_on_account number;
x_amount_in_claim number;
x_prepayment_amount number;
x_amount_unidentified number;
x_discounts_earned number;
x_discounts_unearned number;
x_tot_exchanged_gain_loss number;
-- x_tot_exchanged_gain_loss varchar2(30);
x_line_number varchar2(30);
x_statement_date date;
x_reference_id_dsp varchar2(30);
x_cross_curr_apps_flag varchar2(30);
x_reversal_gl_date date;
x_debit_memo varchar2(30);
x_debit_memo_ccid number;
x_debit_memo_type varchar2(30);
x_debit_memo_number varchar2(30);
x_debit_memo_doc_number varchar2(30);
x_confirm_date date;
x_confirm_gl_date date;
x_statement_number varchar2(30);
begin
-- Test statements here
mo_global.init('AR');
mo_global.set_policy_context('S',4555);
ARP_PROCESS_RCTS.post_query_logic(
p_cr_id => v_cash_receipt_id,
p_receipt_type => null,
p_reference_type => null,
p_reference_id => null,
p_std_reversal_possible => x_std_reversal_possible,
p_apps_exist_flag => x_apps_exist_flag,
p_rec_moved_state_flag => x_rec_moved_state_flag,
p_amount_applied => x_amount_applied,
p_amount_unapplied => x_amount_unapplied,
p_write_off_amount => x_write_off_amount,
p_cc_refund_amount => x_cc_refund_amount,
p_cc_chargeback_amount => x_cc_chargeback_amount,
p_chargeback_amount => x_chargeback_amount,
p_amount_on_account => x_amount_on_account,
p_amount_in_claim => x_amount_in_claim,
p_prepayment_amount => x_prepayment_amount,
p_amount_unidentified => x_amount_unidentified,
p_discounts_earned => x_discounts_earned,
p_discounts_unearned => x_discounts_unearned,
p_tot_exchange_gain_loss => x_tot_exchanged_gain_loss,
p_statement_number => x_statement_number,
p_line_number => x_line_number,
p_statement_date => x_statement_date,
p_reference_id_dsp => x_reference_id_dsp,
p_cross_curr_apps_flag => x_cross_curr_apps_flag,
p_reversal_date => null,
p_reversal_gl_date => x_reversal_gl_date,
p_debit_memo => x_debit_memo,
p_debit_memo_ccid => x_debit_memo_ccid,
p_debit_memo_type => x_debit_memo_type,
p_debit_memo_number => x_debit_memo_number,
p_debit_memo_doc_number => x_debit_memo_doc_number,
p_confirm_date => x_confirm_date,
p_confirm_gl_date => x_confirm_gl_date
);
dbms_output.put_line('x_std_reversal_possible:'||x_std_reversal_possible);
dbms_output.put_line('x_apps_exist_flag:'||x_apps_exist_flag);
dbms_output.put_line('x_rec_moved_state_flag:'||x_rec_moved_state_flag);
dbms_output.put_line('x_amount_applied:'||x_amount_applied);
dbms_output.put_line('x_amount_unapplied:'||x_amount_unapplied);
dbms_output.put_line('x_write_off_amount:'||x_write_off_amount);
dbms_output.put_line('x_cc_refund_amount:'||x_cc_refund_amount);
dbms_output.put_line('x_cc_chargeback_amount:'||x_cc_chargeback_amount);
dbms_output.put_line('x_chargeback_amount:'||x_chargeback_amount);
dbms_output.put_line('x_amount_on_account:'||x_amount_on_account);
dbms_output.put_line('x_amount_in_claim:'||x_amount_in_claim);
dbms_output.put_line('x_prepayment_amount:'||x_prepayment_amount);
dbms_output.put_line('x_amount_unidentified:'||x_amount_unidentified);
dbms_output.put_line('x_discounts_earned:'||x_discounts_earned);
dbms_output.put_line('x_discounts_unearned:'||x_discounts_unearned);
dbms_output.put_line('x_tot_exchanged_gain_loss:'||x_tot_exchanged_gain_loss);
dbms_output.put_line('x_statement_number:'||x_statement_number);
dbms_output.put_line('x_line_number:'||x_line_number);
dbms_output.put_line('x_statement_date:'||x_statement_date);
dbms_output.put_line('x_reference_id_dsp:'||x_reference_id_dsp);
dbms_output.put_line('x_cross_curr_apps_flag:'||x_cross_curr_apps_flag);
dbms_output.put_line('x_reversal_gl_date:'||x_reversal_gl_date);
dbms_output.put_line('x_debit_memo:'||x_debit_memo);
dbms_output.put_line('x_debit_memo_ccid:'||x_debit_memo_ccid);
dbms_output.put_line('x_debit_memo_type:'||x_debit_memo_type);
dbms_output.put_line('x_debit_memo_number:'||x_debit_memo_number);
dbms_output.put_line('x_debit_memo_doc_number:'||x_debit_memo_doc_number);
dbms_output.put_line('x_confirm_date:'||x_confirm_date);
dbms_output.put_line('x_confirm_gl_date:'||x_confirm_gl_date);
end;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13387766/viewspace-767699/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13387766/viewspace-767699/