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_BUDGET_ATTR_UPGR_PKG dependencies on PA_PROJ_FP_OPTIONS

Line 22: from pa_proj_fp_options pfo

18: rev_period_mask_id,all_period_mask_id,decode(revenue_time_phased_code,'G',1,'P',2,
19: decode(cost_time_phased_code,'G',1,'P',2,
20: decode(all_time_phased_code,'G',1,'P',2,null))) time_phased_code,
21: decode(all_resource_list_id,null,decode(cost_resource_list_id,null,revenue_resource_list_id,cost_resource_list_id),all_resource_list_id) resource_list_id
22: from pa_proj_fp_options pfo
23: ,pa_budget_versions pbv
24: where pfo.project_id = c_project_id
25: and pbv.budget_version_id=c_budget_version_id
26: and (fin_plan_version_id = c_budget_version_id OR

Line 65: l_cost_current_planning_period pa_proj_fp_options.cost_current_planning_period%type;

61: l_period_mask_id pa_period_masks_b.period_mask_id%type;
62: l_curr_plan_period pa_budget_versions.current_planning_period%type;
63: l_curr_plan_period_b pa_budget_versions.current_planning_period%type;
64: l_rbs_version_id pa_resource_lists_all_bg.migrated_rbs_version_id%type;
65: l_cost_current_planning_period pa_proj_fp_options.cost_current_planning_period%type;
66: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%type;
67: l_rev_current_planning_period pa_proj_fp_options.rev_current_planning_period%type;
68: l_rev_period_mask_id pa_proj_fp_options.rev_period_mask_id%type;
69: l_all_current_planning_period pa_proj_fp_options.all_current_planning_period%type;

Line 66: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%type;

62: l_curr_plan_period pa_budget_versions.current_planning_period%type;
63: l_curr_plan_period_b pa_budget_versions.current_planning_period%type;
64: l_rbs_version_id pa_resource_lists_all_bg.migrated_rbs_version_id%type;
65: l_cost_current_planning_period pa_proj_fp_options.cost_current_planning_period%type;
66: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%type;
67: l_rev_current_planning_period pa_proj_fp_options.rev_current_planning_period%type;
68: l_rev_period_mask_id pa_proj_fp_options.rev_period_mask_id%type;
69: l_all_current_planning_period pa_proj_fp_options.all_current_planning_period%type;
70: l_all_period_mask_id pa_proj_fp_options.all_period_mask_id%type;

Line 67: l_rev_current_planning_period pa_proj_fp_options.rev_current_planning_period%type;

63: l_curr_plan_period_b pa_budget_versions.current_planning_period%type;
64: l_rbs_version_id pa_resource_lists_all_bg.migrated_rbs_version_id%type;
65: l_cost_current_planning_period pa_proj_fp_options.cost_current_planning_period%type;
66: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%type;
67: l_rev_current_planning_period pa_proj_fp_options.rev_current_planning_period%type;
68: l_rev_period_mask_id pa_proj_fp_options.rev_period_mask_id%type;
69: l_all_current_planning_period pa_proj_fp_options.all_current_planning_period%type;
70: l_all_period_mask_id pa_proj_fp_options.all_period_mask_id%type;
71: l_stage VARCHAR2(240) :='';

Line 68: l_rev_period_mask_id pa_proj_fp_options.rev_period_mask_id%type;

64: l_rbs_version_id pa_resource_lists_all_bg.migrated_rbs_version_id%type;
65: l_cost_current_planning_period pa_proj_fp_options.cost_current_planning_period%type;
66: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%type;
67: l_rev_current_planning_period pa_proj_fp_options.rev_current_planning_period%type;
68: l_rev_period_mask_id pa_proj_fp_options.rev_period_mask_id%type;
69: l_all_current_planning_period pa_proj_fp_options.all_current_planning_period%type;
70: l_all_period_mask_id pa_proj_fp_options.all_period_mask_id%type;
71: l_stage VARCHAR2(240) :='';
72: l_debug_mode varchar2(30);

Line 69: l_all_current_planning_period pa_proj_fp_options.all_current_planning_period%type;

65: l_cost_current_planning_period pa_proj_fp_options.cost_current_planning_period%type;
66: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%type;
67: l_rev_current_planning_period pa_proj_fp_options.rev_current_planning_period%type;
68: l_rev_period_mask_id pa_proj_fp_options.rev_period_mask_id%type;
69: l_all_current_planning_period pa_proj_fp_options.all_current_planning_period%type;
70: l_all_period_mask_id pa_proj_fp_options.all_period_mask_id%type;
71: l_stage VARCHAR2(240) :='';
72: l_debug_mode varchar2(30);
73: l_module_name VARCHAR2(100):= 'pa.plsql.pa_budget_attr_upgr_pkg';

Line 70: l_all_period_mask_id pa_proj_fp_options.all_period_mask_id%type;

66: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%type;
67: l_rev_current_planning_period pa_proj_fp_options.rev_current_planning_period%type;
68: l_rev_period_mask_id pa_proj_fp_options.rev_period_mask_id%type;
69: l_all_current_planning_period pa_proj_fp_options.all_current_planning_period%type;
70: l_all_period_mask_id pa_proj_fp_options.all_period_mask_id%type;
71: l_stage VARCHAR2(240) :='';
72: l_debug_mode varchar2(30);
73: l_module_name VARCHAR2(100):= 'pa.plsql.pa_budget_attr_upgr_pkg';
74: l_msg_count NUMBER :=0;

Line 102: l_cpp_for_gl_time_phase pa_proj_fp_options.cost_time_phased_code%TYPE;

98: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%TYPE; -- Bug 3935863
99:
100: --Bug 3977417.These variables will be used for cost and rev separate options. They will have the
101: --Current Planning Period(cpp) for GL/PA time phasing.
102: l_cpp_for_gl_time_phase pa_proj_fp_options.cost_time_phased_code%TYPE;
103: l_cpp_for_pa_time_phase pa_proj_fp_options.cost_time_phased_code%TYPE;
104: begin
105: -- FND_MSG_PUB.initialize; /* Bug 3800485 */
106: x_msg_count := 0;

Line 103: l_cpp_for_pa_time_phase pa_proj_fp_options.cost_time_phased_code%TYPE;

99:
100: --Bug 3977417.These variables will be used for cost and rev separate options. They will have the
101: --Current Planning Period(cpp) for GL/PA time phasing.
102: l_cpp_for_gl_time_phase pa_proj_fp_options.cost_time_phased_code%TYPE;
103: l_cpp_for_pa_time_phase pa_proj_fp_options.cost_time_phased_code%TYPE;
104: begin
105: -- FND_MSG_PUB.initialize; /* Bug 3800485 */
106: x_msg_count := 0;
107: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 404: pa_debug.g_err_stage := 'Update Pa_proj_fp_options Table.';

400: l_all_period_mask_id := l_period_mask_id;
401: end if;
402:
403: IF l_debug_mode = 'Y' THEN
404: pa_debug.g_err_stage := 'Update Pa_proj_fp_options Table.';
405: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
406: end if;
407:
408: update pa_proj_fp_options

Line 408: update pa_proj_fp_options

404: pa_debug.g_err_stage := 'Update Pa_proj_fp_options Table.';
405: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
406: end if;
407:
408: update pa_proj_fp_options
409: SET cost_current_planning_period = l_cost_current_planning_period,
410: cost_period_mask_id = l_cost_period_mask_id,
411: rev_current_planning_period = l_rev_current_planning_period,
412: rev_period_mask_id = l_rev_period_mask_id,