APPS.PA_BUDGETARY_CONTROLS_PKG dependencies on PA_BUDGET_ENTRY_METHODS

Line 115: ,p_entry_level_code IN PA_BUDGET_ENTRY_METHODS.ENTRY_LEVEL_CODE%type)

111:
112: PROCEDURE del_bc_rec_for_task_auto
113: (p_project_id IN NUMBER
114: ,p_budget_type_code IN PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type
115: ,p_entry_level_code IN PA_BUDGET_ENTRY_METHODS.ENTRY_LEVEL_CODE%type)
116: IS
117: PRAGMA AUTONOMOUS_TRANSACTION;
118: BEGIN
119:

Line 145: ,x_entry_level_code IN PA_BUDGET_ENTRY_METHODS.ENTRY_LEVEL_CODE%type

141:
142: PROCEDURE create_bc_levels
143: (x_project_id IN PA_PROJECTS_ALL.PROJECT_ID%type
144: ,x_budget_type_code IN PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type
145: ,x_entry_level_code IN PA_BUDGET_ENTRY_METHODS.ENTRY_LEVEL_CODE%type
146: ,x_resource_list_id IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%type
147: ,x_group_resource_type_id IN PA_RESOURCE_LISTS_ALL_BG.GROUP_RESOURCE_TYPE_ID%type
148: ,x_calling_mode IN VARCHAR2
149: ,x_return_status OUT NOCOPY VARCHAR2

Line 559: ,PA_BUDGET_ENTRY_METHODS bem

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
563: and bv.resource_list_id = rl.resource_list_id

Line 573: pa_budget_entry_methods bem

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:
577: l_prev_entry_level_code pa_budget_entry_methods.entry_level_code%type;

Line 577: l_prev_entry_level_code pa_budget_entry_methods.entry_level_code%type;

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:
577: l_prev_entry_level_code pa_budget_entry_methods.entry_level_code%type;
578:
579: --===================================================================================
580: /* Called from Budget Baselining / Tieback API
581: The Budget Version has BUDGET_STATUS_CODE = 'B' if Baseline process was successful

Line 731: ,x_entry_level_code IN PA_BUDGET_ENTRY_METHODS.ENTRY_LEVEL_CODE%type

727:
728: PROCEDURE budg_control_reset
729: (x_project_id IN PA_PROJECTS_ALL.PROJECT_ID%type
730: ,x_budget_type_code IN PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type
731: ,x_entry_level_code IN PA_BUDGET_ENTRY_METHODS.ENTRY_LEVEL_CODE%type
732: ,x_resource_list_id IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%type
733: ,x_group_resource_type_id IN PA_RESOURCE_LISTS_ALL_BG.GROUP_RESOURCE_TYPE_ID%type
734: ,x_calling_mode IN VARCHAR2
735: ,x_return_status OUT NOCOPY VARCHAR2