eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 480: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS

476: AND bor.RESOURCE_ID = X_Resource_Id
477: AND bos.DEPARTMENT_ID = X_Department_Id);
478:
479: message_name := 'BOM_CANNOT_DELETE_RES_WIP_OP';
480: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
481: (SELECT 1 FROM WIP_OPERATIONS wo,
482: WIP_OPERATION_RESOURCES wor
483: WHERE wo.WIP_ENTITY_ID = wor.WIP_ENTITY_ID
484: AND wo.OPERATION_SEQ_NUM = wor.OPERATION_SEQ_NUM