eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_ELEMENTS_PUB dependencies on PA_PROJ_FP_OPTIONS

Line 27: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE

23: ,p_cost_resource_list_id IN NUMBER
24: ,p_revenue_resource_list_id IN NUMBER
25: ,p_all_resource_list_id IN NUMBER
26: /*Bug :- 2920954 start of new parameters added for post fp-K one off patch */
27: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
28: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
29: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
30: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
31: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE

Line 28: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE

24: ,p_revenue_resource_list_id IN NUMBER
25: ,p_all_resource_list_id IN NUMBER
26: /*Bug :- 2920954 start of new parameters added for post fp-K one off patch */
27: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
28: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
29: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
30: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
31: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE
32: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE

Line 29: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE

25: ,p_all_resource_list_id IN NUMBER
26: /*Bug :- 2920954 start of new parameters added for post fp-K one off patch */
27: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
28: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
29: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
30: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
31: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE
32: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE
33: /*Bug :- 2920954 end of new parameters added for post fp-K one off patch */

Line 30: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE

26: /*Bug :- 2920954 start of new parameters added for post fp-K one off patch */
27: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
28: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
29: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
30: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
31: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE
32: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE
33: /*Bug :- 2920954 end of new parameters added for post fp-K one off patch */
34: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 31: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE

27: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
28: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
29: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
30: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
31: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE
32: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE
33: /*Bug :- 2920954 end of new parameters added for post fp-K one off patch */
34: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
35: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 32: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE

28: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
29: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
30: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
31: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE
32: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE
33: /*Bug :- 2920954 end of new parameters added for post fp-K one off patch */
34: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
35: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
36: ,x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895

Line 224: l_par_fp_option_id pa_proj_fp_options.PROJ_FP_OPTIONS_ID%TYPE;

220: l_msg_data VARCHAR2(2000);
221: l_msg_index_out NUMBER;
222: l_return_status VARCHAR2(2000);
223: l_stage NUMBER := 100;
224: l_par_fp_option_id pa_proj_fp_options.PROJ_FP_OPTIONS_ID%TYPE;
225: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
226: l_cost_planning_level pa_proj_fp_options.COST_FIN_PLAN_LEVEL_CODE%TYPE;
227: l_rev_planning_level pa_proj_fp_options.REVENUE_FIN_PLAN_LEVEL_CODE%TYPE;
228: l_from_proj_fp_option_id pa_proj_fp_options.PROJ_FP_OPTIONS_ID%TYPE;

Line 225: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;

221: l_msg_index_out NUMBER;
222: l_return_status VARCHAR2(2000);
223: l_stage NUMBER := 100;
224: l_par_fp_option_id pa_proj_fp_options.PROJ_FP_OPTIONS_ID%TYPE;
225: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
226: l_cost_planning_level pa_proj_fp_options.COST_FIN_PLAN_LEVEL_CODE%TYPE;
227: l_rev_planning_level pa_proj_fp_options.REVENUE_FIN_PLAN_LEVEL_CODE%TYPE;
228: l_from_proj_fp_option_id pa_proj_fp_options.PROJ_FP_OPTIONS_ID%TYPE;
229: l_from_element_type pa_fp_elements.ELEMENT_TYPE%TYPE;

Line 226: l_cost_planning_level pa_proj_fp_options.COST_FIN_PLAN_LEVEL_CODE%TYPE;

222: l_return_status VARCHAR2(2000);
223: l_stage NUMBER := 100;
224: l_par_fp_option_id pa_proj_fp_options.PROJ_FP_OPTIONS_ID%TYPE;
225: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
226: l_cost_planning_level pa_proj_fp_options.COST_FIN_PLAN_LEVEL_CODE%TYPE;
227: l_rev_planning_level pa_proj_fp_options.REVENUE_FIN_PLAN_LEVEL_CODE%TYPE;
228: l_from_proj_fp_option_id pa_proj_fp_options.PROJ_FP_OPTIONS_ID%TYPE;
229: l_from_element_type pa_fp_elements.ELEMENT_TYPE%TYPE;
230: l_to_fin_plan_type_id pa_proj_fp_options.FIN_PLAN_TYPE_ID%TYPE;

Line 227: l_rev_planning_level pa_proj_fp_options.REVENUE_FIN_PLAN_LEVEL_CODE%TYPE;

223: l_stage NUMBER := 100;
224: l_par_fp_option_id pa_proj_fp_options.PROJ_FP_OPTIONS_ID%TYPE;
225: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
226: l_cost_planning_level pa_proj_fp_options.COST_FIN_PLAN_LEVEL_CODE%TYPE;
227: l_rev_planning_level pa_proj_fp_options.REVENUE_FIN_PLAN_LEVEL_CODE%TYPE;
228: l_from_proj_fp_option_id pa_proj_fp_options.PROJ_FP_OPTIONS_ID%TYPE;
229: l_from_element_type pa_fp_elements.ELEMENT_TYPE%TYPE;
230: l_to_fin_plan_type_id pa_proj_fp_options.FIN_PLAN_TYPE_ID%TYPE;
231: l_to_fin_plan_version_id pa_proj_fp_options.FIN_PLAN_VERSION_ID%TYPE;

Line 228: l_from_proj_fp_option_id pa_proj_fp_options.PROJ_FP_OPTIONS_ID%TYPE;

224: l_par_fp_option_id pa_proj_fp_options.PROJ_FP_OPTIONS_ID%TYPE;
225: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
226: l_cost_planning_level pa_proj_fp_options.COST_FIN_PLAN_LEVEL_CODE%TYPE;
227: l_rev_planning_level pa_proj_fp_options.REVENUE_FIN_PLAN_LEVEL_CODE%TYPE;
228: l_from_proj_fp_option_id pa_proj_fp_options.PROJ_FP_OPTIONS_ID%TYPE;
229: l_from_element_type pa_fp_elements.ELEMENT_TYPE%TYPE;
230: l_to_fin_plan_type_id pa_proj_fp_options.FIN_PLAN_TYPE_ID%TYPE;
231: l_to_fin_plan_version_id pa_proj_fp_options.FIN_PLAN_VERSION_ID%TYPE;
232: l_to_project_id pa_projects.project_id%TYPE;

Line 230: l_to_fin_plan_type_id pa_proj_fp_options.FIN_PLAN_TYPE_ID%TYPE;

226: l_cost_planning_level pa_proj_fp_options.COST_FIN_PLAN_LEVEL_CODE%TYPE;
227: l_rev_planning_level pa_proj_fp_options.REVENUE_FIN_PLAN_LEVEL_CODE%TYPE;
228: l_from_proj_fp_option_id pa_proj_fp_options.PROJ_FP_OPTIONS_ID%TYPE;
229: l_from_element_type pa_fp_elements.ELEMENT_TYPE%TYPE;
230: l_to_fin_plan_type_id pa_proj_fp_options.FIN_PLAN_TYPE_ID%TYPE;
231: l_to_fin_plan_version_id pa_proj_fp_options.FIN_PLAN_VERSION_ID%TYPE;
232: l_to_project_id pa_projects.project_id%TYPE;
233: l_from_project_id pa_projects.project_id%TYPE;
234: l_element_level VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK;

Line 231: l_to_fin_plan_version_id pa_proj_fp_options.FIN_PLAN_VERSION_ID%TYPE;

227: l_rev_planning_level pa_proj_fp_options.REVENUE_FIN_PLAN_LEVEL_CODE%TYPE;
228: l_from_proj_fp_option_id pa_proj_fp_options.PROJ_FP_OPTIONS_ID%TYPE;
229: l_from_element_type pa_fp_elements.ELEMENT_TYPE%TYPE;
230: l_to_fin_plan_type_id pa_proj_fp_options.FIN_PLAN_TYPE_ID%TYPE;
231: l_to_fin_plan_version_id pa_proj_fp_options.FIN_PLAN_VERSION_ID%TYPE;
232: l_to_project_id pa_projects.project_id%TYPE;
233: l_from_project_id pa_projects.project_id%TYPE;
234: l_element_level VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK;
235:

Line 236: l_source_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE; /* M20-AUG */

232: l_to_project_id pa_projects.project_id%TYPE;
233: l_from_project_id pa_projects.project_id%TYPE;
234: l_element_level VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK;
235:
236: l_source_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE; /* M20-AUG */
237: l_target_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE; /* M20-AUG */
238: l_from_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
239: l_to_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
240: l_from_resource_list_id pa_proj_fp_options.ALL_RESOURCE_LIST_ID%TYPE;

Line 237: l_target_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE; /* M20-AUG */

233: l_from_project_id pa_projects.project_id%TYPE;
234: l_element_level VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK;
235:
236: l_source_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE; /* M20-AUG */
237: l_target_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE; /* M20-AUG */
238: l_from_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
239: l_to_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
240: l_from_resource_list_id pa_proj_fp_options.ALL_RESOURCE_LIST_ID%TYPE;
241: l_to_resource_list_id pa_proj_fp_options.ALL_RESOURCE_LIST_ID%TYPE;

Line 238: l_from_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;

234: l_element_level VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK;
235:
236: l_source_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE; /* M20-AUG */
237: l_target_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE; /* M20-AUG */
238: l_from_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
239: l_to_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
240: l_from_resource_list_id pa_proj_fp_options.ALL_RESOURCE_LIST_ID%TYPE;
241: l_to_resource_list_id pa_proj_fp_options.ALL_RESOURCE_LIST_ID%TYPE;
242:

Line 239: l_to_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;

235:
236: l_source_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE; /* M20-AUG */
237: l_target_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE; /* M20-AUG */
238: l_from_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
239: l_to_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
240: l_from_resource_list_id pa_proj_fp_options.ALL_RESOURCE_LIST_ID%TYPE;
241: l_to_resource_list_id pa_proj_fp_options.ALL_RESOURCE_LIST_ID%TYPE;
242:
243: /* Start of Variables defined for the bug :- 2684766 */

Line 240: l_from_resource_list_id pa_proj_fp_options.ALL_RESOURCE_LIST_ID%TYPE;

236: l_source_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE; /* M20-AUG */
237: l_target_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE; /* M20-AUG */
238: l_from_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
239: l_to_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
240: l_from_resource_list_id pa_proj_fp_options.ALL_RESOURCE_LIST_ID%TYPE;
241: l_to_resource_list_id pa_proj_fp_options.ALL_RESOURCE_LIST_ID%TYPE;
242:
243: /* Start of Variables defined for the bug :- 2684766 */
244:

Line 241: l_to_resource_list_id pa_proj_fp_options.ALL_RESOURCE_LIST_ID%TYPE;

237: l_target_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE; /* M20-AUG */
238: l_from_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
239: l_to_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
240: l_from_resource_list_id pa_proj_fp_options.ALL_RESOURCE_LIST_ID%TYPE;
241: l_to_resource_list_id pa_proj_fp_options.ALL_RESOURCE_LIST_ID%TYPE;
242:
243: /* Start of Variables defined for the bug :- 2684766 */
244:
245: l_all_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;

Line 245: l_all_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;

241: l_to_resource_list_id pa_proj_fp_options.ALL_RESOURCE_LIST_ID%TYPE;
242:
243: /* Start of Variables defined for the bug :- 2684766 */
244:
245: l_all_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
246: l_cost_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
247: l_revenue_fin_plan_level_code pa_proj_fp_options.revenue_fin_plan_level_code%TYPE;
248:
249: /* End of Variables defined for the bug :- 2684766 */

Line 246: l_cost_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;

242:
243: /* Start of Variables defined for the bug :- 2684766 */
244:
245: l_all_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
246: l_cost_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
247: l_revenue_fin_plan_level_code pa_proj_fp_options.revenue_fin_plan_level_code%TYPE;
248:
249: /* End of Variables defined for the bug :- 2684766 */
250:

Line 247: l_revenue_fin_plan_level_code pa_proj_fp_options.revenue_fin_plan_level_code%TYPE;

243: /* Start of Variables defined for the bug :- 2684766 */
244:
245: l_all_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
246: l_cost_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
247: l_revenue_fin_plan_level_code pa_proj_fp_options.revenue_fin_plan_level_code%TYPE;
248:
249: /* End of Variables defined for the bug :- 2684766 */
250:
251: /* start of variables defined for Bug 2920954*/

Line 252: l_select_res_auto_flag PA_PROJ_FP_OPTIONS.select_cost_res_auto_flag%TYPE;

248:
249: /* End of Variables defined for the bug :- 2684766 */
250:
251: /* start of variables defined for Bug 2920954*/
252: l_select_res_auto_flag PA_PROJ_FP_OPTIONS.select_cost_res_auto_flag%TYPE;
253: l_res_planning_level PA_PROJ_FP_OPTIONS.cost_res_planning_level%TYPE;
254: l_select_cost_res_auto_flag PA_PROJ_FP_OPTIONS.select_cost_res_auto_flag%TYPE;
255: l_cost_res_planning_level PA_PROJ_FP_OPTIONS.cost_res_planning_level%TYPE;
256: l_select_rev_res_auto_flag PA_PROJ_FP_OPTIONS.select_rev_res_auto_flag%TYPE;

Line 253: l_res_planning_level PA_PROJ_FP_OPTIONS.cost_res_planning_level%TYPE;

249: /* End of Variables defined for the bug :- 2684766 */
250:
251: /* start of variables defined for Bug 2920954*/
252: l_select_res_auto_flag PA_PROJ_FP_OPTIONS.select_cost_res_auto_flag%TYPE;
253: l_res_planning_level PA_PROJ_FP_OPTIONS.cost_res_planning_level%TYPE;
254: l_select_cost_res_auto_flag PA_PROJ_FP_OPTIONS.select_cost_res_auto_flag%TYPE;
255: l_cost_res_planning_level PA_PROJ_FP_OPTIONS.cost_res_planning_level%TYPE;
256: l_select_rev_res_auto_flag PA_PROJ_FP_OPTIONS.select_rev_res_auto_flag%TYPE;
257: l_revenue_res_planning_level PA_PROJ_FP_OPTIONS.revenue_res_planning_level%TYPE;

Line 254: l_select_cost_res_auto_flag PA_PROJ_FP_OPTIONS.select_cost_res_auto_flag%TYPE;

250:
251: /* start of variables defined for Bug 2920954*/
252: l_select_res_auto_flag PA_PROJ_FP_OPTIONS.select_cost_res_auto_flag%TYPE;
253: l_res_planning_level PA_PROJ_FP_OPTIONS.cost_res_planning_level%TYPE;
254: l_select_cost_res_auto_flag PA_PROJ_FP_OPTIONS.select_cost_res_auto_flag%TYPE;
255: l_cost_res_planning_level PA_PROJ_FP_OPTIONS.cost_res_planning_level%TYPE;
256: l_select_rev_res_auto_flag PA_PROJ_FP_OPTIONS.select_rev_res_auto_flag%TYPE;
257: l_revenue_res_planning_level PA_PROJ_FP_OPTIONS.revenue_res_planning_level%TYPE;
258: /* end of variables defined for Bug 2920954*/

Line 255: l_cost_res_planning_level PA_PROJ_FP_OPTIONS.cost_res_planning_level%TYPE;

251: /* start of variables defined for Bug 2920954*/
252: l_select_res_auto_flag PA_PROJ_FP_OPTIONS.select_cost_res_auto_flag%TYPE;
253: l_res_planning_level PA_PROJ_FP_OPTIONS.cost_res_planning_level%TYPE;
254: l_select_cost_res_auto_flag PA_PROJ_FP_OPTIONS.select_cost_res_auto_flag%TYPE;
255: l_cost_res_planning_level PA_PROJ_FP_OPTIONS.cost_res_planning_level%TYPE;
256: l_select_rev_res_auto_flag PA_PROJ_FP_OPTIONS.select_rev_res_auto_flag%TYPE;
257: l_revenue_res_planning_level PA_PROJ_FP_OPTIONS.revenue_res_planning_level%TYPE;
258: /* end of variables defined for Bug 2920954*/
259:

Line 256: l_select_rev_res_auto_flag PA_PROJ_FP_OPTIONS.select_rev_res_auto_flag%TYPE;

252: l_select_res_auto_flag PA_PROJ_FP_OPTIONS.select_cost_res_auto_flag%TYPE;
253: l_res_planning_level PA_PROJ_FP_OPTIONS.cost_res_planning_level%TYPE;
254: l_select_cost_res_auto_flag PA_PROJ_FP_OPTIONS.select_cost_res_auto_flag%TYPE;
255: l_cost_res_planning_level PA_PROJ_FP_OPTIONS.cost_res_planning_level%TYPE;
256: l_select_rev_res_auto_flag PA_PROJ_FP_OPTIONS.select_rev_res_auto_flag%TYPE;
257: l_revenue_res_planning_level PA_PROJ_FP_OPTIONS.revenue_res_planning_level%TYPE;
258: /* end of variables defined for Bug 2920954*/
259:
260: BEGIN

Line 257: l_revenue_res_planning_level PA_PROJ_FP_OPTIONS.revenue_res_planning_level%TYPE;

253: l_res_planning_level PA_PROJ_FP_OPTIONS.cost_res_planning_level%TYPE;
254: l_select_cost_res_auto_flag PA_PROJ_FP_OPTIONS.select_cost_res_auto_flag%TYPE;
255: l_cost_res_planning_level PA_PROJ_FP_OPTIONS.cost_res_planning_level%TYPE;
256: l_select_rev_res_auto_flag PA_PROJ_FP_OPTIONS.select_rev_res_auto_flag%TYPE;
257: l_revenue_res_planning_level PA_PROJ_FP_OPTIONS.revenue_res_planning_level%TYPE;
258: /* end of variables defined for Bug 2920954*/
259:
260: BEGIN
261:

Line 328: l_par_fp_option_id := PA_PROJ_FP_OPTIONS_PUB.Get_Parent_FP_Option_ID(p_to_proj_fp_options_id);

324:
325: ELSE
326: l_stage := 300;
327: /* If the Source FP Option is not passed, get the Parent FP Option ID */
328: l_par_fp_option_id := PA_PROJ_FP_OPTIONS_PUB.Get_Parent_FP_Option_ID(p_to_proj_fp_options_id);
329:
330:
331: IF (l_par_fp_option_id IS NOT NULL) THEN
332: /* Since Parent FP Option is found, records have to be copied from pa_fp_elements

Line 353: FROM PA_PROJ_FP_OPTIONS pfo_src

349: SELECT pfo_src.fin_plan_preference_code
350: ,pfo_target.fin_plan_preference_code
351: INTO l_source_preference_code
352: ,l_target_preference_code
353: FROM PA_PROJ_FP_OPTIONS pfo_src
354: ,PA_PROJ_FP_OPTIONS pfo_target
355: WHERE pfo_src.proj_fp_options_id = l_from_proj_fp_option_id
356: AND pfo_target.proj_fp_options_id = p_to_proj_fp_options_id;
357:

Line 354: ,PA_PROJ_FP_OPTIONS pfo_target

350: ,pfo_target.fin_plan_preference_code
351: INTO l_source_preference_code
352: ,l_target_preference_code
353: FROM PA_PROJ_FP_OPTIONS pfo_src
354: ,PA_PROJ_FP_OPTIONS pfo_target
355: WHERE pfo_src.proj_fp_options_id = l_from_proj_fp_option_id
356: AND pfo_target.proj_fp_options_id = p_to_proj_fp_options_id;
357:
358:

Line 438: FROM pa_proj_fp_options

434: ,l_select_cost_res_auto_flag /* Bug 2920954 */
435: ,l_cost_res_planning_level /* Bug 2920954 */
436: ,l_select_rev_res_auto_flag /* Bug 2920954 */
437: ,l_revenue_res_planning_level /* Bug 2920954 */
438: FROM pa_proj_fp_options
439: WHERE proj_fp_options_id = p_to_proj_fp_options_id;
440:
441: /* Call Insert_Default twice, once with Element_Type as 'COST' and then as PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
442: as the case of element_type being 'BOTH' is not handled in Insert_Default. */

