[Home] [Help]
30: if so then get the max version of the formula*/
31:
32: CURSOR Cur_check_formula_exists (V_formula_no VARCHAR2, V_formula_vers NUMBER) IS
33: SELECT formula_vers , formula_status
34: FROM fm_form_mst
35: WHERE formula_no = V_formula_no
36: AND formula_vers = V_formula_vers ;
37:
38:
42: WHERE old_formula_id = v_formula_id;
43:
44: CURSOR Cur_get_max_vers(V_formula_no VARCHAR2) IS
45: SELECT max(formula_vers)
46: FROM fm_form_mst
47: WHERE formula_no = V_formula_no;
48:
49:
50: /*Cursor to get the formula_id of the formula with tpformula_id > 0*/
50: /*Cursor to get the formula_id of the formula with tpformula_id > 0*/
51:
52: CURSOR Cur_get_tp_id (V_formula_id NUMBER) IS
53: SELECT formula_id
54: FROM fm_form_mst
55: WHERE (formula_no, formula_vers)
56: IN (SELECT formula_no, formula_vers
57: FROM lm_form_mst
58: WHERE formula_id = V_formula_id);
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,
166: lab_rec.attribute28, lab_rec.attribute29, lab_rec.attribute30, lab_rec.inactive_ind, lab_rec.scale_type, lab_rec.formula_class,
167: lab_rec.fmcontrol_class, lab_rec.creation_date, lab_rec.created_by, lab_rec.last_update_date, lab_rec.last_updated_by,
168: lab_rec.last_update_login);
169:
170: INSERT INTO FM_FORM_MST_TL (formula_id, formula_desc1, formula_desc2, language, source_lang,
171: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
172: SELECT xFormula_Id, lab_rec.formula_desc1, lab_rec.formula_desc2, l.language_code, userenv('LANG'),
173: lab_rec.created_by, lab_rec.creation_date, lab_rec.last_updated_by, lab_rec.last_update_date, lab_rec.last_update_login
174: FROM FND_LANGUAGES l
172: SELECT xFormula_Id, lab_rec.formula_desc1, lab_rec.formula_desc2, l.language_code, userenv('LANG'),
173: lab_rec.created_by, lab_rec.creation_date, lab_rec.last_updated_by, lab_rec.last_update_date, lab_rec.last_update_login
174: FROM FND_LANGUAGES l
175: WHERE l.installed_flag IN ('I', 'B')
176: AND NOT EXISTS (SELECT NULL FROM FM_FORM_MST_TL T WHERE t.formula_id = xFormula_Id AND t.language = l.language_code);
177:
178:
179:
180: INSERT INTO GMD_LAB_FORMULA_ASSOC(old_formula_id,old_formula_no,old_formula_vers,
312: target_id ,
313: message_text )
314: SELECT GMD_REQUEST_ID_S.nextval,
315: 'LM_FORM_MST AND LM_FORM_DTL',
316: 'FM_FORM_MST AND MF_MATL_DTL',
317: lab_rec.formula_id,
318: Xformula_id,
319: error_msg
320: FROM DUAL;
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,
402: lab_rec.attribute28, lab_rec.attribute29, lab_rec.attribute30, lab_rec.inactive_ind, lab_rec.scale_type, lab_rec.formula_class,
403: lab_rec.fmcontrol_class, lab_rec.creation_date, lab_rec.created_by, lab_rec.last_update_date, lab_rec.last_updated_by,
404: lab_rec.last_update_login);
405:
406: INSERT INTO FM_FORM_MST_TL (formula_id, formula_desc1, formula_desc2, language, source_lang,
407: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
408: SELECT xFormula_Id, lab_rec.formula_desc1, lab_rec.formula_desc2, l.language_code, userenv('LANG'),
409: lab_rec.created_by, lab_rec.creation_date, lab_rec.last_updated_by, lab_rec.last_update_date, lab_rec.last_update_login
410: FROM FND_LANGUAGES l
408: SELECT xFormula_Id, lab_rec.formula_desc1, lab_rec.formula_desc2, l.language_code, userenv('LANG'),
409: lab_rec.created_by, lab_rec.creation_date, lab_rec.last_updated_by, lab_rec.last_update_date, lab_rec.last_update_login
410: FROM FND_LANGUAGES l
411: WHERE l.installed_flag IN ('I', 'B')
412: AND NOT EXISTS (SELECT NULL FROM FM_FORM_MST_TL T WHERE t.formula_id = xFormula_Id AND t.language = l.language_code);
413:
414:
415: For lab_detail_rec IN lab_detail(lab_rec.formula_id)
416: LOOP
558: target_id ,
559: message_text )
560: SELECT GMD_REQUEST_ID_S.nextval,
561: 'LM_FORM_MST AND LM_FORM_DTL',
562: 'FM_FORM_MST AND MF_MATL_DTL',
563: lab_rec.formula_id,
564: Xformula_id,
565: error_msg
566: FROM DUAL;