[Home] [Help]
PACKAGE: APPS.PQH_APPLY_BUDGET
Source
1 Package PQH_APPLY_BUDGET AUTHID CURRENT_USER AS
2 /* $Header: pqappbdg.pkh 115.18 2002/11/27 04:03:38 rpasapul ship $ */
3 --
4
5 PROCEDURE apply_budget
6 (
7 p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE,
8 p_budget_version_id OUT NOCOPY pqh_budget_versions.budget_version_id%TYPE
9 );
10
11 PROCEDURE apply_new_budget
12 (
13 p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE,
14 p_mode IN varchar2
15 );
16
17 PROCEDURE edit_create_new_budget
18 (
19 p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE
20 );
21
22 PROCEDURE edit_update_budget
23 (
24 p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE
25 );
26
27 PROCEDURE carry_forward_budget
28 (
29 p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE,
30 p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE
31 );
32
33 PROCEDURE populate_budget_versions
34 (
35 p_worksheets_rec IN pqh_worksheets%ROWTYPE,
36 p_budget_id IN pqh_budgets.budget_id%TYPE,
37 p_worksheet_mode_cd IN pqh_worksheets.worksheet_mode_cd%TYPE,
38 p_budget_version_id_o OUT NOCOPY pqh_budget_versions.budget_version_id%TYPE
39 );
40
41 PROCEDURE populate_budget_details
42 (
43 p_worksheet_details_rec IN pqh_worksheet_details%ROWTYPE,
44 p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
45 p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE,
46 p_worksheet_mode_cd IN pqh_worksheets.worksheet_mode_cd%TYPE,
47 p_budget_detail_id_o OUT NOCOPY pqh_budget_details.budget_detail_id%TYPE
48 );
49
50 PROCEDURE populate_budget_periods
51 (
52 p_worksheet_periods_rec IN pqh_worksheet_periods%ROWTYPE,
53 p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
54 p_budget_period_id_o OUT NOCOPY pqh_budget_periods.budget_period_id%TYPE
55 );
56
57 PROCEDURE populate_budget_sets
58 (
59 p_worksheet_budget_sets_rec IN pqh_worksheet_budget_sets%ROWTYPE,
60 p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
61 p_budget_set_id_o OUT NOCOPY pqh_budget_sets.budget_set_id%TYPE
62 );
63
64 PROCEDURE populate_budget_elements
65 (
66 p_worksheet_bdgt_elmnts_rec IN pqh_worksheet_bdgt_elmnts%ROWTYPE,
67 p_budget_set_id IN pqh_budget_sets.budget_set_id%TYPE,
68 p_budget_element_id_o OUT NOCOPY pqh_budget_elements.budget_element_id%TYPE
69 );
70
71 PROCEDURE populate_budget_fund_srcs
72 (
73 p_worksheet_fund_srcs_rec IN pqh_worksheet_fund_srcs%ROWTYPE,
74 p_budget_element_id IN pqh_budget_elements.budget_element_id%TYPE,
75 p_budget_fund_src_id_o OUT NOCOPY pqh_budget_fund_srcs.budget_fund_src_id%TYPE
76 );
77
78 PROCEDURE carry_forward_budget_details
79 (
80 p_pqh_budget_details_rec IN pqh_budget_details%ROWTYPE,
81 p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
82 p_budget_detail_id_o OUT NOCOPY pqh_budget_details.budget_detail_id%TYPE
83 );
84
85 PROCEDURE carry_forward_budget_periods
86 (
87 p_pqh_budget_periods_rec IN pqh_budget_periods%ROWTYPE,
88 p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
89 p_budget_period_id_o OUT NOCOPY pqh_budget_periods.budget_period_id%TYPE
90 );
91
92 PROCEDURE carry_forward_budget_sets
93 (
94 p_pqh_budget_sets_rec IN pqh_budget_sets%ROWTYPE,
95 p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
96 p_budget_set_id_o OUT NOCOPY pqh_budget_sets.budget_set_id%TYPE
97 );
98
99 PROCEDURE carry_forward_budget_elements
100 (
101 p_pqh_budget_elements_rec IN pqh_budget_elements%ROWTYPE,
102 p_budget_set_id IN pqh_budget_sets.budget_set_id%TYPE,
103 p_budget_element_id_o OUT NOCOPY pqh_budget_elements.budget_element_id%TYPE
104 );
105
106 PROCEDURE carry_forward_budget_fund_srcs
107 (
108 p_pqh_budget_fund_srcs_rec IN pqh_budget_fund_srcs%ROWTYPE,
109 p_budget_element_id IN pqh_budget_elements.budget_element_id%TYPE,
110 p_budget_fund_src_id_o OUT NOCOPY pqh_budget_fund_srcs.budget_fund_src_id%TYPE
111 );
112
113 PROCEDURE delete_child_rows
114 (
115 p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE
116 );
117
118 PROCEDURE check_valid_mode
119 (
120 p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE
121 );
122
123
124 PROCEDURE populate_globals
125 (
126 p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE
127 );
128
129
130 PROCEDURE set_wks_log_context
131 (
132 p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE,
133 p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
134 );
135
136 PROCEDURE set_wpr_log_context
137 (
138 p_worksheet_period_id IN pqh_worksheet_periods.worksheet_period_id%TYPE,
139 p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
140 );
141
142 PROCEDURE set_wst_log_context
143 (
144 p_worksheet_budget_set_id IN pqh_worksheet_budget_sets.worksheet_budget_set_id%TYPE,
145 p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
146 );
147
148 PROCEDURE set_wel_log_context
149 (
150 p_worksheet_bdgt_elmnt_id IN pqh_worksheet_bdgt_elmnts.worksheet_bdgt_elmnt_id%TYPE,
151 p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
152 );
153
154 PROCEDURE set_wfs_log_context
155 (
156 p_worksheet_fund_src_id IN pqh_worksheet_fund_srcs.worksheet_fund_src_id%TYPE,
157 p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
158 );
159
160 -- made a function by sumit goyal to standardize
161
162 FUNCTION apply_transaction
163 (
164 p_transaction_id IN number,
165 p_validate_only IN varchar2
166 ) RETURN varchar2;
167
168
169 PROCEDURE comp_bgt_ver_unit_val
170 (
171 p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE
172 ) ;
173
174
175 PROCEDURE updt_budget_status
176 (
177 p_budget_id IN pqh_budgets.budget_id%TYPE
178 );
179
180 PROCEDURE updt_wks_status
181 (
182 p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE,
183 p_status IN pqh_worksheets.transaction_status%TYPE
184 );
185
186 FUNCTION get_txn_state
187 (
188 p_transaction_category_id IN number,
189 p_action_date IN date
190 ) RETURN VARCHAR2;
191
192 ---------------------------------------------------------
193 -- added as per Sir Hon' Lord Sumit Goyalji
194
195 PROCEDURE complete_all_del_workflow
196 (
197 p_worksheet_id in number,
198 p_transaction_category_id in number
199 );
200
201
202 FUNCTION chk_root_node
203 (
204 p_transaction_id number
205 ) RETURN VARCHAR2;
206
207
208 PROCEDURE delegate_approve
209 (
210 p_worksheet_detail_id in number
211 );
212
213
214 FUNCTION fyi_notification
215 (
216 p_transaction_id in number
217 ) RETURN varchar2 ;
218
219 FUNCTION reject_notification
220 (
221 p_transaction_id in number
222 ) RETURN varchar2 ;
223
224 FUNCTION back_notification
225 (
226 p_transaction_id in number
227 ) RETURN varchar2 ;
228
229 FUNCTION override_notification
230 (
231 p_transaction_id in number
232 ) RETURN varchar2 ;
233
234 FUNCTION apply_notification
235 (
236 p_transaction_id in number
237 ) RETURN varchar2 ;
238
239 FUNCTION warning_notification
240 (
241 p_transaction_id in number
242 ) RETURN varchar2 ;
243
244 FUNCTION respond_notification
245 (
246 p_transaction_id in number
247 ) RETURN varchar2 ;
248
249 -- end added
250
251 ---------------------------------------------------------
252
253 FUNCTION set_status
254 (
255 p_transaction_category_id IN pqh_transaction_categories.transaction_category_id%TYPE,
256 p_transaction_id IN pqh_worksheets.worksheet_id%TYPE,
257 p_status IN pqh_worksheets.transaction_status%TYPE
258 ) RETURN varchar2;
259
260 ---------------------------------------------------------
261
262
263 END; -- Package Specification PQH_APPLY_BUDGET