APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_PRODTYPE_ZONES

Line 176: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE,

172: PROCEDURE validate_pt_zone
173: (
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE,
177: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE
178: );
179:
180: -- Procedure to validate Product Type, Zone and Sub Zone association

Line 177: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE

173: (
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE,
177: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE
178: );
179:
180: -- Procedure to validate Product Type, Zone and Sub Zone association
181: PROCEDURE validate_pt_zone_subzone

Line 185: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE,

181: PROCEDURE validate_pt_zone_subzone
182: (
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE,
186: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE,
187: p_sub_zone_code IN AHL_PRODTYPE_ZONES.sub_zone_code%TYPE
188: );
189:

Line 186: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE,

182: (
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE,
186: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE,
187: p_sub_zone_code IN AHL_PRODTYPE_ZONES.sub_zone_code%TYPE
188: );
189:
190: -- Procedure to validate MFG lookups

Line 187: p_sub_zone_code IN AHL_PRODTYPE_ZONES.sub_zone_code%TYPE

183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: p_product_type_code IN AHL_PRODTYPE_ZONES.product_type_code%TYPE,
186: p_zone_code IN AHL_PRODTYPE_ZONES.zone_code%TYPE,
187: p_sub_zone_code IN AHL_PRODTYPE_ZONES.sub_zone_code%TYPE
188: );
189:
190: -- Procedure to validate MFG lookups
191: PROCEDURE validate_mfg_lookup