APPS.BOM_DEPARTMENT_RESOURCES_PKG dependencies on BOM_RESOURCES

Line 419: SELECT RESOURCE_CODE INTO res_code FROM BOM_RESOURCES

415: X_Resource_Id NUMBER) IS
416: dummy NUMBER;
417: res_code VARCHAR2(10);
418: BEGIN
419: SELECT RESOURCE_CODE INTO res_code FROM BOM_RESOURCES
420: WHERE RESOURCE_ID = X_Resource_Id;
421: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
422: (SELECT 1 FROM BOM_DEPARTMENT_RESOURCES
423: WHERE DEPARTMENT_ID = X_Department_Id

Line 445: SELECT RESOURCE_CODE INTO res_code FROM BOM_RESOURCES

441: err_code NUMBER;
442: message_name VARCHAR2(80);
443: res_code VARCHAR2(10);
444: BEGIN
445: SELECT RESOURCE_CODE INTO res_code FROM BOM_RESOURCES
446: WHERE RESOURCE_ID = X_Resource_Id;
447:
448: err_code := 1;
449: message_name := 'BOM_CANNOT_DELETE_RESOURCE';