DBA Data[Home] [Help]

APPS.IBY_BANKPAYMENT_UPDT_PUB dependencies on FND_GLOBAL

Line 59: last_updated_by = fnd_global.user_id,

55: set batch_status = p_new_status,
56: bep_code = p_error_code,
57: bep_message = p_error_message,
58: last_update_date = sysdate,
59: last_updated_by = fnd_global.user_id,
60: object_version_number = object_version_number + 1
61: where batch_id = p_batch_id;
62:
63: commit;

Line 92: last_updated_by = fnd_global.user_id,

88: SET
89: batch_status = newstatus_in,
90: iby_batch_id = newbatchid_in,
91: last_update_date = sysdate,
92: last_updated_by = fnd_global.user_id,
93: object_version_number = object_version_number + 1
94:
95: WHERE bepid = bepid_in
96: AND bepkey = bepkey_in

Line 159: last_updated_by = fnd_global.user_id,

155: set pmt_status = p_new_status,
156: bep_code = p_error_code,
157: bep_message = p_error_message,
158: last_update_date = sysdate,
159: last_updated_by = fnd_global.user_id,
160: object_version_number = object_version_number + 1
161: where batch_id = p_batch_id and pmt_trxn_id = p_trxn_id;
162:
163: ELSE

Line 170: last_updated_by = fnd_global.user_id,

166: set pmt_status = p_new_status,
167: bep_code = p_error_code,
168: bep_message = p_error_message,
169: last_update_date = sysdate,
170: last_updated_by = fnd_global.user_id,
171: object_version_number = object_version_number + 1
172: where batch_id = p_batch_id;
173:
174: END IF;

Line 238: last_updated_by = fnd_global.user_id,

234: pmt_status = G_STATUS_QRY_TRXN_FAIL,
235: bep_code = p_error_code,
236: bep_message = p_error_message,
237: last_update_date = sysdate,
238: last_updated_by = fnd_global.user_id,
239: last_update_login = fnd_global.conc_login_id,
240: object_version_number = object_version_number + 1
241: WHERE batch_id = l_ec_batch_rec.batch_id;
242:

Line 239: last_update_login = fnd_global.conc_login_id,

235: bep_code = p_error_code,
236: bep_message = p_error_message,
237: last_update_date = sysdate,
238: last_updated_by = fnd_global.user_id,
239: last_update_login = fnd_global.conc_login_id,
240: object_version_number = object_version_number + 1
241: WHERE batch_id = l_ec_batch_rec.batch_id;
242:
243: -- update the EC batch

Line 250: last_updated_by = fnd_global.user_id,

246: batch_status = G_STATUS_QRY_BATCH_FAIL,
247: bep_code = p_error_code,
248: bep_message = p_error_message,
249: last_update_date = sysdate,
250: last_updated_by = fnd_global.user_id,
251: last_update_login = fnd_global.conc_login_id,
252: object_version_number = object_version_number + 1
253: WHERE batch_id = l_ec_batch_rec.batch_id;
254:

Line 251: last_update_login = fnd_global.conc_login_id,

247: bep_code = p_error_code,
248: bep_message = p_error_message,
249: last_update_date = sysdate,
250: last_updated_by = fnd_global.user_id,
251: last_update_login = fnd_global.conc_login_id,
252: object_version_number = object_version_number + 1
253: WHERE batch_id = l_ec_batch_rec.batch_id;
254:
255: END LOOP;

Line 264: last_updated_by = fnd_global.user_id,

260: batchstatus = G_STATUS_QRY_BATCH_FAIL,
261: bepcode = p_error_code,
262: bepmessage = p_error_message,
263: last_update_date = sysdate,
264: last_updated_by = fnd_global.user_id,
265: last_update_login = fnd_global.conc_login_id,
266: object_version_number = object_version_number + 1
267: WHERE batchid = p_iby_batchid
268: AND payeeid = p_payerid;

Line 265: last_update_login = fnd_global.conc_login_id,

261: bepcode = p_error_code,
262: bepmessage = p_error_message,
263: last_update_date = sysdate,
264: last_updated_by = fnd_global.user_id,
265: last_update_login = fnd_global.conc_login_id,
266: object_version_number = object_version_number + 1
267: WHERE batchid = p_iby_batchid
268: AND payeeid = p_payerid;
269:

Line 455: last_updated_by = fnd_global.user_id,

451: batch_status = l_batch_status,
452: bep_code = null,
453: bep_message = null,
454: last_update_date = sysdate,
455: last_updated_by = fnd_global.user_id,
456: last_update_login = fnd_global.conc_login_id,
457: object_version_number = object_version_number + 1
458: WHERE batch_id = l_ec_batch_rec.batch_id;
459:

Line 456: last_update_login = fnd_global.conc_login_id,

452: bep_code = null,
453: bep_message = null,
454: last_update_date = sysdate,
455: last_updated_by = fnd_global.user_id,
456: last_update_login = fnd_global.conc_login_id,
457: object_version_number = object_version_number + 1
458: WHERE batch_id = l_ec_batch_rec.batch_id;
459:
460: END IF;

Line 491: last_updated_by = fnd_global.user_id,

487: batchstatus = l_batch_status,
488: bepcode = null,
489: bepmessage = null,
490: last_update_date = sysdate,
491: last_updated_by = fnd_global.user_id,
492: last_update_login = fnd_global.conc_login_id,
493: object_version_number = object_version_number + 1
494: WHERE batchid = p_iby_batchid
495: AND payeeid = p_payerid;

Line 492: last_update_login = fnd_global.conc_login_id,

488: bepcode = null,
489: bepmessage = null,
490: last_update_date = sysdate,
491: last_updated_by = fnd_global.user_id,
492: last_update_login = fnd_global.conc_login_id,
493: object_version_number = object_version_number + 1
494: WHERE batchid = p_iby_batchid
495: AND payeeid = p_payerid;
496:

Line 518: last_updated_by = fnd_global.user_id,

514: batchstatus = l_batch_status,
515: bepcode = null,
516: bepmessage = null,
517: last_update_date = sysdate,
518: last_updated_by = fnd_global.user_id,
519: last_update_login = fnd_global.conc_login_id,
520: object_version_number = object_version_number + 1
521: WHERE batchid = p_iby_batchid
522: AND payeeid = p_payerid;

Line 519: last_update_login = fnd_global.conc_login_id,

515: bepcode = null,
516: bepmessage = null,
517: last_update_date = sysdate,
518: last_updated_by = fnd_global.user_id,
519: last_update_login = fnd_global.conc_login_id,
520: object_version_number = object_version_number + 1
521: WHERE batchid = p_iby_batchid
522: AND payeeid = p_payerid;
523: