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_CALC_PLAN_PKG dependencies on PA_PROJECTS_ALL

Line 22: g_project_name pa_projects_all.name%TYPE;

18: g_bv_resource_list_id pa_budget_versions.resource_list_id%TYPE;
19: g_resource_id NUMBER := to_number(null);
20: g_bv_approved_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
21: g_fp_multi_curr_enabled pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
22: g_project_name pa_projects_all.name%TYPE;
23: g_task_name pa_proj_elements.name%TYPE;
24: g_resource_name pa_resource_list_members.alias%TYPE;
25: g_spread_required_flag VARCHAR2(1) := 'N';
26: g_rollup_required_flag VARCHAR2(1) := 'Y';

Line 269: ,pa_projects_all pp

265: ,decode(fpt.plan_class_code,'BUDGET'
266: ,decode(bv.wp_version_flag,'Y','WORKPLAN',fpt.plan_class_code),fpt.plan_class_code) Plan_Class_Type
267: FROM pa_proj_fp_options pfo
268: ,pa_budget_versions bv
269: ,pa_projects_all pp
270: ,pa_fin_plan_types_b fpt
271: WHERE pfo.fin_plan_version_id = bv.budget_version_id
272: AND bv.project_id = pp.project_id
273: AND fpt.fin_plan_type_id = pfo.fin_plan_type_id

Line 1397: FROM pa_projects_all

1393: CURSOR get_project_lvl_data IS
1394: SELECT segment1
1395: ,project_currency_code
1396: ,projfunc_currency_code
1397: FROM pa_projects_all
1398: WHERE project_id = p_project_id;
1399: BEGIN
1400: x_return_status := 'S';
1401: g_stage := 'Initialize_fp_cur_details:100';

Line 2763: PROCEDURE validate_inputs( p_project_id IN pa_projects_all.project_id%TYPE

2759: -- txn_currency_code_tab.COUNT must equal p_resource_assignment_tab.COUNT
2760: -- 3. p_resource_assignment_tab and txn_currency_code_tab must not have NULL values if passed
2761: -- 4. If any other parameter is passed they must have an equal count to _resource_assignment_tab
2762: */
2763: PROCEDURE validate_inputs( p_project_id IN pa_projects_all.project_id%TYPE
2764: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
2765: ,p_calling_module IN VARCHAR2 DEFAULT NULL
2766: ,p_refresh_rates_flag IN VARCHAR2 DEFAULT NULL
2767: ,p_refresh_conv_rates_flag IN VARCHAR2 DEFAULT NULL

Line 4685: ,pa_projects_all ppa

4681: 'REVENUE',ppfo.revenue_time_phased_code,
4682: ppfo.all_time_phased_code) time_phase_code
4683: FROM gl_sets_of_books gsb
4684: ,pa_implementations_all pia
4685: ,pa_projects_all ppa
4686: ,pa_budget_versions pbv
4687: ,pa_proj_fp_options ppfo
4688: WHERE ppa.project_id = pbv.project_id
4689: AND pbv.budget_version_id = ppfo.fin_plan_version_id

Line 7759: PROCEDURE calculate ( p_project_id IN pa_projects_all.project_id%TYPE

7755: * the following params are only for internal purposes, the values passed from AMG or page will be ignored
7756: * p_addl_qty_tab,p_addl_raw_cost_tab,p_addl_burdened_cost_tab,p_addl_revenue_tab
7757: *
7758: */
7759: PROCEDURE calculate ( p_project_id IN pa_projects_all.project_id%TYPE
7760: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
7761: ,p_refresh_rates_flag IN VARCHAR2 := 'N'
7762: ,p_refresh_conv_rates_flag IN VARCHAR2 := 'N'
7763: ,p_spread_required_flag IN VARCHAR2 := 'Y'

Line 7945: l_org_id pa_projects_all.org_id%TYPE;

7941: l_burden_cost_rate pa_fp_res_assignments_tmp.burden_cost_rate%TYPE;
7942: l_burden_cost_rate_override pa_fp_res_assignments_tmp.burden_cost_rate_override%TYPE;
7943: l_bill_rate pa_fp_res_assignments_tmp.bill_rate%TYPE;
7944: l_bill_rate_override pa_fp_res_assignments_tmp.bill_rate_override%TYPE;
7945: l_org_id pa_projects_all.org_id%TYPE;
7946:
7947: l_cost_rt_miss_num_flag VARCHAR2(1) := NULL;
7948: l_burd_rt_miss_num_flag VARCHAR2(1) := NULL;
7949: l_bill_rt_miss_num_flag VARCHAR2(1) := NULL;

Line 8006: ,pa_projects_all pp

8002: /*Bugfix:4272944 */
8003: ,NVL(pp.baseline_funding_flag,'N') baseline_funding_flag
8004: FROM pa_proj_fp_options pfo
8005: ,pa_budget_versions bv
8006: ,pa_projects_all pp
8007: WHERE pfo.fin_plan_version_id = bv.budget_version_id
8008: AND bv.project_id = pp.project_id
8009: AND bv.budget_version_id = p_budget_version_id;
8010: ProjFpOptRec get_proj_fp_options_csr%ROWTYPE;

Line 11752: ,pa_projects_all pp

11748: ,bv.project_structure_version_id
11749: ,bv.project_id
11750: FROM pa_proj_fp_options pfo
11751: ,pa_budget_versions bv
11752: ,pa_projects_all pp
11753: WHERE pfo.fin_plan_version_id = bv.budget_version_id
11754: AND bv.budget_version_id = p_budget_version_id
11755: AND pp.project_id = bv.project_id
11756: AND pfo.project_id = pp.project_id;

Line 11833: l_labor_sch_type pa_projects_all.labor_sch_type%TYPE;

11829: l_cost_sch_type VARCHAR2(30) := 'COST';
11830: l_mfc_cost_source CONSTANT NUMBER := 2;
11831: x_stage varchar2(1000);
11832:
11833: l_labor_sch_type pa_projects_all.labor_sch_type%TYPE;
11834: l_non_labor_sch_type pa_projects_all.labor_sch_type%TYPE;
11835:
11836: www get_rollup_csr%rowtype;
11837: l_rate_api_called_flag varchar2(100);

Line 11834: l_non_labor_sch_type pa_projects_all.labor_sch_type%TYPE;

11830: l_mfc_cost_source CONSTANT NUMBER := 2;
11831: x_stage varchar2(1000);
11832:
11833: l_labor_sch_type pa_projects_all.labor_sch_type%TYPE;
11834: l_non_labor_sch_type pa_projects_all.labor_sch_type%TYPE;
11835:
11836: www get_rollup_csr%rowtype;
11837: l_rate_api_called_flag varchar2(100);
11838: l_revenue_generation_method Varchar2(100);