APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_PRODTYPE_ZONES

Line 186: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE,

182: PROCEDURE validate_pt_zone
183: (
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE,
187: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE
188: );
189:
190: -- Procedure to validate Product Type, Zone and Sub Zone association

Line 187: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE

183: (
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE,
187: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE
188: );
189:
190: -- Procedure to validate Product Type, Zone and Sub Zone association
191: PROCEDURE validate_pt_zone_subzone

Line 195: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE,

191: PROCEDURE validate_pt_zone_subzone
192: (
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE,
196: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE,
197: p_sub_zone_code IN AHL_PRODTYPE_ZONES.sub_zone_code%TYPE
198: );
199:

Line 196: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE,

192: (
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE,
196: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE,
197: p_sub_zone_code IN AHL_PRODTYPE_ZONES.sub_zone_code%TYPE
198: );
199:
200: -- Procedure to validate MFG lookups

Line 197: p_sub_zone_code IN AHL_PRODTYPE_ZONES.sub_zone_code%TYPE

193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE,
196: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE,
197: p_sub_zone_code IN AHL_PRODTYPE_ZONES.sub_zone_code%TYPE
198: );
199:
200: -- Procedure to validate MFG lookups
201: PROCEDURE validate_mfg_lookup