2080: IF (x_mode = 'I') THEN
2081: x_last_updated_by := 1;
2082: x_last_update_login := 0;
2083: ELSIF (x_mode = 'R') THEN
2084: x_last_updated_by := fnd_global.user_id;
2085: IF (x_last_updated_by IS NULL) THEN
2086: x_last_updated_by := -1;
2087: END IF;
2088: x_last_update_login := fnd_global.login_id;
2084: x_last_updated_by := fnd_global.user_id;
2085: IF (x_last_updated_by IS NULL) THEN
2086: x_last_updated_by := -1;
2087: END IF;
2088: x_last_update_login := fnd_global.login_id;
2089: IF (x_last_update_login IS NULL) THEN
2090: x_last_update_login := -1;
2091: END IF;
2092: x_request_id := fnd_global.conc_request_id;
2088: x_last_update_login := fnd_global.login_id;
2089: IF (x_last_update_login IS NULL) THEN
2090: x_last_update_login := -1;
2091: END IF;
2092: x_request_id := fnd_global.conc_request_id;
2093: x_program_id := fnd_global.conc_program_id;
2094: x_program_application_id := fnd_global.prog_appl_id;
2095:
2096: IF (x_request_id = -1) THEN
2089: IF (x_last_update_login IS NULL) THEN
2090: x_last_update_login := -1;
2091: END IF;
2092: x_request_id := fnd_global.conc_request_id;
2093: x_program_id := fnd_global.conc_program_id;
2094: x_program_application_id := fnd_global.prog_appl_id;
2095:
2096: IF (x_request_id = -1) THEN
2097: x_request_id := NULL;
2090: x_last_update_login := -1;
2091: END IF;
2092: x_request_id := fnd_global.conc_request_id;
2093: x_program_id := fnd_global.conc_program_id;
2094: x_program_application_id := fnd_global.prog_appl_id;
2095:
2096: IF (x_request_id = -1) THEN
2097: x_request_id := NULL;
2098: x_program_id := NULL;
2568: IF (X_MODE = 'I') THEN
2569: x_last_updated_by := 1;
2570: x_last_update_login := 0;
2571: ELSIF (x_mode = 'R') THEN
2572: x_last_updated_by := fnd_global.user_id;
2573: IF x_last_updated_by IS NULL THEN
2574: x_last_updated_by := -1;
2575: END IF;
2576: x_last_update_login := fnd_global.login_id;
2572: x_last_updated_by := fnd_global.user_id;
2573: IF x_last_updated_by IS NULL THEN
2574: x_last_updated_by := -1;
2575: END IF;
2576: x_last_update_login := fnd_global.login_id;
2577: IF (x_last_update_login IS NULL) THEN
2578: x_last_update_login := -1;
2579: END IF;
2580: ELSE
2638:
2639: );
2640:
2641: IF (x_mode = 'R') THEN
2642: x_request_id := fnd_global.conc_request_id;
2643: x_program_id := fnd_global.conc_program_id;
2644: x_program_application_id := fnd_global.prog_appl_id;
2645: IF (x_request_id = -1) THEN
2646: x_request_id := old_references.request_id;
2639: );
2640:
2641: IF (x_mode = 'R') THEN
2642: x_request_id := fnd_global.conc_request_id;
2643: x_program_id := fnd_global.conc_program_id;
2644: x_program_application_id := fnd_global.prog_appl_id;
2645: IF (x_request_id = -1) THEN
2646: x_request_id := old_references.request_id;
2647: x_program_id := old_references.program_id;
2640:
2641: IF (x_mode = 'R') THEN
2642: x_request_id := fnd_global.conc_request_id;
2643: x_program_id := fnd_global.conc_program_id;
2644: x_program_application_id := fnd_global.prog_appl_id;
2645: IF (x_request_id = -1) THEN
2646: x_request_id := old_references.request_id;
2647: x_program_id := old_references.program_id;
2648: x_program_application_id := old_references.program_application_id;