APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_PRODTYPE_ZONES

Line 2133: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE,

2129: PROCEDURE validate_pt_zone
2130: (
2131: x_return_status OUT NOCOPY VARCHAR2,
2132: x_msg_data OUT NOCOPY VARCHAR2,
2133: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE,
2134: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE
2135: )
2136: IS
2137:

Line 2134: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE

2130: (
2131: x_return_status OUT NOCOPY VARCHAR2,
2132: x_msg_data OUT NOCOPY VARCHAR2,
2133: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE,
2134: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE
2135: )
2136: IS
2137:
2138: CURSOR check_pt_zone ( c_product_type_code AHL_PRODTYPE_ZONES.product_type_code%TYPE,

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

2134: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE
2135: )
2136: IS
2137:
2138: CURSOR check_pt_zone ( c_product_type_code AHL_PRODTYPE_ZONES.product_type_code%TYPE,
2139: c_zone_code AHL_PRODTYPE_ZONES.zone_code%TYPE )
2140: IS
2141: SELECT 'X'
2142: FROM AHL_PRODTYPE_ZONES

Line 2139: c_zone_code AHL_PRODTYPE_ZONES.zone_code%TYPE )

2135: )
2136: IS
2137:
2138: CURSOR check_pt_zone ( c_product_type_code AHL_PRODTYPE_ZONES.product_type_code%TYPE,
2139: c_zone_code AHL_PRODTYPE_ZONES.zone_code%TYPE )
2140: IS
2141: SELECT 'X'
2142: FROM AHL_PRODTYPE_ZONES
2143: WHERE product_type_code = c_product_type_code

Line 2142: FROM AHL_PRODTYPE_ZONES

2138: CURSOR check_pt_zone ( c_product_type_code AHL_PRODTYPE_ZONES.product_type_code%TYPE,
2139: c_zone_code AHL_PRODTYPE_ZONES.zone_code%TYPE )
2140: IS
2141: SELECT 'X'
2142: FROM AHL_PRODTYPE_ZONES
2143: WHERE product_type_code = c_product_type_code
2144: AND zone_code = c_zone_code
2145: AND sub_zone_code IS NULL;
2146:

Line 2181: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE ,

2177: PROCEDURE validate_pt_zone_subzone
2178: (
2179: x_return_status OUT NOCOPY VARCHAR2,
2180: x_msg_data OUT NOCOPY VARCHAR2,
2181: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE ,
2182: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE,
2183: p_sub_zone_code IN AHL_PRODTYPE_ZONES.sub_zone_code%TYPE
2184: )
2185: IS

Line 2182: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE,

2178: (
2179: x_return_status OUT NOCOPY VARCHAR2,
2180: x_msg_data OUT NOCOPY VARCHAR2,
2181: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE ,
2182: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE,
2183: p_sub_zone_code IN AHL_PRODTYPE_ZONES.sub_zone_code%TYPE
2184: )
2185: IS
2186:

Line 2183: p_sub_zone_code IN AHL_PRODTYPE_ZONES.sub_zone_code%TYPE

2179: x_return_status OUT NOCOPY VARCHAR2,
2180: x_msg_data OUT NOCOPY VARCHAR2,
2181: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE ,
2182: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE,
2183: p_sub_zone_code IN AHL_PRODTYPE_ZONES.sub_zone_code%TYPE
2184: )
2185: IS
2186:
2187: 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 2187: 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 )

2183: p_sub_zone_code IN AHL_PRODTYPE_ZONES.sub_zone_code%TYPE
2184: )
2185: IS
2186:
2187: 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 )
2188: IS
2189: SELECT 'X'
2190: FROM AHL_PRODTYPE_ZONES
2191: WHERE product_type_code = c_product_type_code

Line 2190: FROM AHL_PRODTYPE_ZONES

2186:
2187: 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 )
2188: IS
2189: SELECT 'X'
2190: FROM AHL_PRODTYPE_ZONES
2191: WHERE product_type_code = c_product_type_code
2192: AND zone_code = c_zone_code
2193: AND sub_zone_code = c_sub_zone_code;
2194: