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: )
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: ;
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:
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
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
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: (
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