1 PACKAGE CLN_SYNC_ITEM_PKG AUTHID CURRENT_USER AS
2 /* $Header: CLNSYNIS.pls 120.0 2005/05/24 16:22:50 appldev noship $ */
3
4 -- Package
5 -- CLN_SYNC_ITEM_PKG
6 --
7 -- Purpose
8 -- Specs of package CLN_SYNC_ITEM_PKG.
9 --
10 -- History
11 -- July-21-2003 Rahul Krishan Created
12
13
14 -- Name
15 -- SET_SAVEPOINT_SYNC_RN
16 -- Purpose
17 -- This procedure sets the savepoint for deletion event.
18 -- Incase we find the item status as obselete while processing, we rollback to this point
19 --
20 -- Arguments
21 --
22 -- Notes
23 -- No specific notes.
24
25 PROCEDURE SET_SAVEPOINT_SYNC_RN;
26
27
28 -- Name
29 -- CATEGRY_RESOL_RN
30 -- Purpose
31 -- This procedure takes an input of concatenated string of category name and
32 -- category set name delimited by '|'.
33 -- The input would be of the form 'CATNAME=xxxxxx|CATSETNAME=xxxxxxxxx'
34 -- The output parameters individually carry the category name and category set name
35 -- This procedure is called from the inbound XGM
36 -- Arguments
37 --
38 -- Notes
39 -- No specific notes.
40 PROCEDURE catgry_resol_RN(
41 p_concatgset IN VARCHAR2,
42 x_insert IN OUT NOCOPY VARCHAR2,
43 x_catgry OUT NOCOPY VARCHAR2,
44 x_catsetname OUT NOCOPY VARCHAR2);
45
46
47 -- Name
48 -- RAISE_UPDATE_EVENT
49 -- Purpose
50 -- This is the public procedure which raises an event to update collaboration passing these parameters so
51 -- obtained.This procedure requires only p_internal_control_number.
52 -- This procedure is called from the root of XGM map
53 --
54 -- Arguments
55 --
56 -- Notes
57 -- No specific notes.
58
59 PROCEDURE RAISE_UPDATE_EVENT(
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_internal_control_number IN NUMBER,
63 p_sender_header_id IN NUMBER,
64 p_receiver_header_id IN NUMBER,
65 x_supplier_name OUT NOCOPY VARCHAR2,
66 x_master_organization_id OUT NOCOPY NUMBER,
67 x_set_process_id OUT NOCOPY NUMBER,
68 x_cost_group_id OUT NOCOPY NUMBER);
69
70
71 -- Name
72 -- RAISE_ADD_MSG_EVENT
73 -- Purpose
74 -- This is the public procedure which is used to raise an event that add messages into collaboration history passing
75 -- these parameters so obtained.This procedure is called
76 -- for each Item
77 --
78 -- Arguments
79 --
80 -- Notes
81 -- No specific notes.
82
83 PROCEDURE RAISE_ADD_MSG_EVENT(
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 p_sync_indicator IN VARCHAR2,
87 p_supplier_name IN VARCHAR2,
88 p_buyer_part_number IN VARCHAR2,
89 p_supplier_part_number IN VARCHAR2,
90 p_item_number IN VARCHAR2,
91 p_item_desc IN VARCHAR2,
92 p_item_revision IN VARCHAR2,
93 p_organization_id IN NUMBER,
94 p_new_revision_flag IN OUT NOCOPY VARCHAR2,
95 p_new_deletion_flag IN OUT NOCOPY VARCHAR2,
96 p_internal_control_number IN NUMBER,
97 p_hazardous_class IN VARCHAR2,
98 x_hazardous_id OUT NOCOPY NUMBER,
99 x_notification_code OUT NOCOPY VARCHAR2,
100 x_inventory_item_id OUT NOCOPY NUMBER );
101
102
103 -- Name
104 -- INSERT_DATA
105 -- Purpose
106 -- This is the public procedure which checks the status and also the SYNC indicator
107 -- Based on this, global variable INSERT_DATA is set to 'TRUE' or 'FALSE'
108 --
109 -- Arguments
110 --
111 -- Notes
112 -- No specific notes.
113
114 PROCEDURE INSERT_DATA(
115 p_return_status IN VARCHAR2,
116 p_sync_indicator IN VARCHAR2,
117 x_insert_data OUT NOCOPY VARCHAR2 );
118
119
120
121 -- Name
122 -- ERROR_HANDLER
123 -- Purpose
124 --
125 -- Arguments
126 --
127 -- Notes
128 -- No specific notes.
129
130 PROCEDURE ERROR_HANDLER(
131 x_return_status IN OUT NOCOPY VARCHAR2,
132 x_msg_data IN OUT NOCOPY VARCHAR2,
133 p_org_ref IN VARCHAR2,
134 p_internal_control_number IN NUMBER,
135 x_notification_code OUT NOCOPY VARCHAR2,
136 x_notification_status OUT NOCOPY VARCHAR2,
137 x_return_status_tp OUT NOCOPY VARCHAR2,
138 x_return_desc_tp OUT NOCOPY VARCHAR2 );
139
140
141 -- Name
142 -- XGM_CHECK_STATUS
143 -- Purpose
144 -- This procedure returns 'True' incase the status inputted is 'S' and returns 'False'
145 -- incase the status inputted is other then 'S'
146 -- Arguments
147 --
148 -- Notes
149 -- No specific notes.
150
151 PROCEDURE XGM_CHECK_STATUS (
152 p_itemtype IN VARCHAR2,
153 p_itemkey IN VARCHAR2,
154 p_actid IN NUMBER,
155 p_funcmode IN VARCHAR2,
156 x_resultout OUT NOCOPY VARCHAR2 );
157
158
159 -- Name
160 -- ITEM_IMPORT_STATUS_HANDLER
161 -- Purpose
162 -- This API checks for the status and accordingly updates the collaboration. Also, on the basis
163 -- of few parameters, notifications are sent out to Buyer for his necessary actions.
164 -- Arguments
165 --
166 -- Notes
167 -- No specific notes.
168
169 PROCEDURE ITEM_IMPORT_STATUS_HANDLER (
170 p_itemtype IN VARCHAR2,
171 p_itemkey IN VARCHAR2,
172 p_actid IN NUMBER,
173 p_funcmode IN VARCHAR2,
174 x_resultout OUT NOCOPY VARCHAR2 );
175
176
177
178 -- Name
179 -- SETUP_CST_INTERFACE_TABLE
180 -- Purpose
181 -- This API checks for the status and accordingly updates the costing interface table
182 -- with the inventory_item_id for the items which got imported and also it deletes the
183 -- the records for the items which falied to get imported
184 --
185 -- Arguments
186 --
187 -- Notes
188 -- No specific notes.
189
190 PROCEDURE SETUP_CST_INTERFACE_TABLE (
191 p_itemtype IN VARCHAR2,
192 p_itemkey IN VARCHAR2,
193 p_actid IN NUMBER,
194 p_funcmode IN VARCHAR2,
195 x_resultout OUT NOCOPY VARCHAR2 );
196
197
198
199 -- Name
200 -- UPDATE_COLLB_STATUS
201 -- Purpose
202 -- This API updates the collaboration history based on the status after the running of costing
203 -- interface concurrent program
204 --
205 -- Arguments
206 --
207 -- Notes
208 -- No specific notes.
209
210 PROCEDURE UPDATE_COLLB_STATUS (
211 p_itemtype IN VARCHAR2,
212 p_itemkey IN VARCHAR2,
213 p_actid IN NUMBER,
214 p_funcmode IN VARCHAR2,
215 x_resultout OUT NOCOPY VARCHAR2 );
216
217
218 -- Name
219 -- MFG_PARTNUM_STATUS_CHECK
220 -- Purpose
221 -- This API checks for the status of the concurrent program for updating
222 -- the manufacturing part number and incase of an error
223 -- updates the collaboration history.
224 --
225 -- Arguments
226 --
227 -- Notes
228 -- No specific notes.
229
230 PROCEDURE MFG_PARTNUM_STATUS_CHECK (
231 p_itemtype IN VARCHAR2,
232 p_itemkey IN VARCHAR2,
233 p_actid IN NUMBER,
234 p_funcmode IN VARCHAR2,
235 x_resultout OUT NOCOPY VARCHAR2 );
236
237
238 -- Name
239 -- UPDATE_COLLB_STATUS_RN
240 -- Purpose
241 -- This API updates the status of the collaboration based on the document status
242 -- for Rosettanet supported Framework
243 --
244 -- Arguments
245 --
246 -- Notes
247 -- No specific notes.
248
249 PROCEDURE UPDATE_COLLB_STATUS_RN (
250 p_itemtype IN VARCHAR2,
251 p_itemkey IN VARCHAR2,
252 p_actid IN NUMBER,
253 p_funcmode IN VARCHAR2,
254 x_resultout OUT NOCOPY VARCHAR2 );
255
256
257 -- Name
258 -- ROLLBACK_CHANGES_RN
259 -- Purpose
260 -- This is the public procedure which is used to raise an event that add messages into collaboration history passing
261 -- these parameters so obtained.This procedure is called when the item status in the
262 -- inbound document is obselete
263 --
264 -- Arguments
265 --
266 -- Notes
267 -- No specific notes.
268
269 PROCEDURE ROLLBACK_CHANGES_RN(
270 x_return_status OUT NOCOPY VARCHAR2,
271 x_msg_data OUT NOCOPY VARCHAR2,
272 p_supplier_name IN VARCHAR2,
273 p_buyer_part_number IN VARCHAR2,
274 p_supplier_part_number IN VARCHAR2,
275 p_item_number IN VARCHAR2,
276 p_item_revision IN VARCHAR2,
277 p_new_revision_flag IN OUT NOCOPY VARCHAR2,
278 p_new_deletion_flag IN OUT NOCOPY VARCHAR2,
279 p_internal_control_number IN NUMBER,
280 x_notification_code OUT NOCOPY VARCHAR2 );
281
282
283 END CLN_SYNC_ITEM_PKG;
284