DBA Data[Home] [Help]

APPS.QPR_POLICY_EVAL dependencies on FND_GLOBAL

Line 201: fnd_global.user_id,

197: last_updated_by,
198: last_update_login)
199: values(qpr_policies_s.nextval, 'N',
200: sysdate,
201: fnd_global.user_id,
202: sysdate,
203: fnd_global.user_id,
204: fnd_global.login_id)
205: returning POLICY_ID into l_new_pol_id;

Line 203: fnd_global.user_id,

199: values(qpr_policies_s.nextval, 'N',
200: sysdate,
201: fnd_global.user_id,
202: sysdate,
203: fnd_global.user_id,
204: fnd_global.login_id)
205: returning POLICY_ID into l_new_pol_id;
206:
207: for rec_pol in c_pol_tl loop

Line 204: fnd_global.login_id)

200: sysdate,
201: fnd_global.user_id,
202: sysdate,
203: fnd_global.user_id,
204: fnd_global.login_id)
205: returning POLICY_ID into l_new_pol_id;
206:
207: for rec_pol in c_pol_tl loop
208: if p_new_policy_name is not null then

Line 232: fnd_global.user_id,

228: rec_pol.source_lang,
229: l_pol_name,
230: rec_pol.description,
231: sysdate,
232: fnd_global.user_id,
233: sysdate,
234: fnd_global.user_id,
235: fnd_global.login_id);
236: end loop;

Line 234: fnd_global.user_id,

230: rec_pol.description,
231: sysdate,
232: fnd_global.user_id,
233: sysdate,
234: fnd_global.user_id,
235: fnd_global.login_id);
236: end loop;
237:
238: for rec_line in c_pol_line loop

Line 235: fnd_global.login_id);

231: sysdate,
232: fnd_global.user_id,
233: sysdate,
234: fnd_global.user_id,
235: fnd_global.login_id);
236: end loop;
237:
238: for rec_line in c_pol_line loop
239: insert into qpr_policy_lines(policy_line_id,

Line 265: fnd_global.user_id,

261: rec_line.effective_date_to,
262: rec_line.vlb_level_value,
263: rec_line.vlb_level_value_desc,
264: sysdate,
265: fnd_global.user_id,
266: sysdate,
267: fnd_global.user_id,
268: fnd_global.login_id);
269: end loop;

Line 267: fnd_global.user_id,

263: rec_line.vlb_level_value_desc,
264: sysdate,
265: fnd_global.user_id,
266: sysdate,
267: fnd_global.user_id,
268: fnd_global.login_id);
269: end loop;
270:
271: p_new_pol_id := l_new_pol_id;

Line 268: fnd_global.login_id);

264: sysdate,
265: fnd_global.user_id,
266: sysdate,
267: fnd_global.user_id,
268: fnd_global.login_id);
269: end loop;
270:
271: p_new_pol_id := l_new_pol_id;
272: p_new_policy_name := l_pol_name;

Line 418: FND_GLOBAL.USER_ID,

414: c_policy_data_rec.me_pol_imp_rank(I),
415: c_policy_data_rec.lo_pol_imp_rank(I),
416: c_policy_data_rec.rev_at_lis_price(I),
417: sysdate,
418: FND_GLOBAL.USER_ID,
419: sysdate,
420: FND_GLOBAL.USER_ID,
421: FND_GLOBAL.LOGIN_ID,
422: FND_GLOBAL.CONC_REQUEST_ID);

Line 420: FND_GLOBAL.USER_ID,

416: c_policy_data_rec.rev_at_lis_price(I),
417: sysdate,
418: FND_GLOBAL.USER_ID,
419: sysdate,
420: FND_GLOBAL.USER_ID,
421: FND_GLOBAL.LOGIN_ID,
422: FND_GLOBAL.CONC_REQUEST_ID);
423: log_debug('Inserted '|| sql%rowcount ||' records');
424: exception

Line 421: FND_GLOBAL.LOGIN_ID,

417: sysdate,
418: FND_GLOBAL.USER_ID,
419: sysdate,
420: FND_GLOBAL.USER_ID,
421: FND_GLOBAL.LOGIN_ID,
422: FND_GLOBAL.CONC_REQUEST_ID);
423: log_debug('Inserted '|| sql%rowcount ||' records');
424: exception
425: when others then

Line 422: FND_GLOBAL.CONC_REQUEST_ID);

418: FND_GLOBAL.USER_ID,
419: sysdate,
420: FND_GLOBAL.USER_ID,
421: FND_GLOBAL.LOGIN_ID,
422: FND_GLOBAL.CONC_REQUEST_ID);
423: log_debug('Inserted '|| sql%rowcount ||' records');
424: exception
425: when others then
426: errbuf := substr(SQLERRM,1,150);