DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_UTIL dependencies on BOM_DEPARTMENTS

Line 2729: -- 1. verfity that the departmnet is activ in bom_departments

2725: END Validate_Inventory_Org;
2726:
2727: -- ------------------------------------------------------------------------------
2728: -- Validate Owning Department
2729: -- 1. verfity that the departmnet is activ in bom_departments
2730: -- 2. verify that the department is vaild for the given organization
2731: -- ------------------------------------------------------------------------------
2732: PROCEDURE Validate_Owning_Department(
2733: p_api_name IN VARCHAR2,

Line 2751: from bom_departments b

2747: IF (p_maintenance_flag = 'Y' or p_maintenance_flag = 'y') THEN
2748: IF (p_owning_dept_id IS NOT NULL AND
2749: p_owning_dept_id <> FND_API.G_MISS_NUM) THEN
2750: select 'x' INTO l_dummy
2751: from bom_departments b
2752: where b.department_id = p_owning_dept_id
2753: and TRUNC(NVL(b.disable_date,SYSDATE+1)) > TRUNC(SYSDATE)
2754: and b.organization_id = p_inv_org_id;
2755: END IF;