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 1175: UPDATE DPP_EXECUTION_DETAILS

1171: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: END IF;
1174: /*--Update the execution details table
1175: UPDATE DPP_EXECUTION_DETAILS
1176: SET EXECUTION_END_DATE = sysdate,
1177: OUTPUT_XML = XMLTYPE(l_output_xml),
1178: EXECUTION_STATUS = l_status,
1179: LAST_UPDATED_BY = l_txn_hdr_rec.Last_Updated_By,

Line 1188: DPP_UTILITY_PVT.debug_message('Unable to Update DPP_EXECUTION_DETAILS Table');

1184: WHERE EXECUTION_DETAIL_ID = l_txn_hdr_rec.Execution_Detail_ID
1185: AND transaction_header_id = l_txn_hdr_rec.Transaction_Header_ID;
1186:
1187: IF SQL%ROWCOUNT = 0 THEN
1188: DPP_UTILITY_PVT.debug_message('Unable to Update DPP_EXECUTION_DETAILS Table');
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1190: END IF;
1191: */
1192: