201: IF (x_mode = 'I') THEN
202: x_last_updated_by := 1;
203: x_last_update_login := 0;
204: ELSIF (x_mode = 'R') THEN
205: x_last_updated_by := fnd_global.user_id;
206: IF (x_last_updated_by IS NULL) THEN
207: x_last_updated_by := -1;
208: END IF;
209: x_last_update_login := fnd_global.login_id;
205: x_last_updated_by := fnd_global.user_id;
206: IF (x_last_updated_by IS NULL) THEN
207: x_last_updated_by := -1;
208: END IF;
209: x_last_update_login := fnd_global.login_id;
210: IF (x_last_update_login IS NULL) THEN
211: x_last_update_login := -1;
212: END IF;
213: x_request_id := fnd_global.conc_request_id;
209: x_last_update_login := fnd_global.login_id;
210: IF (x_last_update_login IS NULL) THEN
211: x_last_update_login := -1;
212: END IF;
213: x_request_id := fnd_global.conc_request_id;
214: x_program_id := fnd_global.conc_program_id;
215: x_program_application_id := fnd_global.prog_appl_id;
216:
217: IF (x_request_id = -1) THEN
210: IF (x_last_update_login IS NULL) THEN
211: x_last_update_login := -1;
212: END IF;
213: x_request_id := fnd_global.conc_request_id;
214: x_program_id := fnd_global.conc_program_id;
215: x_program_application_id := fnd_global.prog_appl_id;
216:
217: IF (x_request_id = -1) THEN
218: x_request_id := NULL;
211: x_last_update_login := -1;
212: END IF;
213: x_request_id := fnd_global.conc_request_id;
214: x_program_id := fnd_global.conc_program_id;
215: x_program_application_id := fnd_global.prog_appl_id;
216:
217: IF (x_request_id = -1) THEN
218: x_request_id := NULL;
219: x_program_id := NULL;
364: IF (X_MODE = 'I') THEN
365: x_last_updated_by := 1;
366: x_last_update_login := 0;
367: ELSIF (x_mode = 'R') THEN
368: x_last_updated_by := fnd_global.user_id;
369: IF x_last_updated_by IS NULL THEN
370: x_last_updated_by := -1;
371: END IF;
372: x_last_update_login := fnd_global.login_id;
368: x_last_updated_by := fnd_global.user_id;
369: IF x_last_updated_by IS NULL THEN
370: x_last_updated_by := -1;
371: END IF;
372: x_last_update_login := fnd_global.login_id;
373: IF (x_last_update_login IS NULL) THEN
374: x_last_update_login := -1;
375: END IF;
376: ELSE
392: x_last_update_login => x_last_update_login
393: );
394:
395: IF (x_mode = 'R') THEN
396: x_request_id := fnd_global.conc_request_id;
397: x_program_id := fnd_global.conc_program_id;
398: x_program_application_id := fnd_global.prog_appl_id;
399: IF (x_request_id = -1) THEN
400: x_request_id := old_references.request_id;
393: );
394:
395: IF (x_mode = 'R') THEN
396: x_request_id := fnd_global.conc_request_id;
397: x_program_id := fnd_global.conc_program_id;
398: x_program_application_id := fnd_global.prog_appl_id;
399: IF (x_request_id = -1) THEN
400: x_request_id := old_references.request_id;
401: x_program_id := old_references.program_id;
394:
395: IF (x_mode = 'R') THEN
396: x_request_id := fnd_global.conc_request_id;
397: x_program_id := fnd_global.conc_program_id;
398: x_program_application_id := fnd_global.prog_appl_id;
399: IF (x_request_id = -1) THEN
400: x_request_id := old_references.request_id;
401: x_program_id := old_references.program_id;
402: x_program_application_id := old_references.program_application_id;