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.GMD_PROC_PARAMS_MIGR dependencies on DUAL

Line 10: FROM sys.dual

6:
7: PROCEDURE check_process_parameter IS
8: CURSOR Cur_check_param1 IS
9: SELECT 1
10: FROM sys.dual
11: WHERE EXISTS (SELECT 1
12: FROM GMD_OPERATION_RESOURCES
13: WHERE process_parameter_1 IS NOT NULL
14: UNION

Line 28: FROM sys.dual

24: WHERE parameter_id = 1);
25:
26: CURSOR Cur_check_param2 IS
27: SELECT 1
28: FROM sys.dual
29: WHERE EXISTS (SELECT 1
30: FROM GMD_OPERATION_RESOURCES
31: WHERE process_parameter_2 IS NOT NULL
32: UNION

Line 46: FROM sys.dual

42: WHERE parameter_id = 2);
43:
44: CURSOR Cur_check_param3 IS
45: SELECT 1
46: FROM sys.dual
47: WHERE EXISTS (SELECT 1
48: FROM GMD_OPERATION_RESOURCES
49: WHERE process_parameter_3 IS NOT NULL
50: UNION

Line 64: FROM sys.dual

60: WHERE parameter_id = 3);
61:
62: CURSOR Cur_check_param4 IS
63: SELECT 1
64: FROM sys.dual
65: WHERE EXISTS (SELECT 1
66: FROM GMD_OPERATION_RESOURCES
67: WHERE process_parameter_4 IS NOT NULL
68: UNION

Line 82: FROM sys.dual

78: WHERE parameter_id = 4);
79:
80: CURSOR Cur_check_param5 IS
81: SELECT 1
82: FROM sys.dual
83: WHERE EXISTS (SELECT 1
84: FROM GMD_OPERATION_RESOURCES
85: WHERE process_parameter_5 IS NOT NULL
86: UNION

Line 412: FROM DUAL

408: 0,
409: SYSDATE,
410: 0,
411: 0
412: FROM DUAL
413: WHERE NOT EXISTS (SELECT 1
414: FROM gmd_oprn_process_parameters
415: WHERE oprn_line_id = l_rec.oprn_line_id
416: AND resources = l_rec.resources

Line 440: FROM DUAL

436: 0,
437: SYSDATE,
438: 0,
439: 0
440: FROM DUAL
441: WHERE NOT EXISTS (SELECT 1
442: FROM gmd_oprn_process_parameters
443: WHERE oprn_line_id = l_rec.oprn_line_id
444: AND resources = l_rec.resources

Line 468: FROM DUAL

464: 0,
465: SYSDATE,
466: 0,
467: 0
468: FROM DUAL
469: WHERE NOT EXISTS (SELECT 1
470: FROM gmd_oprn_process_parameters
471: WHERE oprn_line_id = l_rec.oprn_line_id
472: AND resources = l_rec.resources

Line 496: FROM DUAL

492: 0,
493: SYSDATE,
494: 0,
495: 0
496: FROM DUAL
497: WHERE NOT EXISTS (SELECT 1
498: FROM gmd_oprn_process_parameters
499: WHERE oprn_line_id = l_rec.oprn_line_id
500: AND resources = l_rec.resources

Line 525: FROM DUAL

521: 0,
522: SYSDATE,
523: 0,
524: 0
525: FROM DUAL
526: WHERE NOT EXISTS (SELECT 1
527: FROM gmd_oprn_process_parameters
528: WHERE oprn_line_id = l_rec.oprn_line_id
529: AND resources = l_rec.resources

Line 588: FROM DUAL

584: 0,
585: SYSDATE,
586: 0,
587: 0
588: FROM DUAL
589: WHERE NOT EXISTS (SELECT 1
590: FROM gmd_recipe_process_parameters
591: WHERE oprn_line_id = l_rec.oprn_line_id
592: AND resources = l_rec.resources

Line 627: FROM DUAL

623: 0,
624: SYSDATE,
625: 0,
626: 0
627: FROM DUAL
628: WHERE NOT EXISTS (SELECT 1
629: FROM gmd_recipe_process_parameters
630: WHERE oprn_line_id = l_rec.oprn_line_id
631: AND resources = l_rec.resources

Line 666: FROM DUAL

662: 0,
663: SYSDATE,
664: 0,
665: 0
666: FROM DUAL
667: WHERE NOT EXISTS (SELECT 1
668: FROM gmd_recipe_process_parameters
669: WHERE oprn_line_id = l_rec.oprn_line_id
670: AND resources = l_rec.resources

Line 705: FROM DUAL

701: 0,
702: SYSDATE,
703: 0,
704: 0
705: FROM DUAL
706: WHERE NOT EXISTS (SELECT 1
707: FROM gmd_recipe_process_parameters
708: WHERE oprn_line_id = l_rec.oprn_line_id
709: AND resources = l_rec.resources

Line 744: FROM DUAL

740: 0,
741: SYSDATE,
742: 0,
743: 0
744: FROM DUAL
745: WHERE NOT EXISTS (SELECT 1
746: FROM gmd_recipe_process_parameters
747: WHERE oprn_line_id = l_rec.oprn_line_id
748: AND resources = l_rec.resources

Line 812: FROM DUAL

808: 0,
809: SYSDATE,
810: 0,
811: 0
812: FROM DUAL
813: WHERE NOT EXISTS (SELECT 1
814: FROM gme_process_parameters
815: WHERE batchstep_resource_id = l_rec.batchstep_resource_id
816: AND parameter_id = 1);

Line 849: FROM DUAL

845: 0,
846: SYSDATE,
847: 0,
848: 0
849: FROM DUAL
850: WHERE NOT EXISTS (SELECT 1
851: FROM gme_process_parameters
852: WHERE batchstep_resource_id = l_rec.batchstep_resource_id
853: AND parameter_id = 2);

Line 886: FROM DUAL

882: 0,
883: SYSDATE,
884: 0,
885: 0
886: FROM DUAL
887: WHERE NOT EXISTS (SELECT 1
888: FROM gme_process_parameters
889: WHERE batchstep_resource_id = l_rec.batchstep_resource_id
890: AND parameter_id = 3);

Line 923: FROM DUAL

919: 0,
920: SYSDATE,
921: 0,
922: 0
923: FROM DUAL
924: WHERE NOT EXISTS (SELECT 1
925: FROM gme_process_parameters
926: WHERE batchstep_resource_id = l_rec.batchstep_resource_id
927: AND parameter_id = 4);

Line 960: FROM DUAL

956: 0,
957: SYSDATE,
958: 0,
959: 0
960: FROM DUAL
961: WHERE NOT EXISTS (SELECT 1
962: FROM gme_process_parameters
963: WHERE batchstep_resource_id = l_rec.batchstep_resource_id
964: AND parameter_id = 5);

Line 1050: FROM DUAL

1046: SYSDATE,
1047: 0,
1048: SYSDATE,
1049: 0
1050: FROM DUAL
1051: WHERE NOT EXISTS (SELECT 1
1052: FROM GMP_RESOURCE_PARAMETERS
1053: WHERE resources = l_rec.resources
1054: AND parameter_id = l_rec.parameter_id);