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;
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
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
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;
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
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,
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;
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;
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;
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);
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
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
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);