1 PACKAGE po_notifications_sv1 AUTHID CURRENT_USER AS
2 /* $Header: POXBWN1S.pls 115.1 2002/11/25 23:08:49 sbull ship $*/
3
4 /*===========================================================================
5 PROCEDURE NAME: delete_po_notif
6
7 DESCRIPTION: - This procedure is called by the following forms:
8 - Enter POs
9 - Enter PAs
10 - Enter Releases
11 - Enter REQs
12 - Enter Quotes
13 - Enter RFQs
14 - Enter Acceptances
15 - Control Documents
16
17 - It is called when:
18 - Document is deleted
19 - Acceptance is entered
20 - Document is finally closed or cancelled
21
22 - It deletes all notifications for a given document.
23 For document of type BLANKET, it deletes all
24 notifications for releases against the blanket
25
26 The document types are:
27 - STANDARD
28 - PLANNED
29 - INTERNAL
30 - PURCHASE
31 - BLANKET
32 - CONTRACT
33 - RELEASE
34 - SCHEDULED
35 - QUOTATION
36 - RFQ
37
38 PARAMETERS: x_document_type_code IN VARCHAR2,
39 x_object_id IN NUMBER
40
41 DESIGN REFERENCES:
42
43 ALGORITHM:
44
45 NOTES:
46
47 OPEN ISSUES:
48
49 CLOSED ISSUES:
50
51 CHANGE HISTORY: cmok 5/25 created
52 ===========================================================================*/
53
54 PROCEDURE delete_po_notif (x_document_type_code IN VARCHAR2,
55 x_object_id IN NUMBER);
56
57 /*===========================================================================
58 PROCEDURE NAME: delete_notif_by_id_type
59
60 DESCRIPTION: Deletes all notifications for a document given the
61 document type and id.
62
63 PARAMETERS: x_object_id NUMBER,
64 x_doc_type VARCHAR
65
66 DESIGN REFERENCES:
67
68 ALGORITHM:
69
70 NOTES:
71
72 OPEN ISSUES:
73
74 CLOSED ISSUES:
75
76 CHANGE HISTORY: cmok 5/25 created
77 ===========================================================================*/
78
79 PROCEDURE delete_notif_by_id_type(x_object_id NUMBER,
80 x_doc_type VARCHAR2);
81
82 /*===========================================================================
83 PROCEDURE NAME: send_po_notif
84
85 DESCRIPTION: - This procedure is called by the following forms:
86 - Enter POs
87 - Enter PAs
88 - Enter Releases
89 - Enter Requisitions
90 - Enter Express Requsitions
91 - Enter Quotes
92 - Enter RFQs
93 - Control Documents
94
95 - It is called when:
96 - Document is inserted
97 - Document is updated
98 - Document is put on hold
99 - Document is released from hold
100
101 - It deletes the notification for a given document
102 and inserts a new notification with updated information.
103 For documents of type BLANKET, it deletes and reinserts
104 notifications for all releases against the blanket.
105 The document types are:
106 - STANDARD
107 - PLANNED
108 - INTERNAL
109 - PURCHASE
110 - BLANKET
111 - CONTRACT
112 - RELEASE
113 - SCHEDULED
114 - QUOTATION
115 - RFQ
116
117 PARAMETERS: x_document_type_code IN VARCHAR2,
118 x_object_id IN NUMBER,
119 x_currency_code IN VARCHAR2,
120 x_start_date_active IN DATE DEFAULT NULL,
121 x_end_date_active IN DATE DEFAULT NULL,
122 x_forward_to_id IN NUMBER DEFAULT NULL,
123 x_forward_from_id IN NUMBER DEFAULT NULL,
124 x_note IN VARCHAR2 DEFAULT NULL
125
126 DESIGN REFERENCES:
127
128 ALGORITHM:
129
130 NOTES:
131
132 OPEN ISSUES:
133
134 CLOSED ISSUES:
135
136 CHANGE HISTORY: cmok 5/25 created
137 ===========================================================================*/
138
139 PROCEDURE send_po_notif(x_document_type_code IN VARCHAR2,
140 x_object_id IN NUMBER,
141 x_currency_code IN VARCHAR2 DEFAULT NULL,
142 x_start_date_active IN DATE DEFAULT NULL,
143 x_end_date_active IN DATE DEFAULT NULL,
144 x_forward_to_id IN NUMBER DEFAULT NULL,
145 x_forward_from_id IN NUMBER DEFAULT NULL,
146 x_note IN VARCHAR2 DEFAULT NULL);
147
148 /*===========================================================================
149 PROCEDURE NAME: get_notif_data
150
151 DESCRIPTION: Retrieves the following information required for
152 inserting a notification into the fnd_notifications
153 table:
154 - start effective date
155 - recipient id
156 - message name
157 - document number
158 - document description
159 - release number if document type is RELEASE
160 - currency code
161 - document total
162 - sender id
163 - note from approver
164 - document owner id
165 - document creation date
166 - acceptance due date if acceptance is required
167 - expiration date if document type is QUOTATION
168 - close date if document type is RFQ
169
170 PARAMETERS: x_document_type_code IN VARCHAR2,
171 x_object_id IN NUMBER,
172 x_end_date_active IN DATE,
173 x_start_date_active IN OUT DATE,
174 x_employee_id IN OUT NUMBER,
175 x_message_name IN OUT VARCHAR2,
176 x_doc_num IN OUT VARCHAR2,
177 x_doc_creation_date IN OUT DATE,
178 x_currency_code IN OUT VARCHAR2,
179 x_from_id IN OUT VARCHAR2,
180 x_note IN OUT VARCHAR2,
181 x_expiration_date IN OUT DATE,
182 x_close_date IN OUT DATE,
183 x_acceptance_due_date IN OUT DATE,
184 x_attribute_array IN OUT ntn.char_array
185
186 DESIGN REFERENCES:
187
188 ALGORITHM:
189
190 NOTES:
191
192 OPEN ISSUES:
193
194 CLOSED ISSUES:
195
196 CHANGE HISTORY: cmok 5/25 created
197 ===========================================================================*/
198
199 PROCEDURE get_notif_data (x_document_type_code IN VARCHAR2,
200 x_object_id IN NUMBER,
201 x_end_date_active IN DATE,
202 x_start_date_active IN OUT NOCOPY DATE,
203 x_employee_id IN OUT NOCOPY NUMBER,
204 x_message_name IN OUT NOCOPY VARCHAR2,
205 x_doc_num IN OUT NOCOPY VARCHAR2,
206 x_doc_creation_date IN OUT NOCOPY DATE,
207 x_currency_code IN OUT NOCOPY VARCHAR2,
208 x_from_id IN OUT NOCOPY NUMBER,
209 x_note IN OUT NOCOPY VARCHAR2,
210 x_expiration_date IN OUT NOCOPY DATE,
211 x_close_date IN OUT NOCOPY DATE,
212 x_acceptance_due_date IN OUT NOCOPY DATE);
213
214 END;