APPS.AHL_RM_APPROVAL_PVT dependencies on AHL_ROUTES_B

Line 811: From ahl_routes_b

807:
808: --bachandr Enigma Phase I changes -- start
809: --snarkhed Enigma Phase II changes to identify automatic enigma routes.
810: Select ENIGMA_ROUTE_ID into l_enigma_route_id
811: From ahl_routes_b
812: Where route_id = p_source_route_id;
813:
814: IF ( l_enigma_route_id is not null)
815: THEN

Line 903: UPDATE AHL_ROUTES_B

899: END IF;
900:
901: IF l_ACTIVE='Y'
902: THEN
903: UPDATE AHL_ROUTES_B
904: SET REVISION_STATUS_CODE=l_upd_status,
905: OBJECT_VERSION_number=OBJECT_VERSION_number+1
906: WHERE ROUTE_ID=p_source_route_id
907: and OBJECT_VERSION_NUMBER=p_object_Version_number;

Line 942: UPDATE AHL_ROUTES_B

938: P_WORKFLOWPROCESS =>l_process_name,
939: P_ITEM_TYPE =>'AHLGAPP');
940:
941: ELSE
942: UPDATE AHL_ROUTES_B
943: SET REVISION_STATUS_CODE=l_upd_status,
944: OBJECT_VERSION_number=OBJECT_VERSION_number+1
945: WHERE ROUTE_ID=p_source_route_id
946: and OBJECT_VERSION_NUMBER=p_object_Version_number;

Line 1149: UPDATE AHL_ROUTES_B

1145:
1146: CLOSE GetRouteDet;
1147: IF l_check_flag='Y' and p_appr_status='REJECTED'
1148: Then
1149: UPDATE AHL_ROUTES_B
1150: SET REVISION_STATUS_CODE=l_status,
1151: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
1152: WHERE ROUTE_ID=P_ROUTE_ID;
1153:

Line 1160: UPDATE AHL_ROUTES_B

1156: WHERE ROUTE_ID=P_ROUTE_ID;
1157: Elsif l_check_flag='Y' and l_curr_status='TERMINATION_PENDING' and
1158: p_appr_status='APPROVED'
1159: Then
1160: UPDATE AHL_ROUTES_B
1161: SET REVISION_STATUS_CODE='TERMINATED',
1162: -- START_DATE_ACTIVE=l_fr_date,
1163: END_DATE_ACTIVE=l_to_date,
1164: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1

Line 1193: UPDATE AHL_ROUTES_B

1189: END IF;
1190: Elsif l_check_flag='Y' and l_route_rec.revision_number=1 and
1191: l_curr_status='APPROVAL_PENDING' AND p_appr_status='APPROVED'
1192: THEN
1193: UPDATE AHL_ROUTES_B
1194: SET REVISION_STATUS_CODE=l_status,
1195: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
1196: WHERE ROUTE_ID=P_ROUTE_ID;
1197:

Line 1232: UPDATE AHL_ROUTES_B

1228:
1229: IF l_check_flag2='Y'
1230: THEN
1231:
1232: UPDATE AHL_ROUTES_B
1233: SET REVISION_STATUS_CODE= l_status,
1234: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
1235: START_DATE_ACTIVE=l_fr_date
1236: WHERE ROUTE_ID=P_ROUTE_ID;

Line 1240: UPDATE AHL_ROUTES_B

1236: WHERE ROUTE_ID=P_ROUTE_ID;
1237:
1238: IF l_check_flag3='Y'
1239: THEN
1240: UPDATE AHL_ROUTES_B
1241: SET REVISION_STATUS_CODE= l_status,
1242: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
1243: END_DATE_ACTIVE=l_to_date
1244: WHERE ROUTE_ID=l_prev_route_rec.ROUTE_ID;

Line 1377: UPDATE AHL_ROUTES_B

1373: END IF;
1374: END IF;
1375:
1376: else
1377: UPDATE AHL_ROUTES_B
1378: SET REVISION_STATUS_CODE= l_status,
1379: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
1380: END_DATE_ACTIVE=l_to_date
1381: WHERE ROUTE_ID=l_prev_route_rec.ROUTE_ID;