APPS.PA_FP_REFRESH_ELEMENTS_PUB dependencies on PA_PROJ_FP_OPTIONS

Line 65: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE

61:
62: PROCEDURE get_refresh_plan_ele_dtls(
63: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
64: DEFAULT NULL,
65: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
66: DEFAULT NULL,
67: x_request_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
68: x_process_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
69: x_refresh_required_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 88: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE

84: p_project_id IN pa_projects_all.project_id%TYPE,
85: p_request_id IN pa_budget_versions.request_id%TYPE,
86: p_process_code IN pa_budget_versions.plan_processing_code%TYPE,
87: p_refresh_required_flag IN VARCHAR2,
88: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
89: DEFAULT NULL,
90: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
91: DEFAULT NULL,
92: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 171: FROM pa_proj_fp_options

167: BULK COLLECT INTO l_fp_opt_tbl,l_tname_tbl
168: FROM
169: (
170: SELECT proj_fp_options_id proj_fp_options_id,'OPT' l_tname
171: FROM pa_proj_fp_options
172: WHERE
173: project_id = p_project_id AND
174: fin_plan_option_level_code IN ( 'PROJECT',
175: 'PLAN_TYPE' ) AND

Line 184: pa_proj_fp_options opt,

180: p_request_id = request_id AND
181: plan_processing_code = 'WUP'
182: UNION ALL
183: SELECT proj_fp_options_id proj_fp_options_id, 'BV' l_tname FROM
184: pa_proj_fp_options opt,
185: pa_budget_versions bv
186: WHERE
187: opt.project_id = p_project_id AND
188: opt.fin_plan_option_level_code = 'PLAN_VERSION' AND

Line 203: FROM pa_proj_fp_options

199: BULK COLLECT INTO l_fp_opt_tbl,l_tname_tbl
200: FROM
201: (
202: SELECT proj_fp_options_id proj_fp_options_id,'OPT' l_tname
203: FROM pa_proj_fp_options
204: WHERE
205: project_id = p_project_id AND
206: fin_plan_option_level_code IN ( 'PROJECT',
207: 'PLAN_TYPE' ) AND

Line 214: pa_proj_fp_options opt,

210: nvl(revenue_fin_plan_level_code,'x' ) IN ( 'L','T','M' ) ) AND
211: NVL(process_update_wbs_flag,'N') = 'Y'
212: UNION ALL
213: SELECT proj_fp_options_id proj_fp_options_id, 'BV' l_tname FROM
214: pa_proj_fp_options opt,
215: pa_budget_versions bv
216: WHERE
217: opt.project_id = p_project_id AND
218: opt.fin_plan_option_level_code = 'PLAN_VERSION' AND