Line 503: FROM pa_proj_fp_options

499: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_res_planning_level
500: ,NULL) res_planning_level
501: INTO l_select_res_auto_flag
502: ,l_res_planning_level
503: FROM pa_proj_fp_options
504: WHERE proj_fp_options_id = p_to_proj_fp_options_id;
505:
506: /* Bug 2920954 end of changes */
507:

Line 548: FROM pa_proj_fp_options

544: PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY, cost_resource_list_id,
545: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY, revenue_resource_list_id) resource_list_id
546: INTO l_to_fin_plan_type_id, l_to_fin_plan_version_id,l_to_project_id, l_to_planning_level,
547: l_to_resource_list_id
548: FROM pa_proj_fp_options
549: WHERE proj_fp_options_id = p_to_proj_fp_options_id;
550:
551:
552: /*Get the project id of source fp options id */

Line 568: FROM pa_proj_fp_options

564: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id,
565: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,
566: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_resource_list_id) plan_type_resource_list_id
567: INTO l_from_project_id, l_from_planning_level,l_from_resource_list_id
568: FROM pa_proj_fp_options
569: WHERE proj_fp_options_id = l_from_proj_fp_option_id;
570: /* WHERE proj_fp_options_id = p_from_proj_fp_options_id; manokuma -- UT fixed*/
571:
572: /* Bug# 2676352 - Included the below check to catch such cases where copy elements is being called

Line 745: FROM pa_proj_fp_options

741: ,revenue_fin_plan_level_code
742: INTO l_all_fin_plan_level_code
743: ,l_cost_fin_plan_level_code
744: ,l_revenue_fin_plan_level_code
745: FROM pa_proj_fp_options
746: WHERE proj_fp_options_id = l_from_proj_fp_option_id;
747:
748: EXCEPTION
749: WHEN OTHERS THEN

Line 913: ,p_select_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE

909: ,p_element_type IN VARCHAR2
910: ,p_planning_level IN VARCHAR2
911: ,p_resource_list_id IN NUMBER
912: /* Bug 2920954 start of parameters added for post fp-K one off patch */
913: ,p_select_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
914: ,p_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
915: /* Bug 2920954 end of parameters added for post fp-K one off patch */
916: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
917: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 914: ,p_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE

910: ,p_planning_level IN VARCHAR2
911: ,p_resource_list_id IN NUMBER
912: /* Bug 2920954 start of parameters added for post fp-K one off patch */
913: ,p_select_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
914: ,p_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
915: /* Bug 2920954 end of parameters added for post fp-K one off patch */
916: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
917: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
918: ,x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895

Line 920: l_project_id pa_proj_fp_options.PROJECT_ID%TYPE;

916: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
917: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
918: ,x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
919:
920: l_project_id pa_proj_fp_options.PROJECT_ID%TYPE;
921: l_fin_plan_type_id pa_proj_fp_options.FIN_PLAN_TYPE_ID%TYPE;
922: l_fin_plan_version_id pa_proj_fp_options.FIN_PLAN_VERSION_ID%TYPE;
923: l_msg_count NUMBER := 0;
924: l_data VARCHAR2(2000);

Line 921: l_fin_plan_type_id pa_proj_fp_options.FIN_PLAN_TYPE_ID%TYPE;

917: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
918: ,x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
919:
920: l_project_id pa_proj_fp_options.PROJECT_ID%TYPE;
921: l_fin_plan_type_id pa_proj_fp_options.FIN_PLAN_TYPE_ID%TYPE;
922: l_fin_plan_version_id pa_proj_fp_options.FIN_PLAN_VERSION_ID%TYPE;
923: l_msg_count NUMBER := 0;
924: l_data VARCHAR2(2000);
925: l_msg_data VARCHAR2(2000);

Line 922: l_fin_plan_version_id pa_proj_fp_options.FIN_PLAN_VERSION_ID%TYPE;

918: ,x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
919:
920: l_project_id pa_proj_fp_options.PROJECT_ID%TYPE;
921: l_fin_plan_type_id pa_proj_fp_options.FIN_PLAN_TYPE_ID%TYPE;
922: l_fin_plan_version_id pa_proj_fp_options.FIN_PLAN_VERSION_ID%TYPE;
923: l_msg_count NUMBER := 0;
924: l_data VARCHAR2(2000);
925: l_msg_data VARCHAR2(2000);
926: l_msg_index_out NUMBER;

Line 930: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;

926: l_msg_index_out NUMBER;
927: l_return_status VARCHAR2(2000);
928: l_debug_mode VARCHAR2(30);
929: l_stage NUMBER := 100;
930: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
931: l_resource_list_id pa_proj_fp_options.ALL_RESOURCE_LIST_ID%TYPE;
932: -- Bug 2920954 l_res_planning_level pa_fp_elements.RESOURCE_PLANNING_LEVEL%TYPE;
933:
934: /* start of variables defined for Bug 2920954*/

Line 931: l_resource_list_id pa_proj_fp_options.ALL_RESOURCE_LIST_ID%TYPE;

927: l_return_status VARCHAR2(2000);
928: l_debug_mode VARCHAR2(30);
929: l_stage NUMBER := 100;
930: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
931: l_resource_list_id pa_proj_fp_options.ALL_RESOURCE_LIST_ID%TYPE;
932: -- Bug 2920954 l_res_planning_level pa_fp_elements.RESOURCE_PLANNING_LEVEL%TYPE;
933:
934: /* start of variables defined for Bug 2920954*/
935: l_select_res_auto_flag pa_proj_fp_options.select_cost_res_auto_flag%TYPE;

Line 935: l_select_res_auto_flag pa_proj_fp_options.select_cost_res_auto_flag%TYPE;

931: l_resource_list_id pa_proj_fp_options.ALL_RESOURCE_LIST_ID%TYPE;
932: -- Bug 2920954 l_res_planning_level pa_fp_elements.RESOURCE_PLANNING_LEVEL%TYPE;
933:
934: /* start of variables defined for Bug 2920954*/
935: l_select_res_auto_flag pa_proj_fp_options.select_cost_res_auto_flag%TYPE;
936: l_res_planning_level pa_proj_fp_options.cost_res_planning_level%TYPE;
937: /*end of variables defined for Bug 2920954*/
938:
939: l_resource_list_member_id CONSTANT pa_fp_elements.RESOURCE_LIST_MEMBER_ID%TYPE := 0;

Line 936: l_res_planning_level pa_proj_fp_options.cost_res_planning_level%TYPE;

