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

Line 78: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;

74: l_source_option_level_code pa_proj_fp_options.FIN_PLAN_OPTION_LEVEL_CODE%TYPE;
75: l_fp_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE;
76: l_copy_project_context VARCHAR2(1);
77: /* Variables added for autobase line Bug#2619022*/
78: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
79: l_approved_rev_plan_type_flag pa_proj_fp_options.APPROVED_REV_PLAN_TYPE_FLAG%TYPE;
80: l_source_fp_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE;
81:
82: /* Bug # 2702000 */

Line 410: FROM pa_projects_all ppa

406: SELECT NVL(baseline_funding_flag,'N')
407: ,NVL(approved_rev_plan_type_flag,'N')
408: INTO l_baseline_funding_flag
409: ,l_approved_rev_plan_type_flag
410: FROM pa_projects_all ppa
411: ,pa_fin_plan_types_b ptb
412: WHERE ppa.project_id = p_target_project_id
413: AND ptb.fin_plan_type_id = p_target_plan_type_id;
414:

Line 2737: p_target_project_id IN pa_projects_all.project_id%TYPE,

2733: instead of pa_implementations as a part of MOAC uptake.
2734: =====================================================================================*/
2735: FUNCTION Get_Default_FP_Options(
2736: p_fin_plan_preference_code IN VARCHAR2 ,
2737: p_target_project_id IN pa_projects_all.project_id%TYPE,
2738: p_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE) RETURN FP_COLS is
2739:
2740: /* Declaring Constants */
2741: l_fin_plan_level_code CONSTANT pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE := 'L';

Line 2765: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

2761:
2762: -- Bug :- 2625872, changed l_multi_curr_flag from constant to variable
2763: --l_multi_curr_flag CONSTANT pa_proj_fp_options.PLAN_IN_MULTI_CURR_FLAG%TYPE := 'N';
2764: l_multi_curr_flag pa_proj_fp_options.PLAN_IN_MULTI_CURR_FLAG%TYPE := 'N';
2765: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
2766: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
2767: l_dummy_currency_code pa_projects_all.project_currency_code%TYPE;
2768:
2769: /* added following local variables as part of changes due to autobaseline */

Line 2766: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

2762: -- Bug :- 2625872, changed l_multi_curr_flag from constant to variable
2763: --l_multi_curr_flag CONSTANT pa_proj_fp_options.PLAN_IN_MULTI_CURR_FLAG%TYPE := 'N';
2764: l_multi_curr_flag pa_proj_fp_options.PLAN_IN_MULTI_CURR_FLAG%TYPE := 'N';
2765: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
2766: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
2767: l_dummy_currency_code pa_projects_all.project_currency_code%TYPE;
2768:
2769: /* added following local variables as part of changes due to autobaseline */
2770: l_rev_fin_plan_level_code pa_proj_fp_options.REVENUE_FIN_PLAN_LEVEL_CODE%TYPE := 'L';

Line 2767: l_dummy_currency_code pa_projects_all.project_currency_code%TYPE;

2763: --l_multi_curr_flag CONSTANT pa_proj_fp_options.PLAN_IN_MULTI_CURR_FLAG%TYPE := 'N';
2764: l_multi_curr_flag pa_proj_fp_options.PLAN_IN_MULTI_CURR_FLAG%TYPE := 'N';
2765: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
2766: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
2767: l_dummy_currency_code pa_projects_all.project_currency_code%TYPE;
2768:
2769: /* added following local variables as part of changes due to autobaseline */
2770: l_rev_fin_plan_level_code pa_proj_fp_options.REVENUE_FIN_PLAN_LEVEL_CODE%TYPE := 'L';
2771: l_autobaseline_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE := 'N';

Line 2771: l_autobaseline_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE := 'N';

2767: l_dummy_currency_code pa_projects_all.project_currency_code%TYPE;
2768:
2769: /* added following local variables as part of changes due to autobaseline */
2770: l_rev_fin_plan_level_code pa_proj_fp_options.REVENUE_FIN_PLAN_LEVEL_CODE%TYPE := 'L';
2771: l_autobaseline_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE := 'N';
2772: l_proj_level_funding pa_projects_all.PROJECT_LEVEL_FUNDING_FLAG%TYPE := 'N';
2773: l_app_rev_plan_type_flag pa_proj_fp_options.APPROVED_REV_PLAN_TYPE_FLAG%TYPE := 'N';
2774:
2775: -- FP M Dev Effort Variables used for calling rate schedules util api

Line 2772: l_proj_level_funding pa_projects_all.PROJECT_LEVEL_FUNDING_FLAG%TYPE := 'N';

