220: PROCEDURE validate_bom_resource
221: (
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_data OUT NOCOPY VARCHAR2,
224: p_bom_resource_code IN BOM_RESOURCES.resource_code%TYPE,
225: p_x_bom_resource_id IN OUT NOCOPY BOM_RESOURCES.resource_id%TYPE,
226: p_x_bom_org_id IN OUT NOCOPY BOM_RESOURCES.organization_id%TYPE
227: );
228:
221: (
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_data OUT NOCOPY VARCHAR2,
224: p_bom_resource_code IN BOM_RESOURCES.resource_code%TYPE,
225: p_x_bom_resource_id IN OUT NOCOPY BOM_RESOURCES.resource_id%TYPE,
226: p_x_bom_org_id IN OUT NOCOPY BOM_RESOURCES.organization_id%TYPE
227: );
228:
229: -- Procedure to validate BOM Resource department
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_data OUT NOCOPY VARCHAR2,
224: p_bom_resource_code IN BOM_RESOURCES.resource_code%TYPE,
225: p_x_bom_resource_id IN OUT NOCOPY BOM_RESOURCES.resource_id%TYPE,
226: p_x_bom_org_id IN OUT NOCOPY BOM_RESOURCES.organization_id%TYPE
227: );
228:
229: -- Procedure to validate BOM Resource department
230: --pdoki ER 7436910 Begin.