APPS.GMD_PROC_PARAMS_MIGR dependencies on GMD_OPRN_PROCESS_PARAMETERS

Line 391: /* Insert process parameter 1 value into GMD_OPRN_PROCESS_PARAMETERS table */

387: Process_parameter_4,Process_parameter_5,oprn_line_id,resources
388: FROM gmd_operation_resources;
389: BEGIN
390: FOR l_rec IN Cur_oprn_parameters LOOP
391: /* Insert process parameter 1 value into GMD_OPRN_PROCESS_PARAMETERS table */
392: IF l_rec.process_parameter_1 IS NOT NULL THEN
393: INSERT INTO gmd_oprn_process_parameters
394: (oprn_line_id,
395: resources,

Line 393: INSERT INTO gmd_oprn_process_parameters

389: BEGIN
390: FOR l_rec IN Cur_oprn_parameters LOOP
391: /* Insert process parameter 1 value into GMD_OPRN_PROCESS_PARAMETERS table */
392: IF l_rec.process_parameter_1 IS NOT NULL THEN
393: INSERT INTO gmd_oprn_process_parameters
394: (oprn_line_id,
395: resources,
396: parameter_id,
397: target_value,

Line 414: FROM gmd_oprn_process_parameters

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
417: AND parameter_id = 1);
418: END IF; /*IF l_rec.process_parameter_1 IS NOT NULL THEN*/

Line 421: INSERT INTO gmd_oprn_process_parameters

417: AND parameter_id = 1);
418: END IF; /*IF l_rec.process_parameter_1 IS NOT NULL THEN*/
419:
420: IF l_rec.process_parameter_2 IS NOT NULL THEN
421: INSERT INTO gmd_oprn_process_parameters
422: (oprn_line_id,
423: resources,
424: parameter_id,
425: target_value,

Line 442: FROM gmd_oprn_process_parameters

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
445: AND parameter_id = 2);
446: END IF; /*IF l_rec.process_parameter_2 IS NOT NULL THEN*/

Line 449: INSERT INTO gmd_oprn_process_parameters

445: AND parameter_id = 2);
446: END IF; /*IF l_rec.process_parameter_2 IS NOT NULL THEN*/
447:
448: IF l_rec.process_parameter_3 IS NOT NULL THEN
449: INSERT INTO gmd_oprn_process_parameters
450: (oprn_line_id,
451: resources,
452: parameter_id,
453: target_value,

Line 470: FROM gmd_oprn_process_parameters

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
473: AND parameter_id = 3);
474: END IF; /*IF l_rec.process_parameter_3 IS NOT NULL THEN*/

Line 477: INSERT INTO gmd_oprn_process_parameters

473: AND parameter_id = 3);
474: END IF; /*IF l_rec.process_parameter_3 IS NOT NULL THEN*/
475:
476: IF l_rec.process_parameter_4 IS NOT NULL THEN
477: INSERT INTO gmd_oprn_process_parameters
478: (oprn_line_id,
479: resources,
480: parameter_id,
481: target_value,

Line 498: FROM gmd_oprn_process_parameters

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
501: AND parameter_id = 4);
502: END IF; /*IF l_rec.process_parameter_4 IS NOT NULL THEN*/

Line 506: INSERT INTO gmd_oprn_process_parameters

502: END IF; /*IF l_rec.process_parameter_4 IS NOT NULL THEN*/
503:
504: IF l_rec.process_parameter_5 IS NOT NULL THEN
505: /*Check if the row for the resource already exists if it does not then*/
506: INSERT INTO gmd_oprn_process_parameters
507: (oprn_line_id,
508: resources,
509: parameter_id,
510: target_value,

Line 527: FROM gmd_oprn_process_parameters

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
530: AND parameter_id = 5);
531: END IF; /*IF l_rec.process_parameter_5 IS NOT NULL THEN*/

Line 537: ,p_table_name => 'GMD_OPRN_PROCESS_PARAMETERS'

533: EXCEPTION
534: WHEN OTHERS THEN
535: P_line_no := P_line_no + 1;
536: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
537: ,p_table_name => 'GMD_OPRN_PROCESS_PARAMETERS'
538: ,p_db_error => sqlerrm
539: ,p_param1 => NULL
540: ,p_param2 => NULL
541: ,p_param3 => NULL

Line 988: FROM gmd_oprn_process_parameters

984:
985: PROCEDURE get_override IS
986: CURSOR Cur_get_override IS
987: SELECT DISTINCT resources,Parameter_id
988: FROM gmd_oprn_process_parameters
989: UNION
990: SELECT DISTINCT resources,Parameter_id
991: FROM gmd_recipe_process_parameters
992: UNION

Line 999: FROM gmd_oprn_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)
999: FROM gmd_oprn_process_parameters
1000: WHERE resources = V_resources
1001: AND parameter_id = V_parameter_id
1002: GROUP BY Target_Value
1003: UNION