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

Line 224: x_project_currency OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895

220: x_grouping_type OUT NOCOPY VARCHAR2, -- valid values: 'GROUPED', 'NONGROUPED', 'MIXED' --File.Sql.39 bug 4440895
221: x_planning_level OUT NOCOPY VARCHAR2, -- valid values: 'P', 'T', 'L', 'M' --File.Sql.39 bug 4440895
222: x_multicurrency_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
223: x_plan_type_name OUT NOCOPY pa_fin_plan_types_tl.name%TYPE, --File.Sql.39 bug 4440895
224: x_project_currency OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
225: x_labor_hrs_from_code OUT NOCOPY pa_proj_fp_options.report_labor_hrs_from_code%TYPE, --File.Sql.39 bug 4440895
226: x_cost_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
227: x_rev_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
228: x_cost_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 337: from pa_projects_all

333: x_ar_ac_flag := 'Y';
334: -- get PROJECT CURRENCY
335: select projfunc_currency_code
336: into x_project_currency
337: from pa_projects_all
338: where project_id = p_project_id;
339: pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE := 'PROJFUNC';
340: else
341: -- NOT APPROVED REVENUE: go with Project Currency

Line 346: from pa_projects_all

342: x_ar_ac_flag := 'N';
343: -- get PROJECT CURRENCY
344: select project_currency_code
345: into x_project_currency
346: from pa_projects_all
347: where project_id = p_project_id;
348: pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE := 'PROJECT';
349: end if; -- approved revenue flag
350:

Line 878: x_project_currency OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895

874: x_grouping_type OUT NOCOPY VARCHAR2, -- valid values: 'GROUPED', 'NONGROUPED', 'MIXED' --File.Sql.39 bug 4440895
875: x_planning_level OUT NOCOPY VARCHAR2, -- valid values: 'P', 'T', 'L', 'M' --File.Sql.39 bug 4440895
876: x_multicurrency_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
877: x_plan_type_name OUT NOCOPY pa_fin_plan_types_tl.name%TYPE, --File.Sql.39 bug 4440895
878: x_project_currency OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
879: x_record_version_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
880: x_plan_type_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
881: x_plan_version_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
882: x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895

Line 973: from pa_projects_all

969: x_ar_ac_flag := 'Y';
970: -- get PROJECT CURRENCY
971: select projfunc_currency_code
972: into x_project_currency
973: from pa_projects_all
974: where project_id = p_project_id;
975: -- >>>> BUG FIX 2730016: check pa_agreements_all as well
976: select ci_id,
977: agreement_id

Line 998: from pa_projects_all

994: x_ar_ac_flag := 'N';
995: -- get PROJECT CURRENCY
996: select project_currency_code
997: into x_project_currency
998: from pa_projects_all
999: where project_id = p_project_id;
1000: pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE := 'PROJECT';
1001: end if; -- approved revenue flag
1002:

Line 1223: p_project_currency IN pa_projects_all.project_currency_code%TYPE,

1219: p_project_id IN pa_budget_versions.project_id%TYPE,
1220: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
1221: p_revenue_version_id IN pa_budget_versions.budget_version_id%TYPE,
1222: p_both_version_id IN pa_budget_versions.budget_version_id%TYPE,
1223: p_project_currency IN pa_projects_all.project_currency_code%TYPE,
1224: p_get_display_from IN VARCHAR2, -- 'COST', 'REVENUE', 'BOTH', 'ANY'
1225: p_filter_task_id IN pa_resource_assignments.task_id%TYPE,
1226: p_filter_resource_id IN pa_resource_list_members.resource_id%TYPE,
1227: p_filter_rlm_id IN pa_resource_assignments.resource_list_member_id%TYPE,

Line 2379: x_project_currency OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895

2375: x_grouping_type OUT NOCOPY VARCHAR2, -- valid values: 'GROUPED', 'NONGROUPED', 'MIXED' --File.Sql.39 bug 4440895
2376: x_planning_level OUT NOCOPY VARCHAR2, -- valid values: 'P', 'T', 'L', 'M' --File.Sql.39 bug 4440895
2377: x_multicurrency_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
2378: x_plan_type_name OUT NOCOPY pa_fin_plan_types_tl.name%TYPE, --File.Sql.39 bug 4440895
2379: x_project_currency OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
2380: x_labor_hrs_from_code OUT NOCOPY pa_proj_fp_options.report_labor_hrs_from_code%TYPE, --File.Sql.39 bug 4440895
2381: x_cost_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
2382: x_rev_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
2383: x_cost_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 2465: from pa_projects_all

2461:
2462: -- get PROJECT CURRENCY
2463: select project_currency_code
2464: into x_project_currency
2465: from pa_projects_all
2466: where project_id = p_project_id;
2467: x_plan_type_name := 'CI STUFF';
2468:
2469: open ci_csr;

Line 2539: from pa_projects_all

2535: else
2536: -- get PROJECT CURRENCY
2537: select projfunc_currency_code
2538: into x_project_currency
2539: from pa_projects_all
2540: where project_id = p_project_id;
2541: pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE := 'PROJFUNC';
2542:
2543: end if; -- ci_id is not null

Line 2551: from pa_projects_all

2547: x_ar_ac_flag := 'N';
2548: -- get PROJECT CURRENCY
2549: select project_currency_code
2550: into x_project_currency
2551: from pa_projects_all
2552: where project_id = p_project_id;
2553: pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE := 'PROJECT';
2554: end if; -- approved revenue flag
2555:

Line 3224: l_project_id pa_projects_all.project_id%TYPE ;

3220: l_debug_level3 CONSTANT NUMBER := 3;
3221: l_debug_level4 CONSTANT NUMBER := 4;
3222: l_debug_level5 CONSTANT NUMBER := 5;
3223:
3224: l_project_id pa_projects_all.project_id%TYPE ;
3225: l_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3226: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3227: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE ;
3228: l_resource_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();