APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_PRODTYPE_ZONES

Line 2265: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE,

2261: PROCEDURE validate_pt_zone
2262: (
2263: x_return_status OUT NOCOPY VARCHAR2,
2264: x_msg_data OUT NOCOPY VARCHAR2,
2265: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE,
2266: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE
2267: )
2268: IS
2269:

Line 2266: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE

2262: (
2263: x_return_status OUT NOCOPY VARCHAR2,
2264: x_msg_data OUT NOCOPY VARCHAR2,
2265: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE,
2266: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE
2267: )
2268: IS
2269:
2270: CURSOR check_pt_zone ( c_product_type_code AHL_PRODTYPE_ZONES.product_type_code%TYPE,

Line 2270: CURSOR check_pt_zone ( c_product_type_code AHL_PRODTYPE_ZONES.product_type_code%TYPE,

2266: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE
2267: )
2268: IS
2269:
2270: CURSOR check_pt_zone ( c_product_type_code AHL_PRODTYPE_ZONES.product_type_code%TYPE,
2271: c_zone_code AHL_PRODTYPE_ZONES.zone_code%TYPE )
2272: IS
2273: SELECT 'X'
2274: FROM AHL_PRODTYPE_ZONES

Line 2271: c_zone_code AHL_PRODTYPE_ZONES.zone_code%TYPE )

2267: )
2268: IS
2269:
2270: CURSOR check_pt_zone ( c_product_type_code AHL_PRODTYPE_ZONES.product_type_code%TYPE,
2271: c_zone_code AHL_PRODTYPE_ZONES.zone_code%TYPE )
2272: IS
2273: SELECT 'X'
2274: FROM AHL_PRODTYPE_ZONES
2275: WHERE product_type_code = c_product_type_code

Line 2274: FROM AHL_PRODTYPE_ZONES

2270: CURSOR check_pt_zone ( c_product_type_code AHL_PRODTYPE_ZONES.product_type_code%TYPE,
2271: c_zone_code AHL_PRODTYPE_ZONES.zone_code%TYPE )
2272: IS
2273: SELECT 'X'
2274: FROM AHL_PRODTYPE_ZONES
2275: WHERE product_type_code = c_product_type_code
2276: AND zone_code = c_zone_code
2277: AND sub_zone_code IS NULL;
2278:

Line 2313: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE ,

2309: PROCEDURE validate_pt_zone_subzone
2310: (
2311: x_return_status OUT NOCOPY VARCHAR2,
2312: x_msg_data OUT NOCOPY VARCHAR2,
2313: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE ,
2314: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE,
2315: p_sub_zone_code IN AHL_PRODTYPE_ZONES.sub_zone_code%TYPE
2316: )
2317: IS

Line 2314: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE,

2310: (
2311: x_return_status OUT NOCOPY VARCHAR2,
2312: x_msg_data OUT NOCOPY VARCHAR2,
2313: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE ,
2314: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE,
2315: p_sub_zone_code IN AHL_PRODTYPE_ZONES.sub_zone_code%TYPE
2316: )
2317: IS
2318:

Line 2315: p_sub_zone_code IN AHL_PRODTYPE_ZONES.sub_zone_code%TYPE

2311: x_return_status OUT NOCOPY VARCHAR2,
2312: x_msg_data OUT NOCOPY VARCHAR2,
2313: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE ,
2314: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE,
2315: p_sub_zone_code IN AHL_PRODTYPE_ZONES.sub_zone_code%TYPE
2316: )
2317: IS
2318:
2319: CURSOR check_pt_zone_subzone ( c_product_type_code AHL_PRODTYPE_ZONES.product_type_code%TYPE, c_zone_code AHL_PRODTYPE_ZONES.zone_code%TYPE, c_sub_zone_code AHL_PRODTYPE_ZONES.sub_zone_code%TYPE )

Line 2319: CURSOR check_pt_zone_subzone ( c_product_type_code AHL_PRODTYPE_ZONES.product_type_code%TYPE, c_zone_code AHL_PRODTYPE_ZONES.zone_code%TYPE, c_sub_zone_code AHL_PRODTYPE_ZONES.sub_zone_code%TYPE )

2315: p_sub_zone_code IN AHL_PRODTYPE_ZONES.sub_zone_code%TYPE
2316: )
2317: IS
2318:
2319: CURSOR check_pt_zone_subzone ( c_product_type_code AHL_PRODTYPE_ZONES.product_type_code%TYPE, c_zone_code AHL_PRODTYPE_ZONES.zone_code%TYPE, c_sub_zone_code AHL_PRODTYPE_ZONES.sub_zone_code%TYPE )
2320: IS
2321: SELECT 'X'
2322: FROM AHL_PRODTYPE_ZONES
2323: WHERE product_type_code = c_product_type_code

Line 2322: FROM AHL_PRODTYPE_ZONES

2318:
2319: CURSOR check_pt_zone_subzone ( c_product_type_code AHL_PRODTYPE_ZONES.product_type_code%TYPE, c_zone_code AHL_PRODTYPE_ZONES.zone_code%TYPE, c_sub_zone_code AHL_PRODTYPE_ZONES.sub_zone_code%TYPE )
2320: IS
2321: SELECT 'X'
2322: FROM AHL_PRODTYPE_ZONES
2323: WHERE product_type_code = c_product_type_code
2324: AND zone_code = c_zone_code
2325: AND sub_zone_code = c_sub_zone_code;
2326: