699: IF (x_mode = 'I') THEN
700: x_last_updated_by := 1;
701: x_last_update_login := 0;
702: ELSIF (x_mode = 'R') THEN
703: x_last_updated_by := fnd_global.user_id;
704: IF x_last_updated_by IS NULL THEN
705: x_last_updated_by := -1;
706: END IF;
707: x_last_update_login := fnd_global.login_id;
703: x_last_updated_by := fnd_global.user_id;
704: IF x_last_updated_by IS NULL THEN
705: x_last_updated_by := -1;
706: END IF;
707: x_last_update_login := fnd_global.login_id;
708: IF x_last_update_login IS NULL THEN
709: x_last_update_login := -1;
710: END IF;
711: x_request_id := fnd_global.conc_request_id;
707: x_last_update_login := fnd_global.login_id;
708: IF x_last_update_login IS NULL THEN
709: x_last_update_login := -1;
710: END IF;
711: x_request_id := fnd_global.conc_request_id;
712: x_program_id := fnd_global.conc_program_id;
713: x_program_application_id := fnd_global.prog_appl_id;
714: IF (x_request_id = -1) THEN
715: x_request_id := NULL;
708: IF x_last_update_login IS NULL THEN
709: x_last_update_login := -1;
710: END IF;
711: x_request_id := fnd_global.conc_request_id;
712: x_program_id := fnd_global.conc_program_id;
713: x_program_application_id := fnd_global.prog_appl_id;
714: IF (x_request_id = -1) THEN
715: x_request_id := NULL;
716: x_program_id := NULL;
709: x_last_update_login := -1;
710: END IF;
711: x_request_id := fnd_global.conc_request_id;
712: x_program_id := fnd_global.conc_program_id;
713: x_program_application_id := fnd_global.prog_appl_id;
714: IF (x_request_id = -1) THEN
715: x_request_id := NULL;
716: x_program_id := NULL;
717: x_program_application_id := NULL;
1009: IF (x_mode = 'I') THEN
1010: x_last_updated_by := 1;
1011: x_last_update_login := 0;
1012: ELSIF (x_mode = 'R') THEN
1013: x_last_updated_by := fnd_global.user_id;
1014: IF x_last_updated_by IS NULL THEN
1015: x_last_updated_by := -1;
1016: END IF;
1017: x_last_update_login := fnd_global.login_id;
1013: x_last_updated_by := fnd_global.user_id;
1014: IF x_last_updated_by IS NULL THEN
1015: x_last_updated_by := -1;
1016: END IF;
1017: x_last_update_login := fnd_global.login_id;
1018: IF x_last_update_login IS NULL THEN
1019: x_last_update_login := -1;
1020: END IF;
1021: x_request_id := fnd_global.conc_request_id;
1017: x_last_update_login := fnd_global.login_id;
1018: IF x_last_update_login IS NULL THEN
1019: x_last_update_login := -1;
1020: END IF;
1021: x_request_id := fnd_global.conc_request_id;
1022: x_program_id := fnd_global.conc_program_id;
1023: x_program_application_id := fnd_global.prog_appl_id;
1024: IF (x_request_id = -1) THEN
1025: x_request_id := NULL;
1018: IF x_last_update_login IS NULL THEN
1019: x_last_update_login := -1;
1020: END IF;
1021: x_request_id := fnd_global.conc_request_id;
1022: x_program_id := fnd_global.conc_program_id;
1023: x_program_application_id := fnd_global.prog_appl_id;
1024: IF (x_request_id = -1) THEN
1025: x_request_id := NULL;
1026: x_program_id := NULL;
1019: x_last_update_login := -1;
1020: END IF;
1021: x_request_id := fnd_global.conc_request_id;
1022: x_program_id := fnd_global.conc_program_id;
1023: x_program_application_id := fnd_global.prog_appl_id;
1024: IF (x_request_id = -1) THEN
1025: x_request_id := NULL;
1026: x_program_id := NULL;
1027: x_program_application_id := NULL;