5: -- Public Variables declared here
6:
7: G_Base_Currency_Code AP_SYSTEM_PARAMETERS.Base_Currency_Code%TYPE;
8:
9: G_Pay_Pmt_History_ID AP_PAYMENT_HISTORY.Payment_History_ID%TYPE;
10: G_Pmt_To_Base_XRate_Type AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Type%TYPE;
11: G_Pmt_To_Base_XRate_Date AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Date%TYPE;
12: G_Pmt_To_Base_XRate AP_PAYMENT_HISTORY.Pmt_To_Base_XRate%TYPE;
13:
6:
7: G_Base_Currency_Code AP_SYSTEM_PARAMETERS.Base_Currency_Code%TYPE;
8:
9: G_Pay_Pmt_History_ID AP_PAYMENT_HISTORY.Payment_History_ID%TYPE;
10: G_Pmt_To_Base_XRate_Type AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Type%TYPE;
11: G_Pmt_To_Base_XRate_Date AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Date%TYPE;
12: G_Pmt_To_Base_XRate AP_PAYMENT_HISTORY.Pmt_To_Base_XRate%TYPE;
13:
14: G_Mat_Pmt_History_ID AP_PAYMENT_HISTORY.Payment_History_ID%TYPE;
7: G_Base_Currency_Code AP_SYSTEM_PARAMETERS.Base_Currency_Code%TYPE;
8:
9: G_Pay_Pmt_History_ID AP_PAYMENT_HISTORY.Payment_History_ID%TYPE;
10: G_Pmt_To_Base_XRate_Type AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Type%TYPE;
11: G_Pmt_To_Base_XRate_Date AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Date%TYPE;
12: G_Pmt_To_Base_XRate AP_PAYMENT_HISTORY.Pmt_To_Base_XRate%TYPE;
13:
14: G_Mat_Pmt_History_ID AP_PAYMENT_HISTORY.Payment_History_ID%TYPE;
15: G_Mat_To_Base_XRate_Type AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Type%TYPE;
8:
9: G_Pay_Pmt_History_ID AP_PAYMENT_HISTORY.Payment_History_ID%TYPE;
10: G_Pmt_To_Base_XRate_Type AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Type%TYPE;
11: G_Pmt_To_Base_XRate_Date AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Date%TYPE;
12: G_Pmt_To_Base_XRate AP_PAYMENT_HISTORY.Pmt_To_Base_XRate%TYPE;
13:
14: G_Mat_Pmt_History_ID AP_PAYMENT_HISTORY.Payment_History_ID%TYPE;
15: G_Mat_To_Base_XRate_Type AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Type%TYPE;
16: G_Mat_To_Base_XRate_Date AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Date%TYPE;
10: G_Pmt_To_Base_XRate_Type AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Type%TYPE;
11: G_Pmt_To_Base_XRate_Date AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Date%TYPE;
12: G_Pmt_To_Base_XRate AP_PAYMENT_HISTORY.Pmt_To_Base_XRate%TYPE;
13:
14: G_Mat_Pmt_History_ID AP_PAYMENT_HISTORY.Payment_History_ID%TYPE;
15: G_Mat_To_Base_XRate_Type AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Type%TYPE;
16: G_Mat_To_Base_XRate_Date AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Date%TYPE;
17: G_Mat_To_Base_XRate AP_PAYMENT_HISTORY.Pmt_To_Base_XRate%TYPE;
18:
11: G_Pmt_To_Base_XRate_Date AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Date%TYPE;
12: G_Pmt_To_Base_XRate AP_PAYMENT_HISTORY.Pmt_To_Base_XRate%TYPE;
13:
14: G_Mat_Pmt_History_ID AP_PAYMENT_HISTORY.Payment_History_ID%TYPE;
15: G_Mat_To_Base_XRate_Type AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Type%TYPE;
16: G_Mat_To_Base_XRate_Date AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Date%TYPE;
17: G_Mat_To_Base_XRate AP_PAYMENT_HISTORY.Pmt_To_Base_XRate%TYPE;
18:
19: G_Clr_Pmt_History_ID AP_PAYMENT_HISTORY.Payment_History_ID%TYPE;
12: G_Pmt_To_Base_XRate AP_PAYMENT_HISTORY.Pmt_To_Base_XRate%TYPE;
13:
14: G_Mat_Pmt_History_ID AP_PAYMENT_HISTORY.Payment_History_ID%TYPE;
15: G_Mat_To_Base_XRate_Type AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Type%TYPE;
16: G_Mat_To_Base_XRate_Date AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Date%TYPE;
17: G_Mat_To_Base_XRate AP_PAYMENT_HISTORY.Pmt_To_Base_XRate%TYPE;
18:
19: G_Clr_Pmt_History_ID AP_PAYMENT_HISTORY.Payment_History_ID%TYPE;
20: G_Clr_To_Base_XRate_Type AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Type%TYPE;
13:
14: G_Mat_Pmt_History_ID AP_PAYMENT_HISTORY.Payment_History_ID%TYPE;
15: G_Mat_To_Base_XRate_Type AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Type%TYPE;
16: G_Mat_To_Base_XRate_Date AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Date%TYPE;
17: G_Mat_To_Base_XRate AP_PAYMENT_HISTORY.Pmt_To_Base_XRate%TYPE;
18:
19: G_Clr_Pmt_History_ID AP_PAYMENT_HISTORY.Payment_History_ID%TYPE;
20: G_Clr_To_Base_XRate_Type AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Type%TYPE;
21: G_Clr_To_Base_XRate_Date AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Date%TYPE;
15: G_Mat_To_Base_XRate_Type AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Type%TYPE;
16: G_Mat_To_Base_XRate_Date AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Date%TYPE;
17: G_Mat_To_Base_XRate AP_PAYMENT_HISTORY.Pmt_To_Base_XRate%TYPE;
18:
19: G_Clr_Pmt_History_ID AP_PAYMENT_HISTORY.Payment_History_ID%TYPE;
20: G_Clr_To_Base_XRate_Type AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Type%TYPE;
21: G_Clr_To_Base_XRate_Date AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Date%TYPE;
22: G_Clr_To_Base_XRate AP_PAYMENT_HISTORY.Pmt_To_Base_XRate%TYPE;
23:
16: G_Mat_To_Base_XRate_Date AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Date%TYPE;
17: G_Mat_To_Base_XRate AP_PAYMENT_HISTORY.Pmt_To_Base_XRate%TYPE;
18:
19: G_Clr_Pmt_History_ID AP_PAYMENT_HISTORY.Payment_History_ID%TYPE;
20: G_Clr_To_Base_XRate_Type AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Type%TYPE;
21: G_Clr_To_Base_XRate_Date AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Date%TYPE;
22: G_Clr_To_Base_XRate AP_PAYMENT_HISTORY.Pmt_To_Base_XRate%TYPE;
23:
24: /* added for Bug10183934 */
17: G_Mat_To_Base_XRate AP_PAYMENT_HISTORY.Pmt_To_Base_XRate%TYPE;
18:
19: G_Clr_Pmt_History_ID AP_PAYMENT_HISTORY.Payment_History_ID%TYPE;
20: G_Clr_To_Base_XRate_Type AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Type%TYPE;
21: G_Clr_To_Base_XRate_Date AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Date%TYPE;
22: G_Clr_To_Base_XRate AP_PAYMENT_HISTORY.Pmt_To_Base_XRate%TYPE;
23:
24: /* added for Bug10183934 */
25: G_TOTAL_PAY CONSTANT VARCHAR2(15) := 'TOTAL_PAY';
18:
19: G_Clr_Pmt_History_ID AP_PAYMENT_HISTORY.Payment_History_ID%TYPE;
20: G_Clr_To_Base_XRate_Type AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Type%TYPE;
21: G_Clr_To_Base_XRate_Date AP_PAYMENT_HISTORY.Pmt_To_Base_XRate_Date%TYPE;
22: G_Clr_To_Base_XRate AP_PAYMENT_HISTORY.Pmt_To_Base_XRate%TYPE;
23:
24: /* added for Bug10183934 */
25: G_TOTAL_PAY CONSTANT VARCHAR2(15) := 'TOTAL_PAY';
26: G_TOTAL_APPL CONSTANT VARCHAR2(15) := 'TOTAL_APPL';
47:
48:
49: -- Record for cursor payment_history
50: TYPE r_pay_hist_info IS RECORD
51: (Payment_History_ID AP_Payment_History.Payment_History_ID%TYPE
52: ,Accounting_Date AP_Payment_History.Accounting_Date%TYPE --bug9271242
53: ,Pmt_Currency_Code AP_Payment_History.Pmt_Currency_Code%TYPE
54: ,Pmt_To_Base_XRate_Type AP_Payment_History.Pmt_To_Base_XRate_Type%TYPE
55: ,Pmt_To_Base_XRate_Date AP_Payment_History.Pmt_To_Base_XRate_Date%TYPE
48:
49: -- Record for cursor payment_history
50: TYPE r_pay_hist_info IS RECORD
51: (Payment_History_ID AP_Payment_History.Payment_History_ID%TYPE
52: ,Accounting_Date AP_Payment_History.Accounting_Date%TYPE --bug9271242
53: ,Pmt_Currency_Code AP_Payment_History.Pmt_Currency_Code%TYPE
54: ,Pmt_To_Base_XRate_Type AP_Payment_History.Pmt_To_Base_XRate_Type%TYPE
55: ,Pmt_To_Base_XRate_Date AP_Payment_History.Pmt_To_Base_XRate_Date%TYPE
56: ,Pmt_To_Base_XRate AP_Payment_History.Pmt_To_Base_XRate%TYPE
49: -- Record for cursor payment_history
50: TYPE r_pay_hist_info IS RECORD
51: (Payment_History_ID AP_Payment_History.Payment_History_ID%TYPE
52: ,Accounting_Date AP_Payment_History.Accounting_Date%TYPE --bug9271242
53: ,Pmt_Currency_Code AP_Payment_History.Pmt_Currency_Code%TYPE
54: ,Pmt_To_Base_XRate_Type AP_Payment_History.Pmt_To_Base_XRate_Type%TYPE
55: ,Pmt_To_Base_XRate_Date AP_Payment_History.Pmt_To_Base_XRate_Date%TYPE
56: ,Pmt_To_Base_XRate AP_Payment_History.Pmt_To_Base_XRate%TYPE
57: ,Bank_Currency_Code AP_Payment_History.Bank_Currency_Code%TYPE
50: TYPE r_pay_hist_info IS RECORD
51: (Payment_History_ID AP_Payment_History.Payment_History_ID%TYPE
52: ,Accounting_Date AP_Payment_History.Accounting_Date%TYPE --bug9271242
53: ,Pmt_Currency_Code AP_Payment_History.Pmt_Currency_Code%TYPE
54: ,Pmt_To_Base_XRate_Type AP_Payment_History.Pmt_To_Base_XRate_Type%TYPE
55: ,Pmt_To_Base_XRate_Date AP_Payment_History.Pmt_To_Base_XRate_Date%TYPE
56: ,Pmt_To_Base_XRate AP_Payment_History.Pmt_To_Base_XRate%TYPE
57: ,Bank_Currency_Code AP_Payment_History.Bank_Currency_Code%TYPE
58: ,Bank_To_Base_XRate_Type AP_Payment_History.Bank_To_Base_XRate_Type%TYPE
51: (Payment_History_ID AP_Payment_History.Payment_History_ID%TYPE
52: ,Accounting_Date AP_Payment_History.Accounting_Date%TYPE --bug9271242
53: ,Pmt_Currency_Code AP_Payment_History.Pmt_Currency_Code%TYPE
54: ,Pmt_To_Base_XRate_Type AP_Payment_History.Pmt_To_Base_XRate_Type%TYPE
55: ,Pmt_To_Base_XRate_Date AP_Payment_History.Pmt_To_Base_XRate_Date%TYPE
56: ,Pmt_To_Base_XRate AP_Payment_History.Pmt_To_Base_XRate%TYPE
57: ,Bank_Currency_Code AP_Payment_History.Bank_Currency_Code%TYPE
58: ,Bank_To_Base_XRate_Type AP_Payment_History.Bank_To_Base_XRate_Type%TYPE
59: ,Bank_To_Base_XRate_Date AP_Payment_History.Bank_To_Base_XRate_Date%TYPE
52: ,Accounting_Date AP_Payment_History.Accounting_Date%TYPE --bug9271242
53: ,Pmt_Currency_Code AP_Payment_History.Pmt_Currency_Code%TYPE
54: ,Pmt_To_Base_XRate_Type AP_Payment_History.Pmt_To_Base_XRate_Type%TYPE
55: ,Pmt_To_Base_XRate_Date AP_Payment_History.Pmt_To_Base_XRate_Date%TYPE
56: ,Pmt_To_Base_XRate AP_Payment_History.Pmt_To_Base_XRate%TYPE
57: ,Bank_Currency_Code AP_Payment_History.Bank_Currency_Code%TYPE
58: ,Bank_To_Base_XRate_Type AP_Payment_History.Bank_To_Base_XRate_Type%TYPE
59: ,Bank_To_Base_XRate_Date AP_Payment_History.Bank_To_Base_XRate_Date%TYPE
60: ,Bank_To_Base_XRate AP_Payment_History.Bank_To_Base_XRate%TYPE
53: ,Pmt_Currency_Code AP_Payment_History.Pmt_Currency_Code%TYPE
54: ,Pmt_To_Base_XRate_Type AP_Payment_History.Pmt_To_Base_XRate_Type%TYPE
55: ,Pmt_To_Base_XRate_Date AP_Payment_History.Pmt_To_Base_XRate_Date%TYPE
56: ,Pmt_To_Base_XRate AP_Payment_History.Pmt_To_Base_XRate%TYPE
57: ,Bank_Currency_Code AP_Payment_History.Bank_Currency_Code%TYPE
58: ,Bank_To_Base_XRate_Type AP_Payment_History.Bank_To_Base_XRate_Type%TYPE
59: ,Bank_To_Base_XRate_Date AP_Payment_History.Bank_To_Base_XRate_Date%TYPE
60: ,Bank_To_Base_XRate AP_Payment_History.Bank_To_Base_XRate%TYPE
61: ,Errors_Bank_Amount AP_Payment_History.Errors_Bank_Amount%TYPE
54: ,Pmt_To_Base_XRate_Type AP_Payment_History.Pmt_To_Base_XRate_Type%TYPE
55: ,Pmt_To_Base_XRate_Date AP_Payment_History.Pmt_To_Base_XRate_Date%TYPE
56: ,Pmt_To_Base_XRate AP_Payment_History.Pmt_To_Base_XRate%TYPE
57: ,Bank_Currency_Code AP_Payment_History.Bank_Currency_Code%TYPE
58: ,Bank_To_Base_XRate_Type AP_Payment_History.Bank_To_Base_XRate_Type%TYPE
59: ,Bank_To_Base_XRate_Date AP_Payment_History.Bank_To_Base_XRate_Date%TYPE
60: ,Bank_To_Base_XRate AP_Payment_History.Bank_To_Base_XRate%TYPE
61: ,Errors_Bank_Amount AP_Payment_History.Errors_Bank_Amount%TYPE
62: ,Charges_Bank_Amount AP_Payment_History.Charges_Bank_Amount%TYPE
55: ,Pmt_To_Base_XRate_Date AP_Payment_History.Pmt_To_Base_XRate_Date%TYPE
56: ,Pmt_To_Base_XRate AP_Payment_History.Pmt_To_Base_XRate%TYPE
57: ,Bank_Currency_Code AP_Payment_History.Bank_Currency_Code%TYPE
58: ,Bank_To_Base_XRate_Type AP_Payment_History.Bank_To_Base_XRate_Type%TYPE
59: ,Bank_To_Base_XRate_Date AP_Payment_History.Bank_To_Base_XRate_Date%TYPE
60: ,Bank_To_Base_XRate AP_Payment_History.Bank_To_Base_XRate%TYPE
61: ,Errors_Bank_Amount AP_Payment_History.Errors_Bank_Amount%TYPE
62: ,Charges_Bank_Amount AP_Payment_History.Charges_Bank_Amount%TYPE
63: ,Rev_Pmt_Hist_ID AP_Payment_History.Rev_Pmt_Hist_ID%TYPE
56: ,Pmt_To_Base_XRate AP_Payment_History.Pmt_To_Base_XRate%TYPE
57: ,Bank_Currency_Code AP_Payment_History.Bank_Currency_Code%TYPE
58: ,Bank_To_Base_XRate_Type AP_Payment_History.Bank_To_Base_XRate_Type%TYPE
59: ,Bank_To_Base_XRate_Date AP_Payment_History.Bank_To_Base_XRate_Date%TYPE
60: ,Bank_To_Base_XRate AP_Payment_History.Bank_To_Base_XRate%TYPE
61: ,Errors_Bank_Amount AP_Payment_History.Errors_Bank_Amount%TYPE
62: ,Charges_Bank_Amount AP_Payment_History.Charges_Bank_Amount%TYPE
63: ,Rev_Pmt_Hist_ID AP_Payment_History.Rev_Pmt_Hist_ID%TYPE
64: ,Related_Event_ID AP_Payment_History.Related_Event_ID%TYPE
57: ,Bank_Currency_Code AP_Payment_History.Bank_Currency_Code%TYPE
58: ,Bank_To_Base_XRate_Type AP_Payment_History.Bank_To_Base_XRate_Type%TYPE
59: ,Bank_To_Base_XRate_Date AP_Payment_History.Bank_To_Base_XRate_Date%TYPE
60: ,Bank_To_Base_XRate AP_Payment_History.Bank_To_Base_XRate%TYPE
61: ,Errors_Bank_Amount AP_Payment_History.Errors_Bank_Amount%TYPE
62: ,Charges_Bank_Amount AP_Payment_History.Charges_Bank_Amount%TYPE
63: ,Rev_Pmt_Hist_ID AP_Payment_History.Rev_Pmt_Hist_ID%TYPE
64: ,Related_Event_ID AP_Payment_History.Related_Event_ID%TYPE
65: ,Invoice_Adjustment_Event_ID AP_Payment_History.Invoice_Adjustment_Event_ID%TYPE
58: ,Bank_To_Base_XRate_Type AP_Payment_History.Bank_To_Base_XRate_Type%TYPE
59: ,Bank_To_Base_XRate_Date AP_Payment_History.Bank_To_Base_XRate_Date%TYPE
60: ,Bank_To_Base_XRate AP_Payment_History.Bank_To_Base_XRate%TYPE
61: ,Errors_Bank_Amount AP_Payment_History.Errors_Bank_Amount%TYPE
62: ,Charges_Bank_Amount AP_Payment_History.Charges_Bank_Amount%TYPE
63: ,Rev_Pmt_Hist_ID AP_Payment_History.Rev_Pmt_Hist_ID%TYPE
64: ,Related_Event_ID AP_Payment_History.Related_Event_ID%TYPE
65: ,Invoice_Adjustment_Event_ID AP_Payment_History.Invoice_Adjustment_Event_ID%TYPE
66: );
59: ,Bank_To_Base_XRate_Date AP_Payment_History.Bank_To_Base_XRate_Date%TYPE
60: ,Bank_To_Base_XRate AP_Payment_History.Bank_To_Base_XRate%TYPE
61: ,Errors_Bank_Amount AP_Payment_History.Errors_Bank_Amount%TYPE
62: ,Charges_Bank_Amount AP_Payment_History.Charges_Bank_Amount%TYPE
63: ,Rev_Pmt_Hist_ID AP_Payment_History.Rev_Pmt_Hist_ID%TYPE
64: ,Related_Event_ID AP_Payment_History.Related_Event_ID%TYPE
65: ,Invoice_Adjustment_Event_ID AP_Payment_History.Invoice_Adjustment_Event_ID%TYPE
66: );
67:
60: ,Bank_To_Base_XRate AP_Payment_History.Bank_To_Base_XRate%TYPE
61: ,Errors_Bank_Amount AP_Payment_History.Errors_Bank_Amount%TYPE
62: ,Charges_Bank_Amount AP_Payment_History.Charges_Bank_Amount%TYPE
63: ,Rev_Pmt_Hist_ID AP_Payment_History.Rev_Pmt_Hist_ID%TYPE
64: ,Related_Event_ID AP_Payment_History.Related_Event_ID%TYPE
65: ,Invoice_Adjustment_Event_ID AP_Payment_History.Invoice_Adjustment_Event_ID%TYPE
66: );
67:
68:
61: ,Errors_Bank_Amount AP_Payment_History.Errors_Bank_Amount%TYPE
62: ,Charges_Bank_Amount AP_Payment_History.Charges_Bank_Amount%TYPE
63: ,Rev_Pmt_Hist_ID AP_Payment_History.Rev_Pmt_Hist_ID%TYPE
64: ,Related_Event_ID AP_Payment_History.Related_Event_ID%TYPE
65: ,Invoice_Adjustment_Event_ID AP_Payment_History.Invoice_Adjustment_Event_ID%TYPE
66: );
67:
68:
69: -- Record for cursor invoice_header