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 99: G_INVOICE_SOURCE1 ap_invoices.source%TYPE;

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

Line 100: G_INVOICE_SOURCE2 ap_invoices.source%TYPE;

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

Line 101: G_INVOICE_SOURCE3 ap_invoices.source%TYPE;

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

Line 102: G_INVOICE_TYPE ap_invoices.invoice_type_lookup_code%TYPE;

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

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

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

Line 356: p_invoice_id IN ap_invoices.invoice_id%TYPE,

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

Line 455: AP_Invoices INV,

451: ,DIST.historical_flag historical_flag
452: ,DIST.PRepay_distribution_id PRepay_distribution_id
453: ,SELF_ASSESSED_FLAG ---Bug 13602288: Self Assessed Tax Changes
454: FROM PO_Vendors VEND,
455: AP_Invoices INV,
456: AP_Invoice_Lines INVL,
457: PA_Transfer_AP_Invoices_View DIST,
458: PA_EXPENDITURE_TYPES TYPE
459: WHERE DIST.Invoice_Id = INV.Invoice_Id

Line 457: PA_Transfer_AP_Invoices_View DIST,

453: ,SELF_ASSESSED_FLAG ---Bug 13602288: Self Assessed Tax Changes
454: FROM PO_Vendors VEND,
455: AP_Invoices INV,
456: AP_Invoice_Lines INVL,
457: PA_Transfer_AP_Invoices_View DIST,
458: PA_EXPENDITURE_TYPES TYPE
459: WHERE DIST.Invoice_Id = INV.Invoice_Id
460: AND INVL.Invoice_id = INV.Invoice_Id
461: AND INVL.Line_Number = DIST.Invoice_Line_Number

Line 563: ap_invoices inv,

559: , paydist.payment_hist_dist_id
560: ,dist.pa_addition_flag pa_addition_flag --Bug# 5516855
561: from AP_Invoice_Payments_all pay,
562: po_vendors vend,
563: ap_invoices inv,
564: ap_payment_hist_dists paydist,
565: PA_Transfer_AP_Invoices_View DIST,
566: ap_checks chk
567: where pay.posted_flag='Y'

Line 565: PA_Transfer_AP_Invoices_View DIST,

561: from AP_Invoice_Payments_all pay,
562: po_vendors vend,
563: ap_invoices inv,
564: ap_payment_hist_dists paydist,
565: PA_Transfer_AP_Invoices_View DIST,
566: ap_checks chk
567: where pay.posted_flag='Y'
568: AND pay.invoice_payment_id = paydist.invoice_payment_id
569: AND pay.check_id = chk.check_id

Line 799: AP_Invoices_all INV,

795: ,'CMT' fc_document_type
796: ,'Y' si_assets_addition_flag
797: ,'Y' insert_flag
798: FROM PO_Vendors VEND,
799: AP_Invoices_all INV,
800: PA_Transfer_AP_Invoices_View DIST
801: WHERE DIST.Invoice_Id = INV.Invoice_Id
802: AND DIST.Pa_Addition_Flag = 'W'
803: AND INV.Vendor_Id = VEND.Vendor_Id

Line 800: PA_Transfer_AP_Invoices_View DIST

796: ,'Y' si_assets_addition_flag
797: ,'Y' insert_flag
798: FROM PO_Vendors VEND,
799: AP_Invoices_all INV,
800: PA_Transfer_AP_Invoices_View DIST
801: WHERE DIST.Invoice_Id = INV.Invoice_Id
802: AND DIST.Pa_Addition_Flag = 'W'
803: AND INV.Vendor_Id = VEND.Vendor_Id
804: AND DIST.request_id = G_REQUEST_ID

Line 929: AP_Invoices INV,

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

Line 1025: AP_Invoices INV,

1021: ,'Y' insert_flag
1022: ,l_pay_hist_id
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

Line 1030: --PA_Transfer_AP_Invoices_View DIST1,

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

Line 1031: -- PA_Transfer_AP_Invoices_View DIST2,

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