[Home] [Help]
6: G_Budget_Status_Code PA_BUDGET_VERSIONS.BUDGET_STATUS_CODE%type := NULL;
7: /* S.N. Bug 4219400 */
8:
9: PROCEDURE insert_rows
10: (x_project_id IN PA_PROJECTS_ALL.PROJECT_ID%type
11: ,x_budget_type_code IN PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type
12: ,x_funds_control_level_code IN PA_BUDGETARY_CONTROLS.FUNDS_CONTROL_LEVEL_CODE%type
13: ,x_top_task_id IN PA_TASKS.TASK_ID%type
14: ,x_task_id IN PA_TASKS.TASK_ID%type
20: );
21:
22:
23: PROCEDURE create_bc_levels
24: (x_project_id IN PA_PROJECTS_ALL.PROJECT_ID%type
25: ,x_budget_type_code IN PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type
26: ,x_entry_level_code IN PA_BUDGET_ENTRY_METHODS.ENTRY_LEVEL_CODE%type
27: ,x_resource_list_id IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%type
28: ,x_group_resource_type_id IN PA_RESOURCE_LISTS_ALL_BG.GROUP_RESOURCE_TYPE_ID%type
39: ,x_msg_count OUT NOCOPY NUMBER
40: ,x_msg_data OUT NOCOPY VARCHAR2 ) ;
41:
42: PROCEDURE budg_control_reset
43: (x_project_id IN PA_PROJECTS_ALL.PROJECT_ID%type
44: ,x_budget_type_code IN PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type
45: ,x_entry_level_code IN PA_BUDGET_ENTRY_METHODS.ENTRY_LEVEL_CODE%type
46: ,x_resource_list_id IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%type
47: ,x_group_resource_type_id IN PA_RESOURCE_LISTS_ALL_BG.GROUP_RESOURCE_TYPE_ID%type
51: ,x_msg_data OUT NOCOPY VARCHAR2 );
52:
53:
54: FUNCTION budget_ctrl_exists
55: (x_project_id IN PA_PROJECTS_ALL.PROJECT_ID%type
56: ,x_budget_type_code IN PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type)
57: return varchar2;
58:
59: FUNCTION budg_control_enabled