DBA Data[Home] [Help]

APPS.CS_CHG_AUTO_SUB_CON_PKG dependencies on FND_GLOBAL

Line 1336: last_update_login = fnd_global.login_id, -- bug 8838622

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:

Line 1337: last_updated_by = fnd_global.user_id -- bug 8838622

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:

Line 1357: last_update_login = fnd_global.login_id, -- bug 8838622

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:

Line 1358: last_updated_by = fnd_global.user_id -- bug 8838622

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;

Line 1382: last_update_login = fnd_global.login_id, -- bug 8838622

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:

Line 1383: last_updated_by = fnd_global.user_id -- bug 8838622

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;