DBA Data[Home] [Help]

APPS.GMD_NPD_MIGRATE dependencies on GMD_PARAMETERS_HDR

Line 96: FROM gmd_parameters_hdr

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

Line 152: GMD_PARAMETERS_HDR_PKG.Insert_Row

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,

Line 319: FROM gmd_parameters_hdr

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

Line 371: GMD_PARAMETERS_HDR_PKG.Insert_Row ( X_rowid => l_rowid,

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,