1 PACKAGE jtf_notes_cuhk AUTHID CURRENT_USER AS
2 /* $Header: jtfntscs.pls 115.10 2002/11/16 00:27:48 hbouten ship $ */
3
4 /*****************************************************************************************
5 This is the Customer User Hook API.
6 The Customers can add customization procedures here for Pre and Post Processing.
7 ******************************************************************************************/
8
9 /* Customer Procedure for pre processing in case of create note */
10
11 PROCEDURE create_note_pre
12 ( p_parent_note_id IN NUMBER DEFAULT NULL
13 , p_api_version IN NUMBER
14 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
15 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
16 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
17 , x_msg_count OUT NOCOPY NUMBER
18 , x_msg_data OUT NOCOPY VARCHAR2
19 , p_org_id IN NUMBER DEFAULT NULL
20 , p_source_object_id IN NUMBER
21 , p_source_object_code IN VARCHAR2
22 , p_notes IN VARCHAR2
23 , p_notes_detail IN VARCHAR2 DEFAULT NULL
24 , p_note_status IN VARCHAR2 DEFAULT 'I'
25 , p_entered_by IN NUMBER
26 , p_entered_date IN DATE
27 , x_jtf_note_id OUT NOCOPY NUMBER
28 , p_last_update_date IN DATE
29 , p_last_updated_by IN NUMBER
30 , p_creation_date IN DATE
31 , p_created_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID
32 , p_last_update_login IN NUMBER DEFAULT FND_GLOBAL.LOGIN_ID
33 , p_attribute1 IN VARCHAR2 DEFAULT NULL
34 , p_attribute2 IN VARCHAR2 DEFAULT NULL
35 , p_attribute3 IN VARCHAR2 DEFAULT NULL
36 , p_attribute4 IN VARCHAR2 DEFAULT NULL
37 , p_attribute5 IN VARCHAR2 DEFAULT NULL
38 , p_attribute6 IN VARCHAR2 DEFAULT NULL
39 , p_attribute7 IN VARCHAR2 DEFAULT NULL
40 , p_attribute8 IN VARCHAR2 DEFAULT NULL
41 , p_attribute9 IN VARCHAR2 DEFAULT NULL
42 , p_attribute10 IN VARCHAR2 DEFAULT NULL
43 , p_attribute11 IN VARCHAR2 DEFAULT NULL
44 , p_attribute12 IN VARCHAR2 DEFAULT NULL
45 , p_attribute13 IN VARCHAR2 DEFAULT NULL
46 , p_attribute14 IN VARCHAR2 DEFAULT NULL
47 , p_attribute15 IN VARCHAR2 DEFAULT NULL
48 , p_context IN VARCHAR2 DEFAULT NULL
49 , p_note_type IN VARCHAR2 DEFAULT NULL
50 , p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
51 DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt
52 , x_return_status OUT NOCOPY VARCHAR2
53 );
54
55
56 /* Customer Procedure for post processing in case of
57 create note */
58
59 PROCEDURE create_note_post
60 ( p_parent_note_id IN NUMBER DEFAULT NULL
61 , p_api_version IN NUMBER
62 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
63 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
64 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
65 , x_msg_count OUT NOCOPY NUMBER
66 , x_msg_data OUT NOCOPY VARCHAR2
67 , p_org_id IN NUMBER DEFAULT NULL
68 , p_source_object_id IN NUMBER
69 , p_source_object_code IN VARCHAR2
70 , p_notes IN VARCHAR2
71 , p_notes_detail IN VARCHAR2 DEFAULT NULL
72 , p_note_status IN VARCHAR2 DEFAULT 'I'
73 , p_entered_by IN NUMBER
74 , p_entered_date IN DATE
75 , x_jtf_note_id OUT NOCOPY NUMBER
76 , p_last_update_date IN DATE
77 , p_last_updated_by IN NUMBER
78 , p_creation_date IN DATE
79 , p_created_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID
80 , p_last_update_login IN NUMBER DEFAULT FND_GLOBAL.LOGIN_ID
81 , p_attribute1 IN VARCHAR2 DEFAULT NULL
82 , p_attribute2 IN VARCHAR2 DEFAULT NULL
83 , p_attribute3 IN VARCHAR2 DEFAULT NULL
84 , p_attribute4 IN VARCHAR2 DEFAULT NULL
85 , p_attribute5 IN VARCHAR2 DEFAULT NULL
86 , p_attribute6 IN VARCHAR2 DEFAULT NULL
87 , p_attribute7 IN VARCHAR2 DEFAULT NULL
88 , p_attribute8 IN VARCHAR2 DEFAULT NULL
89 , p_attribute9 IN VARCHAR2 DEFAULT NULL
90 , p_attribute10 IN VARCHAR2 DEFAULT NULL
91 , p_attribute11 IN VARCHAR2 DEFAULT NULL
92 , p_attribute12 IN VARCHAR2 DEFAULT NULL
93 , p_attribute13 IN VARCHAR2 DEFAULT NULL
94 , p_attribute14 IN VARCHAR2 DEFAULT NULL
95 , p_attribute15 IN VARCHAR2 DEFAULT NULL
96 , p_context IN VARCHAR2 DEFAULT NULL
97 , p_note_type IN VARCHAR2 DEFAULT NULL
98 , p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
99 DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt
100 , x_return_status OUT NOCOPY VARCHAR2
101 , p_jtf_note_id IN NUMBER DEFAULT NULL
102 );
103
104
105 /* Customer Procedure for pre processing in case of
106 update note */
107
108 PROCEDURE update_note_pre
109 ( p_api_version IN NUMBER
110 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
111 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
112 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
113 , x_msg_count OUT NOCOPY NUMBER
114 , x_msg_data OUT NOCOPY VARCHAR2
115 , p_jtf_note_id IN NUMBER
116 , p_entered_by IN NUMBER
117 , p_last_updated_by IN NUMBER
118 , p_last_update_date IN DATE DEFAULT SYSDATE
119 , p_last_update_login IN NUMBER DEFAULT NULL
120 , p_notes IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
121 , p_notes_detail IN VARCHAR2 DEFAULT NULL
122 , p_append_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
123 , p_note_status IN VARCHAR2 DEFAULT 'I'
124 , p_note_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
125 , p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
126 DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt
127 , x_return_status OUT NOCOPY VARCHAR2
128 );
129
130
131 /* Customer Procedure for post processing in case of
132 update note */
133
134 PROCEDURE update_note_post
135 ( p_api_version IN NUMBER
136 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
137 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
138 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
139 , x_msg_count OUT NOCOPY NUMBER
140 , x_msg_data OUT NOCOPY VARCHAR2
141 , p_jtf_note_id IN NUMBER
142 , p_entered_by IN NUMBER
143 , p_last_updated_by IN NUMBER
144 , p_last_update_date IN DATE DEFAULT SYSDATE
145 , p_last_update_login IN NUMBER DEFAULT NULL
146 , p_notes IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
147 , p_notes_detail IN VARCHAR2 DEFAULT NULL
148 , p_append_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
149 , p_note_status IN VARCHAR2 DEFAULT 'I'
150 , p_note_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
151 , p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
152 DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt
153 , x_return_status OUT NOCOPY VARCHAR2
154 );
155
156 FUNCTION Ok_to_generate_msg
157 ( p_parent_note_id IN NUMBER DEFAULT NULL
158 , p_api_version IN NUMBER
159 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
160 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
161 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
162 , x_msg_count OUT NOCOPY NUMBER
163 , x_msg_data OUT NOCOPY VARCHAR2
164 , p_org_id IN NUMBER DEFAULT NULL
165 , p_source_object_id IN NUMBER
166 , p_source_object_code IN VARCHAR2
167 , p_notes IN VARCHAR2
168 , p_notes_detail IN VARCHAR2 DEFAULT NULL
169 , p_note_status IN VARCHAR2 DEFAULT 'I'
170 , p_entered_by IN NUMBER
171 , p_entered_date IN DATE
172 , x_jtf_note_id OUT NOCOPY NUMBER
173 , p_last_update_date IN DATE
174 , p_last_updated_by IN NUMBER
175 , p_creation_date IN DATE
176 , p_created_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID
177 , p_last_update_login IN NUMBER DEFAULT FND_GLOBAL.LOGIN_ID
178 , p_attribute1 IN VARCHAR2 DEFAULT NULL
179 , p_attribute2 IN VARCHAR2 DEFAULT NULL
180 , p_attribute3 IN VARCHAR2 DEFAULT NULL
181 , p_attribute4 IN VARCHAR2 DEFAULT NULL
182 , p_attribute5 IN VARCHAR2 DEFAULT NULL
183 , p_attribute6 IN VARCHAR2 DEFAULT NULL
184 , p_attribute7 IN VARCHAR2 DEFAULT NULL
185 , p_attribute8 IN VARCHAR2 DEFAULT NULL
186 , p_attribute9 IN VARCHAR2 DEFAULT NULL
187 , p_attribute10 IN VARCHAR2 DEFAULT NULL
188 , p_attribute11 IN VARCHAR2 DEFAULT NULL
189 , p_attribute12 IN VARCHAR2 DEFAULT NULL
190 , p_attribute13 IN VARCHAR2 DEFAULT NULL
191 , p_attribute14 IN VARCHAR2 DEFAULT NULL
192 , p_attribute15 IN VARCHAR2 DEFAULT NULL
193 , p_context IN VARCHAR2 DEFAULT NULL
194 , p_note_type IN VARCHAR2 DEFAULT NULL
195 , p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
196 DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt
197 ) RETURN BOOLEAN;
198
199
200 --
201 -- The following versions are maintained for backward compatibility purposes only
202 -- please use the above for new development
203 --
204
205 -- DO NOT USE THIS VERSION OF CREATE_NOTE_POST
206 PROCEDURE create_note_post(
207 p_parent_note_id IN NUMBER DEFAULT NULL,
208 p_api_version IN NUMBER ,
209 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
210 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
211 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
212 x_msg_count OUT NOCOPY NUMBER ,
213 x_msg_data OUT NOCOPY VARCHAR2 ,
214 p_org_id IN NUMBER DEFAULT NULL,
215 p_source_object_id IN NUMBER ,
216 p_source_object_code IN VARCHAR2 ,
217 p_notes IN VARCHAR2 ,
218 p_notes_detail IN VARCHAR2 DEFAULT NULL,
219 p_note_status IN VARCHAR2 DEFAULT 'I',
220 p_entered_by IN NUMBER ,
221 p_entered_date IN DATE ,
222 x_jtf_note_id OUT NOCOPY NUMBER ,
223 p_last_update_date IN DATE ,
224 p_last_updated_by IN NUMBER ,
225 p_creation_date IN DATE ,
226 p_created_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID,
227 p_last_update_login IN NUMBER DEFAULT FND_GLOBAL.LOGIN_ID,
228 p_attribute1 IN VARCHAR2 DEFAULT NULL,
229 p_attribute2 IN VARCHAR2 DEFAULT NULL,
230 p_attribute3 IN VARCHAR2 DEFAULT NULL,
231 p_attribute4 IN VARCHAR2 DEFAULT NULL,
232 p_attribute5 IN VARCHAR2 DEFAULT NULL,
233 p_attribute6 IN VARCHAR2 DEFAULT NULL,
234 p_attribute7 IN VARCHAR2 DEFAULT NULL,
235 p_attribute8 IN VARCHAR2 DEFAULT NULL,
236 p_attribute9 IN VARCHAR2 DEFAULT NULL,
237 p_attribute10 IN VARCHAR2 DEFAULT NULL,
238 p_attribute11 IN VARCHAR2 DEFAULT NULL,
239 p_attribute12 IN VARCHAR2 DEFAULT NULL,
240 p_attribute13 IN VARCHAR2 DEFAULT NULL,
241 p_attribute14 IN VARCHAR2 DEFAULT NULL,
242 p_attribute15 IN VARCHAR2 DEFAULT NULL,
243 p_context IN VARCHAR2 DEFAULT NULL,
244 p_note_type IN VARCHAR2 DEFAULT NULL,
245 p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt,
246 x_return_status OUT NOCOPY VARCHAR2
247 );
248
249 -- DO NOT USE THIS VERSION OF OK_TO_GENERATE_MSG
250 FUNCTION Ok_to_generate_msg
251 ( p_api_version IN NUMBER,
252 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
253 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
254 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
255 x_msg_count OUT NOCOPY NUMBER,
256 x_msg_data OUT NOCOPY VARCHAR2,
257 p_jtf_note_id IN NUMBER,
258 p_entered_by IN NUMBER ,
259 p_last_updated_by IN NUMBER,
260 p_last_update_date IN DATE DEFAULT Sysdate,
261 p_last_update_login IN NUMBER DEFAULT NULL,
262 p_notes IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
263 p_notes_detail IN VARCHAR2 DEFAULT NULL,
264 p_append_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
265 p_note_status IN VARCHAR2 DEFAULT 'I',
266 p_note_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
267 p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
268 DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt ,
269 x_return_status OUT NOCOPY VARCHAR2
270 ) RETURN BOOLEAN;
271 END jtf_notes_cuhk;