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 1427: FROM pa_projects_all

1423: CURSOR get_project_lvl_data IS
1424: SELECT segment1
1425: ,project_currency_code
1426: ,projfunc_currency_code
1427: FROM pa_projects_all
1428: WHERE project_id = p_project_id;
1429: BEGIN
1430: x_return_status := 'S';
1431: g_stage := 'Initialize_fp_cur_details:100';

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

2789: -- txn_currency_code_tab.COUNT must equal p_resource_assignment_tab.COUNT
2790: -- 3. p_resource_assignment_tab and txn_currency_code_tab must not have NULL values if passed
2791: -- 4. If any other parameter is passed they must have an equal count to _resource_assignment_tab
2792: */
2793: PROCEDURE validate_inputs( p_project_id IN pa_projects_all.project_id%TYPE
2794: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
2795: ,p_calling_module IN VARCHAR2 DEFAULT NULL
2796: ,p_refresh_rates_flag IN VARCHAR2 DEFAULT NULL
2797: ,p_refresh_conv_rates_flag IN VARCHAR2 DEFAULT NULL

Line 4720: ,pa_projects_all ppa

4716: 'REVENUE',ppfo.revenue_time_phased_code,
4717: ppfo.all_time_phased_code) time_phase_code
4718: FROM gl_sets_of_books gsb
4719: ,pa_implementations_all pia
4720: ,pa_projects_all ppa
4721: ,pa_budget_versions pbv
4722: ,pa_proj_fp_options ppfo
4723: WHERE ppa.project_id = pbv.project_id
4724: AND pbv.budget_version_id = ppfo.fin_plan_version_id

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

7845: * the following params are only for internal purposes, the values passed from AMG or page will be ignored
7846: * p_addl_qty_tab,p_addl_raw_cost_tab,p_addl_burdened_cost_tab,p_addl_revenue_tab
7847: *
7848: */
7849: PROCEDURE calculate ( p_project_id IN pa_projects_all.project_id%TYPE
7850: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
7851: ,p_refresh_rates_flag IN VARCHAR2 := 'N'
7852: ,p_refresh_conv_rates_flag IN VARCHAR2 := 'N'
7853: ,p_spread_required_flag IN VARCHAR2 := 'Y'

Line 8041: l_org_id pa_projects_all.org_id%TYPE;

8037: l_burden_cost_rate pa_fp_res_assignments_tmp.burden_cost_rate%TYPE;
8038: l_burden_cost_rate_override pa_fp_res_assignments_tmp.burden_cost_rate_override%TYPE;
8039: l_bill_rate pa_fp_res_assignments_tmp.bill_rate%TYPE;
8040: l_bill_rate_override pa_fp_res_assignments_tmp.bill_rate_override%TYPE;
8041: l_org_id pa_projects_all.org_id%TYPE;
8042:
8043: l_cost_rt_miss_num_flag VARCHAR2(1) := NULL;
8044: l_burd_rt_miss_num_flag VARCHAR2(1) := NULL;
8045: l_bill_rt_miss_num_flag VARCHAR2(1) := NULL;

Line 8111: ,pa_projects_all pp

8107: /*Bugfix:4272944 */
8108: ,NVL(pp.baseline_funding_flag,'N') baseline_funding_flag
8109: FROM pa_proj_fp_options pfo
8110: ,pa_budget_versions bv
8111: ,pa_projects_all pp
8112: WHERE pfo.fin_plan_version_id = bv.budget_version_id
8113: AND bv.project_id = pp.project_id
8114: AND bv.budget_version_id = p_budget_version_id;
8115: ProjFpOptRec get_proj_fp_options_csr%ROWTYPE;

Line 11932: ,pa_projects_all pp

11928: ,bv.project_structure_version_id
11929: ,bv.project_id
11930: FROM pa_proj_fp_options pfo
11931: ,pa_budget_versions bv
11932: ,pa_projects_all pp
11933: WHERE pfo.fin_plan_version_id = bv.budget_version_id
11934: AND bv.budget_version_id = p_budget_version_id
11935: AND pp.project_id = bv.project_id
11936: AND pfo.project_id = pp.project_id;

Line 12013: l_labor_sch_type pa_projects_all.labor_sch_type%TYPE;

12009: l_cost_sch_type VARCHAR2(30) := 'COST';
12010: l_mfc_cost_source CONSTANT NUMBER := 2;
12011: x_stage varchar2(1000);
12012:
12013: l_labor_sch_type pa_projects_all.labor_sch_type%TYPE;
12014: l_non_labor_sch_type pa_projects_all.labor_sch_type%TYPE;
12015:
12016: www get_rollup_csr%rowtype;
12017: l_rate_api_called_flag varchar2(100);

Line 12014: l_non_labor_sch_type pa_projects_all.labor_sch_type%TYPE;

12010: l_mfc_cost_source CONSTANT NUMBER := 2;
12011: x_stage varchar2(1000);
12012:
12013: l_labor_sch_type pa_projects_all.labor_sch_type%TYPE;
12014: l_non_labor_sch_type pa_projects_all.labor_sch_type%TYPE;
12015:
12016: www get_rollup_csr%rowtype;
12017: l_rate_api_called_flag varchar2(100);
12018: l_revenue_generation_method Varchar2(100);