APPS.AP_ACCOUNTING_PAY_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 91: (Invoice_Distribution_ID AP_Invoice_Distributions.Invoice_Distribution_ID%TYPE

87:
88:
89: -- Record for cursor invoice_dists
90: TYPE r_inv_dist_info IS RECORD
91: (Invoice_Distribution_ID AP_Invoice_Distributions.Invoice_Distribution_ID%TYPE
92: ,Line_Type_Lookup_Code AP_Invoice_Distributions.Line_Type_Lookup_Code%TYPE
93: ,Amount AP_Invoice_Distributions.Amount%TYPE
94: ,Base_Amount AP_Invoice_Distributions.Base_Amount%TYPE
95: ,PO_Distribution_ID AP_Invoice_Distributions.PO_Distribution_ID%TYPE

Line 92: ,Line_Type_Lookup_Code AP_Invoice_Distributions.Line_Type_Lookup_Code%TYPE

88:
89: -- Record for cursor invoice_dists
90: TYPE r_inv_dist_info IS RECORD
91: (Invoice_Distribution_ID AP_Invoice_Distributions.Invoice_Distribution_ID%TYPE
92: ,Line_Type_Lookup_Code AP_Invoice_Distributions.Line_Type_Lookup_Code%TYPE
93: ,Amount AP_Invoice_Distributions.Amount%TYPE
94: ,Base_Amount AP_Invoice_Distributions.Base_Amount%TYPE
95: ,PO_Distribution_ID AP_Invoice_Distributions.PO_Distribution_ID%TYPE
96: ,RCV_Transaction_ID AP_Invoice_Distributions.RCV_Transaction_ID%TYPE

Line 93: ,Amount AP_Invoice_Distributions.Amount%TYPE

89: -- Record for cursor invoice_dists
90: TYPE r_inv_dist_info IS RECORD
91: (Invoice_Distribution_ID AP_Invoice_Distributions.Invoice_Distribution_ID%TYPE
92: ,Line_Type_Lookup_Code AP_Invoice_Distributions.Line_Type_Lookup_Code%TYPE
93: ,Amount AP_Invoice_Distributions.Amount%TYPE
94: ,Base_Amount AP_Invoice_Distributions.Base_Amount%TYPE
95: ,PO_Distribution_ID AP_Invoice_Distributions.PO_Distribution_ID%TYPE
96: ,RCV_Transaction_ID AP_Invoice_Distributions.RCV_Transaction_ID%TYPE
97: ,Reversal_Flag AP_Invoice_Distributions.Reversal_Flag%TYPE

Line 94: ,Base_Amount AP_Invoice_Distributions.Base_Amount%TYPE

90: TYPE r_inv_dist_info IS RECORD
91: (Invoice_Distribution_ID AP_Invoice_Distributions.Invoice_Distribution_ID%TYPE
92: ,Line_Type_Lookup_Code AP_Invoice_Distributions.Line_Type_Lookup_Code%TYPE
93: ,Amount AP_Invoice_Distributions.Amount%TYPE
94: ,Base_Amount AP_Invoice_Distributions.Base_Amount%TYPE
95: ,PO_Distribution_ID AP_Invoice_Distributions.PO_Distribution_ID%TYPE
96: ,RCV_Transaction_ID AP_Invoice_Distributions.RCV_Transaction_ID%TYPE
97: ,Reversal_Flag AP_Invoice_Distributions.Reversal_Flag%TYPE
98: ,Parent_Reversal_ID AP_Invoice_Distributions.Parent_Reversal_ID%TYPE

Line 95: ,PO_Distribution_ID AP_Invoice_Distributions.PO_Distribution_ID%TYPE

91: (Invoice_Distribution_ID AP_Invoice_Distributions.Invoice_Distribution_ID%TYPE
92: ,Line_Type_Lookup_Code AP_Invoice_Distributions.Line_Type_Lookup_Code%TYPE
93: ,Amount AP_Invoice_Distributions.Amount%TYPE
94: ,Base_Amount AP_Invoice_Distributions.Base_Amount%TYPE
95: ,PO_Distribution_ID AP_Invoice_Distributions.PO_Distribution_ID%TYPE
96: ,RCV_Transaction_ID AP_Invoice_Distributions.RCV_Transaction_ID%TYPE
97: ,Reversal_Flag AP_Invoice_Distributions.Reversal_Flag%TYPE
98: ,Parent_Reversal_ID AP_Invoice_Distributions.Parent_Reversal_ID%TYPE
99: ,AWT_Related_ID AP_Invoice_Distributions.AWT_Related_ID%TYPE

Line 96: ,RCV_Transaction_ID AP_Invoice_Distributions.RCV_Transaction_ID%TYPE

92: ,Line_Type_Lookup_Code AP_Invoice_Distributions.Line_Type_Lookup_Code%TYPE
93: ,Amount AP_Invoice_Distributions.Amount%TYPE
94: ,Base_Amount AP_Invoice_Distributions.Base_Amount%TYPE
95: ,PO_Distribution_ID AP_Invoice_Distributions.PO_Distribution_ID%TYPE
96: ,RCV_Transaction_ID AP_Invoice_Distributions.RCV_Transaction_ID%TYPE
97: ,Reversal_Flag AP_Invoice_Distributions.Reversal_Flag%TYPE
98: ,Parent_Reversal_ID AP_Invoice_Distributions.Parent_Reversal_ID%TYPE
99: ,AWT_Related_ID AP_Invoice_Distributions.AWT_Related_ID%TYPE
100: ,AWT_Invoice_Payment_ID AP_Invoice_Distributions.AWT_Invoice_Payment_ID%TYPE

Line 97: ,Reversal_Flag AP_Invoice_Distributions.Reversal_Flag%TYPE

93: ,Amount AP_Invoice_Distributions.Amount%TYPE
94: ,Base_Amount AP_Invoice_Distributions.Base_Amount%TYPE
95: ,PO_Distribution_ID AP_Invoice_Distributions.PO_Distribution_ID%TYPE
96: ,RCV_Transaction_ID AP_Invoice_Distributions.RCV_Transaction_ID%TYPE
97: ,Reversal_Flag AP_Invoice_Distributions.Reversal_Flag%TYPE
98: ,Parent_Reversal_ID AP_Invoice_Distributions.Parent_Reversal_ID%TYPE
99: ,AWT_Related_ID AP_Invoice_Distributions.AWT_Related_ID%TYPE
100: ,AWT_Invoice_Payment_ID AP_Invoice_Distributions.AWT_Invoice_Payment_ID%TYPE
101: ,Quantity_Variance AP_Invoice_Distributions.Quantity_Variance%TYPE

Line 98: ,Parent_Reversal_ID AP_Invoice_Distributions.Parent_Reversal_ID%TYPE

94: ,Base_Amount AP_Invoice_Distributions.Base_Amount%TYPE
95: ,PO_Distribution_ID AP_Invoice_Distributions.PO_Distribution_ID%TYPE
96: ,RCV_Transaction_ID AP_Invoice_Distributions.RCV_Transaction_ID%TYPE
97: ,Reversal_Flag AP_Invoice_Distributions.Reversal_Flag%TYPE
98: ,Parent_Reversal_ID AP_Invoice_Distributions.Parent_Reversal_ID%TYPE
99: ,AWT_Related_ID AP_Invoice_Distributions.AWT_Related_ID%TYPE
100: ,AWT_Invoice_Payment_ID AP_Invoice_Distributions.AWT_Invoice_Payment_ID%TYPE
101: ,Quantity_Variance AP_Invoice_Distributions.Quantity_Variance%TYPE
102: ,Base_Quantity_Variance AP_Invoice_Distributions.Base_Quantity_Variance%TYPE

Line 99: ,AWT_Related_ID AP_Invoice_Distributions.AWT_Related_ID%TYPE

95: ,PO_Distribution_ID AP_Invoice_Distributions.PO_Distribution_ID%TYPE
96: ,RCV_Transaction_ID AP_Invoice_Distributions.RCV_Transaction_ID%TYPE
97: ,Reversal_Flag AP_Invoice_Distributions.Reversal_Flag%TYPE
98: ,Parent_Reversal_ID AP_Invoice_Distributions.Parent_Reversal_ID%TYPE
99: ,AWT_Related_ID AP_Invoice_Distributions.AWT_Related_ID%TYPE
100: ,AWT_Invoice_Payment_ID AP_Invoice_Distributions.AWT_Invoice_Payment_ID%TYPE
101: ,Quantity_Variance AP_Invoice_Distributions.Quantity_Variance%TYPE
102: ,Base_Quantity_Variance AP_Invoice_Distributions.Base_Quantity_Variance%TYPE
103: ,Amount_Variance AP_Invoice_Distributions.Amount_Variance%TYPE

Line 100: ,AWT_Invoice_Payment_ID AP_Invoice_Distributions.AWT_Invoice_Payment_ID%TYPE

96: ,RCV_Transaction_ID AP_Invoice_Distributions.RCV_Transaction_ID%TYPE
97: ,Reversal_Flag AP_Invoice_Distributions.Reversal_Flag%TYPE
98: ,Parent_Reversal_ID AP_Invoice_Distributions.Parent_Reversal_ID%TYPE
99: ,AWT_Related_ID AP_Invoice_Distributions.AWT_Related_ID%TYPE
100: ,AWT_Invoice_Payment_ID AP_Invoice_Distributions.AWT_Invoice_Payment_ID%TYPE
101: ,Quantity_Variance AP_Invoice_Distributions.Quantity_Variance%TYPE
102: ,Base_Quantity_Variance AP_Invoice_Distributions.Base_Quantity_Variance%TYPE
103: ,Amount_Variance AP_Invoice_Distributions.Amount_Variance%TYPE
104: ,Base_Amount_Variance AP_Invoice_Distributions.Base_Amount_Variance%TYPE

Line 101: ,Quantity_Variance AP_Invoice_Distributions.Quantity_Variance%TYPE

97: ,Reversal_Flag AP_Invoice_Distributions.Reversal_Flag%TYPE
98: ,Parent_Reversal_ID AP_Invoice_Distributions.Parent_Reversal_ID%TYPE
99: ,AWT_Related_ID AP_Invoice_Distributions.AWT_Related_ID%TYPE
100: ,AWT_Invoice_Payment_ID AP_Invoice_Distributions.AWT_Invoice_Payment_ID%TYPE
101: ,Quantity_Variance AP_Invoice_Distributions.Quantity_Variance%TYPE
102: ,Base_Quantity_Variance AP_Invoice_Distributions.Base_Quantity_Variance%TYPE
103: ,Amount_Variance AP_Invoice_Distributions.Amount_Variance%TYPE
104: ,Base_Amount_Variance AP_Invoice_Distributions.Base_Amount_Variance%TYPE
105: ,Historical_Flag AP_Invoice_Distributions.Historical_Flag%TYPE

Line 102: ,Base_Quantity_Variance AP_Invoice_Distributions.Base_Quantity_Variance%TYPE

98: ,Parent_Reversal_ID AP_Invoice_Distributions.Parent_Reversal_ID%TYPE
99: ,AWT_Related_ID AP_Invoice_Distributions.AWT_Related_ID%TYPE
100: ,AWT_Invoice_Payment_ID AP_Invoice_Distributions.AWT_Invoice_Payment_ID%TYPE
101: ,Quantity_Variance AP_Invoice_Distributions.Quantity_Variance%TYPE
102: ,Base_Quantity_Variance AP_Invoice_Distributions.Base_Quantity_Variance%TYPE
103: ,Amount_Variance AP_Invoice_Distributions.Amount_Variance%TYPE
104: ,Base_Amount_Variance AP_Invoice_Distributions.Base_Amount_Variance%TYPE
105: ,Historical_Flag AP_Invoice_Distributions.Historical_Flag%TYPE
106: ,Accounting_Event_Id AP_Invoice_Distributions.Accounting_Event_id%TYPE

Line 103: ,Amount_Variance AP_Invoice_Distributions.Amount_Variance%TYPE

99: ,AWT_Related_ID AP_Invoice_Distributions.AWT_Related_ID%TYPE
100: ,AWT_Invoice_Payment_ID AP_Invoice_Distributions.AWT_Invoice_Payment_ID%TYPE
101: ,Quantity_Variance AP_Invoice_Distributions.Quantity_Variance%TYPE
102: ,Base_Quantity_Variance AP_Invoice_Distributions.Base_Quantity_Variance%TYPE
103: ,Amount_Variance AP_Invoice_Distributions.Amount_Variance%TYPE
104: ,Base_Amount_Variance AP_Invoice_Distributions.Base_Amount_Variance%TYPE
105: ,Historical_Flag AP_Invoice_Distributions.Historical_Flag%TYPE
106: ,Accounting_Event_Id AP_Invoice_Distributions.Accounting_Event_id%TYPE
107: );

Line 104: ,Base_Amount_Variance AP_Invoice_Distributions.Base_Amount_Variance%TYPE

100: ,AWT_Invoice_Payment_ID AP_Invoice_Distributions.AWT_Invoice_Payment_ID%TYPE
101: ,Quantity_Variance AP_Invoice_Distributions.Quantity_Variance%TYPE
102: ,Base_Quantity_Variance AP_Invoice_Distributions.Base_Quantity_Variance%TYPE
103: ,Amount_Variance AP_Invoice_Distributions.Amount_Variance%TYPE
104: ,Base_Amount_Variance AP_Invoice_Distributions.Base_Amount_Variance%TYPE
105: ,Historical_Flag AP_Invoice_Distributions.Historical_Flag%TYPE
106: ,Accounting_Event_Id AP_Invoice_Distributions.Accounting_Event_id%TYPE
107: );
108:

Line 105: ,Historical_Flag AP_Invoice_Distributions.Historical_Flag%TYPE

101: ,Quantity_Variance AP_Invoice_Distributions.Quantity_Variance%TYPE
102: ,Base_Quantity_Variance AP_Invoice_Distributions.Base_Quantity_Variance%TYPE
103: ,Amount_Variance AP_Invoice_Distributions.Amount_Variance%TYPE
104: ,Base_Amount_Variance AP_Invoice_Distributions.Base_Amount_Variance%TYPE
105: ,Historical_Flag AP_Invoice_Distributions.Historical_Flag%TYPE
106: ,Accounting_Event_Id AP_Invoice_Distributions.Accounting_Event_id%TYPE
107: );
108:
109: -- Main procedure to create payment hist dists and prepay appl payment dists

Line 106: ,Accounting_Event_Id AP_Invoice_Distributions.Accounting_Event_id%TYPE

102: ,Base_Quantity_Variance AP_Invoice_Distributions.Base_Quantity_Variance%TYPE
103: ,Amount_Variance AP_Invoice_Distributions.Amount_Variance%TYPE
104: ,Base_Amount_Variance AP_Invoice_Distributions.Base_Amount_Variance%TYPE
105: ,Historical_Flag AP_Invoice_Distributions.Historical_Flag%TYPE
106: ,Accounting_Event_Id AP_Invoice_Distributions.Accounting_Event_id%TYPE
107: );
108:
109: -- Main procedure to create payment hist dists and prepay appl payment dists
110: PROCEDURE Do_Pay_Accounting

Line 252: ,P_Prepay_App_Dist_Id IN AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE

248: --bug 9108925
249: FUNCTION Is_Final_Event
250: (P_Inv_Rec IN r_invoices_info
251: ,P_XLA_Event_Rec IN r_xla_event_info
252: ,P_Prepay_App_Dist_Id IN AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE
253: ,P_Calling_Sequence IN VARCHAR2
254: ) RETURN BOOLEAN;
255:
256: END AP_ACCOUNTING_PAY_PKG;