2768:
2769: /* added following local variables as part of changes due to autobaseline */
2770: l_rev_fin_plan_level_code pa_proj_fp_options.REVENUE_FIN_PLAN_LEVEL_CODE%TYPE := 'L';
2771: l_autobaseline_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE := 'N';
2772: l_proj_level_funding pa_projects_all.PROJECT_LEVEL_FUNDING_FLAG%TYPE := 'N';
2773: l_app_rev_plan_type_flag pa_proj_fp_options.APPROVED_REV_PLAN_TYPE_FLAG%TYPE := 'N';
2774:
2775: -- FP M Dev Effort Variables used for calling rate schedules util api
2776: l_emp_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE;

Line 2865: pa_projects_all prj

2861: SELECT R1.resource_list_id
2862: INTO l_uncategorized_res_id
2863: FROM pa_resource_lists_all_bg R1,
2864: pa_implementations_all pim,
2865: pa_projects_all prj
2866: WHERE prj.project_id = p_target_project_id
2867: AND pim.org_id = prj.org_id
2868: AND R1.uncategorized_flag = 'Y'
2869: AND R1.business_group_id = pim.business_group_id;

Line 2921: FROM pa_projects_all ppa

2917: SELECT NVL(baseline_funding_flag,'N')
2918: ,NVL(approved_rev_plan_type_flag,'N')
2919: INTO l_autobaseline_flag
2920: ,l_app_rev_plan_type_flag
2921: FROM pa_projects_all ppa
2922: ,pa_fin_plan_types_b ptb
2923: WHERE ppa.project_id = p_target_project_id
2924: AND ptb.fin_plan_type_id = p_plan_type_id;
2925:

Line 4007: p_target_project_id IN pa_projects_all.project_id%TYPE,

4003: 23-JAN-2004 rravipat FP M Dev effort Bug 3354518 (IDC)
4004: Initial Creation
4005: =====================================================================================*/
4006: FUNCTION Gen_Src_Plan_Version_Id(
4007: p_target_project_id IN pa_projects_all.project_id%TYPE,
4008: p_target_version_type IN pa_budget_versions.version_type%TYPE,
4009: p_gen_src_plan_type_id IN pa_proj_fp_options.gen_src_cost_plan_type_id%TYPE,
4010: p_gen_src_plan_ver_code IN pa_proj_fp_options.gen_src_cost_plan_ver_code%TYPE)
4011: RETURN pa_budget_versions.budget_version_id%TYPE is

Line 4254: p_target_project_id IN pa_projects_all.project_id%TYPE,

4250: 20-MAR-2004 rravipat FP M Dev effort Phase II changes
4251: Initial Creation
4252: =====================================================================================*/
4253: FUNCTION Gen_Src_WP_Version_Id(
4254: p_target_project_id IN pa_projects_all.project_id%TYPE,
4255: p_gen_src_wp_ver_code IN pa_proj_fp_options.gen_src_cost_wp_ver_code%TYPE)
4256: RETURN pa_budget_versions.budget_version_id%TYPE is
4257:
4258: l_return_status VARCHAR2(2000);

Line 4383: p_project_id IN pa_projects_all.project_id%TYPE

4379: Initial Creation
4380: ===================================================================================*/
4381:
4382: PROCEDURE Create_amt_types (
4383: p_project_id IN pa_projects_all.project_id%TYPE
4384: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4385: ,p_plan_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
4386: ,p_cost_layout_code IN pa_proj_fp_options.cost_layout_code%TYPE
4387: ,p_revenue_layout_code IN pa_proj_fp_options.revenue_layout_code%TYPE

Line 4846: p_source_project_id IN pa_projects_all.project_id%TYPE

4842: Initial Creation
4843: ===================================================================================*/
4844:
4845: PROCEDURE copy_amt_types (
4846: p_source_project_id IN pa_projects_all.project_id%TYPE
4847: ,p_source_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4848: ,p_target_project_id IN pa_projects_all.project_id%TYPE
4849: ,p_target_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4850: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4848: ,p_target_project_id IN pa_projects_all.project_id%TYPE

4844:
4845: PROCEDURE copy_amt_types (
4846: p_source_project_id IN pa_projects_all.project_id%TYPE
4847: ,p_source_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4848: ,p_target_project_id IN pa_projects_all.project_id%TYPE
4849: ,p_target_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4850: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4851: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4852: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4974: p_project_id IN pa_projects_all.project_id%TYPE

4970: END copy_amt_types;
4971:
4972: -- This procedure is used to update the amount types for the periodic budget or forcasts of an existing plan type
4973: PROCEDURE update_amt_types (
4974: p_project_id IN pa_projects_all.project_id%TYPE
4975: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4976: ,p_add_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4977: ,p_del_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4978: ,p_add_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type