APPS.AHL_FMP_MR_ROUTE_SEQNCE_PVT dependencies on AHL_MR_ROUTES_APP_V

Line 331: From AHL_MR_ROUTES_APP_V

327: as
328: CURSOR check_mr_route_id(C_MR_ROUTE_ID NUMBER)
329: IS
330: Select COUNT(*)
331: From AHL_MR_ROUTES_APP_V
332: Where MR_ROUTE_ID=C_MR_ROUTE_ID;
333:
334: -- Check For Unique Combination
335:

Line 494: From AHL_MR_ROUTES_APP_V

490:
491: CURSOR get_mr_route_id(C_ROUTE_ID NUMBER,C_MR_HEADER_ID NUMBER)
492: IS
493: Select MR_ROUTE_ID
494: From AHL_MR_ROUTES_APP_V
495: Where ROUTE_ID=C_ROUTE_ID
496: And MR_HEADER_ID=C_MR_HEADER_ID;
497: CURSOR get_route_num_routeid(C_MR_ROUTE_ID NUMBER)
498: IS

Line 509: From AHL_MR_ROUTES_APP_V

505:
506: CURSOR check_mr_route_id(C_MR_HEADER_ID NUMBER,C_ROUTE_ID NUMBER)
507: IS
508: Select COUNT(*)
509: From AHL_MR_ROUTES_APP_V
510: Where MR_HEADER_ID=C_MR_HEADER_ID
511: And ROUTE_ID<>C_ROUTE_ID;
512:
513: -- Check For Unique Combination

Line 587: From AHL_MR_ROUTES_APP_V

583:
584: IF l_route_id is not null or l_route_id<>fnd_api.g_miss_num
585: THEN
586: Select count(MR_ROUTE_ID) into l_counter
587: From AHL_MR_ROUTES_APP_V
588: Where ROUTE_ID=l_route_id
589: And MR_HEADER_ID=p_x_mr_route_seq_rec.mr_header_id;
590:
591: IF l_counter>1 and

Line 596: from ahl_mr_routes_APP_V

592: (p_x_mr_route_seq_rec.related_mr_route_id is not null OR
593: p_x_mr_route_seq_rec.related_mr_route_id<>fnd_api.g_miss_num)
594: THEN
595: select count(*) into l_counter3
596: from ahl_mr_routes_APP_V
597: where mr_header_id=p_x_mr_route_seq_rec.mr_header_id
598: and route_id=l_route_id
599: and mr_route_id=p_x_mr_route_seq_rec.related_mr_route_id;
600:

Line 667: WHERE MR_ROUTE_ID IN(SELECT MR_ROUTE_ID FROM AHL_MR_ROUTES_APP_V

663: x_return_status:=FND_API.G_RET_STS_SUCCESS;
664:
665: SELECT COUNT(*) INTO l_counter
666: FROM AHL_MR_ROUTE_SEQUENCES A
667: WHERE MR_ROUTE_ID IN(SELECT MR_ROUTE_ID FROM AHL_MR_ROUTES_APP_V
668: WHERE MR_HEADER_ID=P_MR_HEADER_ID
669: AND MR_ROUTE_ID=A.MR_ROUTE_ID)
670: START WITH RELATED_MR_ROUTE_ID=P_MR_ROUTE_ID
671: CONNECT BY PRIOR MR_ROUTE_ID = RELATED_MR_ROUTE_ID;

Line 721: FROM AHL_MR_ROUTES_APP_V

717: -- cursor for getting mr_route_id from route_number, route_revision and mr_header id
718: -- Added for public API in 11.5.10
719: CURSOR get_mr_route_id_type(p_mr_header_id NUMBER, p_route_no VARCHAR2, p_route_revision NUMBER) IS
720: SELECT mr_route_id
721: FROM AHL_MR_ROUTES_APP_V
722: WHERE route_id = (SELECT route_id
723: FROM AHL_ROUTES_APP_V
724: WHERE route_no = p_route_no
725: AND revision_number = p_route_revision)