DBA Data[Home] [Help]

APPS.DPP_CLAIMS_PVT dependencies on DPP_EXECUTION_DETAILS

Line 36: UPDATE DPP_EXECUTION_DETAILS

32: IS
33: PRAGMA AUTONOMOUS_TRANSACTION;
34: BEGIN
35: --Update the execution details table
36: UPDATE DPP_EXECUTION_DETAILS
37: SET EXECUTION_END_DATE = sysdate,
38: OUTPUT_XML = XMLTYPE(p_output_xml),
39: EXECUTION_STATUS = p_status,
40: LAST_UPDATED_BY = p_txn_hdr_rec.Last_Updated_By,

Line 1191: UPDATE DPP_EXECUTION_DETAILS

1187: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1189: END IF;
1190: /*--Update the execution details table
1191: UPDATE DPP_EXECUTION_DETAILS
1192: SET EXECUTION_END_DATE = sysdate,
1193: OUTPUT_XML = XMLTYPE(l_output_xml),
1194: EXECUTION_STATUS = l_status,
1195: LAST_UPDATED_BY = l_txn_hdr_rec.Last_Updated_By,

Line 1204: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update DPP_EXECUTION_DETAILS Table');

1200: WHERE EXECUTION_DETAIL_ID = l_txn_hdr_rec.Execution_Detail_ID
1201: AND transaction_header_id = l_txn_hdr_rec.Transaction_Header_ID;
1202:
1203: IF SQL%ROWCOUNT = 0 THEN
1204: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update DPP_EXECUTION_DETAILS Table');
1205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1206: END IF;
1207: */
1208: