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 2692: p_target_project_id IN pa_projects_all.project_id%TYPE,

2688: instead of pa_implementations as a part of MOAC uptake.
2689: =====================================================================================*/
2690: FUNCTION Get_Default_FP_Options(
2691: p_fin_plan_preference_code IN VARCHAR2 ,
2692: p_target_project_id IN pa_projects_all.project_id%TYPE,
2693: p_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE) RETURN FP_COLS is
2694:
2695: /* Declaring Constants */
2696: l_fin_plan_level_code CONSTANT pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE := 'L';

Line 2720: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

2716:
2717: -- Bug :- 2625872, changed l_multi_curr_flag from constant to variable
2718: --l_multi_curr_flag CONSTANT pa_proj_fp_options.PLAN_IN_MULTI_CURR_FLAG%TYPE := 'N';
2719: l_multi_curr_flag pa_proj_fp_options.PLAN_IN_MULTI_CURR_FLAG%TYPE := 'N';
2720: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
2721: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
2722: l_dummy_currency_code pa_projects_all.project_currency_code%TYPE;
2723:
2724: /* added following local variables as part of changes due to autobaseline */

Line 2721: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

2717: -- Bug :- 2625872, changed l_multi_curr_flag from constant to variable
2718: --l_multi_curr_flag CONSTANT pa_proj_fp_options.PLAN_IN_MULTI_CURR_FLAG%TYPE := 'N';
2719: l_multi_curr_flag pa_proj_fp_options.PLAN_IN_MULTI_CURR_FLAG%TYPE := 'N';
2720: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
2721: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
2722: l_dummy_currency_code pa_projects_all.project_currency_code%TYPE;
2723:
2724: /* added following local variables as part of changes due to autobaseline */
2725: l_rev_fin_plan_level_code pa_proj_fp_options.REVENUE_FIN_PLAN_LEVEL_CODE%TYPE := 'L';

Line 2722: l_dummy_currency_code pa_projects_all.project_currency_code%TYPE;

2718: --l_multi_curr_flag CONSTANT pa_proj_fp_options.PLAN_IN_MULTI_CURR_FLAG%TYPE := 'N';
2719: l_multi_curr_flag pa_proj_fp_options.PLAN_IN_MULTI_CURR_FLAG%TYPE := 'N';
2720: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
2721: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
2722: l_dummy_currency_code pa_projects_all.project_currency_code%TYPE;
2723:
2724: /* added following local variables as part of changes due to autobaseline */
2725: l_rev_fin_plan_level_code pa_proj_fp_options.REVENUE_FIN_PLAN_LEVEL_CODE%TYPE := 'L';
2726: l_autobaseline_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE := 'N';

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

2722: l_dummy_currency_code pa_projects_all.project_currency_code%TYPE;
2723:
2724: /* added following local variables as part of changes due to autobaseline */
2725: l_rev_fin_plan_level_code pa_proj_fp_options.REVENUE_FIN_PLAN_LEVEL_CODE%TYPE := 'L';
2726: l_autobaseline_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE := 'N';
2727: l_proj_level_funding pa_projects_all.PROJECT_LEVEL_FUNDING_FLAG%TYPE := 'N';
2728: l_app_rev_plan_type_flag pa_proj_fp_options.APPROVED_REV_PLAN_TYPE_FLAG%TYPE := 'N';
2729:
2730: -- FP M Dev Effort Variables used for calling rate schedules util api

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

2723:
2724: /* added following local variables as part of changes due to autobaseline */
2725: l_rev_fin_plan_level_code pa_proj_fp_options.REVENUE_FIN_PLAN_LEVEL_CODE%TYPE := 'L';
2726: l_autobaseline_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE := 'N';
2727: l_proj_level_funding pa_projects_all.PROJECT_LEVEL_FUNDING_FLAG%TYPE := 'N';
2728: l_app_rev_plan_type_flag pa_proj_fp_options.APPROVED_REV_PLAN_TYPE_FLAG%TYPE := 'N';
2729:
2730: -- FP M Dev Effort Variables used for calling rate schedules util api
2731: l_emp_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE;

Line 2820: pa_projects_all prj

2816: SELECT R1.resource_list_id
2817: INTO l_uncategorized_res_id
2818: FROM pa_resource_lists_all_bg R1,
2819: pa_implementations_all pim,
2820: pa_projects_all prj
2821: WHERE prj.project_id = p_target_project_id
2822: AND pim.org_id = prj.org_id
2823: AND R1.uncategorized_flag = 'Y'
2824: AND R1.business_group_id = pim.business_group_id;

Line 2876: FROM pa_projects_all ppa

2872: SELECT NVL(baseline_funding_flag,'N')
2873: ,NVL(approved_rev_plan_type_flag,'N')
2874: INTO l_autobaseline_flag
2875: ,l_app_rev_plan_type_flag
2876: FROM pa_projects_all ppa
2877: ,pa_fin_plan_types_b ptb
2878: WHERE ppa.project_id = p_target_project_id
2879: AND ptb.fin_plan_type_id = p_plan_type_id;
2880:

Line 3962: p_target_project_id IN pa_projects_all.project_id%TYPE,

3958: 23-JAN-2004 rravipat FP M Dev effort Bug 3354518 (IDC)
3959: Initial Creation
3960: =====================================================================================*/
3961: FUNCTION Gen_Src_Plan_Version_Id(
3962: p_target_project_id IN pa_projects_all.project_id%TYPE,
3963: p_target_version_type IN pa_budget_versions.version_type%TYPE,
3964: p_gen_src_plan_type_id IN pa_proj_fp_options.gen_src_cost_plan_type_id%TYPE,
3965: p_gen_src_plan_ver_code IN pa_proj_fp_options.gen_src_cost_plan_ver_code%TYPE)
3966: RETURN pa_budget_versions.budget_version_id%TYPE is

Line 4209: p_target_project_id IN pa_projects_all.project_id%TYPE,

4205: 20-MAR-2004 rravipat FP M Dev effort Phase II changes
4206: Initial Creation
4207: =====================================================================================*/
4208: FUNCTION Gen_Src_WP_Version_Id(
4209: p_target_project_id IN pa_projects_all.project_id%TYPE,
4210: p_gen_src_wp_ver_code IN pa_proj_fp_options.gen_src_cost_wp_ver_code%TYPE)
4211: RETURN pa_budget_versions.budget_version_id%TYPE is
4212:
4213: l_return_status VARCHAR2(2000);

Line 4338: p_project_id IN pa_projects_all.project_id%TYPE

4334: Initial Creation
4335: ===================================================================================*/
4336:
4337: PROCEDURE Create_amt_types (
4338: p_project_id IN pa_projects_all.project_id%TYPE
4339: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4340: ,p_plan_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
4341: ,p_cost_layout_code IN pa_proj_fp_options.cost_layout_code%TYPE
4342: ,p_revenue_layout_code IN pa_proj_fp_options.revenue_layout_code%TYPE

Line 4801: p_source_project_id IN pa_projects_all.project_id%TYPE

4797: Initial Creation
4798: ===================================================================================*/
4799:
4800: PROCEDURE copy_amt_types (
4801: p_source_project_id IN pa_projects_all.project_id%TYPE
4802: ,p_source_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4803: ,p_target_project_id IN pa_projects_all.project_id%TYPE
4804: ,p_target_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4805: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4803: ,p_target_project_id IN pa_projects_all.project_id%TYPE

4799:
4800: PROCEDURE copy_amt_types (
4801: p_source_project_id IN pa_projects_all.project_id%TYPE
4802: ,p_source_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4803: ,p_target_project_id IN pa_projects_all.project_id%TYPE
4804: ,p_target_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4805: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4806: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4807: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4929: p_project_id IN pa_projects_all.project_id%TYPE

4925: END copy_amt_types;
4926:
4927: -- This procedure is used to update the amount types for the periodic budget or forcasts of an existing plan type
4928: PROCEDURE update_amt_types (
4929: p_project_id IN pa_projects_all.project_id%TYPE
4930: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4931: ,p_add_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4932: ,p_del_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4933: ,p_add_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type