APPS.PA_AP_INTEGRATION dependencies on PA_EXPENDITURES_ALL

Line 21: type expid_tbl IS TABLE OF PA_EXPENDITURES_ALL.expenditure_id%TYPE INDEX BY BINARY_INTEGER;

17:
18: eiid_rec eiid_tbl;
19: lnum_rec lnum_tbl;
20:
21: type expid_tbl IS TABLE OF PA_EXPENDITURES_ALL.expenditure_id%TYPE INDEX BY BINARY_INTEGER;
22: expid_rec expid_tbl;
23: /* bug 8845025 end */
24: Begin
25: x_stage := 'Updating Pa_implementations Table';

Line 29: x_stage := 'Updating Pa_Expenditures_All Table';

25: x_stage := 'Updating Pa_implementations Table';
26: Update pa_implementations_all set Vendor_Id = p_new_vendor_id
27: Where Vendor_Id = p_old_vendor_id;
28:
29: x_stage := 'Updating Pa_Expenditures_All Table';
30: /* Added for bug# 8845025 */
31: UPDATE pa_expenditures_all e
32: SET e.vendor_id = p_new_vendor_id
33: -- Bug#10254549 added the last updated columns

Line 31: UPDATE pa_expenditures_all e

27: Where Vendor_Id = p_old_vendor_id;
28:
29: x_stage := 'Updating Pa_Expenditures_All Table';
30: /* Added for bug# 8845025 */
31: UPDATE pa_expenditures_all e
32: SET e.vendor_id = p_new_vendor_id
33: -- Bug#10254549 added the last updated columns
34: ,last_update_date = sysdate
35: ,last_updated_by = fnd_global.user_id

Line 50: UPDATE pa_expenditures_all e

46: returning expenditure_id BULK COLLECT INTO expid_rec;
47:
48: /*Code change for 7125912 */
49: /* commenting for bug 8845025
50: UPDATE pa_expenditures_all e
51: SET e.vendor_id = p_new_vendor_id
52: -- Bug#10254549 added the last updated columns
53: ,last_update_date = sysdate
54: ,last_updated_by = fnd_global.user_id