DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_PUB dependencies on PA_PROJ_FP_OPTIONS_S

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

3981: IF P_PA_DEBUG_MODE = 'Y' THEN
3982: pa_debug.write_file('Create_Version_OrgFcst: ' || 'no planning options for plan_type level: creating one now');
3983: END IF;
3984: /* call table handler to create planning options for plan_type */
3985: select pa_proj_fp_options_s.nextVal into l_proj_fin_plan_options_id from dual;
3986: pa_proj_fp_options_pkg.Insert_Row
3987: (px_proj_fp_options_id => l_proj_fin_plan_options_id,
3988: p_project_id => p_project_id,
3989: p_fin_plan_option_level_code => 'PLAN_TYPE',

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

4018: /* create planning option for plan VERSION */
4019: IF P_PA_DEBUG_MODE = 'Y' THEN
4020: pa_debug.write_file('Create_Version_OrgFcst: ' || 'creating planning options for PLAN_VERSION level');
4021: END IF;
4022: select pa_proj_fp_options_s.nextVal into l_proj_fin_plan_options_id from dual;
4023: pa_proj_fp_options_pkg.Insert_Row
4024: (px_proj_fp_options_id => l_proj_fin_plan_options_id,
4025: p_project_id => p_project_id,
4026: p_fin_plan_option_level_code => 'PLAN_VERSION',

Line 5397: ,select_res_auto_flag PA_PROJ_FP_OPTIONS.select_cost_res_auto_flag%TYPE

5393: ,period_mask_id PA_PROJ_FP_OPTIONS.cost_PERIOD_MASK_ID%TYPE
5394: ,plan_in_multi_curr_flag PA_PROJ_FP_OPTIONS.plan_in_multi_curr_flag%TYPE
5395: ,approved_cost_plan_type_flag PA_PROJ_FP_OPTIONS.approved_cost_plan_type_flag%TYPE
5396: ,approved_rev_plan_type_flag PA_PROJ_FP_OPTIONS.approved_rev_plan_type_flag%TYPE
5397: ,select_res_auto_flag PA_PROJ_FP_OPTIONS.select_cost_res_auto_flag%TYPE
5398: ,source_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE
5399: ,version_type PA_BUDGET_VERSIONS.version_type%TYPE
5400: ,project_structure_version_id PA_BUDGET_VERSIONS.project_structure_version_id%TYPE
5401: ,rbs_version_id PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE