DBA Data[Home] [Help]

APPS.GMD_EBI_RECIPE_PUB dependencies on FND_DOCUMENT_CATEGORIES_TL

Line 1110: SELECT category_id INTO l_category_id FROM FND_DOCUMENT_CATEGORIES_tl WHERE user_name='Formula Header Info';

1106:
1107: BEGIN
1108: x_return_status := FND_API.G_RET_STS_SUCCESS;
1109: x_msg_data := NULL;
1110: SELECT category_id INTO l_category_id FROM FND_DOCUMENT_CATEGORIES_tl WHERE user_name='Formula Header Info';
1111: l_text := FND_MESSAGE.GET_STRING('GMD','GMD_FORMULA') ||':'|| p_recipe_obj.formula_obj.formula_header.FORMULA_NO;
1112: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_DESCRIPTION') ||':'|| p_recipe_obj.formula_obj.formula_header.FORMULA_DESC1;
1113: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_STATUS') ||':'|| p_recipe_obj.formula_obj.formula_header.FORMULA_STATUS;
1114: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_FACILITY')|| ':';