342: IF (x_mode = 'I') THEN
343: x_last_updated_by := 1;
344: x_last_update_login := 0;
345: ELSIF (x_mode = 'R') THEN
346: x_last_updated_by := fnd_global.user_id;
347: IF (x_last_updated_by IS NULL) THEN
348: x_last_updated_by := -1;
349: END IF;
350: x_last_update_login := fnd_global.login_id;
346: x_last_updated_by := fnd_global.user_id;
347: IF (x_last_updated_by IS NULL) THEN
348: x_last_updated_by := -1;
349: END IF;
350: x_last_update_login := fnd_global.login_id;
351: IF (x_last_update_login IS NULL) THEN
352: x_last_update_login := -1;
353: END IF;
354: x_request_id := fnd_global.conc_request_id;
350: x_last_update_login := fnd_global.login_id;
351: IF (x_last_update_login IS NULL) THEN
352: x_last_update_login := -1;
353: END IF;
354: x_request_id := fnd_global.conc_request_id;
355: x_program_id := fnd_global.conc_program_id;
356: x_program_application_id := fnd_global.prog_appl_id;
357:
358: IF (x_request_id = -1) THEN
351: IF (x_last_update_login IS NULL) THEN
352: x_last_update_login := -1;
353: END IF;
354: x_request_id := fnd_global.conc_request_id;
355: x_program_id := fnd_global.conc_program_id;
356: x_program_application_id := fnd_global.prog_appl_id;
357:
358: IF (x_request_id = -1) THEN
359: x_request_id := NULL;
352: x_last_update_login := -1;
353: END IF;
354: x_request_id := fnd_global.conc_request_id;
355: x_program_id := fnd_global.conc_program_id;
356: x_program_application_id := fnd_global.prog_appl_id;
357:
358: IF (x_request_id = -1) THEN
359: x_request_id := NULL;
360: x_program_id := NULL;
516: IF (X_MODE = 'I') THEN
517: x_last_updated_by := 1;
518: x_last_update_login := 0;
519: ELSIF (x_mode = 'R') THEN
520: x_last_updated_by := fnd_global.user_id;
521: IF x_last_updated_by IS NULL THEN
522: x_last_updated_by := -1;
523: END IF;
524: x_last_update_login := fnd_global.login_id;
520: x_last_updated_by := fnd_global.user_id;
521: IF x_last_updated_by IS NULL THEN
522: x_last_updated_by := -1;
523: END IF;
524: x_last_update_login := fnd_global.login_id;
525: IF (x_last_update_login IS NULL) THEN
526: x_last_update_login := -1;
527: END IF;
528: ELSE
545: x_last_update_login => x_last_update_login
546: );
547:
548: IF (x_mode = 'R') THEN
549: x_request_id := fnd_global.conc_request_id;
550: x_program_id := fnd_global.conc_program_id;
551: x_program_application_id := fnd_global.prog_appl_id;
552: IF (x_request_id = -1) THEN
553: x_request_id := old_references.request_id;
546: );
547:
548: IF (x_mode = 'R') THEN
549: x_request_id := fnd_global.conc_request_id;
550: x_program_id := fnd_global.conc_program_id;
551: x_program_application_id := fnd_global.prog_appl_id;
552: IF (x_request_id = -1) THEN
553: x_request_id := old_references.request_id;
554: x_program_id := old_references.program_id;
547:
548: IF (x_mode = 'R') THEN
549: x_request_id := fnd_global.conc_request_id;
550: x_program_id := fnd_global.conc_program_id;
551: x_program_application_id := fnd_global.prog_appl_id;
552: IF (x_request_id = -1) THEN
553: x_request_id := old_references.request_id;
554: x_program_id := old_references.program_id;
555: x_program_application_id := old_references.program_application_id;