APPS.PA_AP_XFER_PKG dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 25: l_system_reference2 pa_cost_distribution_lines_all.system_reference2%TYPE;

21: l_stage NUMBER ;
22: l_this_fetch PLS_INTEGER := 0;
23: l_totally_fetched PLS_INTEGER := 0;
24: l_accrue_on_receipt_num NUMBER := 0;
25: l_system_reference2 pa_cost_distribution_lines_all.system_reference2%TYPE;
26:
27: /*Cursor to select the invoices for the newly created cdls after recalc*/
28: CURSOR Inv_stat_cur
29: IS

Line 51: ,pa_cost_distribution_lines_all cdl

47: ,cdl.line_num
48: ,cdl.line_num_reversed
49: ,cdl.dr_code_combination_id
50: FROM pa_expenditure_items_all ei
51: ,pa_cost_distribution_lines_all cdl
52: WHERE ei.cost_distributed_flag = 'S'
53: AND ei.request_id = g_request_id
54: AND ei.system_linkage_function = 'VI'
55: AND cdl.transfer_status_code = 'P'

Line 159: UPDATE PA_COST_DISTRIBUTION_LINES_ALL a

155:
156: l_stage :=100;
157:
158: FORALL i IN l_expenditure_item_id_tab.FIRST..l_expenditure_item_id_tab.LAST
159: UPDATE PA_COST_DISTRIBUTION_LINES_ALL a
160: SET a.TRANSFER_STATUS_CODE ='B'
161: WHERE a.expenditure_item_id = l_expenditure_item_id_tab(i)
162: AND a.line_num in (l_line_num_tab(i) ,l_line_num_tab(i)+ 1)
163: AND EXISTS (SELECT 1

Line 164: FROM PA_COST_DISTRIBUTION_LINES_ALL cdl

160: SET a.TRANSFER_STATUS_CODE ='B'
161: WHERE a.expenditure_item_id = l_expenditure_item_id_tab(i)
162: AND a.line_num in (l_line_num_tab(i) ,l_line_num_tab(i)+ 1)
163: AND EXISTS (SELECT 1
164: FROM PA_COST_DISTRIBUTION_LINES_ALL cdl
165: WHERE cdl.expenditure_item_id = a.expenditure_item_id
166: AND cdl.line_num = l_line_num_tab(i) +1
167: AND cdl.dr_code_combination_id =l_dr_code_combination_id_tab(i));
168: