251: -- obtain program and user info
252:
253: l_trolin_tbl(i).last_update_date := SYSDATE;
254:
255: l_trolin_tbl(i).last_update_login := fnd_global.login_id;
256:
257: if l_trolin_tbl(i).last_update_login = -1 THEN
258: l_trolin_tbl(i).last_update_login :=
259: fnd_global.conc_login_id;
255: l_trolin_tbl(i).last_update_login := fnd_global.login_id;
256:
257: if l_trolin_tbl(i).last_update_login = -1 THEN
258: l_trolin_tbl(i).last_update_login :=
259: fnd_global.conc_login_id;
260: end if;
261: l_trolin_tbl(i).last_updated_by := fnd_global.user_id;
262: l_trolin_tbl(i).program_id := fnd_global.conc_program_id;
263: l_trolin_tbl(i).program_update_date := SYSDATE;
257: if l_trolin_tbl(i).last_update_login = -1 THEN
258: l_trolin_tbl(i).last_update_login :=
259: fnd_global.conc_login_id;
260: end if;
261: l_trolin_tbl(i).last_updated_by := fnd_global.user_id;
262: l_trolin_tbl(i).program_id := fnd_global.conc_program_id;
263: l_trolin_tbl(i).program_update_date := SYSDATE;
264: l_trolin_tbl(i).request_id := fnd_global.conc_request_id;
265: l_trolin_tbl(i).program_application_id :=
258: l_trolin_tbl(i).last_update_login :=
259: fnd_global.conc_login_id;
260: end if;
261: l_trolin_tbl(i).last_updated_by := fnd_global.user_id;
262: l_trolin_tbl(i).program_id := fnd_global.conc_program_id;
263: l_trolin_tbl(i).program_update_date := SYSDATE;
264: l_trolin_tbl(i).request_id := fnd_global.conc_request_id;
265: l_trolin_tbl(i).program_application_id :=
266: fnd_global.prog_appl_id;
260: end if;
261: l_trolin_tbl(i).last_updated_by := fnd_global.user_id;
262: l_trolin_tbl(i).program_id := fnd_global.conc_program_id;
263: l_trolin_tbl(i).program_update_date := SYSDATE;
264: l_trolin_tbl(i).request_id := fnd_global.conc_request_id;
265: l_trolin_tbl(i).program_application_id :=
266: fnd_global.prog_appl_id;
267:
268: IF (l_debug = 1) THEN
262: l_trolin_tbl(i).program_id := fnd_global.conc_program_id;
263: l_trolin_tbl(i).program_update_date := SYSDATE;
264: l_trolin_tbl(i).request_id := fnd_global.conc_request_id;
265: l_trolin_tbl(i).program_application_id :=
266: fnd_global.prog_appl_id;
267:
268: IF (l_debug = 1) THEN
269: TraceLog('calling update_row of trolin', 'Pick Confirm');
270: END IF;
363: -- obtain program and user info
364:
365: l_trolin_tbl(1).last_update_date := SYSDATE;
366:
367: l_trolin_tbl(1).last_update_login := fnd_global.login_id;
368:
369: if l_trolin_tbl(1).last_update_login = -1 THEN
370: l_trolin_tbl(1).last_update_login :=
371: fnd_global.conc_login_id;
367: l_trolin_tbl(1).last_update_login := fnd_global.login_id;
368:
369: if l_trolin_tbl(1).last_update_login = -1 THEN
370: l_trolin_tbl(1).last_update_login :=
371: fnd_global.conc_login_id;
372: end if;
373: l_trolin_tbl(1).last_updated_by := fnd_global.user_id;
374: l_trolin_tbl(1).program_id := fnd_global.conc_program_id;
375: l_trolin_tbl(1).program_update_date := SYSDATE;
369: if l_trolin_tbl(1).last_update_login = -1 THEN
370: l_trolin_tbl(1).last_update_login :=
371: fnd_global.conc_login_id;
372: end if;
373: l_trolin_tbl(1).last_updated_by := fnd_global.user_id;
374: l_trolin_tbl(1).program_id := fnd_global.conc_program_id;
375: l_trolin_tbl(1).program_update_date := SYSDATE;
376: l_trolin_tbl(1).request_id := fnd_global.conc_request_id;
377: l_trolin_tbl(1).program_application_id :=
370: l_trolin_tbl(1).last_update_login :=
371: fnd_global.conc_login_id;
372: end if;
373: l_trolin_tbl(1).last_updated_by := fnd_global.user_id;
374: l_trolin_tbl(1).program_id := fnd_global.conc_program_id;
375: l_trolin_tbl(1).program_update_date := SYSDATE;
376: l_trolin_tbl(1).request_id := fnd_global.conc_request_id;
377: l_trolin_tbl(1).program_application_id :=
378: fnd_global.prog_appl_id;
372: end if;
373: l_trolin_tbl(1).last_updated_by := fnd_global.user_id;
374: l_trolin_tbl(1).program_id := fnd_global.conc_program_id;
375: l_trolin_tbl(1).program_update_date := SYSDATE;
376: l_trolin_tbl(1).request_id := fnd_global.conc_request_id;
377: l_trolin_tbl(1).program_application_id :=
378: fnd_global.prog_appl_id;
379: inv_trolin_util.update_row(l_trolin_tbl(1));
380: --end if;
374: l_trolin_tbl(1).program_id := fnd_global.conc_program_id;
375: l_trolin_tbl(1).program_update_date := SYSDATE;
376: l_trolin_tbl(1).request_id := fnd_global.conc_request_id;
377: l_trolin_tbl(1).program_application_id :=
378: fnd_global.prog_appl_id;
379: inv_trolin_util.update_row(l_trolin_tbl(1));
380: --end if;
381: end loop;
382: end if;