1 PACKAGE BODY IGW_BUDGET_INTEGRATION as
2 -- $Header: igwbuimb.pls 120.10 2006/02/22 23:22:38 dsadhukh ship $
3
4 FUNCTION draft_budget_exists( p_project_id NUMBER
5 ,l_award_id NUMBER
6 ,x_err_code OUT NOCOPY VARCHAR2
7 ,x_err_stage OUT NOCOPY VARCHAR2) RETURN BOOLEAN
8 IS
9
10 BEGIN
11 RETURN null;
12 END draft_budget_exists;
13 -----------------------------------------------------------------------------------------
14 PROCEDURE draft_budget_line_exists(p_project_id NUMBER
15 ,p_award_id NUMBER
16 ,p_task_id NUMBER
17 ,p_resource_list_member_id NUMBER
18 ,p_period_name VARCHAR2
19 ,x_burdened_cost OUT NOCOPY NUMBER
20 ,x_err_code OUT NOCOPY VARCHAR2
21 ,x_err_stage OUT NOCOPY VARCHAR2)
22 IS
23 BEGIN
24 null;
25 END draft_budget_line_exists;
26 --------------------------------------------------------------------------------------
27 PROCEDURE draft_budget_line_exists_dr(p_project_id NUMBER
28 ,p_award_id NUMBER
29 ,p_task_id NUMBER
30 ,p_resource_list_member_id NUMBER
31 ,p_start_date DATE
32 ,p_end_date DATE
33 ,x_burdened_cost OUT NOCOPY NUMBER
34 ,x_err_code OUT NOCOPY VARCHAR2
35 ,x_err_stage OUT NOCOPY VARCHAR2)
36 IS
37 BEGIN
38
39 null;
40 END draft_budget_line_exists_dr;
41
42 -------------------------------------------------------------------------------------
43 FUNCTION project_funding_exists(p_project_id NUMBER
44 ,p_award_id NUMBER
45 ,x_err_code OUT NOCOPY VARCHAR2
46 ,x_err_stage OUT NOCOPY VARCHAR2) RETURN BOOLEAN
47 IS
48 BEGIN
49 RETURN null;
50 END project_funding_exists;
51
52 --------------------------------------------------------------------------------------
53 PROCEDURE get_resource_list_entry_method ( p_project_id NUMBER
54 ,x_budget_entry_method_code OUT NOCOPY VARCHAR2
55 ,x_resource_list_id OUT NOCOPY NUMBER
56 ,x_time_phased_type_code OUT NOCOPY VARCHAR2
57 ,x_entry_level_code OUT NOCOPY VARCHAR2
58 ,x_categorization_code OUT NOCOPY VARCHAR2 --bug 3523294
59 ,x_return_status OUT NOCOPY VARCHAR2
60 ,x_msg_data OUT NOCOPY VARCHAR2)
61 IS
62 BEGIN
63 NULL;
64 END get_resource_list_entry_method;
65 -----------------------------------------------------------------------------------------------
66 /* This procedure is used for the self service version of applications and it
67 reflects the fact that we no longer have unmatched expenditure category,
68 unmatched expenditure category flag, overhead expenditure category and
69 overhead expenditure category flag in the setups. We make sure that the
70 expenditure category is not unmatched by introducing validations in the front
71 end itself. Also the overhead expenditure category is defined in the front end
72 the same way we define the expenditure category for the direct costs */
73
74 PROCEDURE get_resource_list_member_id_ss ( p_resource_list_id NUMBER
75 ,p_expenditure_type VARCHAR2
76 ,p_expenditure_category_flag VARCHAR2
77 ,p_categorization_code VARCHAR2 --bug 3523294
78 ,x_resource_list_member_id OUT NOCOPY NUMBER
79 ,x_return_status OUT NOCOPY VARCHAR2
80 ,x_msg_data OUT NOCOPY VARCHAR2)
81 IS
82
83 BEGIN
84 NULL;
85 END get_resource_list_member_id_ss;
86 -----------------------------------------------------------------------------------------------
87
88 FUNCTION get_line_item_cost(p_line_item_id number) return number as
89 begin
90 RETURN NULL;
91 end get_line_item_cost;
92 -----------------------------------------------------------------------------------------------
93 FUNCTION get_eb_cost(p_line_item_id number) return number as
94 begin
95 RETURN NULL;
96 end get_eb_cost;
97 ----------------------------------------------------------------------------------------------
98 FUNCTION get_eb_cost_personnel(p_personnel_detail_id number) return number as
99 begin
100 RETURN NULL;
101 end get_eb_cost_personnel;
102 -----------------------------------------------------------------------------------------
103 FUNCTION get_oh_cost(p_line_item_id number) return number as
104 begin
105 RETURN NULL;
106 end get_oh_cost;
107
108 -----------------------------------------------------------------------------------------
109 /* _ss functions return unrounded figures */
110 FUNCTION get_eb_cost_ss(p_line_item_id number) return number as
111 begin
112 RETURN NULL;
113 end get_eb_cost_ss;
114 ----------------------------------------------------------------------------------------------
115 /* _ss functions return unrounded figures */
116 FUNCTION get_oh_cost_ss(p_line_item_id number) return number as
117 begin
118 RETURN NULL;
119 end get_oh_cost_ss;
120
121 -----------------------------------------------------------------------------------------
122
123
124 -- This procedure is to be called from Self-Service Applications. This validates
125 -- whether the expenditure type belongs to the resource list associated with the
126 -- project selected
127 FUNCTION valid_expenditure_type(p_project_id IN NUMBER
128 ,p_expenditure_type IN VARCHAR2
129 ,p_expenditure_category_flag IN VARCHAR2) return VARCHAR2 IS
130
131
132 BEGIN
133 return NULL;
134 END valid_expenditure_type;
135
136 ------------------------------------------------------------------------------------------------
137 -- The procedure below has been modified by Debashis to account for changes in structure to table igw_award_budgets
138 -- and the fact that we are only dealing with a single award during budget transfer (previously we were transfering
139 -- lines for multiple awards at the same time). Also we no longer have unmatched expenditure type and overhead type
140 -- defined in the setup. We transfer indirect cost in the same way as direct cost.
141
142 -- This procedure is to be called from Self-Service Applications
143 PROCEDURE create_award_budget( p_proposal_installment_id IN NUMBER
144 ,x_return_status OUT NOCOPY VARCHAR2
145 ,x_msg_count OUT NOCOPY NUMBER
146 ,x_msg_data OUT NOCOPY VARCHAR2) is
147
148
149
150 BEGIN
151 NULL;
152 END CREATE_AWARD_BUDGET;
153 -------------------------------------------------------------------------------------------------------
154
155 END IGW_BUDGET_INTEGRATION;