APPS.PA_AP_XFER_PKG dependencies on PA_COST_DISTRIBUTION_LINES

Line 12: g_request_id pa_cost_distribution_lines.request_id%TYPE ;

8: ,x_error_stage OUT NOCOPY NUMBER
9: )
10: IS
11:
12: g_request_id pa_cost_distribution_lines.request_id%TYPE ;
13: l_expenditure_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
14: l_line_num_tab PA_PLSQL_DATATYPES.NumTabTyp;
15: l_line_num_reversed_tab PA_PLSQL_DATATYPES.NumTabTyp;
16: l_dr_code_combination_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

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 31: from pa_cost_distribution_lines cdl,

27: /*Cursor to select the invoices for the newly created cdls after recalc*/
28: CURSOR Inv_stat_cur
29: IS
30: Select distinct system_reference2
31: from pa_cost_distribution_lines cdl,
32: pa_expenditure_items ei
33: where ei.cost_distributed_flag ='S'
34: AND ei.request_id = g_request_id
35: AND ei.system_linkage_function = 'VI'

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 96: UPDATE PA_COST_DISTRIBUTION_LINES

92: /*Bug 3094341. Added an NVL condition to system_reference2, as it was calling
93: AP_PA_API_PKG, which was erroring out when NULL was passed. No records were retrieved when NULL is passed. */
94: IF pa_integration.check_ap_invoices(nvl(l_system_reference2,0),'ADJUSTMENTS') <> 'N'
95: THEN
96: UPDATE PA_COST_DISTRIBUTION_LINES
97: SET transfer_status_code ='B'
98: WHERE system_reference2 =l_system_reference2
99: AND transfer_status_code = 'P'
100: AND line_type ='R'

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: