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:
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:
25: -- Record for cursor xla_events_cur
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:
25: -- Record for cursor xla_events_cur
26: TYPE r_xla_event_info IS RECORD
35:
36:
37: -- Record for cursor payment_history
38: TYPE r_pay_hist_info IS RECORD
39: (Payment_History_ID AP_Payment_History.Payment_History_ID%TYPE
40: ,Pmt_Currency_Code AP_Payment_History.Pmt_Currency_Code%TYPE
41: ,Pmt_To_Base_XRate_Type AP_Payment_History.Pmt_To_Base_XRate_Type%TYPE
42: ,Pmt_To_Base_XRate_Date AP_Payment_History.Pmt_To_Base_XRate_Date%TYPE
43: ,Pmt_To_Base_XRate AP_Payment_History.Pmt_To_Base_XRate%TYPE
36:
37: -- Record for cursor payment_history
38: TYPE r_pay_hist_info IS RECORD
39: (Payment_History_ID AP_Payment_History.Payment_History_ID%TYPE
40: ,Pmt_Currency_Code AP_Payment_History.Pmt_Currency_Code%TYPE
41: ,Pmt_To_Base_XRate_Type AP_Payment_History.Pmt_To_Base_XRate_Type%TYPE
42: ,Pmt_To_Base_XRate_Date AP_Payment_History.Pmt_To_Base_XRate_Date%TYPE
43: ,Pmt_To_Base_XRate AP_Payment_History.Pmt_To_Base_XRate%TYPE
44: ,Bank_Currency_Code AP_Payment_History.Bank_Currency_Code%TYPE
37: -- Record for cursor payment_history
38: TYPE r_pay_hist_info IS RECORD
39: (Payment_History_ID AP_Payment_History.Payment_History_ID%TYPE
40: ,Pmt_Currency_Code AP_Payment_History.Pmt_Currency_Code%TYPE
41: ,Pmt_To_Base_XRate_Type AP_Payment_History.Pmt_To_Base_XRate_Type%TYPE
42: ,Pmt_To_Base_XRate_Date AP_Payment_History.Pmt_To_Base_XRate_Date%TYPE
43: ,Pmt_To_Base_XRate AP_Payment_History.Pmt_To_Base_XRate%TYPE
44: ,Bank_Currency_Code AP_Payment_History.Bank_Currency_Code%TYPE
45: ,Bank_To_Base_XRate_Type AP_Payment_History.Bank_To_Base_XRate_Type%TYPE
38: TYPE r_pay_hist_info IS RECORD
39: (Payment_History_ID AP_Payment_History.Payment_History_ID%TYPE
40: ,Pmt_Currency_Code AP_Payment_History.Pmt_Currency_Code%TYPE
41: ,Pmt_To_Base_XRate_Type AP_Payment_History.Pmt_To_Base_XRate_Type%TYPE
42: ,Pmt_To_Base_XRate_Date AP_Payment_History.Pmt_To_Base_XRate_Date%TYPE
43: ,Pmt_To_Base_XRate AP_Payment_History.Pmt_To_Base_XRate%TYPE
44: ,Bank_Currency_Code AP_Payment_History.Bank_Currency_Code%TYPE
45: ,Bank_To_Base_XRate_Type AP_Payment_History.Bank_To_Base_XRate_Type%TYPE
46: ,Bank_To_Base_XRate_Date AP_Payment_History.Bank_To_Base_XRate_Date%TYPE
39: (Payment_History_ID AP_Payment_History.Payment_History_ID%TYPE
40: ,Pmt_Currency_Code AP_Payment_History.Pmt_Currency_Code%TYPE
41: ,Pmt_To_Base_XRate_Type AP_Payment_History.Pmt_To_Base_XRate_Type%TYPE
42: ,Pmt_To_Base_XRate_Date AP_Payment_History.Pmt_To_Base_XRate_Date%TYPE
43: ,Pmt_To_Base_XRate AP_Payment_History.Pmt_To_Base_XRate%TYPE
44: ,Bank_Currency_Code AP_Payment_History.Bank_Currency_Code%TYPE
45: ,Bank_To_Base_XRate_Type AP_Payment_History.Bank_To_Base_XRate_Type%TYPE
46: ,Bank_To_Base_XRate_Date AP_Payment_History.Bank_To_Base_XRate_Date%TYPE
47: ,Bank_To_Base_XRate AP_Payment_History.Bank_To_Base_XRate%TYPE
40: ,Pmt_Currency_Code AP_Payment_History.Pmt_Currency_Code%TYPE
41: ,Pmt_To_Base_XRate_Type AP_Payment_History.Pmt_To_Base_XRate_Type%TYPE
42: ,Pmt_To_Base_XRate_Date AP_Payment_History.Pmt_To_Base_XRate_Date%TYPE
43: ,Pmt_To_Base_XRate AP_Payment_History.Pmt_To_Base_XRate%TYPE
44: ,Bank_Currency_Code AP_Payment_History.Bank_Currency_Code%TYPE
45: ,Bank_To_Base_XRate_Type AP_Payment_History.Bank_To_Base_XRate_Type%TYPE
46: ,Bank_To_Base_XRate_Date AP_Payment_History.Bank_To_Base_XRate_Date%TYPE
47: ,Bank_To_Base_XRate AP_Payment_History.Bank_To_Base_XRate%TYPE
48: ,Errors_Bank_Amount AP_Payment_History.Errors_Bank_Amount%TYPE
41: ,Pmt_To_Base_XRate_Type AP_Payment_History.Pmt_To_Base_XRate_Type%TYPE
42: ,Pmt_To_Base_XRate_Date AP_Payment_History.Pmt_To_Base_XRate_Date%TYPE
43: ,Pmt_To_Base_XRate AP_Payment_History.Pmt_To_Base_XRate%TYPE
44: ,Bank_Currency_Code AP_Payment_History.Bank_Currency_Code%TYPE
45: ,Bank_To_Base_XRate_Type AP_Payment_History.Bank_To_Base_XRate_Type%TYPE
46: ,Bank_To_Base_XRate_Date AP_Payment_History.Bank_To_Base_XRate_Date%TYPE
47: ,Bank_To_Base_XRate AP_Payment_History.Bank_To_Base_XRate%TYPE
48: ,Errors_Bank_Amount AP_Payment_History.Errors_Bank_Amount%TYPE
49: ,Charges_Bank_Amount AP_Payment_History.Charges_Bank_Amount%TYPE
42: ,Pmt_To_Base_XRate_Date AP_Payment_History.Pmt_To_Base_XRate_Date%TYPE
43: ,Pmt_To_Base_XRate AP_Payment_History.Pmt_To_Base_XRate%TYPE
44: ,Bank_Currency_Code AP_Payment_History.Bank_Currency_Code%TYPE
45: ,Bank_To_Base_XRate_Type AP_Payment_History.Bank_To_Base_XRate_Type%TYPE
46: ,Bank_To_Base_XRate_Date AP_Payment_History.Bank_To_Base_XRate_Date%TYPE
47: ,Bank_To_Base_XRate AP_Payment_History.Bank_To_Base_XRate%TYPE
48: ,Errors_Bank_Amount AP_Payment_History.Errors_Bank_Amount%TYPE
49: ,Charges_Bank_Amount AP_Payment_History.Charges_Bank_Amount%TYPE
50: ,Rev_Pmt_Hist_ID AP_Payment_History.Rev_Pmt_Hist_ID%TYPE
43: ,Pmt_To_Base_XRate AP_Payment_History.Pmt_To_Base_XRate%TYPE
44: ,Bank_Currency_Code AP_Payment_History.Bank_Currency_Code%TYPE
45: ,Bank_To_Base_XRate_Type AP_Payment_History.Bank_To_Base_XRate_Type%TYPE
46: ,Bank_To_Base_XRate_Date AP_Payment_History.Bank_To_Base_XRate_Date%TYPE
47: ,Bank_To_Base_XRate AP_Payment_History.Bank_To_Base_XRate%TYPE
48: ,Errors_Bank_Amount AP_Payment_History.Errors_Bank_Amount%TYPE
49: ,Charges_Bank_Amount AP_Payment_History.Charges_Bank_Amount%TYPE
50: ,Rev_Pmt_Hist_ID AP_Payment_History.Rev_Pmt_Hist_ID%TYPE
51: ,Related_Event_ID AP_Payment_History.Related_Event_ID%TYPE
44: ,Bank_Currency_Code AP_Payment_History.Bank_Currency_Code%TYPE
45: ,Bank_To_Base_XRate_Type AP_Payment_History.Bank_To_Base_XRate_Type%TYPE
46: ,Bank_To_Base_XRate_Date AP_Payment_History.Bank_To_Base_XRate_Date%TYPE
47: ,Bank_To_Base_XRate AP_Payment_History.Bank_To_Base_XRate%TYPE
48: ,Errors_Bank_Amount AP_Payment_History.Errors_Bank_Amount%TYPE
49: ,Charges_Bank_Amount AP_Payment_History.Charges_Bank_Amount%TYPE
50: ,Rev_Pmt_Hist_ID AP_Payment_History.Rev_Pmt_Hist_ID%TYPE
51: ,Related_Event_ID AP_Payment_History.Related_Event_ID%TYPE
52: ,Invoice_Adjustment_Event_ID AP_Payment_History.Invoice_Adjustment_Event_ID%TYPE
45: ,Bank_To_Base_XRate_Type AP_Payment_History.Bank_To_Base_XRate_Type%TYPE
46: ,Bank_To_Base_XRate_Date AP_Payment_History.Bank_To_Base_XRate_Date%TYPE
47: ,Bank_To_Base_XRate AP_Payment_History.Bank_To_Base_XRate%TYPE
48: ,Errors_Bank_Amount AP_Payment_History.Errors_Bank_Amount%TYPE
49: ,Charges_Bank_Amount AP_Payment_History.Charges_Bank_Amount%TYPE
50: ,Rev_Pmt_Hist_ID AP_Payment_History.Rev_Pmt_Hist_ID%TYPE
51: ,Related_Event_ID AP_Payment_History.Related_Event_ID%TYPE
52: ,Invoice_Adjustment_Event_ID AP_Payment_History.Invoice_Adjustment_Event_ID%TYPE
53: );
46: ,Bank_To_Base_XRate_Date AP_Payment_History.Bank_To_Base_XRate_Date%TYPE
47: ,Bank_To_Base_XRate AP_Payment_History.Bank_To_Base_XRate%TYPE
48: ,Errors_Bank_Amount AP_Payment_History.Errors_Bank_Amount%TYPE
49: ,Charges_Bank_Amount AP_Payment_History.Charges_Bank_Amount%TYPE
50: ,Rev_Pmt_Hist_ID AP_Payment_History.Rev_Pmt_Hist_ID%TYPE
51: ,Related_Event_ID AP_Payment_History.Related_Event_ID%TYPE
52: ,Invoice_Adjustment_Event_ID AP_Payment_History.Invoice_Adjustment_Event_ID%TYPE
53: );
54:
47: ,Bank_To_Base_XRate AP_Payment_History.Bank_To_Base_XRate%TYPE
48: ,Errors_Bank_Amount AP_Payment_History.Errors_Bank_Amount%TYPE
49: ,Charges_Bank_Amount AP_Payment_History.Charges_Bank_Amount%TYPE
50: ,Rev_Pmt_Hist_ID AP_Payment_History.Rev_Pmt_Hist_ID%TYPE
51: ,Related_Event_ID AP_Payment_History.Related_Event_ID%TYPE
52: ,Invoice_Adjustment_Event_ID AP_Payment_History.Invoice_Adjustment_Event_ID%TYPE
53: );
54:
55:
48: ,Errors_Bank_Amount AP_Payment_History.Errors_Bank_Amount%TYPE
49: ,Charges_Bank_Amount AP_Payment_History.Charges_Bank_Amount%TYPE
50: ,Rev_Pmt_Hist_ID AP_Payment_History.Rev_Pmt_Hist_ID%TYPE
51: ,Related_Event_ID AP_Payment_History.Related_Event_ID%TYPE
52: ,Invoice_Adjustment_Event_ID AP_Payment_History.Invoice_Adjustment_Event_ID%TYPE
53: );
54:
55:
56: -- Record for cursor invoice_header