DBA Data[Home] [Help]

APPS.AHL_RM_ROUTE_UTIL dependencies on MFG_LOOKUPS

Line 200: -- Procedure to validate MFG lookups

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,

Line 205: p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,

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:

Line 206: p_lookup_meaning IN MFG_LOOKUPS.meaning%TYPE,

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

Line 207: p_x_lookup_code IN OUT NOCOPY MFG_LOOKUPS.lookup_code%TYPE

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