1 PACKAGE PSB_Submit_Worksheet_PVT AS
2 /* $Header: PSBWSSPS.pls 120.2 2005/07/13 11:38:06 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_review_group_flag IN VARCHAR2 := 'N' ,
19 p_orig_system IN VARCHAR2 ,
20 p_merge_to_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
21 p_comments IN VARCHAR2 ,
22 p_operation_id IN NUMBER ,
23 p_constraint_set_id IN NUMBER
24 );
25
26
27 PROCEDURE Populate_Worksheet
28 (
29 itemtype IN VARCHAR2 ,
30 itemkey IN VARCHAR2 ,
31 actid IN NUMBER ,
32 funcmode IN VARCHAR2 ,
33 result OUT NOCOPY VARCHAR2
34 );
35
36
37 PROCEDURE Enforce_Concurrency_Check
38 (
39 itemtype IN VARCHAR2 ,
40 itemkey IN VARCHAR2 ,
41 actid IN NUMBER ,
42 funcmode IN VARCHAR2 ,
43 result OUT NOCOPY VARCHAR2
44 );
45
46
47 PROCEDURE Perform_Validation
48 (
49 itemtype IN VARCHAR2 ,
50 itemkey IN VARCHAR2 ,
51 actid IN NUMBER ,
52 funcmode IN VARCHAR2 ,
53 result OUT NOCOPY VARCHAR2
54 );
55
56
57 PROCEDURE Validate_Constraints
58 (
59 itemtype IN VARCHAR2 ,
60 itemkey IN VARCHAR2 ,
61 actid IN NUMBER ,
62 funcmode IN VARCHAR2 ,
63 result OUT NOCOPY VARCHAR2
64 );
65
66
67 PROCEDURE Select_Operation
68 (
69 itemtype IN VARCHAR2 ,
70 itemkey IN VARCHAR2 ,
71 actid IN NUMBER ,
72 funcmode IN VARCHAR2 ,
73 result OUT NOCOPY VARCHAR2
74 );
75
76
77 PROCEDURE Copy_Worksheet
78 (
79 itemtype IN VARCHAR2 ,
80 itemkey IN VARCHAR2 ,
81 actid IN NUMBER ,
82 funcmode IN VARCHAR2 ,
83 result OUT NOCOPY VARCHAR2
84 );
85
86
87 PROCEDURE Merge_Worksheets
88 (
89 itemtype IN VARCHAR2 ,
90 itemkey IN VARCHAR2 ,
91 actid IN NUMBER ,
92 funcmode IN VARCHAR2 ,
93 result OUT NOCOPY VARCHAR2
94 );
95
96
97 PROCEDURE Freeze_Worksheets
98 (
99 itemtype IN VARCHAR2 ,
100 itemkey IN VARCHAR2 ,
101 actid IN NUMBER ,
102 funcmode IN VARCHAR2 ,
103 result OUT NOCOPY VARCHAR2
104 );
105
106
107 PROCEDURE Update_View_Line_Flag
108 (
109 itemtype IN VARCHAR2 ,
110 itemkey IN VARCHAR2 ,
111 actid IN NUMBER ,
112 funcmode IN VARCHAR2 ,
113 result OUT NOCOPY VARCHAR2
114 );
115
116
117 PROCEDURE Change_Worksheet_Stage
118 (
119 itemtype IN VARCHAR2 ,
120 itemkey IN VARCHAR2 ,
121 actid IN NUMBER ,
122 funcmode IN VARCHAR2 ,
123 result OUT NOCOPY VARCHAR2
124 );
125
126
127 PROCEDURE Perform_Review_Group_Approval
128 (
129 itemtype IN VARCHAR2 ,
130 itemkey IN VARCHAR2 ,
131 actid IN NUMBER ,
132 funcmode IN VARCHAR2 ,
133 result OUT NOCOPY VARCHAR2
134 );
135
136
137 PROCEDURE Select_Approvers
138 (
139 itemtype IN VARCHAR2 ,
140 itemkey IN VARCHAR2 ,
141 actid IN NUMBER ,
142 funcmode IN VARCHAR2 ,
143 result OUT NOCOPY VARCHAR2
144 );
145
146
147 PROCEDURE Set_Loop_Limit
148 (
149 itemtype IN VARCHAR2 ,
150 itemkey IN VARCHAR2 ,
151 actid IN NUMBER ,
152 funcmode IN VARCHAR2 ,
153 result OUT NOCOPY VARCHAR2
154 );
155
156
157 PROCEDURE Create_Review_Group_Worksheet
158 (
159 itemtype IN VARCHAR2 ,
160 itemkey IN VARCHAR2 ,
161 actid IN NUMBER ,
162 funcmode IN VARCHAR2 ,
163 result OUT NOCOPY VARCHAR2
164 );
165
166
167 PROCEDURE New_Worksheet_Created
168 (
169 itemtype IN VARCHAR2 ,
170 itemkey IN VARCHAR2 ,
171 actid IN NUMBER ,
172 funcmode IN VARCHAR2 ,
173 result OUT NOCOPY VARCHAR2
174 );
175
176
177 PROCEDURE Find_Approval_Option
178 (
179 itemtype IN VARCHAR2 ,
180 itemkey IN VARCHAR2 ,
181 actid IN NUMBER ,
182 funcmode IN VARCHAR2 ,
183 result OUT NOCOPY VARCHAR2
184 );
185
186
187 PROCEDURE Unfreeze_Worksheets
188 (
189 itemtype IN VARCHAR2 ,
190 itemkey IN VARCHAR2 ,
191 actid IN NUMBER ,
192 funcmode IN VARCHAR2 ,
193 result OUT NOCOPY VARCHAR2
194 );
195
196
197 PROCEDURE Set_Reviewed_Flag
198 (
199 itemtype IN VARCHAR2 ,
200 itemkey IN VARCHAR2 ,
201 actid IN NUMBER ,
202 funcmode IN VARCHAR2 ,
203 result OUT NOCOPY VARCHAR2
204 );
205
206
207 PROCEDURE Send_Approval_Notification
208 (
209 itemtype IN VARCHAR2 ,
210 itemkey IN VARCHAR2 ,
211 actid IN NUMBER ,
212 funcmode IN VARCHAR2 ,
213 result OUT NOCOPY VARCHAR2
214 );
215
216
217 PROCEDURE Update_Worksheets_Status
218 (
219 itemtype IN VARCHAR2 ,
220 itemkey IN VARCHAR2 ,
221 actid IN NUMBER ,
222 funcmode IN VARCHAR2 ,
223 result OUT NOCOPY VARCHAR2
224 );
225
226
227 PROCEDURE Callback
228 (
229 command IN VARCHAR2,
230 context IN VARCHAR2,
231 attr_name IN VARCHAR2,
232 attr_type IN VARCHAR2,
233 text_value IN OUT NOCOPY VARCHAR2,
234 number_value IN OUT NOCOPY NUMBER,
235 date_value IN OUT NOCOPY DATE
236 );
237
238
239 PROCEDURE Check_Review_Groups
240 (
241 p_api_version IN NUMBER ,
242 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
243 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
244 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
245 p_return_status OUT NOCOPY VARCHAR2 ,
246 p_msg_count OUT NOCOPY NUMBER ,
247 p_msg_data OUT NOCOPY VARCHAR2 ,
248 --
249 p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
250 p_review_group_exists OUT NOCOPY VARCHAR2
251 );
252
253
254 END PSB_Submit_Worksheet_PVT ;