DBA Data[Home] [Help]

APPS.PAAPIMP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 187: G_Assets_Addition_flag ap_invoice_distributions.Assets_Addition_Flag%TYPE;

183: G_EXPENDITURE_ENDING_DATE pa_transaction_interface.expenditure_ending_date%TYPE;
184: G_PER_BUS_GRP_ID pa_transaction_interface.person_business_group_id%TYPE;
185:
186: /* Added for performance improvement*/
187: G_Assets_Addition_flag ap_invoice_distributions.Assets_Addition_Flag%TYPE;
188:
189: /* Added to create pl/sql table columns in the same cursor*/
190: l_pay_cc_id pa_transaction_interface.dr_code_combination_id%TYPE;
191: l_quantity pa_transaction_interface.quantity%TYPE;

Line 357: p_invoice_distribution_id IN ap_invoice_distributions.invoice_distribution_id %TYPE)

353:
354: /* Populate Transaction Interface Phase --------------------------*/
355: FUNCTION Create_New_Org_Transref ( p_batch_name IN pa_transaction_interface.batch_name%TYPE,
356: p_invoice_id IN ap_invoices.invoice_id%TYPE,
357: p_invoice_distribution_id IN ap_invoice_distributions.invoice_distribution_id %TYPE)
358: RETURN pa_transaction_interface.orig_transaction_reference%TYPE;
359:
360: PRAGMA RESTRICT_REFERENCES(create_new_org_transref, WNDS);
361:

Line 478: PROCEDURE lock_rcv_txn (p_po_distribution_id IN ap_invoice_distributions.po_distribution_id%TYPE);

474: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
475: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
476:
477:
478: PROCEDURE lock_rcv_txn (p_po_distribution_id IN ap_invoice_distributions.po_distribution_id%TYPE);
479:
480: PROCEDURE tieback_locked_rcvtxn;
481:
482: /*=====================================*/

Line 727: PROCEDURE lock_ap_invoice (p_po_distribution_id IN ap_invoice_distributions.po_distribution_id%TYPE);

723: PROCEDURE check_failed_receipts (
724: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
725: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
726:
727: PROCEDURE lock_ap_invoice (p_po_distribution_id IN ap_invoice_distributions.po_distribution_id%TYPE);
728:
729: PROCEDURE tieback_locked_invoice;
730:
731: /*==========================================================*/

Line 930: Ap_Invoice_Distributions DIST,

926: FROM AP_Invoice_Payments Pay,
927: ap_payment_hist_dists Paydist,
928: PO_Vendors VEND,
929: AP_Invoices INV,
930: Ap_Invoice_Distributions DIST,
931: PA_EXPENDITURE_TYPES TYPE,
932: ap_checks chk
933: WHERE DIST.Invoice_Id = INV.Invoice_Id
934: AND Pay.Invoice_Payment_Id = Paydist.Invoice_payment_id

Line 1027: AP_INVOICE_DISTRIBUTIONS DIST1,

1023: ,DIST2.PRepay_distribution_id PRepay_distribution_id
1024: FROM PO_Vendors VEND,
1025: AP_Invoices INV,
1026: AP_Prepay_APP_Dists PDIST,
1027: AP_INVOICE_DISTRIBUTIONS DIST1,
1028: AP_INVOICE_DISTRIBUTIONS DIST2,
1029: -- changed from view to table to process the rec tax part of prorated prepay appl for bug#5514129
1030: --PA_Transfer_AP_Invoices_View DIST1,
1031: -- PA_Transfer_AP_Invoices_View DIST2,

Line 1028: AP_INVOICE_DISTRIBUTIONS DIST2,

1024: FROM PO_Vendors VEND,
1025: AP_Invoices INV,
1026: AP_Prepay_APP_Dists PDIST,
1027: AP_INVOICE_DISTRIBUTIONS DIST1,
1028: AP_INVOICE_DISTRIBUTIONS DIST2,
1029: -- changed from view to table to process the rec tax part of prorated prepay appl for bug#5514129
1030: --PA_Transfer_AP_Invoices_View DIST1,
1031: -- PA_Transfer_AP_Invoices_View DIST2,
1032: PA_EXPENDITURE_TYPES TYPE