427: IF (x_mode = 'I') THEN
428: x_last_updated_by := 1;
429: x_last_update_login := 0;
430: ELSIF (x_mode = 'R') THEN
431: x_last_updated_by := fnd_global.user_id;
432: IF (x_last_updated_by IS NULL) THEN
433: x_last_updated_by := -1;
434: END IF;
435: x_last_update_login := fnd_global.login_id;
431: x_last_updated_by := fnd_global.user_id;
432: IF (x_last_updated_by IS NULL) THEN
433: x_last_updated_by := -1;
434: END IF;
435: x_last_update_login := fnd_global.login_id;
436: IF (x_last_update_login IS NULL) THEN
437: x_last_update_login := -1;
438: END IF;
439: x_request_id := fnd_global.conc_request_id;
435: x_last_update_login := fnd_global.login_id;
436: IF (x_last_update_login IS NULL) THEN
437: x_last_update_login := -1;
438: END IF;
439: x_request_id := fnd_global.conc_request_id;
440: x_program_id := fnd_global.conc_program_id;
441: x_program_application_id := fnd_global.prog_appl_id;
442:
443: IF (x_request_id = -1) THEN
436: IF (x_last_update_login IS NULL) THEN
437: x_last_update_login := -1;
438: END IF;
439: x_request_id := fnd_global.conc_request_id;
440: x_program_id := fnd_global.conc_program_id;
441: x_program_application_id := fnd_global.prog_appl_id;
442:
443: IF (x_request_id = -1) THEN
444: x_request_id := NULL;
437: x_last_update_login := -1;
438: END IF;
439: x_request_id := fnd_global.conc_request_id;
440: x_program_id := fnd_global.conc_program_id;
441: x_program_application_id := fnd_global.prog_appl_id;
442:
443: IF (x_request_id = -1) THEN
444: x_request_id := NULL;
445: x_program_id := NULL;
804: IF (X_MODE = 'I') THEN
805: x_last_updated_by := 1;
806: x_last_update_login := 0;
807: ELSIF (x_mode = 'R') THEN
808: x_last_updated_by := fnd_global.user_id;
809: IF x_last_updated_by IS NULL THEN
810: x_last_updated_by := -1;
811: END IF;
812: x_last_update_login := fnd_global.login_id;
808: x_last_updated_by := fnd_global.user_id;
809: IF x_last_updated_by IS NULL THEN
810: x_last_updated_by := -1;
811: END IF;
812: x_last_update_login := fnd_global.login_id;
813: IF (x_last_update_login IS NULL) THEN
814: x_last_update_login := -1;
815: END IF;
816: ELSE
862: x_notification_date => x_notification_date
863: );
864:
865: IF (x_mode = 'R') THEN
866: x_request_id := fnd_global.conc_request_id;
867: x_program_id := fnd_global.conc_program_id;
868: x_program_application_id := fnd_global.prog_appl_id;
869: IF (x_request_id = -1) THEN
870: x_request_id := old_references.request_id;
863: );
864:
865: IF (x_mode = 'R') THEN
866: x_request_id := fnd_global.conc_request_id;
867: x_program_id := fnd_global.conc_program_id;
868: x_program_application_id := fnd_global.prog_appl_id;
869: IF (x_request_id = -1) THEN
870: x_request_id := old_references.request_id;
871: x_program_id := old_references.program_id;
864:
865: IF (x_mode = 'R') THEN
866: x_request_id := fnd_global.conc_request_id;
867: x_program_id := fnd_global.conc_program_id;
868: x_program_application_id := fnd_global.prog_appl_id;
869: IF (x_request_id = -1) THEN
870: x_request_id := old_references.request_id;
871: x_program_id := old_references.program_id;
872: x_program_application_id := old_references.program_application_id;