DBA Data[Home] [Help]

APPS.PA_BUDGETARY_CONTROLS_PKG dependencies on PA_BUDGETARY_CONTROL_OPTIONS

Line 271: 1. Derive the Default control levels from PA_BUDGETARY_CONTROL_OPTIONS.

267:
268: Procedure Creates Budgetary Controls for
269: Project, Task, Resource Group and resources.
270:
271: 1. Derive the Default control levels from PA_BUDGETARY_CONTROL_OPTIONS.
272: 2. Create Budgetary control for the Project only when x_calling_mode is 'BASELINE' or 'R'.
273: 2.1 if the Project Budget is linked to external budget, the control
274: level should always be set to Absolute 'B'
275: 3. If entry_level_code = 'P' Project then

Line 350: pa_budgetary_control_options

346: v_funds_control_level_task,
347: v_funds_control_level_res_grp,
348: v_funds_control_level_res
349: from
350: pa_budgetary_control_options
351: where
352: project_id = x_project_id and budget_type_code = x_budget_type_code;
353:
354: PA_FCK_UTIL.debug_msg('PA_BC_Log: Control levels derived for ' || x_project_id);

Line 356: PA_FCK_UTIL.debug_msg('PA_BC_Log: Derived Default Budgetary Control levels from PA_BUDGETARY_CONTROL_OPTIONS');

352: project_id = x_project_id and budget_type_code = x_budget_type_code;
353:
354: PA_FCK_UTIL.debug_msg('PA_BC_Log: Control levels derived for ' || x_project_id);
355:
356: PA_FCK_UTIL.debug_msg('PA_BC_Log: Derived Default Budgetary Control levels from PA_BUDGETARY_CONTROL_OPTIONS');
357:
358: PA_DEBUG.g_err_stage := 'PA_BC_Log: Derive default control levels';
359: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
360:

Line 857: l_bdgt_intg_flag pa_budgetary_control_options.external_budget_code%TYPE ;

853: return varchar2 is
854:
855:
856: l_fck_req_flag VARCHAR2(1);
857: l_bdgt_intg_flag pa_budgetary_control_options.external_budget_code%TYPE ;
858: l_bdgt_ver_id pa_budget_versions.budget_version_id%TYPE ;
859: l_encum_type_id pa_budgetary_control_options.encumbrance_type_id%TYPE ;
860: l_balance_type pa_budgetary_control_options.balance_type%TYPE;
861: l_return_status VARCHAR2(10);

Line 859: l_encum_type_id pa_budgetary_control_options.encumbrance_type_id%TYPE ;

855:
856: l_fck_req_flag VARCHAR2(1);
857: l_bdgt_intg_flag pa_budgetary_control_options.external_budget_code%TYPE ;
858: l_bdgt_ver_id pa_budget_versions.budget_version_id%TYPE ;
859: l_encum_type_id pa_budgetary_control_options.encumbrance_type_id%TYPE ;
860: l_balance_type pa_budgetary_control_options.balance_type%TYPE;
861: l_return_status VARCHAR2(10);
862: l_msg_count NUMBER(15);
863: l_msg_data VARCHAR2(2000);

Line 860: l_balance_type pa_budgetary_control_options.balance_type%TYPE;

856: l_fck_req_flag VARCHAR2(1);
857: l_bdgt_intg_flag pa_budgetary_control_options.external_budget_code%TYPE ;
858: l_bdgt_ver_id pa_budget_versions.budget_version_id%TYPE ;
859: l_encum_type_id pa_budgetary_control_options.encumbrance_type_id%TYPE ;
860: l_balance_type pa_budgetary_control_options.balance_type%TYPE;
861: l_return_status VARCHAR2(10);
862: l_msg_count NUMBER(15);
863: l_msg_data VARCHAR2(2000);
864: v_bud_ctrl_exist VARCHAR2(1);

Line 983: l_encum_type_id pa_budgetary_control_options.encumbrance_type_id%TYPE ;

979: l_msg_count NUMBER(15);
980: l_msg_data VARCHAR2(2000);
981:
982: l_bdgt_ver_id pa_budget_versions.budget_version_id%TYPE ;
983: l_encum_type_id pa_budgetary_control_options.encumbrance_type_id%TYPE ;
984: l_balance_type pa_budgetary_control_options.balance_type%TYPE;
985: l_fck_req_flag VARCHAR2(1);
986: l_bdgt_intg_flag VARCHAR2(1);
987: v_bc_enabled VARCHAR2(1);

Line 984: l_balance_type pa_budgetary_control_options.balance_type%TYPE;

980: l_msg_data VARCHAR2(2000);
981:
982: l_bdgt_ver_id pa_budget_versions.budget_version_id%TYPE ;
983: l_encum_type_id pa_budgetary_control_options.encumbrance_type_id%TYPE ;
984: l_balance_type pa_budgetary_control_options.balance_type%TYPE;
985: l_fck_req_flag VARCHAR2(1);
986: l_bdgt_intg_flag VARCHAR2(1);
987: v_bc_enabled VARCHAR2(1);
988: invalid_args_passed EXCEPTION;