DBA Data[Home] [Help]

APPS.GMD_EBI_RECIPE_PUB dependencies on MTL_PARAMETERS

Line 136: SELECT organization_id INTO l_org_id FROM mtl_parameters

132: BEGIN
133: x_return_status := FND_API.G_RET_STS_SUCCESS;
134: l_formula_obj := p_formula_obj;
135: IF l_formula_obj IS NOT NULL THEN
136: SELECT organization_id INTO l_org_id FROM mtl_parameters
137: WHERE organization_code = l_formula_obj.formula_header.OWNER_ORGANIZATION_CODE;
138: l_formula_obj.formula_header.OWNER_ORGANIZATION_ID := l_org_id;
139: FOR j in 1..l_formula_obj.formula_details.COUNT LOOP
140: l_formula_obj.formula_details(j).OWNER_ORGANIZATION_ID := l_org_id;

Line 263: FROM MTL_PARAMETERS

259: IS
260: l_org_id NUMBER;
261: BEGIN
262: SELECT organization_id INTO l_org_id
263: FROM MTL_PARAMETERS
264: WHERE organization_code=p_org_code;
265: RETURN l_org_id;
266: EXCEPTION
267: WHEN OTHERS THEN