231: IF (x_mode = 'I') THEN
232: x_last_updated_by := 1;
233: x_last_update_login := 0;
234: ELSIF (x_mode = 'R') THEN
235: x_last_updated_by := fnd_global.user_id;
236: IF (x_last_updated_by IS NULL) THEN
237: x_last_updated_by := -1;
238: END IF;
239: x_last_update_login := fnd_global.login_id;
235: x_last_updated_by := fnd_global.user_id;
236: IF (x_last_updated_by IS NULL) THEN
237: x_last_updated_by := -1;
238: END IF;
239: x_last_update_login := fnd_global.login_id;
240: IF (x_last_update_login IS NULL) THEN
241: x_last_update_login := -1;
242: END IF;
243: x_request_id := fnd_global.conc_request_id;
239: x_last_update_login := fnd_global.login_id;
240: IF (x_last_update_login IS NULL) THEN
241: x_last_update_login := -1;
242: END IF;
243: x_request_id := fnd_global.conc_request_id;
244: x_program_id := fnd_global.conc_program_id;
245: x_program_application_id := fnd_global.prog_appl_id;
246:
247: IF (x_request_id = -1) THEN
240: IF (x_last_update_login IS NULL) THEN
241: x_last_update_login := -1;
242: END IF;
243: x_request_id := fnd_global.conc_request_id;
244: x_program_id := fnd_global.conc_program_id;
245: x_program_application_id := fnd_global.prog_appl_id;
246:
247: IF (x_request_id = -1) THEN
248: x_request_id := NULL;
241: x_last_update_login := -1;
242: END IF;
243: x_request_id := fnd_global.conc_request_id;
244: x_program_id := fnd_global.conc_program_id;
245: x_program_application_id := fnd_global.prog_appl_id;
246:
247: IF (x_request_id = -1) THEN
248: x_request_id := NULL;
249: x_program_id := NULL;
403: IF (X_MODE = 'I') THEN
404: x_last_updated_by := 1;
405: x_last_update_login := 0;
406: ELSIF (x_mode = 'R') THEN
407: x_last_updated_by := fnd_global.user_id;
408: IF x_last_updated_by IS NULL THEN
409: x_last_updated_by := -1;
410: END IF;
411: x_last_update_login := fnd_global.login_id;
407: x_last_updated_by := fnd_global.user_id;
408: IF x_last_updated_by IS NULL THEN
409: x_last_updated_by := -1;
410: END IF;
411: x_last_update_login := fnd_global.login_id;
412: IF (x_last_update_login IS NULL) THEN
413: x_last_update_login := -1;
414: END IF;
415: ELSE
434: x_last_update_login => x_last_update_login
435: );
436:
437: IF (x_mode = 'R') THEN
438: x_request_id := fnd_global.conc_request_id;
439: x_program_id := fnd_global.conc_program_id;
440: x_program_application_id := fnd_global.prog_appl_id;
441: IF (x_request_id = -1) THEN
442: x_request_id := old_references.request_id;
435: );
436:
437: IF (x_mode = 'R') THEN
438: x_request_id := fnd_global.conc_request_id;
439: x_program_id := fnd_global.conc_program_id;
440: x_program_application_id := fnd_global.prog_appl_id;
441: IF (x_request_id = -1) THEN
442: x_request_id := old_references.request_id;
443: x_program_id := old_references.program_id;
436:
437: IF (x_mode = 'R') THEN
438: x_request_id := fnd_global.conc_request_id;
439: x_program_id := fnd_global.conc_program_id;
440: x_program_application_id := fnd_global.prog_appl_id;
441: IF (x_request_id = -1) THEN
442: x_request_id := old_references.request_id;
443: x_program_id := old_references.program_id;
444: x_program_application_id := old_references.program_application_id;