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 GME_PROCESS_PARAMETERS

Line 781: /* Insert process parameter 1 value into GME_PROCESS_PARAMETERS table */

777: batchstep_activity_id,resources,batchstep_resource_id
778: FROM gme_batch_step_resources;
779: BEGIN
780: FOR l_rec IN Cur_batch_parameters LOOP
781: /* Insert process parameter 1 value into GME_PROCESS_PARAMETERS table */
782: IF l_rec.process_parameter_1 IS NOT NULL THEN
783: /*Check if the row for the resource already exists if it does not then*/
784: INSERT INTO gme_process_parameters
785: (process_param_id,

Line 784: INSERT INTO gme_process_parameters

780: FOR l_rec IN Cur_batch_parameters LOOP
781: /* Insert process parameter 1 value into GME_PROCESS_PARAMETERS table */
782: IF l_rec.process_parameter_1 IS NOT NULL THEN
783: /*Check if the row for the resource already exists if it does not then*/
784: INSERT INTO gme_process_parameters
785: (process_param_id,
786: batch_id,
787: batchstep_id,
788: batchstep_activity_id,

Line 799: gme_process_parameters_id_s.nextval,

795: last_update_date,
796: last_updated_by,
797: last_update_login)
798: SELECT
799: gme_process_parameters_id_s.nextval,
800: l_rec.batch_id,
801: l_rec.batchstep_id,
802: l_rec.batchstep_activity_id,
803: l_rec.resources,

Line 814: FROM gme_process_parameters

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);
817: END IF; /*IF l_rec.process_parameter_1 IS NOT NULL THEN*/
818:

Line 821: INSERT INTO gme_process_parameters

817: END IF; /*IF l_rec.process_parameter_1 IS NOT NULL THEN*/
818:
819: IF l_rec.process_parameter_2 IS NOT NULL THEN
820: /*Check if the row for the resource already exists if it does not then*/
821: INSERT INTO gme_process_parameters
822: (process_param_id,
823: batch_id,
824: batchstep_id,
825: batchstep_activity_id,

Line 836: gme_process_parameters_id_s.nextval,

832: last_update_date,
833: last_updated_by,
834: last_update_login)
835: SELECT
836: gme_process_parameters_id_s.nextval,
837: l_rec.batch_id,
838: l_rec.batchstep_id,
839: l_rec.batchstep_activity_id,
840: l_rec.resources,

Line 851: FROM gme_process_parameters

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);
854: END IF; /*IF l_rec.process_parameter_2 IS NOT NULL THEN*/
855:

Line 858: INSERT INTO gme_process_parameters

854: END IF; /*IF l_rec.process_parameter_2 IS NOT NULL THEN*/
855:
856: IF l_rec.process_parameter_3 IS NOT NULL THEN
857: /*Check if the row for the resource already exists if it does not then*/
858: INSERT INTO gme_process_parameters
859: (process_param_id,
860: batch_id,
861: batchstep_id,
862: batchstep_activity_id,

Line 873: gme_process_parameters_id_s.nextval,

869: last_update_date,
870: last_updated_by,
871: last_update_login)
872: SELECT
873: gme_process_parameters_id_s.nextval,
874: l_rec.batch_id,
875: l_rec.batchstep_id,
876: l_rec.batchstep_activity_id,
877: l_rec.resources,

Line 888: FROM gme_process_parameters

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);
891: END IF; /*IF l_rec.process_parameter_3 IS NOT NULL THEN*/
892:

Line 895: INSERT INTO gme_process_parameters

891: END IF; /*IF l_rec.process_parameter_3 IS NOT NULL THEN*/
892:
893: IF l_rec.process_parameter_4 IS NOT NULL THEN
894: /*Check if the row for the resource already exists if it does not then*/
895: INSERT INTO gme_process_parameters
896: (process_param_id,
897: batch_id,
898: batchstep_id,
899: batchstep_activity_id,

Line 910: gme_process_parameters_id_s.nextval,

906: last_update_date,
907: last_updated_by,
908: last_update_login)
909: SELECT
910: gme_process_parameters_id_s.nextval,
911: l_rec.batch_id,
912: l_rec.batchstep_id,
913: l_rec.batchstep_activity_id,
914: l_rec.resources,

Line 925: FROM gme_process_parameters

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);
928: END IF; /*IF l_rec.process_parameter_4 IS NOT NULL THEN*/
929:

Line 932: INSERT INTO gme_process_parameters

928: END IF; /*IF l_rec.process_parameter_4 IS NOT NULL THEN*/
929:
930: IF l_rec.process_parameter_5 IS NOT NULL THEN
931: /*Check if the row for the resource already exists if it does not then*/
932: INSERT INTO gme_process_parameters
933: (process_param_id,
934: batch_id,
935: batchstep_id,
936: batchstep_activity_id,

Line 947: gme_process_parameters_id_s.nextval,

943: last_update_date,
944: last_updated_by,
945: last_update_login)
946: SELECT
947: gme_process_parameters_id_s.nextval,
948: l_rec.batch_id,
949: l_rec.batchstep_id,
950: l_rec.batchstep_activity_id,
951: l_rec.resources,

Line 962: FROM gme_process_parameters

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);
965: END IF; /*IF l_rec.process_parameter_5 IS NOT NULL THEN*/
966: END LOOP;

Line 971: ,p_table_name => 'GME_PROCESS_PARAMETERS'

967: EXCEPTION
968: WHEN OTHERS THEN
969: P_line_no := P_line_no + 1;
970: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
971: ,p_table_name => 'GME_PROCESS_PARAMETERS'
972: ,p_db_error => sqlerrm
973: ,p_param1 => NULL
974: ,p_param2 => NULL
975: ,p_param3 => NULL

Line 994: FROM gme_process_parameters

990: SELECT DISTINCT resources,Parameter_id
991: FROM gmd_recipe_process_parameters
992: UNION
993: SELECT DISTINCT resources,Parameter_id
994: FROM gme_process_parameters
995: order by 1;
996: l_rec Cur_get_override%ROWTYPE;
997: CURSOR Cur_get_target(V_resources VARCHAR2, V_parameter_id NUMBER) IS
998: SELECT Target_Value, COUNT(1)

Line 1011: FROM gme_process_parameters

1007: AND parameter_id = V_parameter_id
1008: GROUP BY Target_Value
1009: UNION
1010: SELECT Target_Value, COUNT(1)
1011: FROM gme_process_parameters
1012: WHERE resources = V_resources
1013: AND parameter_id = V_parameter_id
1014: GROUP BY Target_Value
1015: ORDER BY 2 DESC;