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

Line 25: from pa_proj_fp_options fp, pa_projects_all pa,

21: , fp.fin_plan_option_level_code
22: --Bug 4046524
23: , pa.project_currency_code
24: , pa.projfunc_currency_code
25: from pa_proj_fp_options fp, pa_projects_all pa,
26: pa_budget_versions pbv
27: where fp.project_id = pa.project_id
28: and fp.project_id = c_project_id
29: and pbv.budget_version_id=c_budget_ver_id

Line 41: select project_id,'Y' from pa_proj_fp_options fp

37: 'R',cost_time_phased_code,
38: revenue_time_phased_code)) = 'R';
39:
40: cursor chk_plan_ver_csr(c_budget_ver_id pa_budget_versions.budget_version_id%type) is
41: select project_id,'Y' from pa_proj_fp_options fp
42: where fin_plan_version_id = c_budget_ver_id and
43: fin_plan_option_level_code like 'PLAN_VERSION';
44:
45: --Bug 4919018. SQL Repository Performance Activity

Line 291: l_cost_current_planning_period pa_proj_fp_options.cost_current_planning_period%type;

287: l_org_id pa_projects_all.org_id%TYPE := NULL;
288:
289: l_period_mask_id pa_period_masks_b.period_mask_id%type;
290: l_curr_plan_period pa_budget_versions.current_planning_period%type;
291: l_cost_current_planning_period pa_proj_fp_options.cost_current_planning_period%type;
292: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%type;
293: l_rev_current_planning_period pa_proj_fp_options.rev_current_planning_period%type;
294: l_rev_period_mask_id pa_proj_fp_options.rev_period_mask_id%type;
295: l_all_current_planning_period pa_proj_fp_options.all_current_planning_period%type;

Line 292: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%type;

288:
289: l_period_mask_id pa_period_masks_b.period_mask_id%type;
290: l_curr_plan_period pa_budget_versions.current_planning_period%type;
291: l_cost_current_planning_period pa_proj_fp_options.cost_current_planning_period%type;
292: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%type;
293: l_rev_current_planning_period pa_proj_fp_options.rev_current_planning_period%type;
294: l_rev_period_mask_id pa_proj_fp_options.rev_period_mask_id%type;
295: l_all_current_planning_period pa_proj_fp_options.all_current_planning_period%type;
296: l_all_period_mask_id pa_proj_fp_options.all_period_mask_id%type;

Line 293: l_rev_current_planning_period pa_proj_fp_options.rev_current_planning_period%type;

289: l_period_mask_id pa_period_masks_b.period_mask_id%type;
290: l_curr_plan_period pa_budget_versions.current_planning_period%type;
291: l_cost_current_planning_period pa_proj_fp_options.cost_current_planning_period%type;
292: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%type;
293: l_rev_current_planning_period pa_proj_fp_options.rev_current_planning_period%type;
294: l_rev_period_mask_id pa_proj_fp_options.rev_period_mask_id%type;
295: l_all_current_planning_period pa_proj_fp_options.all_current_planning_period%type;
296: l_all_period_mask_id pa_proj_fp_options.all_period_mask_id%type;
297:

Line 294: l_rev_period_mask_id pa_proj_fp_options.rev_period_mask_id%type;

290: l_curr_plan_period pa_budget_versions.current_planning_period%type;
291: l_cost_current_planning_period pa_proj_fp_options.cost_current_planning_period%type;
292: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%type;
293: l_rev_current_planning_period pa_proj_fp_options.rev_current_planning_period%type;
294: l_rev_period_mask_id pa_proj_fp_options.rev_period_mask_id%type;
295: l_all_current_planning_period pa_proj_fp_options.all_current_planning_period%type;
296: l_all_period_mask_id pa_proj_fp_options.all_period_mask_id%type;
297:
298: -- End Bug 3804286, 12-AUG-04, jwhite --------------------------------------------

Line 295: l_all_current_planning_period pa_proj_fp_options.all_current_planning_period%type;

291: l_cost_current_planning_period pa_proj_fp_options.cost_current_planning_period%type;
292: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%type;
293: l_rev_current_planning_period pa_proj_fp_options.rev_current_planning_period%type;
294: l_rev_period_mask_id pa_proj_fp_options.rev_period_mask_id%type;
295: l_all_current_planning_period pa_proj_fp_options.all_current_planning_period%type;
296: l_all_period_mask_id pa_proj_fp_options.all_period_mask_id%type;
297:
298: -- End Bug 3804286, 12-AUG-04, jwhite --------------------------------------------
299:

Line 296: l_all_period_mask_id pa_proj_fp_options.all_period_mask_id%type;

292: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%type;
293: l_rev_current_planning_period pa_proj_fp_options.rev_current_planning_period%type;
294: l_rev_period_mask_id pa_proj_fp_options.rev_period_mask_id%type;
295: l_all_current_planning_period pa_proj_fp_options.all_current_planning_period%type;
296: l_all_period_mask_id pa_proj_fp_options.all_period_mask_id%type;
297:
298: -- End Bug 3804286, 12-AUG-04, jwhite --------------------------------------------
299:
300: --Bug 4299635. These tbls given below will use txn currency code as index.

Line 538: pa_debug.g_err_stage := 'Updating pa_proj_fp_options table';

534: end if;
535:
536:
537: IF l_debug_mode = 'Y' THEN
538: pa_debug.g_err_stage := 'Updating pa_proj_fp_options table';
539: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
540: end if;
541:
542: -- Bug 3804286, 12-AUG-03, jwhite -------------------------------------------------------------

Line 687: UPDATE pa_proj_fp_options

683: -- fin plan pref code since the options selected would surely have either cost/rev/all or
684: -- both cost and rev (in case of cost-and-rev-sep pref code) as 'R'. 'COST AND REV SEP'
685: -- is not budget version level but for project/plan type level record of fp opt.
686:
687: UPDATE pa_proj_fp_options
688: SET cost_time_phased_code = decode(cost_time_phased_code,'R',l_time_phased_mode,cost_time_phased_code), /* Bug 3792821 */
689: revenue_time_phased_code = decode(revenue_time_phased_code,'R',l_time_phased_mode,revenue_time_phased_code), /* Bug 3792821 */
690: all_time_phased_code = decode(all_time_phased_code,'R',l_time_phased_mode,all_time_phased_code), /* Bug 3792821 */
691: cost_current_planning_period = l_cost_current_planning_period,