DBA Data[Home] [Help]

APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_MC_HEADERS_V

Line 154: p_mc_name IN AHL_MC_HEADERS_V.NAME%TYPE,

150: PROCEDURE validate_master_configuration
151: (
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_mc_name IN AHL_MC_HEADERS_V.NAME%TYPE,
155: p_x_mc_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_ID%TYPE,
156: p_mc_revision_number IN AHL_MC_HEADERS_V.REVISION%TYPE ,
157: p_x_mc_header_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE
158: )

Line 155: p_x_mc_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_ID%TYPE,

151: (
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_mc_name IN AHL_MC_HEADERS_V.NAME%TYPE,
155: p_x_mc_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_ID%TYPE,
156: p_mc_revision_number IN AHL_MC_HEADERS_V.REVISION%TYPE ,
157: p_x_mc_header_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE
158: )
159: ;

Line 156: p_mc_revision_number IN AHL_MC_HEADERS_V.REVISION%TYPE ,

152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_mc_name IN AHL_MC_HEADERS_V.NAME%TYPE,
155: p_x_mc_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_ID%TYPE,
156: p_mc_revision_number IN AHL_MC_HEADERS_V.REVISION%TYPE ,
157: p_x_mc_header_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE
158: )
159: ;
160:

Line 157: p_x_mc_header_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE

153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_mc_name IN AHL_MC_HEADERS_V.NAME%TYPE,
155: p_x_mc_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_ID%TYPE,
156: p_mc_revision_number IN AHL_MC_HEADERS_V.REVISION%TYPE ,
157: p_x_mc_header_id IN OUT NOCOPY AHL_MC_HEADERS_V.MC_HEADER_ID%TYPE
158: )
159: ;
160:
161: -- Procedure to validate UOM

Line 460: p_mc_name IN AHL_MC_HEADERS_VL.name%TYPE,

456: PROCEDURE Validate_Master_Config
457: (
458: x_return_status OUT NOCOPY VARCHAR2,
459: x_msg_data OUT NOCOPY VARCHAR2,
460: p_mc_name IN AHL_MC_HEADERS_VL.name%TYPE,
461: p_x_mc_id IN OUT NOCOPY AHL_MC_HEADERS_VL.mc_id%TYPE
462: );
463: --Procedure to Validate Master Conf Position
464: PROCEDURE Validate_Mc_Position

Line 461: p_x_mc_id IN OUT NOCOPY AHL_MC_HEADERS_VL.mc_id%TYPE

457: (
458: x_return_status OUT NOCOPY VARCHAR2,
459: x_msg_data OUT NOCOPY VARCHAR2,
460: p_mc_name IN AHL_MC_HEADERS_VL.name%TYPE,
461: p_x_mc_id IN OUT NOCOPY AHL_MC_HEADERS_VL.mc_id%TYPE
462: );
463: --Procedure to Validate Master Conf Position
464: PROCEDURE Validate_Mc_Position
465: (

Line 468: p_mc_id IN AHL_MC_HEADERS_VL.mc_id%TYPE,

464: PROCEDURE Validate_Mc_Position
465: (
466: x_return_status OUT NOCOPY VARCHAR2,
467: x_msg_data OUT NOCOPY VARCHAR2,
468: p_mc_id IN AHL_MC_HEADERS_VL.mc_id%TYPE,
469: p_mc_position IN FND_LOOKUP_VALUES_VL.meaning%TYPE,
470: p_x_mc_position_key IN OUT NOCOPY AHL_MC_RELATIONSHIPS.position_key%TYPE
471: );
472: --sukhwsin: Proceddures for SB Effectivity Requirements ends