209: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_processing_pkg.insert_request_details';
210:
211: BEGIN
212:
213: ln_conc_request_id := FND_PROFILE.value('CONC_REQUEST_ID');
214:
215: OPEN c_request_date(ln_conc_request_id);
216: FETCH c_request_date INTO ln_conc_request_date;
217: CLOSE c_request_date;
244: FND_GLOBAL.user_id,
245: sysdate,
246: fnd_global.user_id,
247: fnd_global.login_id,
248: fnd_profile.value('PROG_APPL_ID'),
249: fnd_profile.value('CONC_PROGRAM_ID'),
250: fnd_profile.value('CONC_LOGIN_ID')
251: ) RETURNING batch_id INTO p_batch_id;
252:
245: sysdate,
246: fnd_global.user_id,
247: fnd_global.login_id,
248: fnd_profile.value('PROG_APPL_ID'),
249: fnd_profile.value('CONC_PROGRAM_ID'),
250: fnd_profile.value('CONC_LOGIN_ID')
251: ) RETURNING batch_id INTO p_batch_id;
252:
253:
246: fnd_global.user_id,
247: fnd_global.login_id,
248: fnd_profile.value('PROG_APPL_ID'),
249: fnd_profile.value('CONC_PROGRAM_ID'),
250: fnd_profile.value('CONC_LOGIN_ID')
251: ) RETURNING batch_id INTO p_batch_id;
252:
253:
254: /* Added by Ramananda for bug#4407165 */