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_COST_DISTRIBUTION_LINES_ALL

Line 16: TYPE lnum_tbl IS TABLE OF PA_COST_DISTRIBUTION_LINES_ALL.line_num%TYPE INDEX BY BINARY_INTEGER;

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;
20:

Line 60: FROM pa_cost_distribution_lines_all c,

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

Line 82: from pa_cost_distribution_lines_all c,

78: ,last_updated_by = fnd_global.user_id -- bug 14012059
79: Where Vendor_Id = p_old_vendor_id
80: and exists
81: (select /*+ no_unnest */ 1
82: from pa_cost_distribution_lines_all c,
83: ap_invoices_all i
84: where i.invoice_id = to_number(c.system_reference2)
85: and c.expenditure_item_id = ei.expenditure_item_id
86: and c.system_reference1 = p_old_vendor_id

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

88: and i.PAYMENT_STATUS_FLAG =
89: decode(nvl(p_paid_inv_flag,'Y'),'N','N',i.PAYMENT_STATUS_FLAG)
90: );
91:
92: x_stage := 'Updating Pa_Cost_Distribution_Lines_All Table';
93: /* Added for bug# 8845025 */
94:
95: FORALL I IN 1 .. expid_rec.count
96: UPDATE PA_COST_DISTRIBUTION_LINES_ALL

Line 96: UPDATE PA_COST_DISTRIBUTION_LINES_ALL

92: x_stage := 'Updating Pa_Cost_Distribution_Lines_All Table';
93: /* Added for bug# 8845025 */
94:
95: FORALL I IN 1 .. expid_rec.count
96: UPDATE PA_COST_DISTRIBUTION_LINES_ALL
97: SET System_reference1 = to_char(p_new_vendor_id)
98: -- Bug#10254549 added the program update columns
99: ,program_id = FND_GLOBAL.CONC_PROGRAM_ID()
100: ,program_update_date = sysdate

Line 113: from pa_cost_distribution_lines_all c, ap_invoices_all i

109:
110: --Code change for 7125912
111: Declare Cursor c1 is
112: Select c.rowid row_id, c.expenditure_item_id, c.line_num
113: from pa_cost_distribution_lines_all c, ap_invoices_all i
114: where to_char(i.invoice_id) = c.system_reference2
115: --and i.vendor_id = to_number(c.system_reference1) --Vendor_ID on Invoice is already changed...so this is not needed
116: and c.system_reference1 = to_char(p_old_vendor_id)
117: and i.vendor_id = p_new_vendor_id

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

119:
120: --Code change for 7125912 END
121: Begin
122:
123: x_stage := 'Updating Pa_Cost_Distribution_Lines_All Table For UNPAID Invoices';
124:
125: For Rec in C1 Loop
126:
127: Update pa_cost_distribution_lines_all

Line 127: Update pa_cost_distribution_lines_all

123: x_stage := 'Updating Pa_Cost_Distribution_Lines_All Table For UNPAID Invoices';
124:
125: For Rec in C1 Loop
126:
127: Update pa_cost_distribution_lines_all
128: Set System_reference1 = (p_new_vendor_id)
129: -- Bug#10254549 added the program update columns
130: ,program_id = FND_GLOBAL.CONC_PROGRAM_ID()
131: ,program_update_date = sysdate

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

135: End;
136:
137: Else -- p_paid_inv_flag <> 'N'
138:
139: x_stage := 'Updating Pa_Cost_Distribution_Lines_All Table For ALL Invoices';
140:
141: Update Pa_Cost_Distribution_Lines_All cdl
142: Set System_Reference1 = to_char(p_new_vendor_id)
143: -- Bug#10254549 added the program update columns

Line 141: Update Pa_Cost_Distribution_Lines_All cdl

137: Else -- p_paid_inv_flag <> 'N'
138:
139: x_stage := 'Updating Pa_Cost_Distribution_Lines_All Table For ALL Invoices';
140:
141: Update Pa_Cost_Distribution_Lines_All cdl
142: Set System_Reference1 = to_char(p_new_vendor_id)
143: -- Bug#10254549 added the program update columns
144: ,program_id = FND_GLOBAL.CONC_PROGRAM_ID()
145: ,program_update_date = sysdate

Line 614: p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE,

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