APPS.GMD_FORM_MIGRATION dependencies on FM_MATL_DTL

Line 19: FROM ic_item_mst i, fm_matl_dtl d

15: /* BUG # 2562689 - Cursor that gets all formulas that have
16: inactive items */
17: CURSOR get_inactive_item_formula IS
18: SELECT distinct d.formula_id
19: FROM ic_item_mst i, fm_matl_dtl d
20: WHERE i.item_id = d.item_id
21: AND i.delete_mark = 1
22: GROUP BY d.formula_id;
23:

Line 141: -- FOR my_rec IN (select * from fm_matl_dtl) LOOP

137: BEGIN
138: /*Bug 2980227 - Thomas Daniel */
139: /*Fixed the following code for not resetting the values for customers who are upgrading */
140: /*Introduced the NVL statements to update the defaults only if they were not filled in earlier */
141: -- FOR my_rec IN (select * from fm_matl_dtl) LOOP
142:
143: BEGIN
144: UPDATE fm_matl_dtl
145: SET contribute_step_qty_ind = NVL(contribute_step_qty_ind, 'Y'),

Line 144: UPDATE fm_matl_dtl

140: /*Introduced the NVL statements to update the defaults only if they were not filled in earlier */
141: -- FOR my_rec IN (select * from fm_matl_dtl) LOOP
142:
143: BEGIN
144: UPDATE fm_matl_dtl
145: SET contribute_step_qty_ind = NVL(contribute_step_qty_ind, 'Y'),
146: scale_multiple = NVL(scale_multiple, 0),
147: scale_rounding_variance = NVL(scale_rounding_variance, 0),
148: contribute_yield_ind = NVL(contribute_yield_ind, 'Y');

Line 158: GMD_RECIPE_MIGRATION.insert_message (p_source_table => 'FM_MATL_DTL'

154:
155: EXCEPTION
156: WHEN OTHERS THEN
157: error_msg := SQLERRM;
158: GMD_RECIPE_MIGRATION.insert_message (p_source_table => 'FM_MATL_DTL'
159: ,p_target_table => 'FM_MATL_DTL'
160: ,p_source_id => NULL
161: ,p_target_id => NULL
162: ,p_message => error_msg

Line 159: ,p_target_table => 'FM_MATL_DTL'

155: EXCEPTION
156: WHEN OTHERS THEN
157: error_msg := SQLERRM;
158: GMD_RECIPE_MIGRATION.insert_message (p_source_table => 'FM_MATL_DTL'
159: ,p_target_table => 'FM_MATL_DTL'
160: ,p_source_id => NULL
161: ,p_target_id => NULL
162: ,p_message => error_msg
163: ,p_error_type => 'U');