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.PA_AP_INTEGRATION dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 15: TYPE eiid_tbl IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.expenditure_item_id%TYPE INDEX BY BINARY_INTEGER;

11: x_status OUT NOCOPY VARCHAR2)
12:
13: IS
14: /* bug 8845025 start */
15: TYPE eiid_tbl IS TABLE OF PA_EXPENDITURE_ITEMS_ALL.expenditure_item_id%TYPE INDEX BY BINARY_INTEGER;
16: TYPE lnum_tbl IS TABLE OF PA_COST_DISTRIBUTION_LINES_ALL.line_num%TYPE INDEX BY BINARY_INTEGER;
17:
18: eiid_rec eiid_tbl;
19: lnum_rec lnum_tbl;

Line 61: pa_expenditure_items_all ei,

57: AND e.expenditure_id in (
58: SELECT ---- /*+ LEADING(ei)
59: ei.expenditure_id
60: FROM pa_cost_distribution_lines_all c,
61: pa_expenditure_items_all ei,
62: ap_invoices_all i
63: WHERE TO_CHAR (i.invoice_id) = c.system_reference2
64: AND c.expenditure_item_id = ei.expenditure_item_id
65: -- AND ei.expenditure_id = e.expenditure_id

Line 71: x_stage := 'Updating Pa_Expenditure_Items_All Table';

67: AND i.vendor_id = p_new_vendor_id
68: AND i.payment_status_flag = DECODE (NVL (p_paid_inv_flag, 'Y'), 'N', 'N', i.payment_status_flag)
69: ) ; */
70: /*Code change for 7125912 END */
71: x_stage := 'Updating Pa_Expenditure_Items_All Table';
72:
73: /*Changed for Bug:5864959*/
74: /* Bug 13013074 Added no_unnest hint */
75: Update pa_expenditure_items_all ei

Line 75: Update pa_expenditure_items_all ei

71: x_stage := 'Updating Pa_Expenditure_Items_All Table';
72:
73: /*Changed for Bug:5864959*/
74: /* Bug 13013074 Added no_unnest hint */
75: Update pa_expenditure_items_all ei
76: set vendor_id = p_new_vendor_id
77: ,last_update_date = sysdate --bug 14012059
78: ,last_updated_by = fnd_global.user_id -- bug 14012059
79: Where Vendor_Id = p_old_vendor_id

Line 103: FROM PA_EXPENDITURE_ITEMS_ALL ei

99: ,program_id = FND_GLOBAL.CONC_PROGRAM_ID()
100: ,program_update_date = sysdate
101: WHERE expenditure_item_id IN (
102: SELECT expenditure_item_id
103: FROM PA_EXPENDITURE_ITEMS_ALL ei
104: WHERE ei.expenditure_id = expid_rec(i)
105: );
106:
107: /* Commented for bug# 88845025

Line 613: FUNCTION Get_si_cost_exp_item_date ( p_transaction_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,

609: -- p_calling_program : a. when called during the PO Match case : PO-MATCH b. When called from Invoice form : APXINWKB
610: -- c. When called from supplier cost xface for discounts : DISCOUNT d. When called from supplier cost xface for Payment: PAYMENT
611: -- e. When called from supplier cost xface for Receipts : RECEIPT
612: -- ==========================================================================================================================================
613: FUNCTION Get_si_cost_exp_item_date ( p_transaction_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
614: p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE,
615: p_po_exp_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
616: p_creation_date IN pa_expenditure_items_all.creation_date%TYPE,
617: p_po_distribution_id IN pa_expenditure_items_all.document_distribution_id%TYPE,

Line 615: p_po_exp_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,

611: -- e. When called from supplier cost xface for Receipts : RECEIPT
612: -- ==========================================================================================================================================
613: FUNCTION Get_si_cost_exp_item_date ( p_transaction_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
614: p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE,
615: p_po_exp_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
616: p_creation_date IN pa_expenditure_items_all.creation_date%TYPE,
617: p_po_distribution_id IN pa_expenditure_items_all.document_distribution_id%TYPE,
618: p_calling_program IN varchar2 )
619: RETURN date is

Line 616: p_creation_date IN pa_expenditure_items_all.creation_date%TYPE,

612: -- ==========================================================================================================================================
613: FUNCTION Get_si_cost_exp_item_date ( p_transaction_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
614: p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE,
615: p_po_exp_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
616: p_creation_date IN pa_expenditure_items_all.creation_date%TYPE,
617: p_po_distribution_id IN pa_expenditure_items_all.document_distribution_id%TYPE,
618: p_calling_program IN varchar2 )
619: RETURN date is
620: l_return_date date ;

Line 617: p_po_distribution_id IN pa_expenditure_items_all.document_distribution_id%TYPE,

613: FUNCTION Get_si_cost_exp_item_date ( p_transaction_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
614: p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE,
615: p_po_exp_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
616: p_creation_date IN pa_expenditure_items_all.creation_date%TYPE,
617: p_po_distribution_id IN pa_expenditure_items_all.document_distribution_id%TYPE,
618: p_calling_program IN varchar2 )
619: RETURN date is
620: l_return_date date ;
621: l_pa_exp_date_default varchar2(50) ;