DBA Data[Home] [Help]

APPS.DPP_EXECUTIONDETAILS_PVT dependencies on DPP_CUSTOMER_CLAIMS_ALL

Line 178: UPDATE DPP_customer_claims_all

174: WHERE transaction_header_id = l_EXE_UPDATE_rec.Transaction_Header_ID
175: AND transaction_line_id = l_status_Update_tbl(i).transaction_line_id;
176:
177: ELSIF l_process_code = 'CUSTINVCL' THEN
178: UPDATE DPP_customer_claims_all
179: SET supplier_claim_created = l_status_Update_tbl(i).Update_Status
180: ,object_version_number = object_version_number + 1
181: ,last_update_date = sysdate
182: ,last_updated_by = l_exe_update_rec.Last_Updated_By

Line 187: UPDATE DPP_customer_claims_all

183: WHERE transaction_header_id = l_EXE_UPDATE_rec.Transaction_Header_ID
184: AND customer_inv_line_id = l_status_Update_tbl(i).transaction_line_id;
185:
186: ELSIF l_process_code = 'CUSTCL' THEN
187: UPDATE DPP_customer_claims_all
188: SET customer_claim_created = l_status_Update_tbl(i).Update_Status
189: ,object_version_number = object_version_number + 1
190: ,last_update_date = sysdate
191: ,last_updated_by = l_exe_update_rec.Last_Updated_By