APPS.DPP_EXECUTIONDETAILS_PVT dependencies on DPP_EXECUTION_DETAILS

Line 87: FROM dpp_execution_details

83: l_exe_update_rec.execution_status := UPPER(l_exe_update_rec.execution_status);
84: BEGIN
85: SELECT process_code
86: INTO l_process_code
87: FROM dpp_execution_details
88: WHERE execution_detail_id = l_exe_update_rec.execution_detail_id;
89: EXCEPTION
90: WHEN NO_DATA_FOUND THEN
91: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module, 'Invalid Execution Detail ID: ' || l_exe_update_rec.execution_detail_id);

Line 95: UPDATE DPP_EXECUTION_DETAILS

91: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module, 'Invalid Execution Detail ID: ' || l_exe_update_rec.execution_detail_id);
92: RAISE FND_API.G_EXC_ERROR;
93: END;
94:
95: UPDATE DPP_EXECUTION_DETAILS
96: SET execution_end_date = sysdate
97: ,execution_status = DECODE(execution_status,'WARNING', execution_status, l_exe_update_rec.execution_status)
98: ,last_update_date = sysdate
99: ,last_updated_by = l_exe_update_rec.Last_Updated_By

Line 336: UPDATE dpp_execution_details

332:
333: --
334: -- API body
335: --
336: UPDATE dpp_execution_details
337: SET last_update_date = sysdate,
338: last_updated_by = fnd_global.user_id,
339: esb_instance_id = p_esb_instance_id,
340: object_version_number = object_version_number + 1