1332: UPDATE CS_ESTIMATE_DETAILS
1333: SET submit_restriction_message = (submit_restriction_message || lx_msg_data),
1334: line_submitted = p_line_submitted,
1335: last_update_date = sysdate, -- bug 8838622
1336: last_update_login = fnd_global.login_id, -- bug 8838622
1337: last_updated_by = fnd_global.user_id -- bug 8838622
1338: WHERE Estimate_Detail_Id = p_estimate_detail_id
1339: AND incident_id = p_incident_id;
1340:
1333: SET submit_restriction_message = (submit_restriction_message || lx_msg_data),
1334: line_submitted = p_line_submitted,
1335: last_update_date = sysdate, -- bug 8838622
1336: last_update_login = fnd_global.login_id, -- bug 8838622
1337: last_updated_by = fnd_global.user_id -- bug 8838622
1338: WHERE Estimate_Detail_Id = p_estimate_detail_id
1339: AND incident_id = p_incident_id;
1340:
1341:
1353: UPDATE CS_ESTIMATE_DETAILS
1354: SET submit_restriction_message = (submit_restriction_message || lx_msg_data),
1355: line_submitted = p_line_submitted,
1356: last_update_date = sysdate, -- bug 8838622
1357: last_update_login = fnd_global.login_id, -- bug 8838622
1358: last_updated_by = fnd_global.user_id -- bug 8838622
1359: WHERE incident_id = p_incident_id
1360: AND estimate_detail_id = chglnctTAB(t).estimate_detail_id;
1361:
1354: SET submit_restriction_message = (submit_restriction_message || lx_msg_data),
1355: line_submitted = p_line_submitted,
1356: last_update_date = sysdate, -- bug 8838622
1357: last_update_login = fnd_global.login_id, -- bug 8838622
1358: last_updated_by = fnd_global.user_id -- bug 8838622
1359: WHERE incident_id = p_incident_id
1360: AND estimate_detail_id = chglnctTAB(t).estimate_detail_id;
1361:
1362: END LOOP;
1378: UPDATE CS_ESTIMATE_DETAILS
1379: SET submit_restriction_message = NULL,
1380: line_submitted = p_line_submitted,
1381: last_update_date = sysdate, -- bug 8838622
1382: last_update_login = fnd_global.login_id, -- bug 8838622
1383: last_updated_by = fnd_global.user_id -- bug 8838622
1384: WHERE incident_id = p_incident_id
1385: AND estimate_detail_id = chglnctTAB(t).estimate_detail_id; -- For bug 5697830
1386:
1379: SET submit_restriction_message = NULL,
1380: line_submitted = p_line_submitted,
1381: last_update_date = sysdate, -- bug 8838622
1382: last_update_login = fnd_global.login_id, -- bug 8838622
1383: last_updated_by = fnd_global.user_id -- bug 8838622
1384: WHERE incident_id = p_incident_id
1385: AND estimate_detail_id = chglnctTAB(t).estimate_detail_id; -- For bug 5697830
1386:
1387: COMMIT;