1 package Bom_Business_Event_PKG AUTHID CURRENT_USER as
2 /* $Header: BOMSBESS.pls 120.4.12010000.5 2009/12/24 08:20:11 gliang ship $ */
3 /*==========================================================================+
4 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5 | All rights reserved. |
6 +===========================================================================+
7 | |
8 | File Name : BOMSBESS.pls |
9 | DESCRIPTION : Package for raising various BOM Business Events |
10 | User of this API would use one of the defined constants |
11 | and call the raise event with the necessary parameters |
12 | Any Event that requires parameters must first call the |
13 | first call the Add_Parameter_To_List and then call the |
14 | raise_Event method. wf_parameter_list_t can be initialized |
15 | as <variable> := wf_parameter_list_t() |
16 | History: |
17 |-------- |
18 | 01-Sept-2003 Rahul Chitko Initial Creation |
19 +==========================================================================*/
20
21 /**
22 *** Item Events
23 **/
24 G_ITEM_DEL_SUCCESS_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.bom.item.deleteSuccess';
25 G_ITEM_DEL_ERROR_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.bom.item.deleteError';
26 G_ITEM_MARKED_DEL_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.bom.item.itemMarkedForDelete';
27
28 /**
29 *** Structure Events
30 **/
31 G_STRUCTURE_DEL_SUCCESS_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.bom.structure.deleteSuccess';
32 G_STRUCTURE_DEL_ERROR_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.bom.structure.deleteError';
33 G_STRUCTURE_MODIFIED_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.bom.structure.modified';
34 G_STRUCTURE_CREATION_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.bom.structure.created';
35 G_STRUCTURE_NEWREVISION_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.bom.structure.revisionCreated';
36 G_STRUCTURE_CPY_COMPLETE_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.bom.structure.copy.complete'; -- 4306013
37
38 /**
39 *** Components Events
40 **/
41
42 G_COMPONENT_DEL_SUCCESS_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.bom.component.deleteSuccess';
43 G_COMPONENT_DEL_ERROR_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.bom.component.deleteError';
44 G_COMPONENT_MODIFIED_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.bom.component.modified';
45 G_COMPONENT_ADDED_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.bom.component.created';
46 /* Added for bug 8462879*/
47 G_SUBSCRIPTION_EXC EXCEPTION; --Subscription Exception defined
48 PROCEDURE Raise_Event( p_Event_Name IN VARCHAR2
49 , p_Event_Key IN VARCHAR2
50 , p_Parameter_List IN OUT NOCOPY wf_parameter_list_t
51 );
52
53 PROCEDURE Add_Parameter_To_List( p_Parameter_Name IN VARCHAR2
54 , p_Value IN VARCHAR2
55 , p_parameter_List IN OUT NOCOPY wf_parameter_list_t
56 );
57
58 /* Utility procedures */
59
60 PROCEDURE Raise_Item_Event
61 ( p_organization_id IN NUMBER
62 ,p_inventory_item_id IN NUMBER
63 ,p_item_name IN VARCHAR2
64 ,p_item_description IN VARCHAR2
65 ,p_Event_Name IN VARCHAR2);
66
67
68 PROCEDURE Raise_Bill_Event
69 ( p_pk1_value IN VARCHAR2,
70 p_pk2_value IN VARCHAR2,
71 p_obj_name IN VARCHAR2,
72 p_structure_name IN VARCHAR2,
73 p_organization_id IN NUMBER,
74 p_structure_comment IN VARCHAR2,
75 p_Event_Name IN VARCHAR2,
76 p_revised_item_sequence_id IN NUMBER DEFAULT NULL
77 --addeed for Bug8574333
78 );
79
80 PROCEDURE Raise_Component_Event
81 ( p_bill_sequence_Id IN NUMBER,
82 p_pk1_value IN VARCHAR2,
83 p_pk2_value IN VARCHAR2,
84 p_obj_name IN VARCHAR2,
85 p_organization_id IN NUMBER,
86 p_comp_item_name IN VARCHAR2,
87 p_comp_description in VARCHAR2,
88 p_Event_Name IN VARCHAR2
89 );
90
91
92 --4306013
93 -- Modified for BE Changes
94 PROCEDURE Raise_Bill_Event
95 ( p_pk1_value IN VARCHAR2,
96 p_pk2_value IN VARCHAR2,
97 p_obj_name IN VARCHAR2,
98 p_structure_name IN VARCHAR2,
99 p_organization_id IN NUMBER,
100 p_structure_comment IN VARCHAR2,
101 p_Event_Load_Type IN VARCHAR2,
102 p_Event_Entity_Name IN VARCHAR2,
103 p_Event_Entity_Parent_Id IN NUMBER,
104 p_Event_Name IN VARCHAR2,
105 p_last_update_date IN DATE DEFAULT SYSDATE,
106 p_last_updated_by IN NUMBER DEFAULT NULL,
107 p_creation_date IN DATE DEFAULT SYSDATE,
108 p_created_by IN NUMBER DEFAULT NULL,
109 p_last_update_login IN NUMBER DEFAULT NULL,
110 p_component_seq_id IN NUMBER DEFAULT NULL
111 );
112
113 --Added for bug 8462879
114 PROCEDURE Raise_Bill_Event
115 ( p_pk1_value IN VARCHAR2,
116 p_pk2_value IN VARCHAR2,
117 p_obj_name IN VARCHAR2,
118 p_structure_name IN VARCHAR2,
119 p_organization_id IN NUMBER,
120 p_structure_comment IN VARCHAR2,
121 p_Event_Load_Type IN VARCHAR2,
122 p_Event_Entity_Name IN VARCHAR2,
123 p_Event_Entity_Parent_Id IN NUMBER,
124 p_Event_Name IN VARCHAR2,
125 p_last_update_date IN DATE DEFAULT SYSDATE,
126 p_last_updated_by IN NUMBER DEFAULT NULL,
127 p_creation_date IN DATE DEFAULT SYSDATE,
128 p_created_by IN NUMBER DEFAULT NULL,
129 p_last_update_login IN NUMBER DEFAULT NULL,
130 p_component_seq_id IN NUMBER DEFAULT NULL,
131 p_return_status OUT NOCOPY VARCHAR2, --Added for bug 8462879
132 p_msg_data OUT NOCOPY VARCHAR2 --Added for bug 8462879
133 );
134
135 -- Modified for BE Changes
136 PROCEDURE Raise_Bill_Event --4306013
137 ( p_Event_Load_Type IN VARCHAR2
138 ,p_Request_Identifier IN NUMBER
139 ,p_Batch_Identifier IN NUMBER
140 ,p_Event_Entity_Name IN VARCHAR2
141 ,p_Event_Entity_Parent_Id IN NUMBER
142 ,p_Event_Name IN VARCHAR2
143 ,p_last_update_date IN DATE DEFAULT SYSDATE
144 ,p_last_updated_by IN NUMBER DEFAULT NULL
145 ,p_creation_date IN DATE DEFAULT SYSDATE
146 ,p_created_by IN NUMBER DEFAULT NULL
147 ,p_last_update_login IN NUMBER DEFAULT NULL
148 );
149
150 -- Modified for BE Changes
151 PROCEDURE Raise_Bill_Event --4306013 for bulk operations -- component
152 ( p_Event_Load_Type IN VARCHAR2
153 ,p_Request_Identifier IN NUMBER
154 ,p_Batch_Identifier IN NUMBER
155 ,p_Event_Entity_Name IN VARCHAR2
156 ,p_Event_Name IN VARCHAR2
157 ,p_last_update_date IN DATE DEFAULT SYSDATE
158 ,p_last_updated_by IN NUMBER DEFAULT NULL
159 ,p_creation_date IN DATE DEFAULT SYSDATE
160 ,p_created_by IN NUMBER DEFAULT NULL
161 ,p_last_update_login IN NUMBER DEFAULT NULL
162 );
163
164 PROCEDURE Raise_Component_Event --4306013
165 (p_Event_Load_Type IN VARCHAR2
166 ,p_Request_Identifier IN NUMBER
167 ,p_Batch_Identifier IN NUMBER
168 ,p_Event_Entity_Name IN VARCHAR2
169 ,p_Event_Entity_Parent_Id IN NUMBER
170 ,p_Event_Name IN VARCHAR2);
171
172 -- Modified for BE Changes
173 PROCEDURE Raise_Component_Event --4306013 for bulk operations -- SC, RD, CO
174 ( p_Event_Load_Type IN VARCHAR2
175 ,p_Request_Identifier IN NUMBER
176 ,p_Batch_Identifier IN NUMBER
177 ,p_Event_Entity_Name IN VARCHAR2
178 ,p_Event_Name IN VARCHAR2
179 ,p_last_update_date IN DATE DEFAULT SYSDATE
180 ,p_last_updated_by IN NUMBER DEFAULT NULL
181 ,p_creation_date IN DATE DEFAULT SYSDATE
182 ,p_created_by IN NUMBER DEFAULT NULL
183 ,p_last_update_login IN NUMBER DEFAULT NULL
184 );
185
186 -- Modified for BE Changes
187 --4306013
188 PROCEDURE Raise_Component_Event
189 ( p_bill_sequence_Id IN NUMBER,
190 p_pk1_value IN VARCHAR2,
191 p_pk2_value IN VARCHAR2,
192 p_obj_name IN VARCHAR2,
193 p_organization_id IN NUMBER,
194 p_comp_item_name IN VARCHAR2,
195 p_comp_description in VARCHAR2,
196 p_Event_Load_Type IN VARCHAR2,
197 p_Event_Entity_Name IN VARCHAR2,
198 p_Event_Entity_Parent_Id IN NUMBER,
199 p_Event_Name IN VARCHAR2,
200 p_last_update_date IN DATE DEFAULT SYSDATE,
201 p_last_updated_by IN NUMBER DEFAULT NULL,
202 p_creation_date IN DATE DEFAULT SYSDATE,
203 p_created_by IN NUMBER DEFAULT NULL,
204 p_last_update_login IN NUMBER DEFAULT NULL
205 );
206 --Add for bug 9108842
207 PROCEDURE Raise_Component_Event
208 ( p_bill_sequence_Id IN NUMBER,
209 p_pk1_value IN VARCHAR2,
210 p_pk2_value IN VARCHAR2,
211 p_obj_name IN VARCHAR2,
212 p_organization_id IN NUMBER,
213 p_comp_item_name IN VARCHAR2,
214 p_comp_description in VARCHAR2,
215 p_Event_Load_Type IN VARCHAR2,
216 p_Event_Entity_Name IN VARCHAR2,
217 p_Event_Entity_Parent_Id IN NUMBER,
218 p_Event_Name IN VARCHAR2,
219 p_last_update_date IN DATE DEFAULT SYSDATE,
220 p_last_updated_by IN NUMBER DEFAULT NULL,
221 p_creation_date IN DATE DEFAULT SYSDATE,
222 p_created_by IN NUMBER DEFAULT NULL,
223 p_last_update_login IN NUMBER DEFAULT NULL,
224 p_return_status OUT NOCOPY VARCHAR2, --Added for bug 9108842
225 p_msg_data OUT NOCOPY VARCHAR2 --Added for bug 9108842
226 );
227 --4306013
228 PROCEDURE Raise_Bill_Event
229 (p_Request_Identifier IN NUMBER
230 ,p_Event_Name IN VARCHAR2);
231
232 -- Bug 5244896
233 PROCEDURE raise_str_cpy_complete_event
234 (p_copy_request_id IN NUMBER);
235
236 END Bom_Business_Event_PKG;