APPS.AHL_RM_APPROVAL_PVT dependencies on AHL_MR_ROUTE_SEQUENCES

Line 1033: SELECT * FROM AHL_MR_ROUTE_SEQUENCES

1029: l_seq_rel_mr_route_id NUMBER:=0;
1030: -- Route Sequences
1031: CURSOR CurGetRouteSeqDet(C_MR_ROUTE_ID NUMBER)
1032: iS
1033: SELECT * FROM AHL_MR_ROUTE_SEQUENCES
1034: WHERE (MR_ROUTE_ID=C_MR_ROUTE_ID OR RELATED_MR_ROUTE_ID=C_MR_ROUTE_ID);
1035:
1036: l_mr_route_seq_rec CurGetRouteSeqDet%rowtype;
1037: l_rowid VARCHAR2(30);

Line 1237: SELECT AHL_MR_ROUTE_SEQUENCES_S .NEXTVAL

1233: LOOP
1234: FETCH CurGetRouteSeqDet INTO l_mr_route_seq_rec;
1235: IF CurGetRouteSeqDet%FOUND
1236: THEN
1237: SELECT AHL_MR_ROUTE_SEQUENCES_S .NEXTVAL
1238: INTO l_new_mr_ROUTE_SEQ_ID FROM DUAL;
1239: IF l_mr_route_seq_rec.mr_route_id=l_old_mr_route_id
1240: THEN
1241: l_seq_rel_mr_route_id:=l_mr_route_seq_rec.related_mr_route_id;

Line 1249: AHL_MR_ROUTE_SEQUENCES_PKG.INSERT_ROW (

1245: THEN
1246: l_seq_mr_route_id:=l_mr_route_seq_rec.mr_route_id;
1247: l_seq_rel_mr_route_id:=l_new_mr_ROUTE_ID;
1248: END IF;
1249: AHL_MR_ROUTE_SEQUENCES_PKG.INSERT_ROW (
1250: X_MR_ROUTE_SEQUENCE_ID =>l_new_mr_route_seq_id,
1251: X_RELATED_MR_ROUTE_ID =>l_seq_rel_mr_route_id,
1252: X_SEQUENCE_CODE =>l_mr_route_seq_rec.SEQUENCE_CODE,
1253: X_MR_ROUTE_ID =>l_seq_mr_route_id,