DBA Data[Home] [Help]

APPS.AHL_RM_ROUTE_UTIL dependencies on MFG_LOOKUPS

Line 190: -- Procedure to validate MFG lookups

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
192: (
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_data OUT NOCOPY VARCHAR2,

Line 195: p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,

191: PROCEDURE validate_mfg_lookup
192: (
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,
196: p_lookup_meaning IN MFG_LOOKUPS.meaning%TYPE,
197: p_x_lookup_code IN OUT NOCOPY MFG_LOOKUPS.lookup_code%TYPE
198: );
199:

Line 196: p_lookup_meaning IN MFG_LOOKUPS.meaning%TYPE,

192: (
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,
196: p_lookup_meaning IN MFG_LOOKUPS.meaning%TYPE,
197: p_x_lookup_code IN OUT NOCOPY MFG_LOOKUPS.lookup_code%TYPE
198: );
199:
200: -- Procedure to validate ASO Resource

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

193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,
196: p_lookup_meaning IN MFG_LOOKUPS.meaning%TYPE,
197: p_x_lookup_code IN OUT NOCOPY MFG_LOOKUPS.lookup_code%TYPE
198: );
199:
200: -- Procedure to validate ASO Resource
201: PROCEDURE validate_aso_resource