1 PACKAGE po_notifications_sv2 AUTHID CURRENT_USER AS
2 /* $Header: POXBWN2S.pls 115.1 2002/11/26 23:56:17 sbull ship $*/
3
4 /*===========================================================================
5 PROCEDURE NAME: insert_into_po_notif
6
7 DESCRIPTION: Called by the send_po_notif procedure
8 to insert notification into the po_notifications
9 table when a notification is inserted into the
10 fnd_notifications table.
11
12 PARAMETERS: x_employee_id IN NUMBER,
13 x_message_name IN VARCHAR2,
14 x_doc_type IN VARCHAR2,
15 x_object_id IN NUMBER,
16 x_doc_creation_date IN DATE,
17 x_start_effective_date IN DATE,
18 x_end_effective_date IN DATE
19
20 DESIGN REFERENCES:
21
22 ALGORITHM:
23
24 NOTES:
25
26 OPEN ISSUES:
27
28 CLOSED ISSUES:
29
30 CHANGE HISTORY: cmok 5/25 created
31 ===========================================================================*/
32
33 PROCEDURE insert_into_po_notif (x_employee_id IN NUMBER,
34 x_message_name IN VARCHAR2,
35 x_doc_type IN VARCHAR2,
36 x_object_id IN NUMBER,
37 x_doc_creation_date IN DATE,
38 x_start_effective_date IN DATE,
39 x_end_effective_date IN DATE);
40
41 /*===========================================================================
42 PROCEDURE NAME: update_fnd_notif
43
44 DESCRIPTION: Called by the database trigger to update
45 notification in fnd_notifications when one is
46 updated in po_notifications.
47
48 PARAMETERS: x_object_type_lookup_code IN VARCHAR2,
49 x_object_id IN NUMBER,
50 x_old_employee_id IN NUMBER,
51 x_new_employee_id IN NUMBER
52
53 DESIGN REFERENCES:
54
55 ALGORITHM:
56
57 NOTES:
58
59 OPEN ISSUES:
60
61 CLOSED ISSUES:
62
63 CHANGE HISTORY: cmok 5/25 created
64 ===========================================================================*/
65
66 PROCEDURE update_fnd_notif (x_object_type_lookup_code IN VARCHAR2,
67 x_object_id IN NUMBER,
68 x_old_employee_id IN NUMBER,
69 x_new_employee_id IN NUMBER);
70
71 /*===========================================================================
72 PROCEDURE NAME: update_po_notif
73
74 DESCRIPTION: Forwards notification into the po_notifications
75 table when a notification is forwarded into the
76 fnd_notifications table.
77
78 PARAMETERS: x_new_employee_id IN NUMBER,
79 x_doc_type IN VARCHAR2,
80 x_object_id IN NUMBER
81
82 DESIGN REFERENCES:
83
84 ALGORITHM:
85
86 NOTES:
87
88 OPEN ISSUES:
89
90 CLOSED ISSUES:
91
92 CHANGE HISTORY: cmok 6/14 created
93 ===========================================================================*/
94
95 PROCEDURE update_po_notif (x_new_employee_id IN NUMBER,
96 x_doc_type IN VARCHAR2,
97 x_object_id IN NUMBER);
98
99 /*===========================================================================
100 PROCEDURE NAME: delete_from_po_notif
101
102 DESCRIPTION: Deletes notification from the po_notifications
103 table when a notification is deleted from the
104 fnd_notifications table.
105
106 PARAMETERS: x_new_employee_id NUMBER,
107 x_old_employe_id NUMBER,
108 x_doc_type VARCHAR2,
109 x_object_id NUMBER
110
111 DESIGN REFERENCES:
112
113 ALGORITHM:
114
115 NOTES:
116
117 OPEN ISSUES:
118
119 CLOSED ISSUES:
120
121 CHANGE HISTORY: cmok 6/14 created
122 ===========================================================================*/
123
124 PROCEDURE delete_from_po_notif (x_doc_type IN VARCHAR2,
125 x_object_id IN NUMBER);
126
127 /*===========================================================================
128 PROCEDURE NAME: get_doc_type_subtype
129
130 DESCRIPTION: Determines the document type and subtype given the
131 document type lookup code used by fnd_notifications.
132
133 PARAMETERS: x_notif_doc_type IN VARCHAR2,
134 x_type OUT VARCHAR2,
135 x_subtype OUT VARCHAR2
136
137 DESIGN REFERENCES:
138
139 ALGORITHM:
140
141 NOTES:
142
143 OPEN ISSUES:
144
145 CLOSED ISSUES:
146
147 CHANGE HISTORY: cmok 6/15 created
148 ===========================================================================*/
149
150 PROCEDURE get_doc_type_subtype (x_notif_doc_type IN VARCHAR2,
151 x_type OUT NOCOPY VARCHAR2,
152 x_subtype OUT NOCOPY VARCHAR2);
153
154 /*===========================================================================
155 PROCEDURE NAME: get_fnd_doc_type
156
157 DESCRIPTION: Determines the document type lookup code used by the
158 fnd_notifications table given the document type lookup
159 code used by the po_notifications table.
160
161 PARAMETERS: x_po_type_code IN VARCHAR2,
162 x_object_id IN NUMBER,
163 x_fnd_type_code IN OUT VARCHAR2
164
165 DESIGN REFERENCES:
166
167 ALGORITHM:
168
169 NOTES:
170
171 OPEN ISSUES:
172
173 CLOSED ISSUES:
174
175 CHANGE HISTORY: cmok 5/25 created
176 ===========================================================================*/
177
178 PROCEDURE get_fnd_doc_type (x_po_type_code IN VARCHAR2,
179 x_object_id IN NUMBER,
180 x_fnd_type_code IN OUT NOCOPY VARCHAR2);
181
182 /*===========================================================================
183 PROCEDURE NAME: get_fnd_message_name
184
185 DESCRIPTION: Determines the message name used by the fnd_notifications
186 table given the message name used by the po_notifications
187 table.
188
189 PARAMETERS: x_old_message_name IN VARCHAR2,
190 x_new_message_name IN OUT VARCHAR2
191
192 DESIGN REFERENCES:
193
194 ALGORITHM:
195
196 NOTES:
197
198 OPEN ISSUES:
199
200 CLOSED ISSUES:
201
202 CHANGE HISTORY: cmok 5/25 created
203 ===========================================================================*/
204
205 PROCEDURE get_fnd_msg_name (x_old_message_name IN VARCHAR2,
206 x_new_message_name IN OUT NOCOPY VARCHAR2);
207
208 /*===========================================================================
209 PROCEDURE NAME: insert_into_fnd_notif
210
211 DESCRIPTION: Inserts a notification into fnd_notifications.
212 This procedure is called by the database trigger to insert
213 a notification into fnd_notifications whenever one is
214 inserted into po_notifications. It is also called by the
215 procedure install_fnd_notif to copy notifications from
216 the po_notifications table to the fnd_notifications table.
217
218 PARAMETERS: n_object_type_lookup_code IN VARCHAR2,
219 n_object_id IN NUMBER,
220 n_employee_id IN NUMBER,
221 n_start_date_active IN DATE,
222 n_end_date_active IN DATE,
223 n_notification_id OUT NUMBER
224
225 DESIGN REFERENCES:
226
227 ALGORITHM:
228
229 NOTES:
230
231 OPEN ISSUES:
232
233 CLOSED ISSUES:
234
235 CHANGE HISTORY: cmok 5/25 created
236 ===========================================================================*/
237
238 PROCEDURE insert_into_fnd_notif(n_object_type_lookup_code IN VARCHAR2,
239 n_object_id IN NUMBER,
240 n_employee_id IN NUMBER,
241 n_start_date_active IN DATE,
242 n_end_date_active IN DATE,
243 n_notification_id OUT NOCOPY NUMBER);
244
245 /*===========================================================================
246 PROCEDURE NAME: Install_fnd_notif
247
248 DESCRIPTION: Copies all notifications from the po_notifications
249 table into the fnd_notifications table.
250
251 PARAMETERS:
252
253 DESIGN REFERENCES:
254
255 ALGORITHM:
256
257 NOTES:
258
259 OPEN ISSUES:
260
261 CLOSED ISSUES:
262
263 CHANGE HISTORY: cmok 5/25 created
264 ===========================================================================*/
265
266 PROCEDURE install_fnd_notif;
267
268 END;