DBA Data[Home] [Help]

APPS.DPP_CLAIMS_PVT dependencies on DPP_TRANSACTION_LINES_ALL

Line 610: UPDATE DPP_TRANSACTION_LINES_ALL

606: --Assign the claim id to the corresponding lines
607: FOR i IN l_txn_line_tbl.FIRST..l_txn_line_tbl.LAST LOOP
608: --Insert into the output xml table to generate the error log
609: FOR get_claim_id_rec IN get_claim_id_csr (l_txn_line_tbl(i).transaction_line_id) LOOP
610: UPDATE DPP_TRANSACTION_LINES_ALL
611: SET supp_dist_claim_id = to_char(get_claim_id_rec.claim_id),
612: supp_dist_claim_status = 'Y',
613: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
614: last_updated_by = l_txn_hdr_rec.LAST_UPDATED_BY,

Line 620: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column supp_dist_claim_id in DPP_TRANSACTION_LINES_ALL Table');

616: last_update_login = l_txn_hdr_rec.LAST_UPDATED_BY
617: WHERE transaction_line_id = l_txn_line_tbl(i).transaction_line_id;
618:
619: IF SQL%ROWCOUNT = 0 THEN
620: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column supp_dist_claim_id in DPP_TRANSACTION_LINES_ALL Table');
621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
622: END IF;
623: END LOOP; --getting the claim id loop
624: END LOOP; --lines table loop