DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_UTIL dependencies on BOM_DEPARTMENTS

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

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

Line 2753: from bom_departments b

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