259: IF (x_mode = 'I') THEN
260: x_last_updated_by := 1;
261: x_last_update_login := 0;
262: ELSIF (X_MODE IN ('R', 'S')) THEN
263: x_last_updated_by := fnd_global.user_id;
264: IF (x_last_updated_by IS NULL) THEN
265: x_last_updated_by := -1;
266: END IF;
267: x_last_update_login := fnd_global.login_id;
263: x_last_updated_by := fnd_global.user_id;
264: IF (x_last_updated_by IS NULL) THEN
265: x_last_updated_by := -1;
266: END IF;
267: x_last_update_login := fnd_global.login_id;
268: IF (x_last_update_login IS NULL) THEN
269: x_last_update_login := -1;
270: END IF;
271: x_request_id := fnd_global.conc_request_id;
267: x_last_update_login := fnd_global.login_id;
268: IF (x_last_update_login IS NULL) THEN
269: x_last_update_login := -1;
270: END IF;
271: x_request_id := fnd_global.conc_request_id;
272: x_program_id := fnd_global.conc_program_id;
273: x_program_application_id := fnd_global.prog_appl_id;
274:
275: IF (x_request_id = -1) THEN
268: IF (x_last_update_login IS NULL) THEN
269: x_last_update_login := -1;
270: END IF;
271: x_request_id := fnd_global.conc_request_id;
272: x_program_id := fnd_global.conc_program_id;
273: x_program_application_id := fnd_global.prog_appl_id;
274:
275: IF (x_request_id = -1) THEN
276: x_request_id := NULL;
269: x_last_update_login := -1;
270: END IF;
271: x_request_id := fnd_global.conc_request_id;
272: x_program_id := fnd_global.conc_program_id;
273: x_program_application_id := fnd_global.prog_appl_id;
274:
275: IF (x_request_id = -1) THEN
276: x_request_id := NULL;
277: x_program_id := NULL;
463: IF (X_MODE = 'I') THEN
464: x_last_updated_by := 1;
465: x_last_update_login := 0;
466: ELSIF (X_MODE IN ('R', 'S')) THEN
467: x_last_updated_by := fnd_global.user_id;
468: IF x_last_updated_by IS NULL THEN
469: x_last_updated_by := -1;
470: END IF;
471: x_last_update_login := fnd_global.login_id;
467: x_last_updated_by := fnd_global.user_id;
468: IF x_last_updated_by IS NULL THEN
469: x_last_updated_by := -1;
470: END IF;
471: x_last_update_login := fnd_global.login_id;
472: IF (x_last_update_login IS NULL) THEN
473: x_last_update_login := -1;
474: END IF;
475: ELSE
494: x_last_update_login => x_last_update_login
495: );
496:
497: IF (X_MODE IN ('R', 'S')) THEN
498: x_request_id := fnd_global.conc_request_id;
499: x_program_id := fnd_global.conc_program_id;
500: x_program_application_id := fnd_global.prog_appl_id;
501: IF (x_request_id = -1) THEN
502: x_request_id := old_references.request_id;
495: );
496:
497: IF (X_MODE IN ('R', 'S')) THEN
498: x_request_id := fnd_global.conc_request_id;
499: x_program_id := fnd_global.conc_program_id;
500: x_program_application_id := fnd_global.prog_appl_id;
501: IF (x_request_id = -1) THEN
502: x_request_id := old_references.request_id;
503: x_program_id := old_references.program_id;
496:
497: IF (X_MODE IN ('R', 'S')) THEN
498: x_request_id := fnd_global.conc_request_id;
499: x_program_id := fnd_global.conc_program_id;
500: x_program_application_id := fnd_global.prog_appl_id;
501: IF (x_request_id = -1) THEN
502: x_request_id := old_references.request_id;
503: x_program_id := old_references.program_id;
504: x_program_application_id := old_references.program_application_id;