323: IF (x_mode = 'I') THEN
324: x_last_updated_by := 1;
325: x_last_update_login := 0;
326: ELSIF (x_mode = 'R') THEN
327: x_last_updated_by := fnd_global.user_id;
328: IF (x_last_updated_by IS NULL) THEN
329: x_last_updated_by := -1;
330: END IF;
331: x_last_update_login := fnd_global.login_id;
327: x_last_updated_by := fnd_global.user_id;
328: IF (x_last_updated_by IS NULL) THEN
329: x_last_updated_by := -1;
330: END IF;
331: x_last_update_login := fnd_global.login_id;
332: IF (x_last_update_login IS NULL) THEN
333: x_last_update_login := -1;
334: END IF;
335: x_request_id := fnd_global.conc_request_id;
331: x_last_update_login := fnd_global.login_id;
332: IF (x_last_update_login IS NULL) THEN
333: x_last_update_login := -1;
334: END IF;
335: x_request_id := fnd_global.conc_request_id;
336: x_program_id := fnd_global.conc_program_id;
337: x_program_application_id := fnd_global.prog_appl_id;
338:
339: IF (x_request_id = -1) THEN
332: IF (x_last_update_login IS NULL) THEN
333: x_last_update_login := -1;
334: END IF;
335: x_request_id := fnd_global.conc_request_id;
336: x_program_id := fnd_global.conc_program_id;
337: x_program_application_id := fnd_global.prog_appl_id;
338:
339: IF (x_request_id = -1) THEN
340: x_request_id := NULL;
333: x_last_update_login := -1;
334: END IF;
335: x_request_id := fnd_global.conc_request_id;
336: x_program_id := fnd_global.conc_program_id;
337: x_program_application_id := fnd_global.prog_appl_id;
338:
339: IF (x_request_id = -1) THEN
340: x_request_id := NULL;
341: x_program_id := NULL;
490: IF (X_MODE = 'I') THEN
491: x_last_updated_by := 1;
492: x_last_update_login := 0;
493: ELSIF (x_mode = 'R') THEN
494: x_last_updated_by := fnd_global.user_id;
495: IF x_last_updated_by IS NULL THEN
496: x_last_updated_by := -1;
497: END IF;
498: x_last_update_login := fnd_global.login_id;
494: x_last_updated_by := fnd_global.user_id;
495: IF x_last_updated_by IS NULL THEN
496: x_last_updated_by := -1;
497: END IF;
498: x_last_update_login := fnd_global.login_id;
499: IF (x_last_update_login IS NULL) THEN
500: x_last_update_login := -1;
501: END IF;
502: ELSE
518: x_last_update_login => x_last_update_login
519: );
520:
521: IF (x_mode = 'R') THEN
522: x_request_id := fnd_global.conc_request_id;
523: x_program_id := fnd_global.conc_program_id;
524: x_program_application_id := fnd_global.prog_appl_id;
525: IF (x_request_id = -1) THEN
526: x_request_id := old_references.request_id;
519: );
520:
521: IF (x_mode = 'R') THEN
522: x_request_id := fnd_global.conc_request_id;
523: x_program_id := fnd_global.conc_program_id;
524: x_program_application_id := fnd_global.prog_appl_id;
525: IF (x_request_id = -1) THEN
526: x_request_id := old_references.request_id;
527: x_program_id := old_references.program_id;
520:
521: IF (x_mode = 'R') THEN
522: x_request_id := fnd_global.conc_request_id;
523: x_program_id := fnd_global.conc_program_id;
524: x_program_application_id := fnd_global.prog_appl_id;
525: IF (x_request_id = -1) THEN
526: x_request_id := old_references.request_id;
527: x_program_id := old_references.program_id;
528: x_program_application_id := old_references.program_application_id;