APPS.GMD_EBI_RECIPE_PUB dependencies on FM_MATL_DTL

Line 228: SELECT formulaline_id INTO l_form_line_id FROM fm_matl_dtl WHERE formula_id = l_form_id

224: ELSE
225: l_form_id := p_input.formula_header.FORMULA_ID;
226: END IF;
227: FOR j IN 1..p_input.formula_details.Count LOOP
228: SELECT formulaline_id INTO l_form_line_id FROM fm_matl_dtl WHERE formula_id = l_form_id
229: AND line_type=p_input.formula_details(j).line_type AND line_no = p_input.formula_details(j).line_no;
230: l_out_line_sync_obj := gmd_ebi_formula_line_sync_obj(l_form_line_id,p_input.formula_details(j).business_component_id);
231: l_out_line_sync_tbl.extend(1);
232: l_out_line_sync_tbl(line_ctr) := l_out_line_sync_obj;

Line 1397: SELECT formula_id,formulaline_id FROM fm_matl_dtl WHERE formula_id = p_formula_detail_tbl(1).formula_id;

1393:
1394:
1395: CURSOR get_formula_line_id
1396: IS
1397: SELECT formula_id,formulaline_id FROM fm_matl_dtl WHERE formula_id = p_formula_detail_tbl(1).formula_id;
1398:
1399: BEGIN
1400: FOR formula_line IN get_formula_line_id LOOP
1401: l_line_found:=0;

Line 1927: SELECT Count(*) INTO l_msg_count FROM fm_matl_dtl WHERE formula_id=470;

1923: ,x_msg_count => l_msg_count
1924: ,x_msg_data => l_msg_data
1925: ,p_formula_detail_tbl =>l_formula_insert_detail_tbl
1926: );
1927: SELECT Count(*) INTO l_msg_count FROM fm_matl_dtl WHERE formula_id=470;
1928: IF (l_ret_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN
1929: x_msg_data := l_msg_data;
1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1931: END If;