1 PACKAGE PSB_Submit_Revision_PVT AS
2 /* $Header: PSBVBRSS.pls 120.2 2005/07/13 11:23:33 shtripat ship $ */
3
4 PROCEDURE Start_Process
5 (
6 p_api_version IN NUMBER ,
7 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
8 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
9 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
10 p_return_status OUT NOCOPY VARCHAR2 ,
11 p_msg_count OUT NOCOPY NUMBER ,
12 p_msg_data OUT NOCOPY VARCHAR2 ,
13 --
14 p_item_key IN VARCHAR2 ,
15 p_submitter_id IN NUMBER ,
16 p_submitter_name IN VARCHAR2 ,
17 p_operation_type IN VARCHAR2 ,
18 p_orig_system IN VARCHAR2 ,
19 p_comments IN VARCHAR2 ,
20 p_operation_id IN NUMBER ,
21 p_constraint_set_id IN NUMBER
22 );
23
24
25 PROCEDURE Populate_Revision
26 (
27 itemtype IN VARCHAR2 ,
28 itemkey IN VARCHAR2 ,
29 actid IN NUMBER ,
30 funcmode IN VARCHAR2 ,
31 result OUT NOCOPY VARCHAR2
32 );
33
34
35 PROCEDURE Enforce_Concurrency_Check
36 (
37 itemtype IN VARCHAR2 ,
38 itemkey IN VARCHAR2 ,
39 actid IN NUMBER ,
40 funcmode IN VARCHAR2 ,
41 result OUT NOCOPY VARCHAR2
42 );
43
44
45 PROCEDURE Validate_Constraints
46 (
47 itemtype IN VARCHAR2 ,
48 itemkey IN VARCHAR2 ,
49 actid IN NUMBER ,
50 funcmode IN VARCHAR2 ,
51 result OUT NOCOPY VARCHAR2
52 );
53
54
55 PROCEDURE Select_Operation
56 (
57 itemtype IN VARCHAR2 ,
58 itemkey IN VARCHAR2 ,
59 actid IN NUMBER ,
60 funcmode IN VARCHAR2 ,
61 result OUT NOCOPY VARCHAR2
62 );
63
64
65 PROCEDURE Freeze_Revisions
66 (
67 itemtype IN VARCHAR2 ,
68 itemkey IN VARCHAR2 ,
69 actid IN NUMBER ,
70 funcmode IN VARCHAR2 ,
71 result OUT NOCOPY VARCHAR2
72 );
73
74
75 PROCEDURE Update_View_Line_Flag
76 (
77 itemtype IN VARCHAR2 ,
78 itemkey IN VARCHAR2 ,
79 actid IN NUMBER ,
80 funcmode IN VARCHAR2 ,
81 result OUT NOCOPY VARCHAR2
82 );
83
84
85 PROCEDURE Select_Approvers
86 (
87 itemtype IN VARCHAR2 ,
88 itemkey IN VARCHAR2 ,
89 actid IN NUMBER ,
90 funcmode IN VARCHAR2 ,
91 result OUT NOCOPY VARCHAR2
92 );
93
94
95 PROCEDURE Find_Override_Approver
96 (
97 itemtype IN VARCHAR2 ,
98 itemkey IN VARCHAR2 ,
99 actid IN NUMBER ,
100 funcmode IN VARCHAR2 ,
101 result OUT NOCOPY VARCHAR2
102 );
103
104
105 PROCEDURE Unfreeze_Revisions
106 (
107 itemtype IN VARCHAR2 ,
108 itemkey IN VARCHAR2 ,
109 actid IN NUMBER ,
110 funcmode IN VARCHAR2 ,
111 result OUT NOCOPY VARCHAR2
112 );
113
114
115 PROCEDURE Callback
116 (
117 command IN VARCHAR2,
118 context IN VARCHAR2,
119 attr_name IN VARCHAR2,
120 attr_type IN VARCHAR2,
121 text_value IN OUT NOCOPY VARCHAR2,
122 number_value IN OUT NOCOPY NUMBER,
123 date_value IN OUT NOCOPY DATE
124 );
125
126 PROCEDURE Set_Reviewed_Flag
127 (
128 itemtype IN VARCHAR2 ,
129 itemkey IN VARCHAR2 ,
130 actid IN NUMBER ,
131 funcmode IN VARCHAR2 ,
132 result OUT NOCOPY VARCHAR2
133 );
134
135 PROCEDURE Set_Approval_Status
136 (
137 itemtype IN VARCHAR2 ,
138 itemkey IN VARCHAR2 ,
139 actid IN NUMBER ,
140 funcmode IN VARCHAR2 ,
141 result OUT NOCOPY VARCHAR2
142 );
143
144 PROCEDURE Set_Rejection_Status
145 (
146 itemtype IN VARCHAR2 ,
147 itemkey IN VARCHAR2 ,
148 actid IN NUMBER ,
149 funcmode IN VARCHAR2 ,
150 result OUT NOCOPY VARCHAR2
151 );
152
153 PROCEDURE Send_Approval_Notification
154 (
155 itemtype IN VARCHAR2 ,
156 itemkey IN VARCHAR2 ,
157 actid IN NUMBER ,
158 funcmode IN VARCHAR2 ,
159 result OUT NOCOPY VARCHAR2
160 );
161
162
163 PROCEDURE Update_Revisions_Status
164 (
165 itemtype IN VARCHAR2 ,
166 itemkey IN VARCHAR2 ,
167 actid IN NUMBER ,
168 funcmode IN VARCHAR2 ,
169 result OUT NOCOPY VARCHAR2
170 );
171
172 PROCEDURE Post_Revisions_To_GL
173 (
174 itemtype IN VARCHAR2 ,
175 itemkey IN VARCHAR2 ,
176 actid IN NUMBER ,
177 funcmode IN VARCHAR2 ,
178 result OUT NOCOPY VARCHAR2
179 );
180
181 PROCEDURE Update_Baseline_Values
182 (
183 itemtype IN VARCHAR2,
184 itemkey IN VARCHAR2,
185 actid IN NUMBER,
186 funcmode IN VARCHAR2,
187 result OUT NOCOPY VARCHAR2
188 );
189
190
191 PROCEDURE Funds_Reservation_Update
192 (
193 itemtype IN VARCHAR2,
194 itemkey IN VARCHAR2,
195 actid IN NUMBER,
196 funcmode IN VARCHAR2,
197 result OUT NOCOPY VARCHAR2
198 );
199
200 PROCEDURE Start_Distribution_Process
201 (
202 p_api_version IN NUMBER ,
203 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
204 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
205 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
206 p_return_status OUT NOCOPY VARCHAR2 ,
207 p_msg_count OUT NOCOPY NUMBER ,
208 p_msg_data OUT NOCOPY VARCHAR2 ,
209 --
210 p_item_key IN NUMBER ,
211 p_distribution_instructions IN VARCHAR2 ,
212 p_recipient_name IN VARCHAR2
213 );
214
215
216 PROCEDURE Populate_Distribute_Revision
217 (
218 itemtype IN VARCHAR2,
219 itemkey IN VARCHAR2,
220 actid IN NUMBER,
221 funcmode IN VARCHAR2,
222 result OUT NOCOPY VARCHAR2
223 );
224
225 PROCEDURE Set_Loop_Limit
226 (
227 itemtype IN VARCHAR2,
228 itemkey IN VARCHAR2,
229 actid IN NUMBER,
230 funcmode IN VARCHAR2,
231 result OUT NOCOPY VARCHAR2
232 );
233
234 PROCEDURE Find_Approver
235 (
236 itemtype IN VARCHAR2,
237 itemkey IN VARCHAR2,
238 actid IN NUMBER,
239 funcmode IN VARCHAR2,
240 result OUT NOCOPY VARCHAR2
241 );
242
243 PROCEDURE Find_Requestor
244 (
245 itemtype IN VARCHAR2,
246 itemkey IN VARCHAR2,
247 actid IN NUMBER,
248 funcmode IN VARCHAR2,
249 result OUT NOCOPY VARCHAR2
250 );
251
252 /* Budget Revison Rules Enhancement Start */
253
254 PROCEDURE Validate_Revision_Rules
255 (
256 itemtype IN VARCHAR2,
257 itemkey IN VARCHAR2,
258 actid IN NUMBER,
259 funcmode IN VARCHAR2,
260 result OUT NOCOPY VARCHAR2
261 );
262
263 /* Budget Revison Rules Enhancement End */
264
265 END PSB_Submit_Revision_PVT;