DBA Data[Home] [Help]

APPS.DPP_BUSINESSEVENTS_PVT dependencies on DPP_EXECUTION_DETAILS

Line 1279: --Check if the event subscription can be raised or not before inserting into the DPP_EXECUTION_DETAILS table

1275: SAVEPOINT Raise_Workflow_Event;
1276:
1277: --Get a unique value for the l_new_item_key key
1278: l_new_item_key := TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
1279: --Check if the event subscription can be raised or not before inserting into the DPP_EXECUTION_DETAILS table
1280: l_event_test := wf_event.test(l_event_name);
1281: IF l_event_test = 'NONE' THEN
1282: DPP_UTILITY_PVT.debug_message('No enabled local subscriptions reference the event, or the event does not exist.');
1283: RAISE FND_API.g_exc_error;

Line 1290: --Insert a line in to the DPP_EXECUTION_DETAILS table corresponding to the process which has been started

1286: DPP_UTILITY_PVT.debug_message('Number of rows Processed : '||p_row_count);
1287: END IF;
1288: --Check if the xml has any rows processed and raise the event
1289: IF p_row_count > 0 THEN
1290: --Insert a line in to the DPP_EXECUTION_DETAILS table corresponding to the process which has been started
1291: BEGIN
1292: INSERT INTO DPP_EXECUTION_DETAILS (EXECUTION_DETAIL_ID,
1293: object_version_number,
1294: TRANSACTION_HEADER_ID,

Line 1292: INSERT INTO DPP_EXECUTION_DETAILS (EXECUTION_DETAIL_ID,

1288: --Check if the xml has any rows processed and raise the event
1289: IF p_row_count > 0 THEN
1290: --Insert a line in to the DPP_EXECUTION_DETAILS table corresponding to the process which has been started
1291: BEGIN
1292: INSERT INTO DPP_EXECUTION_DETAILS (EXECUTION_DETAIL_ID,
1293: object_version_number,
1294: TRANSACTION_HEADER_ID,
1295: PROCESS_CODE,
1296: INPUT_XML,