[Home] [Help]
PACKAGE: APPS.PA_BUDGETARY_CONTROLS_PKG
Source
1 PACKAGE PA_BUDGETARY_CONTROLS_PKG AUTHID CURRENT_USER AS
2 -- $Header: PAXBCCRS.pls 120.1 2006/04/01 19:46:20 appldev noship $
3
4 /* S.N. Bug 4219400 */
5 G_Budget_Version_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%type := NULL;
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
15 ,x_parent_member_id IN PA_RESOURCE_LIST_MEMBERS.PARENT_MEMBER_ID%type
16 ,x_resource_list_member_id IN PA_RESOURCE_LIST_MEMBERS.resource_list_member_id%type
17 ,x_return_status OUT NOCOPY VARCHAR2
18 ,x_msg_count OUT NOCOPY NUMBER
19 ,x_msg_data OUT NOCOPY VARCHAR2
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
29 ,x_calling_mode IN VARCHAR2
30 ,x_return_status OUT NOCOPY VARCHAR2
31 ,x_msg_count OUT NOCOPY NUMBER
32 ,x_msg_data OUT NOCOPY VARCHAR2 );
33
34
35 PROCEDURE bud_ctrl_create
36 (x_budget_version_id IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%type
37 ,x_calling_mode IN VARCHAR2
38 ,x_return_status OUT NOCOPY VARCHAR2
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
48 ,x_calling_mode IN VARCHAR2
49 ,x_return_status OUT NOCOPY VARCHAR2
50 ,x_msg_count OUT NOCOPY NUMBER
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
60 (x_budget_version_id IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%type)
61 return varchar2;
62
63 FUNCTION get_budget_status
64 (p_budget_version_id IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%type)
65 return varchar2;
66 end; -- end of Package