DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_PUB dependencies on PA_PROJ_FP_OPTIONS_S

Line 4001: select pa_proj_fp_options_s.nextVal into l_proj_fin_plan_options_id from dual;

3997: IF P_PA_DEBUG_MODE = 'Y' THEN
3998: pa_debug.write_file('Create_Version_OrgFcst: ' || 'no planning options for plan_type level: creating one now');
3999: END IF;
4000: /* call table handler to create planning options for plan_type */
4001: select pa_proj_fp_options_s.nextVal into l_proj_fin_plan_options_id from dual;
4002: pa_proj_fp_options_pkg.Insert_Row
4003: (px_proj_fp_options_id => l_proj_fin_plan_options_id,
4004: p_project_id => p_project_id,
4005: p_fin_plan_option_level_code => 'PLAN_TYPE',

Line 4038: select pa_proj_fp_options_s.nextVal into l_proj_fin_plan_options_id from dual;

4034: /* create planning option for plan VERSION */
4035: IF P_PA_DEBUG_MODE = 'Y' THEN
4036: pa_debug.write_file('Create_Version_OrgFcst: ' || 'creating planning options for PLAN_VERSION level');
4037: END IF;
4038: select pa_proj_fp_options_s.nextVal into l_proj_fin_plan_options_id from dual;
4039: pa_proj_fp_options_pkg.Insert_Row
4040: (px_proj_fp_options_id => l_proj_fin_plan_options_id,
4041: p_project_id => p_project_id,
4042: p_fin_plan_option_level_code => 'PLAN_VERSION',

Line 5414: ,select_res_auto_flag PA_PROJ_FP_OPTIONS.select_cost_res_auto_flag%TYPE

5410: ,period_mask_id PA_PROJ_FP_OPTIONS.cost_PERIOD_MASK_ID%TYPE
5411: ,plan_in_multi_curr_flag PA_PROJ_FP_OPTIONS.plan_in_multi_curr_flag%TYPE
5412: ,approved_cost_plan_type_flag PA_PROJ_FP_OPTIONS.approved_cost_plan_type_flag%TYPE
5413: ,approved_rev_plan_type_flag PA_PROJ_FP_OPTIONS.approved_rev_plan_type_flag%TYPE
5414: ,select_res_auto_flag PA_PROJ_FP_OPTIONS.select_cost_res_auto_flag%TYPE
5415: ,source_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE
5416: ,version_type PA_BUDGET_VERSIONS.version_type%TYPE
5417: ,project_structure_version_id PA_BUDGET_VERSIONS.project_structure_version_id%TYPE
5418: ,rbs_version_id PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE