APPS.AHL_RM_APPROVAL_PVT dependencies on AHL_ROUTES_B

Line 753: From ahl_routes_b

749: THEN
750:
751: --bachandr Enigma Phase I changes -- start
752: Select ENIGMA_DOC_ID into l_enigma_doc_id
753: From ahl_routes_b
754: Where route_id = p_source_route_id;
755:
756: IF ( l_enigma_doc_id is not null)
757: THEN

Line 845: UPDATE AHL_ROUTES_B

841: END IF;
842:
843: IF l_ACTIVE='Y'
844: THEN
845: UPDATE AHL_ROUTES_B
846: SET REVISION_STATUS_CODE=l_upd_status,
847: OBJECT_VERSION_number=OBJECT_VERSION_number+1
848: WHERE ROUTE_ID=p_source_route_id
849: and OBJECT_VERSION_NUMBER=p_object_Version_number;

Line 884: UPDATE AHL_ROUTES_B

880: P_WORKFLOWPROCESS =>l_process_name,
881: P_ITEM_TYPE =>'AHLGAPP');
882:
883: ELSE
884: UPDATE AHL_ROUTES_B
885: SET REVISION_STATUS_CODE=l_upd_status,
886: OBJECT_VERSION_number=OBJECT_VERSION_number+1
887: WHERE ROUTE_ID=p_source_route_id
888: and OBJECT_VERSION_NUMBER=p_object_Version_number;

Line 1091: UPDATE AHL_ROUTES_B

1087:
1088: CLOSE GetRouteDet;
1089: IF l_check_flag='Y' and p_appr_status='REJECTED'
1090: Then
1091: UPDATE AHL_ROUTES_B
1092: SET REVISION_STATUS_CODE=l_status,
1093: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
1094: WHERE ROUTE_ID=P_ROUTE_ID;
1095:

Line 1102: UPDATE AHL_ROUTES_B

1098: WHERE ROUTE_ID=P_ROUTE_ID;
1099: Elsif l_check_flag='Y' and l_curr_status='TERMINATION_PENDING' and
1100: p_appr_status='APPROVED'
1101: Then
1102: UPDATE AHL_ROUTES_B
1103: SET REVISION_STATUS_CODE='TERMINATED',
1104: -- START_DATE_ACTIVE=l_fr_date,
1105: END_DATE_ACTIVE=l_to_date,
1106: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1

Line 1135: UPDATE AHL_ROUTES_B

1131: END IF;
1132: Elsif l_check_flag='Y' and l_route_rec.revision_number=1 and
1133: l_curr_status='APPROVAL_PENDING' AND p_appr_status='APPROVED'
1134: THEN
1135: UPDATE AHL_ROUTES_B
1136: SET REVISION_STATUS_CODE=l_status,
1137: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
1138: WHERE ROUTE_ID=P_ROUTE_ID;
1139:

Line 1174: UPDATE AHL_ROUTES_B

1170:
1171: IF l_check_flag2='Y'
1172: THEN
1173:
1174: UPDATE AHL_ROUTES_B
1175: SET REVISION_STATUS_CODE= l_status,
1176: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
1177: START_DATE_ACTIVE=l_fr_date
1178: WHERE ROUTE_ID=P_ROUTE_ID;

Line 1182: UPDATE AHL_ROUTES_B

1178: WHERE ROUTE_ID=P_ROUTE_ID;
1179:
1180: IF l_check_flag3='Y'
1181: THEN
1182: UPDATE AHL_ROUTES_B
1183: SET REVISION_STATUS_CODE= l_status,
1184: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
1185: END_DATE_ACTIVE=l_to_date
1186: WHERE ROUTE_ID=l_prev_route_rec.ROUTE_ID;

Line 1317: UPDATE AHL_ROUTES_B

1313: END IF;
1314: END IF;
1315:
1316: else
1317: UPDATE AHL_ROUTES_B
1318: SET REVISION_STATUS_CODE= l_status,
1319: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
1320: END_DATE_ACTIVE=l_to_date
1321: WHERE ROUTE_ID=l_prev_route_rec.ROUTE_ID;