APPS.POS_SBD_TBL_PKG dependencies on FND_GLOBAL

Line 104: , last_updated_by = fnd_global.user_id

100: l_step:= 0;
101:
102: update pos_acnt_addr_summ_req set
103: last_update_date = sysdate
104: , last_updated_by = fnd_global.user_id
105: , last_update_login = fnd_global.login_id
106: , ext_bank_account_id = nvl(p_ext_bank_account_id,ext_bank_account_id)
107: , account_request_id = nvl(p_account_request_id, account_request_id)
108: , assignment_status = nvl(p_assignment_status, assignment_status)

Line 105: , last_update_login = fnd_global.login_id

101:
102: update pos_acnt_addr_summ_req set
103: last_update_date = sysdate
104: , last_updated_by = fnd_global.user_id
105: , last_update_login = fnd_global.login_id
106: , ext_bank_account_id = nvl(p_ext_bank_account_id,ext_bank_account_id)
107: , account_request_id = nvl(p_account_request_id, account_request_id)
108: , assignment_status = nvl(p_assignment_status, assignment_status)
109: , start_date = p_start_date

Line 167: , fnd_global.user_id -- created_by

163: values
164: (
165: x_assignment_request_id
166: , sysdate -- creation_date
167: , fnd_global.user_id -- created_by
168: , sysdate -- last_update_date
169: , fnd_global.user_id -- last_updated_by
170: , fnd_global.login_id -- last_update_login
171: , 1

Line 169: , fnd_global.user_id -- last_updated_by

165: x_assignment_request_id
166: , sysdate -- creation_date
167: , fnd_global.user_id -- created_by
168: , sysdate -- last_update_date
169: , fnd_global.user_id -- last_updated_by
170: , fnd_global.login_id -- last_update_login
171: , 1
172: , p_mapping_id
173: , 'PENDING'

Line 170: , fnd_global.login_id -- last_update_login

166: , sysdate -- creation_date
167: , fnd_global.user_id -- created_by
168: , sysdate -- last_update_date
169: , fnd_global.user_id -- last_updated_by
170: , fnd_global.login_id -- last_update_login
171: , 1
172: , p_mapping_id
173: , 'PENDING'
174: , p_request_type

Line 228: , fnd_global.user_id -- created_by

224: values
225: (
226: x_account_request_id
227: , sysdate -- creation_date
228: , fnd_global.user_id -- created_by
229: , sysdate -- last_update_date
230: , fnd_global.user_id -- last_updated_by
231: , fnd_global.login_id -- last_update_login
232: , 1

Line 230: , fnd_global.user_id -- last_updated_by

226: x_account_request_id
227: , sysdate -- creation_date
228: , fnd_global.user_id -- created_by
229: , sysdate -- last_update_date
230: , fnd_global.user_id -- last_updated_by
231: , fnd_global.login_id -- last_update_login
232: , 1
233: , p_mapping_id
234: , p_temp_ext_bank_account_id

Line 231: , fnd_global.login_id -- last_update_login

227: , sysdate -- creation_date
228: , fnd_global.user_id -- created_by
229: , sysdate -- last_update_date
230: , fnd_global.user_id -- last_updated_by
231: , fnd_global.login_id -- last_update_login
232: , 1
233: , p_mapping_id
234: , p_temp_ext_bank_account_id
235: , p_ext_bank_account_id

Line 291: , fnd_global.user_id -- created_by

287: values
288: (
289: x_assignment_id
290: , sysdate -- creation_date
291: , fnd_global.user_id -- created_by
292: , sysdate -- last_update_date
293: , fnd_global.user_id -- last_updated_by
294: , fnd_global.login_id -- last_update_login
295: , p_assignment_request_id

Line 293: , fnd_global.user_id -- last_updated_by

289: x_assignment_id
290: , sysdate -- creation_date
291: , fnd_global.user_id -- created_by
292: , sysdate -- last_update_date
293: , fnd_global.user_id -- last_updated_by
294: , fnd_global.login_id -- last_update_login
295: , p_assignment_request_id
296: , p_ext_bank_account_id
297: , p_start_date

Line 294: , fnd_global.login_id -- last_update_login

290: , sysdate -- creation_date
291: , fnd_global.user_id -- created_by
292: , sysdate -- last_update_date
293: , fnd_global.user_id -- last_updated_by
294: , fnd_global.login_id -- last_update_login
295: , p_assignment_request_id
296: , p_ext_bank_account_id
297: , p_start_date
298: , p_end_date

Line 351: , last_updated_by = fnd_global.user_id

347:
348: l_step := 2;
349: update POS_ACNT_ADDR_REQ set
350: last_update_date = sysdate
351: , last_updated_by = fnd_global.user_id
352: , last_update_login = fnd_global.login_id
353: , request_status = nvl(p_request_status, request_status)
354: , party_site_id = p_party_site_id
355: , address_request_id = p_address_request_id

Line 352: , last_update_login = fnd_global.login_id

348: l_step := 2;
349: update POS_ACNT_ADDR_REQ set
350: last_update_date = sysdate
351: , last_updated_by = fnd_global.user_id
352: , last_update_login = fnd_global.login_id
353: , request_status = nvl(p_request_status, request_status)
354: , party_site_id = p_party_site_id
355: , address_request_id = p_address_request_id
356: where assignment_request_id = p_assignment_request_id;