eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAAPIMP_PKG dependencies on AP_INVOICES

Line 28: p_invoice_source1 IN ap_invoices.source%TYPE DEFAULT NULL,

24: p_gl_date IN DATE,
25: p_transaction_date IN DATE,
26: p_debug_mode IN VARCHAR2,
27: p_output IN NUMBER,
28: p_invoice_source1 IN ap_invoices.source%TYPE DEFAULT NULL,
29: p_invoice_source2 IN ap_invoices.source%TYPE DEFAULT NULL,
30: p_invoice_source3 IN ap_invoices.source%TYPE DEFAULT NULL,
31: p_invoice_type IN ap_invoices.invoice_type_lookup_code%TYPE,
32: p_system_linkage IN pa_transaction_interface.system_linkage%TYPE,

Line 29: p_invoice_source2 IN ap_invoices.source%TYPE DEFAULT NULL,

25: p_transaction_date IN DATE,
26: p_debug_mode IN VARCHAR2,
27: p_output IN NUMBER,
28: p_invoice_source1 IN ap_invoices.source%TYPE DEFAULT NULL,
29: p_invoice_source2 IN ap_invoices.source%TYPE DEFAULT NULL,
30: p_invoice_source3 IN ap_invoices.source%TYPE DEFAULT NULL,
31: p_invoice_type IN ap_invoices.invoice_type_lookup_code%TYPE,
32: p_system_linkage IN pa_transaction_interface.system_linkage%TYPE,
33: p_process_receipts IN VARCHAR2 DEFAULT 'N');

Line 30: p_invoice_source3 IN ap_invoices.source%TYPE DEFAULT NULL,

26: p_debug_mode IN VARCHAR2,
27: p_output IN NUMBER,
28: p_invoice_source1 IN ap_invoices.source%TYPE DEFAULT NULL,
29: p_invoice_source2 IN ap_invoices.source%TYPE DEFAULT NULL,
30: p_invoice_source3 IN ap_invoices.source%TYPE DEFAULT NULL,
31: p_invoice_type IN ap_invoices.invoice_type_lookup_code%TYPE,
32: p_system_linkage IN pa_transaction_interface.system_linkage%TYPE,
33: p_process_receipts IN VARCHAR2 DEFAULT 'N');
34:

Line 31: p_invoice_type IN ap_invoices.invoice_type_lookup_code%TYPE,

27: p_output IN NUMBER,
28: p_invoice_source1 IN ap_invoices.source%TYPE DEFAULT NULL,
29: p_invoice_source2 IN ap_invoices.source%TYPE DEFAULT NULL,
30: p_invoice_source3 IN ap_invoices.source%TYPE DEFAULT NULL,
31: p_invoice_type IN ap_invoices.invoice_type_lookup_code%TYPE,
32: p_system_linkage IN pa_transaction_interface.system_linkage%TYPE,
33: p_process_receipts IN VARCHAR2 DEFAULT 'N');
34:
35: PROCEDURE fetch_pf_var(p_process_receipts IN VARCHAR2 DEFAULT 'N');

Line 98: G_INVOICE_SOURCE1 ap_invoices.source%TYPE;

94: G_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
95: G_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
96: G_NRT_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
97: G_NRT_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
98: G_INVOICE_SOURCE1 ap_invoices.source%TYPE;
99: G_INVOICE_SOURCE2 ap_invoices.source%TYPE;
100: G_INVOICE_SOURCE3 ap_invoices.source%TYPE;
101: G_INVOICE_TYPE ap_invoices.invoice_type_lookup_code%TYPE;
102: G_BATCH_NAME pa_transaction_interface.batch_name%TYPE;

Line 99: G_INVOICE_SOURCE2 ap_invoices.source%TYPE;

95: G_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
96: G_NRT_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
97: G_NRT_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
98: G_INVOICE_SOURCE1 ap_invoices.source%TYPE;
99: G_INVOICE_SOURCE2 ap_invoices.source%TYPE;
100: G_INVOICE_SOURCE3 ap_invoices.source%TYPE;
101: G_INVOICE_TYPE ap_invoices.invoice_type_lookup_code%TYPE;
102: G_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
103: G_NRT_BATCH_NAME pa_transaction_interface.batch_name%TYPE;

Line 100: G_INVOICE_SOURCE3 ap_invoices.source%TYPE;

96: G_NRT_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
97: G_NRT_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
98: G_INVOICE_SOURCE1 ap_invoices.source%TYPE;
99: G_INVOICE_SOURCE2 ap_invoices.source%TYPE;
100: G_INVOICE_SOURCE3 ap_invoices.source%TYPE;
101: G_INVOICE_TYPE ap_invoices.invoice_type_lookup_code%TYPE;
102: G_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
103: G_NRT_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
104: G_INTERFACE_ID NUMBER;

Line 101: G_INVOICE_TYPE ap_invoices.invoice_type_lookup_code%TYPE;

