1177: IF (x_mode = 'I') THEN
1178: x_last_updated_by := 1;
1179: x_last_update_login := 0;
1180: ELSIF (x_mode = 'R') THEN
1181: x_last_updated_by := fnd_global.user_id;
1182: IF (x_last_updated_by IS NULL) THEN
1183: x_last_updated_by := -1;
1184: END IF;
1185: x_last_update_login := fnd_global.login_id;
1181: x_last_updated_by := fnd_global.user_id;
1182: IF (x_last_updated_by IS NULL) THEN
1183: x_last_updated_by := -1;
1184: END IF;
1185: x_last_update_login := fnd_global.login_id;
1186: IF (x_last_update_login IS NULL) THEN
1187: x_last_update_login := -1;
1188: END IF;
1189: x_request_id := fnd_global.conc_request_id;
1185: x_last_update_login := fnd_global.login_id;
1186: IF (x_last_update_login IS NULL) THEN
1187: x_last_update_login := -1;
1188: END IF;
1189: x_request_id := fnd_global.conc_request_id;
1190: x_program_id := fnd_global.conc_program_id;
1191: x_program_application_id := fnd_global.prog_appl_id;
1192:
1193: IF (x_request_id = -1) THEN
1186: IF (x_last_update_login IS NULL) THEN
1187: x_last_update_login := -1;
1188: END IF;
1189: x_request_id := fnd_global.conc_request_id;
1190: x_program_id := fnd_global.conc_program_id;
1191: x_program_application_id := fnd_global.prog_appl_id;
1192:
1193: IF (x_request_id = -1) THEN
1194: x_request_id := NULL;
1187: x_last_update_login := -1;
1188: END IF;
1189: x_request_id := fnd_global.conc_request_id;
1190: x_program_id := fnd_global.conc_program_id;
1191: x_program_application_id := fnd_global.prog_appl_id;
1192:
1193: IF (x_request_id = -1) THEN
1194: x_request_id := NULL;
1195: x_program_id := NULL;
2135: IF (X_MODE = 'I') THEN
2136: x_last_updated_by := 1;
2137: x_last_update_login := 0;
2138: ELSIF (x_mode = 'R') THEN
2139: x_last_updated_by := fnd_global.user_id;
2140: IF x_last_updated_by IS NULL THEN
2141: x_last_updated_by := -1;
2142: END IF;
2143: x_last_update_login := fnd_global.login_id;
2139: x_last_updated_by := fnd_global.user_id;
2140: IF x_last_updated_by IS NULL THEN
2141: x_last_updated_by := -1;
2142: END IF;
2143: x_last_update_login := fnd_global.login_id;
2144: IF (x_last_update_login IS NULL) THEN
2145: x_last_update_login := -1;
2146: END IF;
2147: ELSE
2285:
2286: );
2287:
2288: IF (x_mode = 'R') THEN
2289: x_request_id := fnd_global.conc_request_id;
2290: x_program_id := fnd_global.conc_program_id;
2291: x_program_application_id := fnd_global.prog_appl_id;
2292: IF (x_request_id = -1) THEN
2293: x_request_id := old_references.request_id;
2286: );
2287:
2288: IF (x_mode = 'R') THEN
2289: x_request_id := fnd_global.conc_request_id;
2290: x_program_id := fnd_global.conc_program_id;
2291: x_program_application_id := fnd_global.prog_appl_id;
2292: IF (x_request_id = -1) THEN
2293: x_request_id := old_references.request_id;
2294: x_program_id := old_references.program_id;
2287:
2288: IF (x_mode = 'R') THEN
2289: x_request_id := fnd_global.conc_request_id;
2290: x_program_id := fnd_global.conc_program_id;
2291: x_program_application_id := fnd_global.prog_appl_id;
2292: IF (x_request_id = -1) THEN
2293: x_request_id := old_references.request_id;
2294: x_program_id := old_references.program_id;
2295: x_program_application_id := old_references.program_application_id;