DBA Data[Home] [Help]

APPS.PAAPIMP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 185: G_Assets_Addition_flag ap_invoice_distributions.Assets_Addition_Flag%TYPE;

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

Line 353: p_invoice_distribution_id IN ap_invoice_distributions.invoice_distribution_id %TYPE)

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

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

469: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
470: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
471:
472:
473: PROCEDURE lock_rcv_txn (p_po_distribution_id IN ap_invoice_distributions.po_distribution_id%TYPE);
474:
475: PROCEDURE tieback_locked_rcvtxn;
476:
477: /*=====================================*/

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

716: PROCEDURE check_failed_receipts (
717: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
718: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
719:
720: PROCEDURE lock_ap_invoice (p_po_distribution_id IN ap_invoice_distributions.po_distribution_id%TYPE);
721:
722: PROCEDURE tieback_locked_invoice;
723:
724: /*==========================================================*/

Line 923: Ap_Invoice_Distributions DIST,

919: FROM AP_Invoice_Payments Pay,
920: ap_payment_hist_dists Paydist,
921: PO_Vendors VEND,
922: AP_Invoices INV,
923: Ap_Invoice_Distributions DIST,
924: PA_EXPENDITURE_TYPES TYPE,
925: ap_checks chk
926: WHERE DIST.Invoice_Id = INV.Invoice_Id
927: AND Pay.Invoice_Payment_Id = Paydist.Invoice_payment_id

Line 1020: AP_INVOICE_DISTRIBUTIONS DIST1,

1016: ,DIST2.PRepay_distribution_id PRepay_distribution_id
1017: FROM PO_Vendors VEND,
1018: AP_Invoices INV,
1019: AP_Prepay_APP_Dists PDIST,
1020: AP_INVOICE_DISTRIBUTIONS DIST1,
1021: AP_INVOICE_DISTRIBUTIONS DIST2,
1022: -- changed from view to table to process the rec tax part of prorated prepay appl for bug#5514129
1023: --PA_Transfer_AP_Invoices_View DIST1,
1024: -- PA_Transfer_AP_Invoices_View DIST2,

Line 1021: AP_INVOICE_DISTRIBUTIONS DIST2,

1017: FROM PO_Vendors VEND,
1018: AP_Invoices INV,
1019: AP_Prepay_APP_Dists PDIST,
1020: AP_INVOICE_DISTRIBUTIONS DIST1,
1021: AP_INVOICE_DISTRIBUTIONS DIST2,
1022: -- changed from view to table to process the rec tax part of prorated prepay appl for bug#5514129
1023: --PA_Transfer_AP_Invoices_View DIST1,
1024: -- PA_Transfer_AP_Invoices_View DIST2,
1025: PA_EXPENDITURE_TYPES TYPE