932: -- Bug 2920954 l_res_planning_level pa_fp_elements.RESOURCE_PLANNING_LEVEL%TYPE;
933:
934: /* start of variables defined for Bug 2920954*/
935: l_select_res_auto_flag pa_proj_fp_options.select_cost_res_auto_flag%TYPE;
936: l_res_planning_level pa_proj_fp_options.cost_res_planning_level%TYPE;
937: /*end of variables defined for Bug 2920954*/
938:
939: l_resource_list_member_id CONSTANT pa_fp_elements.RESOURCE_LIST_MEMBER_ID%TYPE := 0;
940: l_task_planning_level_top CONSTANT pa_fp_elements.TOP_TASK_PLANNING_LEVEL%TYPE := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP;

Line 1047: from the table pa_proj_fp_options depending on the Element_Type. */

1043: END IF;
1044:
1045: l_stage :=200;
1046: /* If the Planning Level parameter is not passed, get the value of the planning level
1047: from the table pa_proj_fp_options depending on the Element_Type. */
1048:
1049: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': Getting the value of Planning Level.';
1050: IF P_PA_DEBUG_MODE = 'Y' THEN
1051: pa_debug.write('Insert_Default: ' || l_module_name,pa_debug.g_err_stage,1);

Line 1065: FROM pa_proj_fp_options

1061: /* M20-AUG replaced by call
1062: SELECT decode(p_element_type,'COST',cost_fin_plan_level_code,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,revenue_fin_plan_level_code,
1063: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,all_fin_plan_level_code,NULL)
1064: INTO l_planning_level
1065: FROM pa_proj_fp_options
1066: WHERE proj_fp_options_id = p_proj_fp_options_id;
1067: */
1068:
1069: END IF;

Line 1073: from the table pa_proj_fp_options depending on the Element_Type. */

1069: END IF;
1070:
1071: l_stage := 300;
1072: /* If the Resouce List ID parameter is not passed, get the value of the resource list id
1073: from the table pa_proj_fp_options depending on the Element_Type. */
1074:
1075: IF (p_resource_list_id IS NOT NULL) THEN
1076: /* Resource List ID is passed to the procedure, if Proj FP Option records
1077: have not been saved to the Database. */

Line 1089: FROM pa_proj_fp_options

1085: SELECT decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,cost_resource_list_id
1086: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,revenue_resource_list_id,
1087: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,all_resource_list_id,NULL)
1088: INTO l_resource_list_id
1089: FROM pa_proj_fp_options
1090: WHERE proj_fp_options_id = p_proj_fp_options_id;
1091: END IF;
1092:
1093: /* Bug 2920954 If the auto resource addition paramters aren't passed, get the values

Line 1094: from the table pa_proj_fp_options depending on the Element_Type. */

1090: WHERE proj_fp_options_id = p_proj_fp_options_id;
1091: END IF;
1092:
1093: /* Bug 2920954 If the auto resource addition paramters aren't passed, get the values
1094: from the table pa_proj_fp_options depending on the Element_Type. */
1095:
1096: IF (p_select_res_auto_flag IS NULL) AND (p_res_planning_level IS NULL)
1097: THEN
1098:

Line 1114: FROM pa_proj_fp_options

1110: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_res_planning_level
1111: ,NULL) res_planning_level
1112: INTO l_select_res_auto_flag
1113: ,l_res_planning_level
1114: FROM pa_proj_fp_options
1115: WHERE proj_fp_options_id = p_proj_fp_options_id;
1116:
1117: ELSE
1118:

Line 1133: FROM pa_proj_fp_options

1129: END IF;
1130:
1131: SELECT project_id, fin_plan_type_id, fin_plan_version_id
1132: INTO l_project_id, l_fin_plan_type_id, l_fin_plan_version_id
1133: FROM pa_proj_fp_options
1134: WHERE proj_fp_options_id = p_proj_fp_options_id;
1135:
1136: /* Get the value of the Resource Planning Level. The value is NULL if the resource_list_id of the
1137: element_type is Uncategorised, else it is "RESOURCE". */

Line 1594: l_proj_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;

1590: l_err_stage VARCHAR2(100);
1591: l_err_stack VARCHAR2(1000);
1592:
1593: l_resource_exists_flag VARCHAR2(1);
1594: l_proj_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;
1595:
1596: --Bug 2774779
1597: l_top_task_id pa_tasks.task_id%TYPE;
1598: l_row_update_count NUMBER;

Line 1626: FROM pa_proj_fp_options pfo

1622: ,p_err_stack => l_err_stack);
1623:
1624: SELECT proj_fp_options_id
1625: INTO l_proj_fp_options_id
1626: FROM pa_proj_fp_options pfo
1627: WHERE fin_plan_version_id = p_budget_version_id;
1628:
1629: /* #2593264: The following condition was corrected from
1630: p_resource_list_member_id <> l_uncat_res_list_mem_id. */

Line 2097: l_fp_pref_code PA_PROJ_FP_OPTIONS.FIN_PLAN_PREFERENCE_CODE%TYPE;

2093:
2094: l_resource_list_id PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE;
2095: l_project_id PA_BUDGET_VERSIONS.PROJECT_ID%TYPE;
2096: l_uncat_flag PA_RESOURCE_LISTS.UNCATEGORIzED_FLAG%TYPE;
2097: l_fp_pref_code PA_PROJ_FP_OPTIONS.FIN_PLAN_PREFERENCE_CODE%TYPE;
2098: l_fp_level_code PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE;
2099: l_proj_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;
2100: l_uncat_rlmid PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE;
2101: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;

Line 2098: l_fp_level_code PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE;

2094: l_resource_list_id PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE;
2095: l_project_id PA_BUDGET_VERSIONS.PROJECT_ID%TYPE;
2096: l_uncat_flag PA_RESOURCE_LISTS.UNCATEGORIzED_FLAG%TYPE;
2097: l_fp_pref_code PA_PROJ_FP_OPTIONS.FIN_PLAN_PREFERENCE_CODE%TYPE;
2098: l_fp_level_code PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE;
2099: l_proj_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;
2100: l_uncat_rlmid PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE;
2101: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;
2102: l_unit_of_measure PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE;

Line 2099: l_proj_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;

2095: l_project_id PA_BUDGET_VERSIONS.PROJECT_ID%TYPE;
2096: l_uncat_flag PA_RESOURCE_LISTS.UNCATEGORIzED_FLAG%TYPE;
2097: l_fp_pref_code PA_PROJ_FP_OPTIONS.FIN_PLAN_PREFERENCE_CODE%TYPE;
2098: l_fp_level_code PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE;
2099: l_proj_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;
2100: l_uncat_rlmid PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE;
2101: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;
2102: l_unit_of_measure PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE;
2103:

Line 2232: FROM pa_proj_fp_options

2228: -- avoid full table scan on pa_fp_elements
2229:
2230: SELECT proj_fp_options_id
2231: INTO l_proj_fp_options_id
2232: FROM pa_proj_fp_options
2233: WHERE fin_plan_version_id = p_plan_version_id;
2234:
2235: pa_debug.g_err_stage:='checking if resource list is uncategorised';
2236: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2598: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE

2594: get_element_id: This procedure is used from setup pages to get the element id in case an element
2595: is already available in database.
2596: ==================================================================================================*/
2597: FUNCTION get_element_id (
2598: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
2599: ,p_element_type IN pa_fp_elements.element_type%TYPE
2600: ,p_task_id IN pa_tasks.task_id%TYPE
2601: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE)
2602: RETURN pa_fp_elements.proj_fp_elements_id%TYPE

Line 2631: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE

2627: get_element_plannable_flag: This procedure is used from setup pages to get the plannable flag in
2628: case an element is already available in database.
2629: ==================================================================================================*/
2630: FUNCTION get_element_plannable_flag (
2631: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
2632: ,p_element_type IN pa_fp_elements.element_type%TYPE
2633: ,p_task_id IN pa_tasks.task_id%TYPE
2634: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE)
2635: RETURN pa_fp_elements.plannable_flag%TYPE

Line 2664: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE

2660: get_plan_amount_exists_flag: This procedure is used from setup pages to get the plan amount exists
2661: in case an elementis already available in database.
2662: ==================================================================================================*/
2663: FUNCTION get_plan_amount_exists_flag (
2664: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
2665: ,p_element_type IN pa_fp_elements.element_type%TYPE
2666: ,p_task_id IN pa_tasks.task_id%TYPE
2667: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE)
2668: RETURN pa_fp_elements.plan_amount_exists_flag%TYPE

Line 2750: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE

2746: to new model, we should check if mixed resource planning level exists
2747: for the current budget version.
2748: ===================================================================*/
2749: PROCEDURE Create_elements_from_version(
2750: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
2751: ,p_element_type IN pa_fp_elements.element_type%TYPE
2752: ,p_from_version_id IN pa_budget_versions.budget_version_id%TYPE
2753: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
2754: ,x_mixed_resource_planned_flag OUT NOCOPY VARCHAR2 -- new parameter for Bug :- 2625872 --File.Sql.39 bug 4440895

Line 2798: c_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE

2794:
2795: ---- variables added for Bug :- 2625872 ----
2796:
2797: CURSOR fp_options_cur(
2798: c_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
2799: ,c_element_type IN pa_fp_elements.element_type%TYPE) IS
2800: SELECT project_id
2801: ,fin_plan_type_id
2802: ,fin_plan_version_id

Line 2804: FROM pa_proj_fp_options

2800: SELECT project_id
2801: ,fin_plan_type_id
2802: ,fin_plan_version_id
2803: ,PA_FIN_PLAN_UTILS.GET_OPTION_PLANNING_LEVEL(c_proj_fp_options_id,c_element_type) fin_plan_level_code
2804: FROM pa_proj_fp_options
2805: WHERE proj_fp_options_id = c_proj_fp_options_id;
2806:
2807: fp_options_rec fp_options_cur%ROWTYPE;
2808:

Line 2936: c_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE ) IS

2932: -- to insert top task level records for the task level records inserted using the above cursor
2933: -- irrespective of resource list categorized or not
2934:
2935: CURSOR top_task_level_elements_cur(
2936: c_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE ) IS
2937: SELECT DISTINCT pt.top_task_id task_id
2938: ,pt.top_task_id top_task_id
2939: ,0 resource_list_member_id
2940: ,PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST top_task_planning_level

Line 3355: p_proj_fp_options_id IN PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE

