APPS.PA_AP_INTEGRATION dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 27: pa_expenditure_items_all ei,

23: AND e.expenditure_id in (
24: SELECT ---- /*+ LEADING(ei) */
25: ei.expenditure_id
26: FROM pa_cost_distribution_lines_all c,
27: pa_expenditure_items_all ei,
28: ap_invoices_all i
29: WHERE TO_CHAR (i.invoice_id) = c.system_reference2
30: AND c.expenditure_item_id = ei.expenditure_item_id
31: -- AND ei.expenditure_id = e.expenditure_id

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

33: AND i.vendor_id = p_new_vendor_id
34: AND i.payment_status_flag = DECODE (NVL (p_paid_inv_flag, 'Y'), 'N', 'N', i.payment_status_flag)
35: ) ;
36: /*Code change for 7125912 END */
37: x_stage := 'Updating Pa_Expenditure_Items_All Table';
38:
39: /*Changed for Bug:5864959*/
40: Update pa_expenditure_items_all ei set vendor_id = p_new_vendor_id
41: Where Vendor_Id = p_old_vendor_id

Line 40: Update pa_expenditure_items_all ei set vendor_id = p_new_vendor_id

36: /*Code change for 7125912 END */
37: x_stage := 'Updating Pa_Expenditure_Items_All Table';
38:
39: /*Changed for Bug:5864959*/
40: Update pa_expenditure_items_all ei set vendor_id = p_new_vendor_id
41: Where Vendor_Id = p_old_vendor_id
42: and exists
43: (select 1
44: from pa_cost_distribution_lines_all c,

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

545: -- p_calling_program : a. when called during the PO Match case : PO-MATCH b. When called from Invoice form : APXINWKB
546: -- c. When called from supplier cost xface for discounts : DISCOUNT d. When called from supplier cost xface for Payment: PAYMENT
547: -- e. When called from supplier cost xface for Receipts : RECEIPT
548: -- ==========================================================================================================================================
549: FUNCTION Get_si_cost_exp_item_date ( p_transaction_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
550: p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE,
551: p_po_exp_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
552: p_creation_date IN pa_expenditure_items_all.creation_date%TYPE,
553: p_po_distribution_id IN pa_expenditure_items_all.document_distribution_id%TYPE,

Line 551: p_po_exp_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,

547: -- e. When called from supplier cost xface for Receipts : RECEIPT
548: -- ==========================================================================================================================================
549: FUNCTION Get_si_cost_exp_item_date ( p_transaction_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
550: p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE,
551: p_po_exp_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
552: p_creation_date IN pa_expenditure_items_all.creation_date%TYPE,
553: p_po_distribution_id IN pa_expenditure_items_all.document_distribution_id%TYPE,
554: p_calling_program IN varchar2 )
555: RETURN date is

Line 552: p_creation_date IN pa_expenditure_items_all.creation_date%TYPE,

548: -- ==========================================================================================================================================
549: FUNCTION Get_si_cost_exp_item_date ( p_transaction_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
550: p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE,
551: p_po_exp_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
552: p_creation_date IN pa_expenditure_items_all.creation_date%TYPE,
553: p_po_distribution_id IN pa_expenditure_items_all.document_distribution_id%TYPE,
554: p_calling_program IN varchar2 )
555: RETURN date is
556: l_return_date date ;

Line 553: p_po_distribution_id IN pa_expenditure_items_all.document_distribution_id%TYPE,

549: FUNCTION Get_si_cost_exp_item_date ( p_transaction_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
550: p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE,
551: p_po_exp_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
552: p_creation_date IN pa_expenditure_items_all.creation_date%TYPE,
553: p_po_distribution_id IN pa_expenditure_items_all.document_distribution_id%TYPE,
554: p_calling_program IN varchar2 )
555: RETURN date is
556: l_return_date date ;
557: l_pa_exp_date_default varchar2(50) ;