[Home] [Help]
133: select fnd_profile.value_specific('GEMMS_DEFAULT_ORGN',lab_rec.created_by)
134: INTO l_orgn_code
135: FROM sys.dual;
136:
137: /* Step 3 : To insert data ino the fm_form_mst_b and fm_form_mst_vl
138: table */
139: /* changed x_formula_vers to lab_rec.formula_vers */
140:
141: /* BEGIN BUG#3217071*/
145: X_STATUS := 400;
146: END IF;
147: /* END BUG#3217071*/
148:
149: INSERT INTO FM_FORM_MST_B (formula_id, orgn_code, total_input_qty, total_output_qty, formula_status,
150: formula_uom, owner_id, attribute_category, text_code, delete_mark,
151: formula_no, formula_vers, formula_type, attribute1, attribute2, attribute3,
152: attribute4, attribute5, attribute6, attribute7, attribute8, attribute9,
153: attribute10, attribute11, attribute12, attribute13, attribute14, attribute15,
365: select fnd_profile.value_specific('GEMMS_DEFAULT_ORGN',lab_rec.created_by)
366: INTO l_orgn_code
367: FROM sys.dual;
368:
369: /* Step 3 : To insert data ino the fm_form_mst_b and fm_form_mst_vl
370: table */
371: INSERT INTO GMD_LAB_FORMULA_ASSOC(old_formula_id,old_formula_no,old_formula_vers,
372: new_formula_id,new_formula_no,new_formula_vers
373: ,migrated)
381: X_STATUS := 400;
382: END IF;
383: /* END BUG#3217071*/
384:
385: INSERT INTO FM_FORM_MST_B (formula_id, orgn_code, total_input_qty, total_output_qty, formula_status,
386: formula_uom, owner_id, attribute_category, text_code, delete_mark,
387: formula_no, formula_vers, formula_type, attribute1, attribute2, attribute3,
388: attribute4, attribute5, attribute6, attribute7, attribute8, attribute9,
389: attribute10, attribute11, attribute12, attribute13, attribute14, attribute15,