APPS.PA_BUDGETARY_CONTROLS_PKG dependencies on PA_BUDGET_VERSIONS

Line 522: (x_budget_version_id IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%type

518:
519: ------------------------------------------------------------------------------------
520:
521: PROCEDURE bud_ctrl_create
522: (x_budget_version_id IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%type
523: ,x_calling_mode IN VARCHAR2
524: ,x_return_status OUT NOCOPY VARCHAR2
525: ,x_msg_count OUT NOCOPY NUMBER
526: ,x_msg_data OUT NOCOPY VARCHAR2 ) is

Line 545: PA_BUDGET_VERSIONS pbv

541: SELECT 'Y'
542: FROM DUAL
543: WHERE EXISTS (SELECT 1
544: FROM pa_budgetary_controls bc,
545: PA_BUDGET_VERSIONS pbv
546: WHERE BUDGET_VERSION_ID = p_budget_version_id
547: and bc.project_id = pbv.project_id
548: and bc.budget_type_code = pbv.budget_type_code);
549:

Line 558: from PA_BUDGET_VERSIONS bv

554: ,bv.budget_type_code
555: ,bv.resource_list_id
556: ,rl.group_resource_type_id
557: ,bem.entry_level_code
558: from PA_BUDGET_VERSIONS bv
559: ,PA_BUDGET_ENTRY_METHODS bem
560: ,PA_RESOURCE_LISTS_ALL_BG rl
561: where bv.budget_version_id = p_budget_version_id
562: and bv.budget_entry_method_code = bem.budget_entry_method_code

Line 572: from pa_budget_versions bv,

568:
569: -- Bug 4551528 : This cursor is used to retrieve the entry_level_code for the previous version of the budget.
570: cursor c_prev_entry_level_code(p_budget_version_id number) is
571: select bem.entry_level_code
572: from pa_budget_versions bv,
573: pa_budget_entry_methods bem
574: where bv.budget_version_id = p_budget_version_id
575: and bv. budget_entry_method_code = bem. budget_entry_method_code;
576:

Line 858: l_bdgt_ver_id pa_budget_versions.budget_version_id%TYPE ;

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);
862: l_msg_count NUMBER(15);

Line 973: ( x_budget_version_id IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%type)

969:
970: ------------------------------------------------------------------------------------
971:
972: FUNCTION budg_control_enabled
973: ( x_budget_version_id IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%type)
974: return varchar2 is
975:
976: l_project_id PA_PROJECTS_ALL.PROJECT_ID%type;
977: l_budget_type_code PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type;

Line 982: l_bdgt_ver_id pa_budget_versions.budget_version_id%TYPE ;

978: l_return_status VARCHAR2(10);
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);

Line 993: -- Derive the PROJECT_ID and BUDGET_TYPE_CODE from PA_BUDGET_VERSIONS

989:
990: --============================================================================
991: --Called from Budgets Form
992: --Returns 'Y' if Budgetary Controls enabled for given PROJECT_ID and BUDGET_TYPE_CODE
993: -- Derive the PROJECT_ID and BUDGET_TYPE_CODE from PA_BUDGET_VERSIONS
994: -- if Budgetary Controls enabled (Call to PA_BUDGET_FUND API) and BALANCE_TYPE in ('B','E')
995: -- return 'Y'
996: -- else
997: -- return 'N'

Line 1011: from PA_BUDGET_VERSIONS

1007: end if;
1008:
1009: select PROJECT_ID,BUDGET_TYPE_CODE
1010: into l_project_id, l_budget_type_code
1011: from PA_BUDGET_VERSIONS
1012: where BUDGET_VERSION_ID = x_budget_version_id;
1013:
1014:
1015:

Line 1064: (p_budget_version_id IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%type)

1060: end ; -- end of Function
1061:
1062:
1063: FUNCTION get_budget_status
1064: (p_budget_version_id IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%type)
1065: return varchar2 is
1066:
1067: v_budget_status_code PA_BUDGET_VERSIONS.BUDGET_STATUS_CODE%type;
1068:

Line 1067: v_budget_status_code PA_BUDGET_VERSIONS.BUDGET_STATUS_CODE%type;

1063: FUNCTION get_budget_status
1064: (p_budget_version_id IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%type)
1065: return varchar2 is
1066:
1067: v_budget_status_code PA_BUDGET_VERSIONS.BUDGET_STATUS_CODE%type;
1068:
1069: cursor c_budget_status is
1070: select budget_status_code from PA_BUDGET_VERSIONS where budget_version_id = p_budget_version_id;
1071:

Line 1070: select budget_status_code from PA_BUDGET_VERSIONS where budget_version_id = p_budget_version_id;

1066:
1067: v_budget_status_code PA_BUDGET_VERSIONS.BUDGET_STATUS_CODE%type;
1068:
1069: cursor c_budget_status is
1070: select budget_status_code from PA_BUDGET_VERSIONS where budget_version_id = p_budget_version_id;
1071:
1072: begin
1073:
1074: if (nvl(G_Budget_Version_ID,-9999) = p_budget_version_id ) then /*4219400*/