321: IF (x_mode = 'I') THEN
322: x_last_updated_by := 1;
323: x_last_update_login := 0;
324: ELSIF (x_mode = 'R') THEN
325: x_last_updated_by := fnd_global.user_id;
326: IF (x_last_updated_by IS NULL) THEN
327: x_last_updated_by := -1;
328: END IF;
329: x_last_update_login := fnd_global.login_id;
325: x_last_updated_by := fnd_global.user_id;
326: IF (x_last_updated_by IS NULL) THEN
327: x_last_updated_by := -1;
328: END IF;
329: x_last_update_login := fnd_global.login_id;
330: IF (x_last_update_login IS NULL) THEN
331: x_last_update_login := -1;
332: END IF;
333: x_request_id := fnd_global.conc_request_id;
329: x_last_update_login := fnd_global.login_id;
330: IF (x_last_update_login IS NULL) THEN
331: x_last_update_login := -1;
332: END IF;
333: x_request_id := fnd_global.conc_request_id;
334: x_program_id := fnd_global.conc_program_id;
335: x_program_application_id := fnd_global.prog_appl_id;
336:
337: IF (x_request_id = -1) THEN
330: IF (x_last_update_login IS NULL) THEN
331: x_last_update_login := -1;
332: END IF;
333: x_request_id := fnd_global.conc_request_id;
334: x_program_id := fnd_global.conc_program_id;
335: x_program_application_id := fnd_global.prog_appl_id;
336:
337: IF (x_request_id = -1) THEN
338: x_request_id := NULL;
331: x_last_update_login := -1;
332: END IF;
333: x_request_id := fnd_global.conc_request_id;
334: x_program_id := fnd_global.conc_program_id;
335: x_program_application_id := fnd_global.prog_appl_id;
336:
337: IF (x_request_id = -1) THEN
338: x_request_id := NULL;
339: x_program_id := NULL;
565: IF (X_MODE = 'I') THEN
566: x_last_updated_by := 1;
567: x_last_update_login := 0;
568: ELSIF (x_mode = 'R') THEN
569: x_last_updated_by := fnd_global.user_id;
570: IF x_last_updated_by IS NULL THEN
571: x_last_updated_by := -1;
572: END IF;
573: x_last_update_login := fnd_global.login_id;
569: x_last_updated_by := fnd_global.user_id;
570: IF x_last_updated_by IS NULL THEN
571: x_last_updated_by := -1;
572: END IF;
573: x_last_update_login := fnd_global.login_id;
574: IF (x_last_update_login IS NULL) THEN
575: x_last_update_login := -1;
576: END IF;
577: ELSE
604: x_last_update_login => x_last_update_login
605: );
606:
607: IF (x_mode = 'R') THEN
608: x_request_id := fnd_global.conc_request_id;
609: x_program_id := fnd_global.conc_program_id;
610: x_program_application_id := fnd_global.prog_appl_id;
611: IF (x_request_id = -1) THEN
612: x_request_id := old_references.request_id;
605: );
606:
607: IF (x_mode = 'R') THEN
608: x_request_id := fnd_global.conc_request_id;
609: x_program_id := fnd_global.conc_program_id;
610: x_program_application_id := fnd_global.prog_appl_id;
611: IF (x_request_id = -1) THEN
612: x_request_id := old_references.request_id;
613: x_program_id := old_references.program_id;
606:
607: IF (x_mode = 'R') THEN
608: x_request_id := fnd_global.conc_request_id;
609: x_program_id := fnd_global.conc_program_id;
610: x_program_application_id := fnd_global.prog_appl_id;
611: IF (x_request_id = -1) THEN
612: x_request_id := old_references.request_id;
613: x_program_id := old_references.program_id;
614: x_program_application_id := old_references.program_application_id;