APPS.AHL_RM_APPROVAL_PVT dependencies on AHL_MR_ROUTE_SEQUENCES

Line 1091: SELECT * FROM AHL_MR_ROUTE_SEQUENCES

1087: l_seq_rel_mr_route_id NUMBER:=0;
1088: -- Route Sequences
1089: CURSOR CurGetRouteSeqDet(C_MR_ROUTE_ID NUMBER)
1090: iS
1091: SELECT * FROM AHL_MR_ROUTE_SEQUENCES
1092: WHERE (MR_ROUTE_ID=C_MR_ROUTE_ID OR RELATED_MR_ROUTE_ID=C_MR_ROUTE_ID);
1093:
1094: l_mr_route_seq_rec CurGetRouteSeqDet%rowtype;
1095: l_rowid VARCHAR2(30);

Line 1297: SELECT AHL_MR_ROUTE_SEQUENCES_S .NEXTVAL

1293: LOOP
1294: FETCH CurGetRouteSeqDet INTO l_mr_route_seq_rec;
1295: IF CurGetRouteSeqDet%FOUND
1296: THEN
1297: SELECT AHL_MR_ROUTE_SEQUENCES_S .NEXTVAL
1298: INTO l_new_mr_ROUTE_SEQ_ID FROM DUAL;
1299: IF l_mr_route_seq_rec.mr_route_id=l_old_mr_route_id
1300: THEN
1301: l_seq_rel_mr_route_id:=l_mr_route_seq_rec.related_mr_route_id;

Line 1309: AHL_MR_ROUTE_SEQUENCES_PKG.INSERT_ROW (

1305: THEN
1306: l_seq_mr_route_id:=l_mr_route_seq_rec.mr_route_id;
1307: l_seq_rel_mr_route_id:=l_new_mr_ROUTE_ID;
1308: END IF;
1309: AHL_MR_ROUTE_SEQUENCES_PKG.INSERT_ROW (
1310: X_MR_ROUTE_SEQUENCE_ID =>l_new_mr_route_seq_id,
1311: X_RELATED_MR_ROUTE_ID =>l_seq_rel_mr_route_id,
1312: X_SEQUENCE_CODE =>l_mr_route_seq_rec.SEQUENCE_CODE,
1313: X_MR_ROUTE_ID =>l_seq_mr_route_id,