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
16: | History: |
17: |-------- |
18: | 02-Sept-2003 Rahul Chitko Initial Creation |
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
17: |-------- |
18: | 02-Sept-2003 Rahul Chitko Initial Creation |
19: +==========================================================================*/
28: ** Parameter List - this is a name/value pair of parameters that will be passed to the event.
29: */
30: PROCEDURE Raise_Event( p_Event_Name IN VARCHAR2
31: , p_Event_Key IN VARCHAR2
32: , p_Parameter_List IN OUT NOCOPY wf_parameter_list_t
33: )
34: IS
35: BEGIN
36: wf_event.raise( p_Event_Name => p_Event_Name
60: ** parameter_list - returns the new parameter list
61: */
62: PROCEDURE Add_Parameter_To_List( p_Parameter_Name IN VARCHAR2
63: , p_Value IN VARCHAR2
64: , p_parameter_List IN OUT NOCOPY wf_parameter_list_t
65: )
66: IS
67: BEGIN
68:
82: ,p_item_name IN VARCHAR2
83: ,p_item_description IN VARCHAR2
84: ,p_Event_Name IN VARCHAR2)
85: IS
86: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
87: BEGIN
88: Bom_Business_Event_PKG.Add_Parameter_To_List
89: ( p_parameter_name => 'INVENTORY_ITEM_ID'
90: ,p_value => p_inventory_item_id
124: ,p_Event_Name IN VARCHAR2
125: ,p_revised_item_sequence_id IN NUMBER DEFAULT NULL --Added for BUG#8266922
126: )
127: IS
128: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
129:
130: BEGIN
131:
132: Bom_Business_Event_PKG.Add_Parameter_To_List
176: ,p_comp_description IN VARCHAR2
177: ,p_Event_Name IN VARCHAR2)
178: IS
179:
180: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
181:
182: BEGIN
183:
184: Bom_Business_Event_PKG.Add_Parameter_To_List
238: ,p_created_by IN NUMBER DEFAULT NULL
239: ,p_last_update_login IN NUMBER DEFAULT NULL
240: )
241: IS
242: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
243: l_common_bill_sequence_id NUMBER;
244: BEGIN
245: SELECT common_bill_sequence_id INTO l_common_bill_sequence_id
246: FROM bom_structures_b
318: ,p_created_by IN NUMBER DEFAULT NULL
319: ,p_last_update_login IN NUMBER DEFAULT NULL
320: )
321: IS
322: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
323: BEGIN
324: Bom_Business_Event_PKG.Add_Parameter_To_List
325: ( p_parameter_name => 'EVENT_TYPE'
326: ,p_value => p_Event_Load_Type
392: p_component_seq_id IN NUMBER DEFAULT NULL
393: )
394:
395: IS
396: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
397: l_common_bill_sequence_id NUMBER;
398: BEGIN
399:
400: SELECT common_bill_sequence_id INTO l_common_bill_sequence_id
548: ,p_Event_Entity_Name IN VARCHAR2
549: ,p_Event_Entity_Parent_Id IN NUMBER
550: ,p_Event_Name IN VARCHAR2)
551: IS
552: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
553: BEGIN
554:
555: Bom_Business_Event_PKG.Add_Parameter_To_List
556: ( p_parameter_name => 'EVENT_TYPE'
597: ,p_created_by IN NUMBER DEFAULT NULL
598: ,p_last_update_login IN NUMBER DEFAULT NULL
599: )
600: IS
601: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
602: BEGIN
603:
604: Bom_Business_Event_PKG.Add_Parameter_To_List
605: ( p_parameter_name => 'EVENT_TYPE'
675: p_last_update_login IN NUMBER DEFAULT NULL
676: )
677:
678: IS
679: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
680: BEGIN
681:
682: Bom_Business_Event_PKG.Add_Parameter_To_List
683: ( p_parameter_name => 'OBJ_NAME'
821: PROCEDURE Raise_Bill_Event --4306013
822: (p_Request_Identifier IN NUMBER
823: ,p_Event_Name IN VARCHAR2)
824: IS
825: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
826: BEGIN
827:
828: Bom_Business_Event_PKG.Add_Parameter_To_List
829: (p_parameter_name => 'REQUEST_IDENTIFIER'
839: -- Bug 5244896
840: PROCEDURE raise_str_cpy_complete_event
841: ( p_copy_request_id IN NUMBER )
842: IS
843: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
844: BEGIN
845: bom_business_event_pkg.add_parameter_to_list
846: (p_parameter_name => 'COPY_REQUEST_ID'
847: ,p_value => p_copy_request_id