67:
68:
69: -- Record for cursor invoice_header
70: TYPE r_invoices_info IS RECORD
71: (Invoice_ID AP_Invoices.Invoice_ID%TYPE
72: ,GL_Date AP_Invoices.GL_Date%TYPE --bug9271242
73: ,Invoice_Amount AP_Invoices.Invoice_Amount%TYPE
74: ,Invoice_Currency_Code AP_Invoices.Invoice_Currency_Code%TYPE
75: ,Payment_Currency_Code AP_Invoices.Payment_Currency_Code%TYPE
68:
69: -- Record for cursor invoice_header
70: TYPE r_invoices_info IS RECORD
71: (Invoice_ID AP_Invoices.Invoice_ID%TYPE
72: ,GL_Date AP_Invoices.GL_Date%TYPE --bug9271242
73: ,Invoice_Amount AP_Invoices.Invoice_Amount%TYPE
74: ,Invoice_Currency_Code AP_Invoices.Invoice_Currency_Code%TYPE
75: ,Payment_Currency_Code AP_Invoices.Payment_Currency_Code%TYPE
76: ,Base_Currency_Code AP_System_Parameters.Base_Currency_Code%TYPE
69: -- Record for cursor invoice_header
70: TYPE r_invoices_info IS RECORD
71: (Invoice_ID AP_Invoices.Invoice_ID%TYPE
72: ,GL_Date AP_Invoices.GL_Date%TYPE --bug9271242
73: ,Invoice_Amount AP_Invoices.Invoice_Amount%TYPE
74: ,Invoice_Currency_Code AP_Invoices.Invoice_Currency_Code%TYPE
75: ,Payment_Currency_Code AP_Invoices.Payment_Currency_Code%TYPE
76: ,Base_Currency_Code AP_System_Parameters.Base_Currency_Code%TYPE
77: ,Pay_Curr_Invoice_Amount AP_Invoices.Pay_Curr_Invoice_Amount%TYPE
70: TYPE r_invoices_info IS RECORD
71: (Invoice_ID AP_Invoices.Invoice_ID%TYPE
72: ,GL_Date AP_Invoices.GL_Date%TYPE --bug9271242
73: ,Invoice_Amount AP_Invoices.Invoice_Amount%TYPE
74: ,Invoice_Currency_Code AP_Invoices.Invoice_Currency_Code%TYPE
75: ,Payment_Currency_Code AP_Invoices.Payment_Currency_Code%TYPE
76: ,Base_Currency_Code AP_System_Parameters.Base_Currency_Code%TYPE
77: ,Pay_Curr_Invoice_Amount AP_Invoices.Pay_Curr_Invoice_Amount%TYPE
78: ,Payment_Cross_Rate_Type AP_Invoices.Payment_Cross_Rate_Type%TYPE
71: (Invoice_ID AP_Invoices.Invoice_ID%TYPE
72: ,GL_Date AP_Invoices.GL_Date%TYPE --bug9271242
73: ,Invoice_Amount AP_Invoices.Invoice_Amount%TYPE
74: ,Invoice_Currency_Code AP_Invoices.Invoice_Currency_Code%TYPE
75: ,Payment_Currency_Code AP_Invoices.Payment_Currency_Code%TYPE
76: ,Base_Currency_Code AP_System_Parameters.Base_Currency_Code%TYPE
77: ,Pay_Curr_Invoice_Amount AP_Invoices.Pay_Curr_Invoice_Amount%TYPE
78: ,Payment_Cross_Rate_Type AP_Invoices.Payment_Cross_Rate_Type%TYPE
79: ,Payment_Cross_Rate_Date AP_Invoices.Payment_Cross_Rate_Date%TYPE
73: ,Invoice_Amount AP_Invoices.Invoice_Amount%TYPE
74: ,Invoice_Currency_Code AP_Invoices.Invoice_Currency_Code%TYPE
75: ,Payment_Currency_Code AP_Invoices.Payment_Currency_Code%TYPE
76: ,Base_Currency_Code AP_System_Parameters.Base_Currency_Code%TYPE
77: ,Pay_Curr_Invoice_Amount AP_Invoices.Pay_Curr_Invoice_Amount%TYPE
78: ,Payment_Cross_Rate_Type AP_Invoices.Payment_Cross_Rate_Type%TYPE
79: ,Payment_Cross_Rate_Date AP_Invoices.Payment_Cross_Rate_Date%TYPE
80: ,Payment_Cross_Rate AP_Invoices.Payment_Cross_Rate%TYPE
81: ,Exchange_Rate_Type AP_Invoices.Exchange_Rate_Type%TYPE
74: ,Invoice_Currency_Code AP_Invoices.Invoice_Currency_Code%TYPE
75: ,Payment_Currency_Code AP_Invoices.Payment_Currency_Code%TYPE
76: ,Base_Currency_Code AP_System_Parameters.Base_Currency_Code%TYPE
77: ,Pay_Curr_Invoice_Amount AP_Invoices.Pay_Curr_Invoice_Amount%TYPE
78: ,Payment_Cross_Rate_Type AP_Invoices.Payment_Cross_Rate_Type%TYPE
79: ,Payment_Cross_Rate_Date AP_Invoices.Payment_Cross_Rate_Date%TYPE
80: ,Payment_Cross_Rate AP_Invoices.Payment_Cross_Rate%TYPE
81: ,Exchange_Rate_Type AP_Invoices.Exchange_Rate_Type%TYPE
82: ,Exchange_Date AP_Invoices.Exchange_Date%TYPE
75: ,Payment_Currency_Code AP_Invoices.Payment_Currency_Code%TYPE
76: ,Base_Currency_Code AP_System_Parameters.Base_Currency_Code%TYPE
77: ,Pay_Curr_Invoice_Amount AP_Invoices.Pay_Curr_Invoice_Amount%TYPE
78: ,Payment_Cross_Rate_Type AP_Invoices.Payment_Cross_Rate_Type%TYPE
79: ,Payment_Cross_Rate_Date AP_Invoices.Payment_Cross_Rate_Date%TYPE
80: ,Payment_Cross_Rate AP_Invoices.Payment_Cross_Rate%TYPE
81: ,Exchange_Rate_Type AP_Invoices.Exchange_Rate_Type%TYPE
82: ,Exchange_Date AP_Invoices.Exchange_Date%TYPE
83: ,Exchange_Rate AP_Invoices.Exchange_Rate%TYPE
76: ,Base_Currency_Code AP_System_Parameters.Base_Currency_Code%TYPE
77: ,Pay_Curr_Invoice_Amount AP_Invoices.Pay_Curr_Invoice_Amount%TYPE
78: ,Payment_Cross_Rate_Type AP_Invoices.Payment_Cross_Rate_Type%TYPE
79: ,Payment_Cross_Rate_Date AP_Invoices.Payment_Cross_Rate_Date%TYPE
80: ,Payment_Cross_Rate AP_Invoices.Payment_Cross_Rate%TYPE
81: ,Exchange_Rate_Type AP_Invoices.Exchange_Rate_Type%TYPE
82: ,Exchange_Date AP_Invoices.Exchange_Date%TYPE
83: ,Exchange_Rate AP_Invoices.Exchange_Rate%TYPE
84: ,Disc_Is_Inv_Less_Tax_Flag AP_Invoices.Disc_Is_Inv_Less_Tax_Flag%TYPE
77: ,Pay_Curr_Invoice_Amount AP_Invoices.Pay_Curr_Invoice_Amount%TYPE
78: ,Payment_Cross_Rate_Type AP_Invoices.Payment_Cross_Rate_Type%TYPE
79: ,Payment_Cross_Rate_Date AP_Invoices.Payment_Cross_Rate_Date%TYPE
80: ,Payment_Cross_Rate AP_Invoices.Payment_Cross_Rate%TYPE
81: ,Exchange_Rate_Type AP_Invoices.Exchange_Rate_Type%TYPE
82: ,Exchange_Date AP_Invoices.Exchange_Date%TYPE
83: ,Exchange_Rate AP_Invoices.Exchange_Rate%TYPE
84: ,Disc_Is_Inv_Less_Tax_Flag AP_Invoices.Disc_Is_Inv_Less_Tax_Flag%TYPE
85: ,Exclude_Freight_From_Discount AP_Invoices.Exclude_Freight_From_Discount%TYPE
78: ,Payment_Cross_Rate_Type AP_Invoices.Payment_Cross_Rate_Type%TYPE
79: ,Payment_Cross_Rate_Date AP_Invoices.Payment_Cross_Rate_Date%TYPE
80: ,Payment_Cross_Rate AP_Invoices.Payment_Cross_Rate%TYPE
81: ,Exchange_Rate_Type AP_Invoices.Exchange_Rate_Type%TYPE
82: ,Exchange_Date AP_Invoices.Exchange_Date%TYPE
83: ,Exchange_Rate AP_Invoices.Exchange_Rate%TYPE
84: ,Disc_Is_Inv_Less_Tax_Flag AP_Invoices.Disc_Is_Inv_Less_Tax_Flag%TYPE
85: ,Exclude_Freight_From_Discount AP_Invoices.Exclude_Freight_From_Discount%TYPE
86: );
79: ,Payment_Cross_Rate_Date AP_Invoices.Payment_Cross_Rate_Date%TYPE
80: ,Payment_Cross_Rate AP_Invoices.Payment_Cross_Rate%TYPE
81: ,Exchange_Rate_Type AP_Invoices.Exchange_Rate_Type%TYPE
82: ,Exchange_Date AP_Invoices.Exchange_Date%TYPE
83: ,Exchange_Rate AP_Invoices.Exchange_Rate%TYPE
84: ,Disc_Is_Inv_Less_Tax_Flag AP_Invoices.Disc_Is_Inv_Less_Tax_Flag%TYPE
85: ,Exclude_Freight_From_Discount AP_Invoices.Exclude_Freight_From_Discount%TYPE
86: );
87:
80: ,Payment_Cross_Rate AP_Invoices.Payment_Cross_Rate%TYPE
81: ,Exchange_Rate_Type AP_Invoices.Exchange_Rate_Type%TYPE
82: ,Exchange_Date AP_Invoices.Exchange_Date%TYPE
83: ,Exchange_Rate AP_Invoices.Exchange_Rate%TYPE
84: ,Disc_Is_Inv_Less_Tax_Flag AP_Invoices.Disc_Is_Inv_Less_Tax_Flag%TYPE
85: ,Exclude_Freight_From_Discount AP_Invoices.Exclude_Freight_From_Discount%TYPE
86: );
87:
88:
81: ,Exchange_Rate_Type AP_Invoices.Exchange_Rate_Type%TYPE
82: ,Exchange_Date AP_Invoices.Exchange_Date%TYPE
83: ,Exchange_Rate AP_Invoices.Exchange_Rate%TYPE
84: ,Disc_Is_Inv_Less_Tax_Flag AP_Invoices.Disc_Is_Inv_Less_Tax_Flag%TYPE
85: ,Exclude_Freight_From_Discount AP_Invoices.Exclude_Freight_From_Discount%TYPE
86: );
87:
88:
89: -- Record for cursor invoice_dists