APPS.AHL_RM_ROUTE_PVT dependencies on AHL_ROUTE_EFFECTIVITIES

Line 3007: DELETE ahl_route_effectivities

3003:
3004: -- Delete all the associations
3005:
3006: -- 0.Delete Effectivities
3007: DELETE ahl_route_effectivities
3008: WHERE ROUTE_ID = p_route_id;
3009:
3010: -- If no records exist, then, Continue.
3011: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 3320: FROM ahl_route_effectivities

3316: ATTRIBUTE12,
3317: ATTRIBUTE13,
3318: ATTRIBUTE14,
3319: ATTRIBUTE15
3320: FROM ahl_route_effectivities
3321: WHERE route_id = c_route_id
3322: ;
3323:
3324: -- Pekambar(Praveen) Modifed for USAF - VEE

Line 3631: SELECT ahl_route_effectivities_s.nextval into l_route_effectivity_id

3627:
3628: -- Create copies of the route associations
3629: -- 0.Copy Route Effectivities
3630: FOR l_get_route_efcts IN get_route_efcts(p_route_id) LOOP
3631: SELECT ahl_route_effectivities_s.nextval into l_route_effectivity_id
3632: FROM dual;
3633: INSERT INTO ahl_route_effectivities
3634: (
3635: route_effectivity_id

Line 3633: INSERT INTO ahl_route_effectivities

3629: -- 0.Copy Route Effectivities
3630: FOR l_get_route_efcts IN get_route_efcts(p_route_id) LOOP
3631: SELECT ahl_route_effectivities_s.nextval into l_route_effectivity_id
3632: FROM dual;
3633: INSERT INTO ahl_route_effectivities
3634: (
3635: route_effectivity_id
3636: , route_id
3637: , inventory_item_id