637: IF (x_mode = 'I') THEN
638: x_last_updated_by := 1;
639: x_last_update_login := 0;
640: ELSIF (x_mode = 'R') THEN
641: x_last_updated_by := fnd_global.user_id;
642: IF (x_last_updated_by IS NULL) THEN
643: x_last_updated_by := -1;
644: END IF;
645: x_last_update_login := fnd_global.login_id;
641: x_last_updated_by := fnd_global.user_id;
642: IF (x_last_updated_by IS NULL) THEN
643: x_last_updated_by := -1;
644: END IF;
645: x_last_update_login := fnd_global.login_id;
646: IF (x_last_update_login IS NULL) THEN
647: x_last_update_login := -1;
648: END IF;
649: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
645: x_last_update_login := fnd_global.login_id;
646: IF (x_last_update_login IS NULL) THEN
647: x_last_update_login := -1;
648: END IF;
649: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
650: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
651: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
652:
653: IF (x_request_id = -1) THEN
646: IF (x_last_update_login IS NULL) THEN
647: x_last_update_login := -1;
648: END IF;
649: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
650: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
651: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
652:
653: IF (x_request_id = -1) THEN
654: x_request_id := NULL;
647: x_last_update_login := -1;
648: END IF;
649: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
650: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
651: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
652:
653: IF (x_request_id = -1) THEN
654: x_request_id := NULL;
655: x_program_id := NULL;
1340: IF (X_MODE = 'I') THEN
1341: x_last_updated_by := 1;
1342: x_last_update_login := 0;
1343: ELSIF (x_mode = 'R') THEN
1344: x_last_updated_by := fnd_global.user_id;
1345: IF x_last_updated_by IS NULL THEN
1346: x_last_updated_by := -1;
1347: END IF;
1348: x_last_update_login := fnd_global.login_id;
1344: x_last_updated_by := fnd_global.user_id;
1345: IF x_last_updated_by IS NULL THEN
1346: x_last_updated_by := -1;
1347: END IF;
1348: x_last_update_login := fnd_global.login_id;
1349: IF (x_last_update_login IS NULL) THEN
1350: x_last_update_login := -1;
1351: END IF;
1352: ELSE
1444: x_cs2_years_at_address_txt => x_cs2_years_at_address_txt
1445: );
1446:
1447: IF (x_mode = 'R') THEN
1448: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1449: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1450: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
1451: IF (x_request_id = -1) THEN
1452: x_request_id := old_references.request_id;
1445: );
1446:
1447: IF (x_mode = 'R') THEN
1448: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1449: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1450: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
1451: IF (x_request_id = -1) THEN
1452: x_request_id := old_references.request_id;
1453: x_program_id := old_references.program_id;
1446:
1447: IF (x_mode = 'R') THEN
1448: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1449: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1450: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
1451: IF (x_request_id = -1) THEN
1452: x_request_id := old_references.request_id;
1453: x_program_id := old_references.program_id;
1454: x_program_application_id := old_references.program_application_id;