692: IF (x_mode = 'I') THEN
693: x_last_updated_by := 1;
694: x_last_update_login := 0;
695: ELSIF (x_mode = 'R') THEN
696: x_last_updated_by := fnd_global.user_id;
697: IF (x_last_updated_by IS NULL) THEN
698: x_last_updated_by := -1;
699: END IF;
700: x_last_update_login := fnd_global.login_id;
696: x_last_updated_by := fnd_global.user_id;
697: IF (x_last_updated_by IS NULL) THEN
698: x_last_updated_by := -1;
699: END IF;
700: x_last_update_login := fnd_global.login_id;
701: IF (x_last_update_login IS NULL) THEN
702: x_last_update_login := -1;
703: END IF;
704: x_request_id := fnd_global.conc_request_id;
700: x_last_update_login := fnd_global.login_id;
701: IF (x_last_update_login IS NULL) THEN
702: x_last_update_login := -1;
703: END IF;
704: x_request_id := fnd_global.conc_request_id;
705: x_program_id := fnd_global.conc_program_id;
706: x_program_application_id := fnd_global.prog_appl_id;
707:
708: IF (x_request_id = -1) THEN
701: IF (x_last_update_login IS NULL) THEN
702: x_last_update_login := -1;
703: END IF;
704: x_request_id := fnd_global.conc_request_id;
705: x_program_id := fnd_global.conc_program_id;
706: x_program_application_id := fnd_global.prog_appl_id;
707:
708: IF (x_request_id = -1) THEN
709: x_request_id := NULL;
702: x_last_update_login := -1;
703: END IF;
704: x_request_id := fnd_global.conc_request_id;
705: x_program_id := fnd_global.conc_program_id;
706: x_program_application_id := fnd_global.prog_appl_id;
707:
708: IF (x_request_id = -1) THEN
709: x_request_id := NULL;
710: x_program_id := NULL;
1211: IF (X_MODE = 'I') THEN
1212: x_last_updated_by := 1;
1213: x_last_update_login := 0;
1214: ELSIF (x_mode = 'R') THEN
1215: x_last_updated_by := fnd_global.user_id;
1216: IF x_last_updated_by IS NULL THEN
1217: x_last_updated_by := -1;
1218: END IF;
1219: x_last_update_login := fnd_global.login_id;
1215: x_last_updated_by := fnd_global.user_id;
1216: IF x_last_updated_by IS NULL THEN
1217: x_last_updated_by := -1;
1218: END IF;
1219: x_last_update_login := fnd_global.login_id;
1220: IF (x_last_update_login IS NULL) THEN
1221: x_last_update_login := -1;
1222: END IF;
1223: ELSE
1290:
1291: );
1292:
1293: IF (x_mode = 'R') THEN
1294: x_request_id := fnd_global.conc_request_id;
1295: x_program_id := fnd_global.conc_program_id;
1296: x_program_application_id := fnd_global.prog_appl_id;
1297: IF (x_request_id = -1) THEN
1298: x_request_id := old_references.request_id;
1291: );
1292:
1293: IF (x_mode = 'R') THEN
1294: x_request_id := fnd_global.conc_request_id;
1295: x_program_id := fnd_global.conc_program_id;
1296: x_program_application_id := fnd_global.prog_appl_id;
1297: IF (x_request_id = -1) THEN
1298: x_request_id := old_references.request_id;
1299: x_program_id := old_references.program_id;
1292:
1293: IF (x_mode = 'R') THEN
1294: x_request_id := fnd_global.conc_request_id;
1295: x_program_id := fnd_global.conc_program_id;
1296: x_program_application_id := fnd_global.prog_appl_id;
1297: IF (x_request_id = -1) THEN
1298: x_request_id := old_references.request_id;
1299: x_program_id := old_references.program_id;
1300: x_program_application_id := old_references.program_application_id;