559: IF (NVL(x_mode,'R') = 'I') THEN
560: x_last_updated_by := 1;
561: x_last_update_login := 0;
562: ELSIF (NVL(x_mode,'R') = 'R') THEN
563: x_last_updated_by := fnd_global.user_id;
564: IF (x_last_updated_by IS NULL) THEN
565: x_last_updated_by := -1;
566: END IF;
567: x_last_update_login := fnd_global.login_id;
563: x_last_updated_by := fnd_global.user_id;
564: IF (x_last_updated_by IS NULL) THEN
565: x_last_updated_by := -1;
566: END IF;
567: x_last_update_login := fnd_global.login_id;
568: IF (x_last_update_login IS NULL) THEN
569: x_last_update_login := -1;
570: END IF;
571: x_request_id := fnd_global.conc_request_id;
567: x_last_update_login := fnd_global.login_id;
568: IF (x_last_update_login IS NULL) THEN
569: x_last_update_login := -1;
570: END IF;
571: x_request_id := fnd_global.conc_request_id;
572: x_program_id := fnd_global.conc_program_id;
573: x_program_application_id := fnd_global.prog_appl_id;
574:
575: IF (x_request_id = -1) THEN
568: IF (x_last_update_login IS NULL) THEN
569: x_last_update_login := -1;
570: END IF;
571: x_request_id := fnd_global.conc_request_id;
572: x_program_id := fnd_global.conc_program_id;
573: x_program_application_id := fnd_global.prog_appl_id;
574:
575: IF (x_request_id = -1) THEN
576: x_request_id := NULL;
569: x_last_update_login := -1;
570: END IF;
571: x_request_id := fnd_global.conc_request_id;
572: x_program_id := fnd_global.conc_program_id;
573: x_program_application_id := fnd_global.prog_appl_id;
574:
575: IF (x_request_id = -1) THEN
576: x_request_id := NULL;
577: x_program_id := NULL;
1096: IF (NVL(x_mode,'R') = 'I') THEN
1097: x_last_updated_by := 1;
1098: x_last_update_login := 0;
1099: ELSIF (NVL(x_mode,'R') = 'R') THEN
1100: x_last_updated_by := fnd_global.user_id;
1101: IF x_last_updated_by IS NULL THEN
1102: x_last_updated_by := -1;
1103: END IF;
1104: x_last_update_login := fnd_global.login_id;
1100: x_last_updated_by := fnd_global.user_id;
1101: IF x_last_updated_by IS NULL THEN
1102: x_last_updated_by := -1;
1103: END IF;
1104: x_last_update_login := fnd_global.login_id;
1105: IF (x_last_update_login IS NULL) THEN
1106: x_last_update_login := -1;
1107: END IF;
1108: ELSE
1177: x_attribute24 => x_attribute24
1178: );
1179:
1180: IF (NVL(x_mode,'R') = 'R') THEN
1181: x_request_id := fnd_global.conc_request_id;
1182: x_program_id := fnd_global.conc_program_id;
1183: x_program_application_id := fnd_global.prog_appl_id;
1184: IF (x_request_id = -1) THEN
1185: x_request_id := old_references.request_id;
1178: );
1179:
1180: IF (NVL(x_mode,'R') = 'R') THEN
1181: x_request_id := fnd_global.conc_request_id;
1182: x_program_id := fnd_global.conc_program_id;
1183: x_program_application_id := fnd_global.prog_appl_id;
1184: IF (x_request_id = -1) THEN
1185: x_request_id := old_references.request_id;
1186: x_program_id := old_references.program_id;
1179:
1180: IF (NVL(x_mode,'R') = 'R') THEN
1181: x_request_id := fnd_global.conc_request_id;
1182: x_program_id := fnd_global.conc_program_id;
1183: x_program_application_id := fnd_global.prog_appl_id;
1184: IF (x_request_id = -1) THEN
1185: x_request_id := old_references.request_id;
1186: x_program_id := old_references.program_id;
1187: x_program_application_id := old_references.program_application_id;