210: PROCEDURE validate_bom_resource
211: (
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_data OUT NOCOPY VARCHAR2,
214: p_bom_resource_code IN BOM_RESOURCES.resource_code%TYPE,
215: p_x_bom_resource_id IN OUT NOCOPY BOM_RESOURCES.resource_id%TYPE,
216: p_x_bom_org_id IN OUT NOCOPY BOM_RESOURCES.organization_id%TYPE
217: );
218:
211: (
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_data OUT NOCOPY VARCHAR2,
214: p_bom_resource_code IN BOM_RESOURCES.resource_code%TYPE,
215: p_x_bom_resource_id IN OUT NOCOPY BOM_RESOURCES.resource_id%TYPE,
216: p_x_bom_org_id IN OUT NOCOPY BOM_RESOURCES.organization_id%TYPE
217: );
218:
219: -- Procedure to validate BOM Resource department
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_data OUT NOCOPY VARCHAR2,
214: p_bom_resource_code IN BOM_RESOURCES.resource_code%TYPE,
215: p_x_bom_resource_id IN OUT NOCOPY BOM_RESOURCES.resource_id%TYPE,
216: p_x_bom_org_id IN OUT NOCOPY BOM_RESOURCES.organization_id%TYPE
217: );
218:
219: -- Procedure to validate BOM Resource department
220: --pdoki ER 7436910 Begin.