92: CURSOR Cur_check_existence (V_organization_id NUMBER) IS
93: SELECT 1
94: FROM sys.dual
95: WHERE EXISTS (SELECT 1
96: FROM gmd_parameters_hdr
97: WHERE organization_id = V_organization_id);
98:
99: CURSOR Cur_get_new_parameter_id IS
100: SELECT GMD_Parameter_Id_S.nextval
148: l_lab_ind := 1;
149: END IF;
150:
151: /* Lets create the parameter record for the organization */
152: GMD_PARAMETERS_HDR_PKG.Insert_Row
153: (X_rowid => l_rowid,
154: X_Parameter_Id => l_Parameter_Id,
155: X_organization_id => l_rec.organization_id,
156: X_Lab_Ind => l_lab_ind,
315:
316: /* ------------------ CURSORS ---------------------- */
317: CURSOR Cur_get_parameter_id IS
318: SELECT parameter_id
319: FROM gmd_parameters_hdr
320: WHERE organization_id IS NULL;
321:
322: CURSOR Cur_check_parameter_exists (V_parameter_id NUMBER,
323: V_parameter VARCHAR2) IS
367:
368: L_new := 1;
369:
370: /*Insert a row into the header table for Global organization */
371: GMD_PARAMETERS_HDR_PKG.Insert_Row ( X_rowid => l_rowid,
372: X_Parameter_Id => l_parameter_id,
373: X_organization_id => NULL,
374: X_Lab_Ind => 0,
375: X_plant_Ind => 0,