APPS.PA_AP_INTEGRATION dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 26: FROM pa_cost_distribution_lines_all c,

22: WHERE e.vendor_id = p_old_vendor_id
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

Line 44: from pa_cost_distribution_lines_all c,

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,
45: ap_invoices_all i
46: where i.invoice_id = to_number(c.system_reference2)
47: and c.expenditure_item_id = ei.expenditure_item_id
48: and c.system_reference1 = p_old_vendor_id

Line 54: x_stage := 'Updating Pa_Cost_Distribution_Lines_All Table';

50: and i.PAYMENT_STATUS_FLAG =
51: decode(nvl(p_paid_inv_flag,'Y'),'N','N',i.PAYMENT_STATUS_FLAG)
52: );
53:
54: x_stage := 'Updating Pa_Cost_Distribution_Lines_All Table';
55:
56: If nvl(p_paid_inv_flag,'Y') = 'N' Then
57:
58: /*Code change for 7125912 */

Line 61: from pa_cost_distribution_lines_all c, ap_invoices_all i

57:
58: /*Code change for 7125912 */
59: Declare Cursor c1 is
60: Select c.rowid row_id, c.expenditure_item_id, c.line_num
61: from pa_cost_distribution_lines_all c, ap_invoices_all i
62: where to_char(i.invoice_id) = c.system_reference2
63: /*and i.vendor_id = to_number(c.system_reference1)*/ /*Vendor_ID on Invoice is already changed...so this is not needed */
64: and c.system_reference1 = to_char(p_old_vendor_id)
65: and i.vendor_id = p_new_vendor_id

Line 71: x_stage := 'Updating Pa_Cost_Distribution_Lines_All Table For UNPAID Invoices';

67:
68: /*Code change for 7125912 END */
69: Begin
70:
71: x_stage := 'Updating Pa_Cost_Distribution_Lines_All Table For UNPAID Invoices';
72:
73: For Rec in C1 Loop
74:
75: Update pa_cost_distribution_lines_all

Line 75: Update pa_cost_distribution_lines_all

71: x_stage := 'Updating Pa_Cost_Distribution_Lines_All Table For UNPAID Invoices';
72:
73: For Rec in C1 Loop
74:
75: Update pa_cost_distribution_lines_all
76: Set System_reference1 = (p_new_vendor_id)
77: Where rowid = rec.row_id;
78:
79: End Loop;

Line 84: x_stage := 'Updating Pa_Cost_Distribution_Lines_All Table For ALL Invoices';

80: End;
81:
82: Else -- p_paid_inv_flag <> 'N'
83:
84: x_stage := 'Updating Pa_Cost_Distribution_Lines_All Table For ALL Invoices';
85:
86: Update Pa_Cost_Distribution_Lines_All
87: Set System_Reference1 = to_char(p_new_vendor_id)
88: Where System_Reference1 = to_char(p_old_vendor_id)

Line 86: Update Pa_Cost_Distribution_Lines_All

82: Else -- p_paid_inv_flag <> 'N'
83:
84: x_stage := 'Updating Pa_Cost_Distribution_Lines_All Table For ALL Invoices';
85:
86: Update Pa_Cost_Distribution_Lines_All
87: Set System_Reference1 = to_char(p_new_vendor_id)
88: Where System_Reference1 = to_char(p_old_vendor_id)
89: And system_reference1 is not null
90: And system_reference2 is not null

Line 550: p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE,

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,
554: p_calling_program IN varchar2 )