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
202: (
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_data OUT NOCOPY VARCHAR2,
201: PROCEDURE validate_mfg_lookup
202: (
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,
206: p_lookup_meaning IN MFG_LOOKUPS.meaning%TYPE,
207: p_x_lookup_code IN OUT NOCOPY MFG_LOOKUPS.lookup_code%TYPE
208: );
209:
202: (
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,
206: p_lookup_meaning IN MFG_LOOKUPS.meaning%TYPE,
207: p_x_lookup_code IN OUT NOCOPY MFG_LOOKUPS.lookup_code%TYPE
208: );
209:
210: -- Procedure to validate ASO Resource
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,
206: p_lookup_meaning IN MFG_LOOKUPS.meaning%TYPE,
207: p_x_lookup_code IN OUT NOCOPY MFG_LOOKUPS.lookup_code%TYPE
208: );
209:
210: -- Procedure to validate ASO Resource
211: PROCEDURE validate_aso_resource