APPS.PA_FP_WEBADI_UTILS dependencies on BNE_LAYOUTS_TL

Line 218: FROM bne_layouts_tl

214: AND l_integrator_code NOT IN ('FINPLAN_FORECAST_PERIODIC' , 'FINPLAN_FORECAST_NON_PERIODIC' ))) THEN
215:
216: SELECT user_name
217: INTO l_layout_meaning
218: FROM bne_layouts_tl
219: WHERE layout_code = x_layout_code
220: AND language = userenv('lang')
221: AND application_id = (SELECT application_id
222: FROM FND_APPLICATION

Line 2280: ,x_layout_name OUT NOCOPY bne_layouts_tl.user_name%TYPE --File.Sql.39 bug 4440895

2276: ===================================================================================*/
2277: PROCEDURE get_layout_details
2278: (p_layout_code IN pa_proj_fp_options.cost_layout_code%TYPE
2279: ,p_integrator_code IN bne_integrators_b.integrator_code%TYPE
2280: ,x_layout_name OUT NOCOPY bne_layouts_tl.user_name%TYPE --File.Sql.39 bug 4440895
2281: ,x_layout_type_code OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
2282: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2283: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2284: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2299: l_layout_name bne_layouts_tl.user_name%TYPE;

2295: l_debug_level5 CONSTANT NUMBER := 5;
2296: l_module_name VARCHAR2(200) := g_module_name||'.get_layout_details';
2297: --End of variables used for debugging
2298: l_integrator_code VARCHAR2(30);
2299: l_layout_name bne_layouts_tl.user_name%TYPE;
2300: BEGIN
2301: x_msg_count := 0;
2302: x_return_status := FND_API.G_RET_STS_SUCCESS;
2303: