APPS.PA_AP_INTEGRATION dependencies on FND_GLOBAL

Line 35: ,last_updated_by = fnd_global.user_id

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
36: ,last_update_login =fnd_global.login_id
37: WHERE e.vendor_id = p_old_vendor_id and
38: orig_exp_txn_reference1 = nvl(p_invoice_id, orig_exp_txn_reference1) and -- Added nvl for the Bug 14387738
39: exists (

Line 36: ,last_update_login =fnd_global.login_id

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
36: ,last_update_login =fnd_global.login_id
37: WHERE e.vendor_id = p_old_vendor_id and
38: orig_exp_txn_reference1 = nvl(p_invoice_id, orig_exp_txn_reference1) and -- Added nvl for the Bug 14387738
39: exists (
40: select 1 from ap_invoices_all i

Line 54: ,last_updated_by = fnd_global.user_id

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
55: ,last_update_login =fnd_global.login_id
56: WHERE e.vendor_id = p_old_vendor_id
57: AND e.expenditure_id in (
58: SELECT ---- /*+ LEADING(ei)

Line 55: ,last_update_login =fnd_global.login_id

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
55: ,last_update_login =fnd_global.login_id
56: WHERE e.vendor_id = p_old_vendor_id
57: AND e.expenditure_id in (
58: SELECT ---- /*+ LEADING(ei)
59: ei.expenditure_id

Line 78: ,last_updated_by = fnd_global.user_id -- bug 14012059

74: /* Bug 13013074 Added no_unnest hint */
75: Update pa_expenditure_items_all ei
76: set vendor_id = p_new_vendor_id
77: ,last_update_date = sysdate --bug 14012059
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,

Line 99: ,program_id = FND_GLOBAL.CONC_PROGRAM_ID()

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
101: WHERE expenditure_item_id IN (
102: SELECT expenditure_item_id
103: FROM PA_EXPENDITURE_ITEMS_ALL ei

Line 130: ,program_id = FND_GLOBAL.CONC_PROGRAM_ID()

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
132: Where rowid = rec.row_id;
133:
134: End Loop;

Line 144: ,program_id = FND_GLOBAL.CONC_PROGRAM_ID()

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
146: Where System_Reference1 = to_char(p_old_vendor_id)
147: And system_reference1 is not null
148: And system_reference2 is not null