3351: or project elements based on the input resource list id and the automatic resource selection
3352: parameter and resource planning level for automatic resource selection
3353: ==================================================================================================*/
3354: PROCEDURE refresh_res_list_changes (
3355: p_proj_fp_options_id IN PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE
3356: ,p_element_type IN PA_FP_ELEMENTS.ELEMENT_TYPE%TYPE /* COST,REVENUE,ALL,BOTH */
3357: ,p_cost_resource_list_id IN PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE
3358: ,p_rev_resource_list_id IN PA_PROJ_FP_OPTIONS.REVENUE_RESOURCE_LIST_ID%TYPE
3359: ,p_all_resource_list_id IN PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID%TYPE

Line 3357: ,p_cost_resource_list_id IN PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE

3353: ==================================================================================================*/
3354: PROCEDURE refresh_res_list_changes (
3355: p_proj_fp_options_id IN PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE
3356: ,p_element_type IN PA_FP_ELEMENTS.ELEMENT_TYPE%TYPE /* COST,REVENUE,ALL,BOTH */
3357: ,p_cost_resource_list_id IN PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE
3358: ,p_rev_resource_list_id IN PA_PROJ_FP_OPTIONS.REVENUE_RESOURCE_LIST_ID%TYPE
3359: ,p_all_resource_list_id IN PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID%TYPE
3360: /* Bug 2920954 start of new parameters added for post fp-K one off patch */
3361: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE

Line 3358: ,p_rev_resource_list_id IN PA_PROJ_FP_OPTIONS.REVENUE_RESOURCE_LIST_ID%TYPE

3354: PROCEDURE refresh_res_list_changes (
3355: p_proj_fp_options_id IN PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE
3356: ,p_element_type IN PA_FP_ELEMENTS.ELEMENT_TYPE%TYPE /* COST,REVENUE,ALL,BOTH */
3357: ,p_cost_resource_list_id IN PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE
3358: ,p_rev_resource_list_id IN PA_PROJ_FP_OPTIONS.REVENUE_RESOURCE_LIST_ID%TYPE
3359: ,p_all_resource_list_id IN PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID%TYPE
3360: /* Bug 2920954 start of new parameters added for post fp-K one off patch */
3361: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
3362: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE

Line 3359: ,p_all_resource_list_id IN PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID%TYPE

3355: p_proj_fp_options_id IN PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE
3356: ,p_element_type IN PA_FP_ELEMENTS.ELEMENT_TYPE%TYPE /* COST,REVENUE,ALL,BOTH */
3357: ,p_cost_resource_list_id IN PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE
3358: ,p_rev_resource_list_id IN PA_PROJ_FP_OPTIONS.REVENUE_RESOURCE_LIST_ID%TYPE
3359: ,p_all_resource_list_id IN PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID%TYPE
3360: /* Bug 2920954 start of new parameters added for post fp-K one off patch */
3361: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
3362: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
3363: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE

Line 3361: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE

3357: ,p_cost_resource_list_id IN PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE
3358: ,p_rev_resource_list_id IN PA_PROJ_FP_OPTIONS.REVENUE_RESOURCE_LIST_ID%TYPE
3359: ,p_all_resource_list_id IN PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID%TYPE
3360: /* Bug 2920954 start of new parameters added for post fp-K one off patch */
3361: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
3362: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
3363: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
3364: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
3365: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE

Line 3362: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE

3358: ,p_rev_resource_list_id IN PA_PROJ_FP_OPTIONS.REVENUE_RESOURCE_LIST_ID%TYPE
3359: ,p_all_resource_list_id IN PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID%TYPE
3360: /* Bug 2920954 start of new parameters added for post fp-K one off patch */
3361: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
3362: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
3363: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
3364: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
3365: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE
3366: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE

Line 3363: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE

3359: ,p_all_resource_list_id IN PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID%TYPE
3360: /* Bug 2920954 start of new parameters added for post fp-K one off patch */
3361: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
3362: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
3363: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
3364: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
3365: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE
3366: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE
3367: /* Bug 2920954 end of new parameters added for post fp-K one off patch */

Line 3364: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE

3360: /* Bug 2920954 start of new parameters added for post fp-K one off patch */
3361: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
3362: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
3363: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
3364: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
3365: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE
3366: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE
3367: /* Bug 2920954 end of new parameters added for post fp-K one off patch */
3368: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3365: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE

3361: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
3362: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
3363: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
3364: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
3365: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE
3366: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE
3367: /* Bug 2920954 end of new parameters added for post fp-K one off patch */
3368: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3369: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 3366: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE

3362: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
3363: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
3364: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
3365: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE
3366: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE
3367: /* Bug 2920954 end of new parameters added for post fp-K one off patch */
3368: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3369: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3370: ,x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895

Line 3381: l_resource_list_id PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID%TYPE;

3377: l_debug_mode VARCHAR2(30);
3378: l_res_list_is_uncategorized PA_RESOURCE_LISTS_ALL_BG.UNCATEGORIZED_FLAG%TYPE;
3379: l_is_resource_list_grouped VARCHAR2(1);
3380: l_group_resource_type_id PA_RESOURCE_LISTS_ALL_BG.GROUP_RESOURCE_TYPE_ID%TYPE;
3381: l_resource_list_id PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID%TYPE;
3382: l_res_planning_level PA_FP_ELEMENTS.RESOURCE_PLANNING_LEVEL%TYPE;
3383: l_fin_plan_level_code PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE;
3384: l_stage NUMBER := 100;
3385:

Line 3383: l_fin_plan_level_code PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE;

3379: l_is_resource_list_grouped VARCHAR2(1);
3380: l_group_resource_type_id PA_RESOURCE_LISTS_ALL_BG.GROUP_RESOURCE_TYPE_ID%TYPE;
3381: l_resource_list_id PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID%TYPE;
3382: l_res_planning_level PA_FP_ELEMENTS.RESOURCE_PLANNING_LEVEL%TYPE;
3383: l_fin_plan_level_code PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE;
3384: l_stage NUMBER := 100;
3385:
3386: l_dummy_task_id_tbl pa_fp_elements_pub.l_task_id_tbl_typ;
3387:

Line 3793: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

3789: --l_quantity_tbl pa_fp_rollup_pkg.l_quantity_tbl_typ;
3790: /* Bug 2677597 - declaration change end */
3791:
3792: l_project_id pa_projects_all.project_id%TYPE;
3793: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3794: l_element_type pa_fp_elements.element_type%TYPE;
3795: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
3796: l_mixed_resource_planned_flag VARCHAR2(1); -- Added for Bug:- 2625872
3797:

Line 3898: from pa_proj_fp_options opt,pa_budget_versions pbv

3894: l_project_id
3895: ,l_fp_options_id
3896: ,l_element_type
3897: ,l_resource_list_id
3898: from pa_proj_fp_options opt,pa_budget_versions pbv
3899: where opt.fin_plan_version_id = pbv.budget_version_id
3900: and pbv.budget_version_id = p_fin_plan_version_id;
3901: EXCEPTION
3902: WHEN NO_DATA_FOUND THEN

Line 4142: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

4138:
4139: l_no_of_records_processed NUMBER;
4140: l_count NUMBER;
4141:
4142: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
4143:
4144: -- Bug Fix: 4569365. Removed MRC code.
4145: -- l_calling_context pa_mrc_finplan.g_calling_module%TYPE;
4146: l_calling_context VARCHAR2(30);

Line 4149: l_plan_version_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;

4145: -- l_calling_context pa_mrc_finplan.g_calling_module%TYPE;
4146: l_calling_context VARCHAR2(30);
4147:
4148: l_ci_apprv_cw_bv_id pa_budget_versions.budget_version_id%TYPE :=NULL;
4149: l_plan_version_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
4150:
4151: /* PL/SQL table types to be passed to create_res_task_map */
4152:
4153: l_src_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

Line 4532: ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE

4528: level planning options.
4529: ==================================================================*/
4530:
4531: PROCEDURE Add_resources_automatically
4532: ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
4533: ,p_element_type IN pa_fp_elements.element_type%TYPE
4534: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
4535: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE
4536: ,p_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE

Line 4534: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE

4530:
4531: PROCEDURE Add_resources_automatically
4532: ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
4533: ,p_element_type IN pa_fp_elements.element_type%TYPE
4534: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
4535: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE
4536: ,p_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
4537: ,p_entire_option IN VARCHAR2
4538: ,p_element_task_id_tbl IN pa_fp_elements_pub.l_task_id_tbl_typ

Line 4536: ,p_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE

4532: ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
4533: ,p_element_type IN pa_fp_elements.element_type%TYPE
4534: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
4535: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE
4536: ,p_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
4537: ,p_entire_option IN VARCHAR2
4538: ,p_element_task_id_tbl IN pa_fp_elements_pub.l_task_id_tbl_typ
4539: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4540: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4573: ( c_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE

4569: The following cursor is used to fetch project_id, plan_type_id
4570: based on the element type etc., for an option_id
4571: */
4572: CURSOR proj_fp_options_info_cur
4573: ( c_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE
4574: ,c_element_type pa_fp_elements.element_type%TYPE)
4575: IS
4576: SELECT project_id
4577: ,fin_plan_type_id

Line 4579: FROM pa_proj_fp_options

4575: IS
4576: SELECT project_id
4577: ,fin_plan_type_id
4578: ,fin_plan_version_id
4579: FROM pa_proj_fp_options
4580: WHERE proj_fp_options_id = c_proj_fp_options_id;
4581:
4582: proj_fp_options_info_rec proj_fp_options_info_cur%ROWTYPE;
4583:

Line 4590: ( c_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE

4586: planned for an option and element_type combination for automatic
4587: resource addition in the context of entire option
4588: */
4589: CURSOR all_plannable_tasks_cur
4590: ( c_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE
4591: ,c_element_type pa_fp_elements.element_type%TYPE)
4592: IS
4593: SELECT task_id
4594: ,top_task_id

Line 5155: ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE

5151: This API will be used to decide whether to insert a task in fp elements table or not. This api will also
5152: provide the plannable flag and task planning level of all the tasks that are eligible for insertion.
5153: */
5154: PROCEDURE Get_Task_Element_Attributes
5155: ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
5156: ,p_element_type IN pa_fp_elements.element_type%TYPE
5157: ,p_task_id IN pa_fp_elements.task_id%TYPE
5158: ,p_top_task_id IN pa_fp_elements.top_task_id%TYPE
5159: ,p_task_level IN VARCHAR2

Line 5160: ,p_option_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE

5156: ,p_element_type IN pa_fp_elements.element_type%TYPE
5157: ,p_task_id IN pa_fp_elements.task_id%TYPE
5158: ,p_top_task_id IN pa_fp_elements.top_task_id%TYPE
5159: ,p_task_level IN VARCHAR2
5160: ,p_option_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
5161: ,x_task_inclusion_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5162: ,x_task_plannable_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5163: ,x_top_task_planning_level OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5164: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 5546: ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE

5542: Bug 2989900. In case of CI versions, the tasks would be made plannable only if the task
5543: is an impacted task or a child task of impacted task */
5544:
5545: PROCEDURE add_tasks_to_option
5546: ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
5547: ,p_element_type IN pa_fp_elements.element_type%TYPE
5548: ,p_tasks_tbl IN pa_fp_elements_pub.l_wbs_refresh_tasks_tbl_typ
5549: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5550: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 5588: FROM pa_proj_fp_options pfo

5584: DECODE(p_element_type,
5585: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_resource_list_id,
5586: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_resource_list_id,
5587: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_resource_list_id) resource_list_id
5588: FROM pa_proj_fp_options pfo
5589: WHERE pfo.proj_fp_options_id = p_proj_fp_options_id;
5590:
5591: proj_fp_options_rec proj_fp_options_cur%ROWTYPE;
5592:

Line 5603: (c_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE)

5599: --For Bug 2976168.
5600: l_task_inclusion_flag VARCHAR2(1); /*Required to know whether the task can be is
5601: eligible for inserting into pa_fp_elements or not*/
5602: CURSOR ci_version_info_cur
5603: (c_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE)
5604: IS
5605: SELECT bv.ci_id,
5606: impacted_task_id
5607: FROM pa_budget_versions bv,

Line 6049: (c_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE)

6045: L_DEBUG_LEVEL5 CONSTANT NUMBER := 5;
6046:
6047:
6048: CURSOR fp_options_info_cur
6049: (c_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE)
6050: IS
6051: SELECT pfo.proj_fp_options_id,
6052: pfo.fin_plan_option_level_code,
6053: pfo.fin_plan_preference_code,

Line 6058: FROM pa_proj_fp_options pfo

6054: pfo.cost_fin_plan_level_code,
6055: pfo.revenue_fin_plan_level_code,
6056: pfo.all_fin_plan_level_code,
6057: pfo.fin_plan_version_id
6058: FROM pa_proj_fp_options pfo
6059: WHERE pfo.proj_fp_options_id = c_proj_fp_options_id;
6060: fp_options_info_rec fp_options_info_cur%ROWTYPE;
6061:
6062: l_process_option VARCHAR2(1);

Line 6151: FROM pa_proj_fp_options pfo

6147: DELETE
6148: FROM pa_resource_assignments pra
6149: WHERE pra.task_id = p_tasks_tbl(i).task_id
6150: AND pra.budget_version_id in (SELECT pfo.fin_plan_version_id
6151: FROM pa_proj_fp_options pfo
6152: WHERE pfo.proj_fp_options_id =
6153: p_refresh_fp_options_tbl(k))
6154: AND pra.resource_assignment_type = PA_FP_CONSTANTS_PKG.G_USER_ENTERED;
6155:

Line 6445: (select 1 from pa_proj_fp_options

6441: IS
6442: select 1
6443: from sys.dual
6444: where exists
6445: (select 1 from pa_proj_fp_options
6446: where project_id = p_project_id);
6447:
6448: /* end of Bug 3342975 */
6449: /* The below declarations are for Bug 2976168 */

Line 6454: FROM pa_proj_fp_options pfo

6450:
6451: CURSOR all_fp_options_cur
6452: IS
6453: SELECT pfo.proj_fp_options_id
6454: FROM pa_proj_fp_options pfo
6455: WHERE pfo.project_id = p_project_id
6456: AND pfo.fin_plan_option_level_code <> PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION
6457: UNION ALL
6458: SELECT pfo.proj_fp_options_id

Line 6460: pa_proj_fp_options pfo

6456: AND pfo.fin_plan_option_level_code <> PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION
6457: UNION ALL
6458: SELECT pfo.proj_fp_options_id
6459: FROM pa_budget_versions bv,
6460: pa_proj_fp_options pfo
6461: WHERE bv.project_id = p_project_id
6462: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION
6463: AND bv.budget_status_code <> PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED /* Should not modify baselined versions */
6464: AND pfo.project_id = bv.project_id

Line 7150: pa_debug.g_err_stage := 'Updating pa_proj_fp_options with RVN and who columns.';

7146:
7147: IF nvl(l_all_fp_options_tbl.last,0) >= 1 THEN /* only if something is fetched */
7148:
7149: IF P_PA_DEBUG_MODE = 'Y' THEN
7150: pa_debug.g_err_stage := 'Updating pa_proj_fp_options with RVN and who columns.';
7151: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL3);
7152: END IF;
7153:
7154: FORALL i in l_all_fp_options_tbl.first..l_all_fp_options_tbl.last

Line 7155: UPDATE pa_proj_fp_options pfo

7151: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL3);
7152: END IF;
7153:
7154: FORALL i in l_all_fp_options_tbl.first..l_all_fp_options_tbl.last
7155: UPDATE pa_proj_fp_options pfo
7156: SET pfo.record_version_number = pfo.record_version_number + 1,
7157: pfo.last_update_date = sysdate,
7158: pfo.last_updated_by = FND_GLOBAL.USER_ID,
7159: pfo.last_update_login = FND_GLOBAL.LOGIN_ID

Line 7173: FROM pa_proj_fp_options pfo

7169: bv.last_update_date = sysdate,
7170: bv.last_updated_by = FND_GLOBAL.USER_ID,
7171: bv.last_update_login = FND_GLOBAL.LOGIN_ID
7172: WHERE bv.budget_version_id in (SELECT pfo.fin_plan_version_id
7173: FROM pa_proj_fp_options pfo
7174: WHERE pfo.proj_fp_options_id = l_all_fp_options_tbl(i));
7175:
7176: END IF; /* nvl(l_all_fp_options_tbl.last,0) >= 1 */
7177: