APPS.DPP_CLAIMS_PVT dependencies on DPP_TRANSACTION_LINES_ALL

Line 601: UPDATE DPP_TRANSACTION_LINES_ALL

597: --Assign the claim id to the corresponding lines
598: FOR i IN l_txn_line_tbl.FIRST..l_txn_line_tbl.LAST LOOP
599: --Insert into the output xml table to generate the error log
600: FOR get_claim_id_rec IN get_claim_id_csr (l_txn_line_tbl(i).transaction_line_id) LOOP
601: UPDATE DPP_TRANSACTION_LINES_ALL
602: SET supp_dist_claim_id = to_char(get_claim_id_rec.claim_id),
603: supp_dist_claim_status = 'Y',
604: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
605: last_updated_by = l_txn_hdr_rec.LAST_UPDATED_BY,

Line 611: DPP_UTILITY_PVT.debug_message('Unable to Update the column supp_dist_claim_id in DPP_TRANSACTION_LINES_ALL Table');

607: last_update_login = l_txn_hdr_rec.LAST_UPDATED_BY
608: WHERE transaction_line_id = l_txn_line_tbl(i).transaction_line_id;
609:
610: IF SQL%ROWCOUNT = 0 THEN
611: DPP_UTILITY_PVT.debug_message('Unable to Update the column supp_dist_claim_id in DPP_TRANSACTION_LINES_ALL Table');
612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: END IF;
614: END LOOP; --getting the claim id loop
615: END LOOP; --lines table loop