1129: IF (x_mode = 'I') THEN
1130: x_last_updated_by := 1;
1131: x_last_update_login := 0;
1132: ELSIF (x_mode = 'R') THEN
1133: x_last_updated_by := fnd_global.user_id;
1134: IF (x_last_updated_by IS NULL) THEN
1135: x_last_updated_by := -1;
1136: END IF;
1137: x_last_update_login := fnd_global.login_id;
1133: x_last_updated_by := fnd_global.user_id;
1134: IF (x_last_updated_by IS NULL) THEN
1135: x_last_updated_by := -1;
1136: END IF;
1137: x_last_update_login := fnd_global.login_id;
1138: IF (x_last_update_login IS NULL) THEN
1139: x_last_update_login := -1;
1140: END IF;
1141: x_request_id := fnd_global.conc_request_id;
1137: x_last_update_login := fnd_global.login_id;
1138: IF (x_last_update_login IS NULL) THEN
1139: x_last_update_login := -1;
1140: END IF;
1141: x_request_id := fnd_global.conc_request_id;
1142: x_program_id := fnd_global.conc_program_id;
1143: x_program_application_id := fnd_global.prog_appl_id;
1144:
1145: IF (x_request_id = -1) THEN
1138: IF (x_last_update_login IS NULL) THEN
1139: x_last_update_login := -1;
1140: END IF;
1141: x_request_id := fnd_global.conc_request_id;
1142: x_program_id := fnd_global.conc_program_id;
1143: x_program_application_id := fnd_global.prog_appl_id;
1144:
1145: IF (x_request_id = -1) THEN
1146: x_request_id := NULL;
1139: x_last_update_login := -1;
1140: END IF;
1141: x_request_id := fnd_global.conc_request_id;
1142: x_program_id := fnd_global.conc_program_id;
1143: x_program_application_id := fnd_global.prog_appl_id;
1144:
1145: IF (x_request_id = -1) THEN
1146: x_request_id := NULL;
1147: x_program_id := NULL;
1636: IF (X_MODE = 'I') THEN
1637: x_last_updated_by := 1;
1638: x_last_update_login := 0;
1639: ELSIF (x_mode = 'R') THEN
1640: x_last_updated_by := fnd_global.user_id;
1641: IF x_last_updated_by IS NULL THEN
1642: x_last_updated_by := -1;
1643: END IF;
1644: x_last_update_login := fnd_global.login_id;
1640: x_last_updated_by := fnd_global.user_id;
1641: IF x_last_updated_by IS NULL THEN
1642: x_last_updated_by := -1;
1643: END IF;
1644: x_last_update_login := fnd_global.login_id;
1645: IF (x_last_update_login IS NULL) THEN
1646: x_last_update_login := -1;
1647: END IF;
1648: ELSE
1705: x_publish_in_ss_flag => x_publish_in_ss_flag
1706: );
1707:
1708: IF (x_mode = 'R') THEN
1709: x_request_id := fnd_global.conc_request_id;
1710: x_program_id := fnd_global.conc_program_id;
1711: x_program_application_id := fnd_global.prog_appl_id;
1712: IF (x_request_id = -1) THEN
1713: x_request_id := old_references.request_id;
1706: );
1707:
1708: IF (x_mode = 'R') THEN
1709: x_request_id := fnd_global.conc_request_id;
1710: x_program_id := fnd_global.conc_program_id;
1711: x_program_application_id := fnd_global.prog_appl_id;
1712: IF (x_request_id = -1) THEN
1713: x_request_id := old_references.request_id;
1714: x_program_id := old_references.program_id;
1707:
1708: IF (x_mode = 'R') THEN
1709: x_request_id := fnd_global.conc_request_id;
1710: x_program_id := fnd_global.conc_program_id;
1711: x_program_application_id := fnd_global.prog_appl_id;
1712: IF (x_request_id = -1) THEN
1713: x_request_id := old_references.request_id;
1714: x_program_id := old_references.program_id;
1715: x_program_application_id := old_references.program_application_id;