APPS.GMD_SEARCH_REPLACE_VERS dependencies on FM_FORM_MST_B

Line 1085: FROM fm_form_mst_b

1081: WHERE formula_id = p_formula_id;
1082:
1083: CURSOR Cur_get_status (V_formula_id IN NUMBER) IS
1084: SELECT formula_status
1085: FROM fm_form_mst_b
1086: WHERE formula_id = V_formula_id;
1087:
1088: CURSOR Cur_get_auto_recipe(V_orgn_id fm_form_mst_b.owner_organization_id%TYPE) IS
1089: SELECT creation_type

Line 1088: CURSOR Cur_get_auto_recipe(V_orgn_id fm_form_mst_b.owner_organization_id%TYPE) IS

1084: SELECT formula_status
1085: FROM fm_form_mst_b
1086: WHERE formula_id = V_formula_id;
1087:
1088: CURSOR Cur_get_auto_recipe(V_orgn_id fm_form_mst_b.owner_organization_id%TYPE) IS
1089: SELECT creation_type
1090: FROM gmd_recipe_generation
1091: WHERE organization_id = V_orgn_id
1092: AND creation_type IN (1,2)

Line 1238: OPEN cur_form_att('FM_FORM_MST_B',to_char(p_formula_id));

1234: X_YIELD_UOM => x_hdr_rec.yield_uom,
1235: X_AUTO_PRODUCT_CALC => x_hdr_rec.auto_product_calc);
1236: --kkillams, Bug 3738941
1237: --Added following validation to copy the attachments
1238: OPEN cur_form_att('FM_FORM_MST_B',to_char(p_formula_id));
1239: FETCH cur_form_att INTO l_dummy;
1240: IF cur_form_att%FOUND THEN
1241: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
1242: X_from_entity_name => 'FM_FORM_MST_B',

Line 1242: X_from_entity_name => 'FM_FORM_MST_B',

1238: OPEN cur_form_att('FM_FORM_MST_B',to_char(p_formula_id));
1239: FETCH cur_form_att INTO l_dummy;
1240: IF cur_form_att%FOUND THEN
1241: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
1242: X_from_entity_name => 'FM_FORM_MST_B',
1243: X_from_pk1_value => TO_CHAR(p_formula_id),
1244: X_from_pk2_value => NULL,
1245: X_from_pk3_value => NULL,
1246: X_from_pk4_value => NULL,

Line 1248: X_to_entity_name => 'FM_FORM_MST_B',

1244: X_from_pk2_value => NULL,
1245: X_from_pk3_value => NULL,
1246: X_from_pk4_value => NULL,
1247: X_from_pk5_value => NULL,
1248: X_to_entity_name => 'FM_FORM_MST_B',
1249: X_to_pk1_value => TO_CHAR(X_formula_id),
1250: X_to_pk2_value => NULL,
1251: X_to_pk3_value => NULL,
1252: X_to_pk4_value => NULL,

Line 1357: UPDATE fm_form_mst_b

1353: x_return_status => x_return_status_for_calc ,
1354: x_msg_count => X_msg_cnt ,
1355: x_msg_data => x_msg_dat );
1356:
1357: UPDATE fm_form_mst_b
1358: SET total_output_qty = l_output_qty,
1359: total_input_qty = l_input_qty,
1360: formula_uom = l_uom
1361: WHERE formula_id = X_formula_id;