1 package Bom_Business_Event_PKG as
2 /* $Header: BOMSBESS.pls 120.4 2006/06/11 19:28:59 seradhak noship $ */
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
47 PROCEDURE Raise_Event( p_Event_Name IN VARCHAR2
48 , p_Event_Key IN VARCHAR2
49 , p_Parameter_List IN OUT NOCOPY wf_parameter_list_t
50 );
51
52 PROCEDURE Add_Parameter_To_List( p_Parameter_Name IN VARCHAR2
53 , p_Value IN VARCHAR2
54 , p_parameter_List IN OUT NOCOPY wf_parameter_list_t
55 );
56
57 /* Utility procedures */
58
59 PROCEDURE Raise_Item_Event
60 ( p_organization_id IN NUMBER
61 ,p_inventory_item_id IN NUMBER
62 ,p_item_name IN VARCHAR2
63 ,p_item_description IN VARCHAR2
64 ,p_Event_Name IN VARCHAR2);
65
66
67 PROCEDURE Raise_Bill_Event
68 ( p_pk1_value IN VARCHAR2,
69 p_pk2_value IN VARCHAR2,
70 p_obj_name IN VARCHAR2,
71 p_structure_name IN VARCHAR2,
72 p_organization_id IN NUMBER,
73 p_structure_comment IN VARCHAR2,
74 p_Event_Name IN VARCHAR2);
75
76 PROCEDURE Raise_Component_Event
77 ( p_bill_sequence_Id IN NUMBER,
78 p_pk1_value IN VARCHAR2,
79 p_pk2_value IN VARCHAR2,
80 p_obj_name IN VARCHAR2,
81 p_organization_id IN NUMBER,
82 p_comp_item_name IN VARCHAR2,
83 p_comp_description in VARCHAR2,
84 p_Event_Name IN VARCHAR2);
85
86
87 --4306013
88 -- Modified for BE Changes
89 PROCEDURE Raise_Bill_Event
90 ( p_pk1_value IN VARCHAR2,
91 p_pk2_value IN VARCHAR2,
92 p_obj_name IN VARCHAR2,
93 p_structure_name IN VARCHAR2,
94 p_organization_id IN NUMBER,
95 p_structure_comment IN VARCHAR2,
96 p_Event_Load_Type IN VARCHAR2,
97 p_Event_Entity_Name IN VARCHAR2,
98 p_Event_Entity_Parent_Id IN NUMBER,
99 p_Event_Name IN VARCHAR2,
100 p_last_update_date IN DATE DEFAULT SYSDATE,
101 p_last_updated_by IN NUMBER DEFAULT NULL,
102 p_creation_date IN DATE DEFAULT SYSDATE,
103 p_created_by IN NUMBER DEFAULT NULL,
104 p_last_update_login IN NUMBER DEFAULT NULL,
105 p_component_seq_id IN NUMBER DEFAULT NULL
106 );
107
108
109 -- Modified for BE Changes
110 PROCEDURE Raise_Bill_Event --4306013
111 ( p_Event_Load_Type IN VARCHAR2
112 ,p_Request_Identifier IN NUMBER
113 ,p_Batch_Identifier IN NUMBER
114 ,p_Event_Entity_Name IN VARCHAR2
115 ,p_Event_Entity_Parent_Id IN NUMBER
116 ,p_Event_Name IN VARCHAR2
117 ,p_last_update_date IN DATE DEFAULT SYSDATE
118 ,p_last_updated_by IN NUMBER DEFAULT NULL
119 ,p_creation_date IN DATE DEFAULT SYSDATE
120 ,p_created_by IN NUMBER DEFAULT NULL
121 ,p_last_update_login IN NUMBER DEFAULT NULL
122 );
123
124 -- Modified for BE Changes
125 PROCEDURE Raise_Bill_Event --4306013 for bulk operations -- component
126 ( p_Event_Load_Type IN VARCHAR2
127 ,p_Request_Identifier IN NUMBER
128 ,p_Batch_Identifier IN NUMBER
129 ,p_Event_Entity_Name IN VARCHAR2
130 ,p_Event_Name IN VARCHAR2
131 ,p_last_update_date IN DATE DEFAULT SYSDATE
132 ,p_last_updated_by IN NUMBER DEFAULT NULL
133 ,p_creation_date IN DATE DEFAULT SYSDATE
134 ,p_created_by IN NUMBER DEFAULT NULL
135 ,p_last_update_login IN NUMBER DEFAULT NULL
136 );
137
138 PROCEDURE Raise_Component_Event --4306013
139 (p_Event_Load_Type IN VARCHAR2
140 ,p_Request_Identifier IN NUMBER
141 ,p_Batch_Identifier IN NUMBER
142 ,p_Event_Entity_Name IN VARCHAR2
143 ,p_Event_Entity_Parent_Id IN NUMBER
144 ,p_Event_Name IN VARCHAR2);
145
146 -- Modified for BE Changes
147 PROCEDURE Raise_Component_Event --4306013 for bulk operations -- SC, RD, CO
148 ( p_Event_Load_Type IN VARCHAR2
149 ,p_Request_Identifier IN NUMBER
150 ,p_Batch_Identifier IN NUMBER
151 ,p_Event_Entity_Name IN VARCHAR2
152 ,p_Event_Name IN VARCHAR2
153 ,p_last_update_date IN DATE DEFAULT SYSDATE
154 ,p_last_updated_by IN NUMBER DEFAULT NULL
155 ,p_creation_date IN DATE DEFAULT SYSDATE
156 ,p_created_by IN NUMBER DEFAULT NULL
157 ,p_last_update_login IN NUMBER DEFAULT NULL
158 );
159
160 -- Modified for BE Changes
161 --4306013
162 PROCEDURE Raise_Component_Event
163 ( p_bill_sequence_Id IN NUMBER,
164 p_pk1_value IN VARCHAR2,
165 p_pk2_value IN VARCHAR2,
166 p_obj_name IN VARCHAR2,
167 p_organization_id IN NUMBER,
168 p_comp_item_name IN VARCHAR2,
169 p_comp_description in VARCHAR2,
170 p_Event_Load_Type IN VARCHAR2,
171 p_Event_Entity_Name IN VARCHAR2,
172 p_Event_Entity_Parent_Id IN NUMBER,
173 p_Event_Name IN VARCHAR2,
174 p_last_update_date IN DATE DEFAULT SYSDATE,
175 p_last_updated_by IN NUMBER DEFAULT NULL,
176 p_creation_date IN DATE DEFAULT SYSDATE,
177 p_created_by IN NUMBER DEFAULT NULL,
178 p_last_update_login IN NUMBER DEFAULT NULL
179 );
180
181 --4306013
182 PROCEDURE Raise_Bill_Event
183 (p_Request_Identifier IN NUMBER
184 ,p_Event_Name IN VARCHAR2);
185
186 -- Bug 5244896
187 PROCEDURE raise_str_cpy_complete_event
188 (p_copy_request_id IN NUMBER);
189
190 END Bom_Business_Event_PKG;