APPS.GMD_FORM_MIGRATION dependencies on FM_FORM_MST

Line 6: /* Need to migrate data from fm_form_mst to fm_form_mst_vl */

2: /* $Header: GMDFMIGB.pls 120.1 2005/08/12 06:18:41 txdaniel noship $ pxkumar*/
3:
4: PROCEDURE Insert_form_status
5: IS
6: /* Need to migrate data from fm_form_mst to fm_form_mst_vl */
7: CURSOR formula_cur_vl IS
8: SELECT * from fm_form_mst m1
9: WHERE EXISTS ( Select 1
10: from fm_form_mst

Line 8: SELECT * from fm_form_mst m1

4: PROCEDURE Insert_form_status
5: IS
6: /* Need to migrate data from fm_form_mst to fm_form_mst_vl */
7: CURSOR formula_cur_vl IS
8: SELECT * from fm_form_mst m1
9: WHERE EXISTS ( Select 1
10: from fm_form_mst
11: Where formula_no = m1.formula_no AND
12: formula_vers = m1.formula_vers AND

Line 10: from fm_form_mst

6: /* Need to migrate data from fm_form_mst to fm_form_mst_vl */
7: CURSOR formula_cur_vl IS
8: SELECT * from fm_form_mst m1
9: WHERE EXISTS ( Select 1
10: from fm_form_mst
11: Where formula_no = m1.formula_no AND
12: formula_vers = m1.formula_vers AND
13: formula_status IS NULL);
14:

Line 37: l_fm_desc fm_form_mst.formula_desc1%TYPE;

33: l_msg_data varchar2(240);
34: l_msg_count NUMBER;
35: error_msg varchar2(240);
36: /* TKW 6/25/2002 B2428431 */
37: l_fm_desc fm_form_mst.formula_desc1%TYPE;
38:
39: l_inactive_ind NUMBER;
40:
41: TOTAL_OUTPUT_NOT_CALC EXCEPTION ;

Line 45: /* Update the apps.fm_form_mst with appropriate status and qty values */

41: TOTAL_OUTPUT_NOT_CALC EXCEPTION ;
42:
43: BEGIN
44:
45: /* Update the apps.fm_form_mst with appropriate status and qty values */
46: FOR formula_rec IN formula_cur_vl LOOP
47: BEGIN
48: /* get the qty and uoms */
49: GMD_COMMON_VAL.CALCULATE_TOTAL_QTY (

Line 90: UPDATE fm_form_mst_b

86: /* Define the creation and owner orgn values */
87: l_orgn_code := fnd_profile.value_specific('GEMMS_DEFAULT_ORGN',formula_rec.created_by);
88:
89: /* Call the formula update MLS API*/
90: UPDATE fm_form_mst_b
91: SET orgn_code = l_orgn_code,
92: total_output_qty = l_total_output_qty,
93: total_input_qty = l_total_input_qty,
94: formula_uom = l_uom,

Line 101: UPDATE fm_form_mst_tl

97: inactive_ind = l_inactive_ind
98: WHERE formula_id = formula_rec.formula_id;
99:
100: IF formula_rec.FORMULA_DESC1 IS NULL THEN
101: UPDATE fm_form_mst_tl
102: SET formula_desc1 = l_fm_desc
103: WHERE formula_id = formula_rec.formula_id
104: AND userenv('LANG') IN (language, source_lang);
105: END IF;

Line 109: GMD_RECIPE_MIGRATION.insert_message (p_source_table => 'FM_FORM_MST'

105: END IF;
106: EXCEPTION
107: WHEN TOTAL_OUTPUT_NOT_CALC THEN
108: error_msg := 'The Total Output Quantity for this formula cannot be calculated';
109: GMD_RECIPE_MIGRATION.insert_message (p_source_table => 'FM_FORM_MST'
110: ,p_target_table => 'FM_FORM_MST'
111: ,p_source_id => formula_rec.formula_id
112: ,p_target_id => formula_rec.formula_id
113: ,p_message => error_msg

Line 110: ,p_target_table => 'FM_FORM_MST'

106: EXCEPTION
107: WHEN TOTAL_OUTPUT_NOT_CALC THEN
108: error_msg := 'The Total Output Quantity for this formula cannot be calculated';
109: GMD_RECIPE_MIGRATION.insert_message (p_source_table => 'FM_FORM_MST'
110: ,p_target_table => 'FM_FORM_MST'
111: ,p_source_id => formula_rec.formula_id
112: ,p_target_id => formula_rec.formula_id
113: ,p_message => error_msg
114: ,p_error_type => 'E');

Line 117: GMD_RECIPE_MIGRATION.insert_message (p_source_table => 'FM_FORM_MST'

113: ,p_message => error_msg
114: ,p_error_type => 'E');
115: WHEN OTHERS THEN
116: error_msg := SQLERRM;
117: GMD_RECIPE_MIGRATION.insert_message (p_source_table => 'FM_FORM_MST'
118: ,p_target_table => 'FM_FORM_MST'
119: ,p_source_id => formula_rec.formula_id
120: ,p_target_id => formula_rec.formula_id
121: ,p_message => error_msg

Line 118: ,p_target_table => 'FM_FORM_MST'

114: ,p_error_type => 'E');
115: WHEN OTHERS THEN
116: error_msg := SQLERRM;
117: GMD_RECIPE_MIGRATION.insert_message (p_source_table => 'FM_FORM_MST'
118: ,p_target_table => 'FM_FORM_MST'
119: ,p_source_id => formula_rec.formula_id
120: ,p_target_id => formula_rec.formula_id
121: ,p_message => error_msg
122: ,p_error_type => 'U');

Line 128: UPDATE fm_form_mst_b

124: END LOOP;
125:
126: /* Bug # 2562689 - Obsolete all formulas whose item are inactive */
127: FOR get_inactive_form_rec IN get_inactive_item_formula LOOP
128: UPDATE fm_form_mst_b
129: SET formula_status = '1000'
130: WHERE formula_id = get_inactive_form_rec.formula_id;
131: END LOOP;
132: