918: IF (x_mode = 'I') THEN
919: x_last_updated_by := 1;
920: x_last_update_login := 0;
921: ELSIF (x_mode = 'R') THEN
922: x_last_updated_by := fnd_global.user_id;
923: IF x_last_updated_by IS NULL THEN
924: x_last_updated_by := -1;
925: END IF;
926: x_last_update_login := fnd_global.login_id;
922: x_last_updated_by := fnd_global.user_id;
923: IF x_last_updated_by IS NULL THEN
924: x_last_updated_by := -1;
925: END IF;
926: x_last_update_login := fnd_global.login_id;
927: IF x_last_update_login IS NULL THEN
928: x_last_update_login := -1;
929: END IF;
930: x_request_id := fnd_global.conc_request_id;
926: x_last_update_login := fnd_global.login_id;
927: IF x_last_update_login IS NULL THEN
928: x_last_update_login := -1;
929: END IF;
930: x_request_id := fnd_global.conc_request_id;
931: x_program_id := fnd_global.conc_program_id;
932: x_program_application_id := fnd_global.prog_appl_id;
933: IF (x_request_id = -1) THEN
934: x_request_id := NULL;
927: IF x_last_update_login IS NULL THEN
928: x_last_update_login := -1;
929: END IF;
930: x_request_id := fnd_global.conc_request_id;
931: x_program_id := fnd_global.conc_program_id;
932: x_program_application_id := fnd_global.prog_appl_id;
933: IF (x_request_id = -1) THEN
934: x_request_id := NULL;
935: x_program_id := NULL;
928: x_last_update_login := -1;
929: END IF;
930: x_request_id := fnd_global.conc_request_id;
931: x_program_id := fnd_global.conc_program_id;
932: x_program_application_id := fnd_global.prog_appl_id;
933: IF (x_request_id = -1) THEN
934: x_request_id := NULL;
935: x_program_id := NULL;
936: x_program_application_id := NULL;
1236: IF (x_mode = 'I') THEN
1237: x_last_updated_by := 1;
1238: x_last_update_login := 0;
1239: ELSIF (x_mode = 'R') THEN
1240: x_last_updated_by := fnd_global.user_id;
1241: IF x_last_updated_by IS NULL THEN
1242: x_last_updated_by := -1;
1243: END IF;
1244: x_last_update_login := fnd_global.login_id;
1240: x_last_updated_by := fnd_global.user_id;
1241: IF x_last_updated_by IS NULL THEN
1242: x_last_updated_by := -1;
1243: END IF;
1244: x_last_update_login := fnd_global.login_id;
1245: IF x_last_update_login IS NULL THEN
1246: x_last_update_login := -1;
1247: END IF;
1248: ELSE
1286: x_final_mandatory_type_code => x_final_mandatory_type_code,
1287: x_final_weight_qty => x_final_weight_qty
1288: );
1289: IF (x_mode = 'R') THEN
1290: x_request_id := fnd_global.conc_request_id;
1291: x_program_id := fnd_global.conc_program_id;
1292: x_program_application_id := fnd_global.prog_appl_id;
1293: IF (x_request_id = -1) THEN
1294: x_request_id := old_references.request_id;
1287: x_final_weight_qty => x_final_weight_qty
1288: );
1289: IF (x_mode = 'R') THEN
1290: x_request_id := fnd_global.conc_request_id;
1291: x_program_id := fnd_global.conc_program_id;
1292: x_program_application_id := fnd_global.prog_appl_id;
1293: IF (x_request_id = -1) THEN
1294: x_request_id := old_references.request_id;
1295: x_program_id := old_references.program_id;
1288: );
1289: IF (x_mode = 'R') THEN
1290: x_request_id := fnd_global.conc_request_id;
1291: x_program_id := fnd_global.conc_program_id;
1292: x_program_application_id := fnd_global.prog_appl_id;
1293: IF (x_request_id = -1) THEN
1294: x_request_id := old_references.request_id;
1295: x_program_id := old_references.program_id;
1296: x_program_application_id := old_references.program_application_id;