APPS.BOM_DEPARTMENT_RESOURCES_PKG dependencies on DUAL

Line 421: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS

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
424: AND RESOURCE_ID = X_Resource_Id
425: AND ((X_Rowid IS NULL) OR (ROWID <> X_Rowid))

Line 450: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS

446: WHERE RESOURCE_ID = X_Resource_Id;
447:
448: err_code := 1;
449: message_name := 'BOM_CANNOT_DELETE_RESOURCE';
450: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
451: (SELECT 1 FROM BOM_RESOURCE_SHIFTS
452: WHERE DEPARTMENT_ID = X_Department_Id
453: AND RESOURCE_ID = X_Resource_Id);
454:

Line 457: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS

453: AND RESOURCE_ID = X_Resource_Id);
454:
455: err_code := 2;
456: message_name := 'BOM_CANNOT_DELETE_SHARED_RES';
457: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
458: (SELECT 1 FROM BOM_DEPARTMENT_RESOURCES
459: WHERE SHARE_FROM_DEPT_ID = X_Department_Id
460: AND RESOURCE_ID = X_Resource_Id);
461:

Line 464: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS

460: AND RESOURCE_ID = X_Resource_Id);
461:
462: err_code := 3;
463: message_name := 'BOM_CANNOT_DELETE_RES_STD_OP';
464: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
465: (SELECT 1 FROM BOM_STD_OP_RESOURCES bsor,
466: BOM_STANDARD_OPERATIONS bso
467: WHERE bso.STANDARD_OPERATION_ID = bsor.STANDARD_OPERATION_ID
468: AND bso.DEPARTMENT_ID = X_Department_Id

Line 472: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS

468: AND bso.DEPARTMENT_ID = X_Department_Id
469: AND bsor.RESOURCE_ID = X_Resource_Id);
470:
471: message_name := 'BOM_CANNOT_DELETE_RES_ROUTING';
472: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
473: (SELECT 1 FROM BOM_OPERATION_RESOURCES bor,
474: BOM_OPERATION_SEQUENCES bos
475: WHERE bor.OPERATION_SEQUENCE_ID = bos.OPERATION_SEQUENCE_ID
476: AND bor.RESOURCE_ID = X_Resource_Id

Line 481: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS

477: AND bos.DEPARTMENT_ID = X_Department_Id);
478:
479: message_name := 'BOM_CANNOT_DELETE_RES_WIP_OP';
480: /* bug 9186572 - added WIP_DISCRETE_JOBS to check for the status of job also */
481: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
482: (SELECT 1 FROM WIP_OPERATIONS wo,
483: WIP_OPERATION_RESOURCES wor,
484: WIP_DISCRETE_JOBS wdj
485: WHERE wo.WIP_ENTITY_ID = wor.WIP_ENTITY_ID