97: G_NRT_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
98: G_INVOICE_SOURCE1 ap_invoices.source%TYPE;
99: G_INVOICE_SOURCE2 ap_invoices.source%TYPE;
100: G_INVOICE_SOURCE3 ap_invoices.source%TYPE;
101: G_INVOICE_TYPE ap_invoices.invoice_type_lookup_code%TYPE;
102: G_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
103: G_NRT_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
104: G_INTERFACE_ID NUMBER;
105: G_NRT_INTERFACE_ID NUMBER;

Line 176: L_pay_code_combination_id ap_invoices.accts_pay_code_combination_id%TYPE := NULL;

172: /* MC Upgrade variables */
173: G_ACCT_CURRENCY_CODE VARCHAR(15);
174: G_ORG_ID NUMBER;
175: E_DIFFERENT_SOB EXCEPTION;
176: L_pay_code_combination_id ap_invoices.accts_pay_code_combination_id%TYPE := NULL;
177:
178: /* Used during insertion into pa_transaction_interface, this variable is set
179: to the weekending date of the maximum expenditure item date of an invoice */
180:

Line 352: p_invoice_id IN ap_invoices.invoice_id%TYPE,

348: PROCEDURE mark_PAflag_O;
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);

Line 450: AP_Invoices INV,

446: ,'Y' insert_flag
447: ,DIST.historical_flag historical_flag
448: ,DIST.PRepay_distribution_id PRepay_distribution_id
449: FROM PO_Vendors VEND,
450: AP_Invoices INV,
451: AP_Invoice_Lines INVL,
452: PA_Transfer_AP_Invoices_View DIST,
453: PA_EXPENDITURE_TYPES TYPE
454: WHERE DIST.Invoice_Id = INV.Invoice_Id

Line 452: PA_Transfer_AP_Invoices_View DIST,

448: ,DIST.PRepay_distribution_id PRepay_distribution_id
449: FROM PO_Vendors VEND,
450: AP_Invoices INV,
451: AP_Invoice_Lines INVL,
452: PA_Transfer_AP_Invoices_View DIST,
453: PA_EXPENDITURE_TYPES TYPE
454: WHERE DIST.Invoice_Id = INV.Invoice_Id
455: AND INVL.Invoice_id = INV.Invoice_Id
456: AND INVL.Line_Number = DIST.Invoice_Line_Number

Line 558: ap_invoices inv,

554: , paydist.payment_hist_dist_id
555: ,dist.pa_addition_flag pa_addition_flag --Bug# 5516855
556: from AP_Invoice_Payments_all pay,
557: po_vendors vend,
558: ap_invoices inv,
559: ap_payment_hist_dists paydist,
560: PA_Transfer_AP_Invoices_View DIST,
561: ap_checks chk
562: where pay.posted_flag='Y'

Line 560: PA_Transfer_AP_Invoices_View DIST,

556: from AP_Invoice_Payments_all pay,
557: po_vendors vend,
558: ap_invoices inv,
559: ap_payment_hist_dists paydist,
560: PA_Transfer_AP_Invoices_View DIST,
561: ap_checks chk
562: where pay.posted_flag='Y'
563: AND pay.invoice_payment_id = paydist.invoice_payment_id
564: AND pay.check_id = chk.check_id

Line 792: AP_Invoices_all INV,

788: ,'CMT' fc_document_type
789: ,'Y' si_assets_addition_flag
790: ,'Y' insert_flag
791: FROM PO_Vendors VEND,
792: AP_Invoices_all INV,
793: PA_Transfer_AP_Invoices_View DIST
794: WHERE DIST.Invoice_Id = INV.Invoice_Id
795: AND DIST.Pa_Addition_Flag = 'W'
796: AND INV.Vendor_Id = VEND.Vendor_Id

Line 793: PA_Transfer_AP_Invoices_View DIST

789: ,'Y' si_assets_addition_flag
790: ,'Y' insert_flag
791: FROM PO_Vendors VEND,
792: AP_Invoices_all INV,
793: PA_Transfer_AP_Invoices_View DIST
794: WHERE DIST.Invoice_Id = INV.Invoice_Id
795: AND DIST.Pa_Addition_Flag = 'W'
796: AND INV.Vendor_Id = VEND.Vendor_Id
797: AND DIST.request_id = G_REQUEST_ID

Line 922: AP_Invoices INV,

918: , l_PRepay_dist_id
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

Line 1018: AP_Invoices INV,

1014: ,'Y' insert_flag
1015: ,l_pay_hist_id
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

Line 1023: --PA_Transfer_AP_Invoices_View DIST1,

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
1026: WHERE DIST1.Invoice_Id = INV.Invoice_Id
1027: AND DIST1.invoice_distribution_id = PDIST.invoice_distribution_id -- Std inv line to which Prepay is applied

Line 1024: -- PA_Transfer_AP_Invoices_View DIST2,

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
1026: WHERE DIST1.Invoice_Id = INV.Invoice_Id
1027: AND DIST1.invoice_distribution_id = PDIST.invoice_distribution_id -- Std inv line to which Prepay is applied
1028: AND DIST2.invoice_id = DIST1.invoice_id