[Home] [Help]
86: /*-- This cursor checks the existence of the Enigma Route in the staging table with status as pending.
87: CURSOR check_route_exists (p_route_id IN VARCHAR2)
88: IS
89: SELECT 'X'
90: FROM AHL_RT_OPER_INTERFACE
91: WHERE ROUTE_ID = p_route_id
92: AND STATUS = 'PENDING';*/
93:
94: -- This cursor is used to fetch the details of the routes that exists in the staging table with status PENDING
103: ENIGMA_ID,
104: CHANGE_FLAG,
105: PDF
106: FROM
107: AHL_RT_OPER_INTERFACE
108: WHERE
109: STATUS = 'PENDING'
110: AND PARENT_ROUTE_ID IS NULL;
111:
121: PARENT_ROUTE_ID,
122: ENIGMA_ID,
123: CHANGE_FLAG
124: FROM
125: AHL_RT_OPER_INTERFACE
126: WHERE PARENT_ROUTE_ID = p_route_id
127: AND STATUS = 'PENDING';
128:
129: -- Declare local variables
216: END IF;
217:
218: -- Delete all the routes in pending status from the stagin table
219: -- as they have already been queried by the cursor
220: DELETE FROM AHL_RT_OPER_INTERFACE
221: WHERE STATUS = 'PENDING' AND PARENT_ROUTE_ID IS NULL;
222:
223: -- Delete all the operations from the stagin table that are in the pending status
224: -- and that correspond to the parent route
222:
223: -- Delete all the operations from the stagin table that are in the pending status
224: -- and that correspond to the parent route
225:
226: DELETE FROM AHL_RT_OPER_INTERFACE
227: WHERE PARENT_ROUTE_ID = l_route_id AND STATUS = 'PENDING';
228:
229: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
230: THEN
589: 'Before Inserting into the staging table'
590: );
591: END IF;
592:
593: INSERT INTO AHL_RT_OPER_INTERFACE
594: (
595: CONTEXT,
596: PUBLISH_DATE,
597: ROUTE_ID,
766: 'Route is in Approval pending'
767: );
768: END IF;
769:
770: INSERT INTO AHL_RT_OPER_INTERFACE
771: (
772: CONTEXT,
773: PUBLISH_DATE,
774: ROUTE_ID,
821: 'Inserting the operations into the staging table'
822: );
823: END IF;
824:
825: INSERT INTO AHL_RT_OPER_INTERFACE
826: (
827: CONTEXT,
828: PUBLISH_DATE,
829: OPERATION_ID,
1110: );
1111: END IF;
1112:
1113: -- Insert the transaction record into the staging table, with status as success
1114: INSERT INTO AHL_RT_OPER_INTERFACE
1115: (
1116: CONTEXT,
1117: PUBLISH_DATE,
1118: ROUTE_ID,
1403: RAISE FND_API.G_EXC_ERROR;
1404: END IF;
1405:
1406: -- If the return status is success, then add the transaction to the stating table and status as "Success"
1407: INSERT INTO AHL_RT_OPER_INTERFACE
1408: (
1409: CONTEXT,
1410: PUBLISH_DATE,
1411: ROUTE_ID,
1798: );
1799: END IF;
1800:
1801: -- If the return status is success, then add the transaction to the stating table and status as "Success"
1802: INSERT INTO AHL_RT_OPER_INTERFACE
1803: (
1804: CONTEXT,
1805: PUBLISH_DATE,
1806: ROUTE_ID,
2166:
2167: -- IF the operation is in Approval Pending status , then insert the operation record into the
2168: -- staging table with status as pending.
2169: IF ( upper(l_get_latest_oper_rev.revision_status) = 'APPROVAL_PENDING' ) THEN
2170: INSERT INTO AHL_RT_OPER_INTERFACE
2171: (
2172: CONTEXT,
2173: PUBLISH_DATE,
2174: OPERATION_ID,
2310:
2311: -- If the operation is in Approval Pending status , then insert the operation record into the
2312: -- staging table with status as pending.
2313: IF ( upper(l_get_latest_oper_rev.revision_status) = 'APPROVAL_PENDING' ) THEN
2314: INSERT INTO AHL_RT_OPER_INTERFACE
2315: (
2316: CONTEXT,
2317: PUBLISH_DATE,
2318: OPERATION_ID,
2453: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation -> updation Successful');
2454: END IF;
2455:
2456: -- Insert the transaction record into the staging table, with status as success
2457: INSERT INTO AHL_RT_OPER_INTERFACE
2458: (
2459: CONTEXT,
2460: PUBLISH_DATE,
2461: OPERATION_ID,
2644: );
2645: END IF;
2646:
2647: -- Insert the transaction record into the staging table, with status as success
2648: INSERT INTO AHL_RT_OPER_INTERFACE
2649: (
2650: CONTEXT,
2651: PUBLISH_DATE,
2652: OPERATION_ID,
2811: );
2812: END IF;
2813:
2814: -- Insert the transaction record into the staging table, with status as success
2815: INSERT INTO AHL_RT_OPER_INTERFACE
2816: (
2817: CONTEXT,
2818: PUBLISH_DATE,
2819: OPERATION_ID,