APPS.GMD_NPD_MIGRATE dependencies on GMD_PARAMETERS_DTL

Line 327: FROM gmd_parameters_dtl

323: V_parameter VARCHAR2) IS
324: SELECT 1
325: FROM sys.dual
326: WHERE EXISTS (SELECT 1
327: FROM gmd_parameters_dtl
328: WHERE parameter_id = V_parameter_id
329: AND parameter_name = V_parameter);
330:
331: CURSOR Cur_get_new_parameter_id IS

Line 431: GMD_Parameters_Dtl_Pkg.Insert_Row

427: OPEN Cur_get_new_parameter_line_id;
428: FETCH Cur_get_new_parameter_line_id INTO l_Parameter_line_Id;
429: CLOSE Cur_get_new_parameter_line_id;
430:
431: GMD_Parameters_Dtl_Pkg.Insert_Row
432: ( X_rowid => l_rowid,
433: X_parameter_line_id => l_Parameter_line_Id,
434: X_parameter_id => l_parameter_id,
435: X_parm_Type => 1,

Line 473: GMD_Parameters_Dtl_Pkg.Insert_Row

469: OPEN Cur_get_new_parameter_line_id;
470: FETCH Cur_get_new_parameter_line_id INTO l_Parameter_line_Id;
471: CLOSE Cur_get_new_parameter_line_id;
472:
473: GMD_Parameters_Dtl_Pkg.Insert_Row
474: ( X_rowid => l_rowid,
475: X_parameter_line_id => l_Parameter_line_Id,
476: X_parameter_id => l_parameter_id,
477: X_parm_Type => 1,

Line 516: GMD_Parameters_Dtl_Pkg.Insert_Row

512: OPEN Cur_get_new_parameter_line_id;
513: FETCH Cur_get_new_parameter_line_id INTO l_Parameter_line_Id;
514: CLOSE Cur_get_new_parameter_line_id;
515:
516: GMD_Parameters_Dtl_Pkg.Insert_Row
517: ( X_rowid => l_rowid,
518: X_parameter_line_id => l_parameter_line_id,
519: X_parameter_id => l_parameter_id,
520: X_parm_Type => 1,

Line 558: GMD_Parameters_Dtl_Pkg.Insert_Row

554: OPEN Cur_get_new_parameter_line_id;
555: FETCH Cur_get_new_parameter_line_id INTO l_Parameter_line_Id;
556: CLOSE Cur_get_new_parameter_line_id;
557:
558: GMD_Parameters_Dtl_Pkg.Insert_Row
559: ( X_rowid => l_rowid,
560: X_parameter_line_id => l_parameter_line_id,
561: X_parameter_id => l_parameter_id,
562: X_parm_Type => 1,

Line 599: GMD_Parameters_Dtl_Pkg.Insert_Row

595: OPEN Cur_get_new_parameter_line_id;
596: FETCH Cur_get_new_parameter_line_id INTO l_Parameter_line_Id;
597: CLOSE Cur_get_new_parameter_line_id;
598:
599: GMD_Parameters_Dtl_Pkg.Insert_Row
600: ( X_rowid => l_rowid,
601: X_parameter_line_id => l_parameter_line_id,
602: X_parameter_id => l_parameter_id,
603: X_parm_Type => 1,

Line 640: GMD_Parameters_Dtl_Pkg.Insert_Row

636: OPEN Cur_get_new_parameter_line_id;
637: FETCH Cur_get_new_parameter_line_id INTO l_Parameter_line_Id;
638: CLOSE Cur_get_new_parameter_line_id;
639:
640: GMD_Parameters_Dtl_Pkg.Insert_Row
641: ( X_rowid => l_rowid,
642: X_parameter_line_id => l_parameter_line_id,
643: X_parameter_id => l_parameter_id,
644: X_parm_Type => 1,

Line 682: GMD_Parameters_Dtl_Pkg.Insert_Row

678: OPEN Cur_get_new_parameter_line_id;
679: FETCH Cur_get_new_parameter_line_id INTO l_Parameter_line_Id;
680: CLOSE Cur_get_new_parameter_line_id;
681:
682: GMD_Parameters_Dtl_Pkg.Insert_Row
683: ( X_rowid => l_rowid,
684: X_parameter_line_id => l_parameter_line_id,
685: X_parameter_id => l_parameter_id,
686: X_parm_Type => 1,

Line 728: GMD_Parameters_Dtl_Pkg.Insert_Row

724: OPEN Cur_get_new_parameter_line_id;
725: FETCH Cur_get_new_parameter_line_id INTO l_Parameter_line_Id;
726: CLOSE Cur_get_new_parameter_line_id;
727:
728: GMD_Parameters_Dtl_Pkg.Insert_Row
729: ( X_rowid => l_rowid,
730: X_parameter_line_id => l_parameter_line_id,
731: X_parameter_id => l_parameter_id,
732: X_parm_Type => 4,

Line 769: GMD_Parameters_Dtl_Pkg.Insert_Row

765: OPEN Cur_get_new_parameter_line_id;
766: FETCH Cur_get_new_parameter_line_id INTO l_Parameter_line_Id;
767: CLOSE Cur_get_new_parameter_line_id;
768:
769: GMD_Parameters_Dtl_Pkg.Insert_Row
770: ( X_rowid => l_rowid,
771: X_parameter_line_id => l_parameter_line_id,
772: X_parameter_id => l_parameter_id,
773: X_parm_Type => 4,

Line 815: GMD_Parameters_Dtl_Pkg.Insert_Row

811: OPEN Cur_get_new_parameter_line_id;
812: FETCH Cur_get_new_parameter_line_id INTO l_Parameter_line_Id;
813: CLOSE Cur_get_new_parameter_line_id;
814:
815: GMD_Parameters_Dtl_Pkg.Insert_Row
816: ( X_rowid => l_rowid,
817: X_parameter_line_id => l_parameter_line_id,
818: X_parameter_id => l_parameter_id,
819: X_parm_Type => 2,

Line 861: GMD_Parameters_Dtl_Pkg.Insert_Row

857: OPEN Cur_get_new_parameter_line_id;
858: FETCH Cur_get_new_parameter_line_id INTO l_Parameter_line_Id;
859: CLOSE Cur_get_new_parameter_line_id;
860:
861: GMD_Parameters_Dtl_Pkg.Insert_Row
862: ( X_rowid => l_rowid,
863: X_parameter_line_id => l_parameter_line_id,
864: X_parameter_id => l_parameter_id,
865: X_parm_Type => 3,

Line 902: GMD_Parameters_Dtl_Pkg.Insert_Row

898: OPEN Cur_get_new_parameter_line_id;
899: FETCH Cur_get_new_parameter_line_id INTO l_Parameter_line_Id;
900: CLOSE Cur_get_new_parameter_line_id;
901:
902: GMD_Parameters_Dtl_Pkg.Insert_Row
903: ( X_rowid => l_rowid,
904: X_parameter_line_id => l_parameter_line_id,
905: X_parameter_id => l_parameter_id,
906: X_parm_Type => 3,

Line 944: GMD_Parameters_Dtl_Pkg.Insert_Row

940: OPEN Cur_get_new_parameter_line_id;
941: FETCH Cur_get_new_parameter_line_id INTO l_Parameter_line_Id;
942: CLOSE Cur_get_new_parameter_line_id;
943:
944: GMD_Parameters_Dtl_Pkg.Insert_Row
945: ( X_rowid => l_rowid,
946: X_parameter_line_id => l_parameter_line_id,
947: X_parameter_id => l_parameter_id,
948: X_parm_Type => 3,