APPS.AHL_RM_ROUTE_PVT dependencies on AHL_ROUTE_EFFECTIVITIES

Line 2676: DELETE ahl_route_effectivities

2672:
2673: -- Delete all the associations
2674:
2675: -- 0.Delete Effectivities
2676: DELETE ahl_route_effectivities
2677: WHERE ROUTE_ID = p_route_id;
2678:
2679: -- If no records exist, then, Continue.
2680: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 2989: FROM ahl_route_effectivities

2985: ATTRIBUTE12,
2986: ATTRIBUTE13,
2987: ATTRIBUTE14,
2988: ATTRIBUTE15
2989: FROM ahl_route_effectivities
2990: WHERE route_id = c_route_id
2991: ;
2992:
2993: BEGIN

Line 3214: SELECT ahl_route_effectivities_s.nextval into l_route_effectivity_id

3210:
3211: -- Create copies of the route associations
3212: -- 0.Copy Route Effectivities
3213: FOR l_get_route_efcts IN get_route_efcts(p_route_id) LOOP
3214: SELECT ahl_route_effectivities_s.nextval into l_route_effectivity_id
3215: FROM dual;
3216: INSERT INTO ahl_route_effectivities
3217: (
3218: route_effectivity_id

Line 3216: INSERT INTO ahl_route_effectivities

3212: -- 0.Copy Route Effectivities
3213: FOR l_get_route_efcts IN get_route_efcts(p_route_id) LOOP
3214: SELECT ahl_route_effectivities_s.nextval into l_route_effectivity_id
3215: FROM dual;
3216: INSERT INTO ahl_route_effectivities
3217: (
3218: route_effectivity_id
3219: , route_id
3220: , inventory_item_id