APPS.GMD_SEARCH_REPLACE_VERS dependencies on FM_FORM_MST

Line 1070: FROM fm_form_mst

1066: SELECT gem5_formula_id_s.NEXTVAL
1067: FROM FND_DUAL;
1068: CURSOR Cur_get_hdr IS
1069: SELECT *
1070: FROM fm_form_mst
1071: WHERE formula_id = p_formula_id;
1072: X_hdr_rec Cur_get_hdr%ROWTYPE;
1073: CURSOR Cur_formula_vers IS
1074: SELECT MAX(formula_vers) + 1

Line 1075: FROM fm_form_mst

1071: WHERE formula_id = p_formula_id;
1072: X_hdr_rec Cur_get_hdr%ROWTYPE;
1073: CURSOR Cur_formula_vers IS
1074: SELECT MAX(formula_vers) + 1
1075: FROM fm_form_mst
1076: WHERE formula_no = X_hdr_rec.formula_no;
1077:
1078: CURSOR Cur_get_dtl IS
1079: SELECT *

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 1177: fm_form_mst_mls.insert_row(X_ROWID => l_rowid,

1173: x_return_status => x_return_status);
1174: END IF;
1175:
1176: /* Insert header record */
1177: fm_form_mst_mls.insert_row(X_ROWID => l_rowid,
1178: X_FORMULA_ID => X_formula_id,
1179: X_MASTER_FORMULA_ID => NULL,
1180: X_OWNER_ORGANIZATION_ID => X_hdr_rec.owner_organization_id,
1181: X_TEXT_CODE => X_hdr_rec.text_code,

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;