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
50: ** parameter_list - returns the new parameter list
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: IS
57: BEGIN
58:
72: ,p_item_name IN VARCHAR2
73: ,p_item_description IN VARCHAR2
74: ,p_Event_Name IN VARCHAR2)
75: IS
76: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
77: BEGIN
78: Bom_Business_Event_PKG.Add_Parameter_To_List
79: ( p_parameter_name => 'INVENTORY_ITEM_ID'
80: ,p_value => p_inventory_item_id
112: ,p_organization_id IN NUMBER
113: ,p_structure_comment IN VARCHAR2
114: ,p_Event_Name IN VARCHAR2)
115: IS
116: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
117:
118: BEGIN
119:
120: Bom_Business_Event_PKG.Add_Parameter_To_List
158: ,p_comp_description IN VARCHAR2
159: ,p_Event_Name IN VARCHAR2)
160: IS
161:
162: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
163:
164: BEGIN
165:
166: Bom_Business_Event_PKG.Add_Parameter_To_List
220: ,p_created_by IN NUMBER DEFAULT NULL
221: ,p_last_update_login IN NUMBER DEFAULT NULL
222: )
223: IS
224: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
225: l_common_bill_sequence_id NUMBER;
226: BEGIN
227: SELECT common_bill_sequence_id INTO l_common_bill_sequence_id
228: FROM bom_structures_b
300: ,p_created_by IN NUMBER DEFAULT NULL
301: ,p_last_update_login IN NUMBER DEFAULT NULL
302: )
303: IS
304: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
305: BEGIN
306: Bom_Business_Event_PKG.Add_Parameter_To_List
307: ( p_parameter_name => 'EVENT_TYPE'
308: ,p_value => p_Event_Load_Type
374: p_component_seq_id IN NUMBER DEFAULT NULL
375: )
376:
377: IS
378: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
379: l_common_bill_sequence_id NUMBER;
380: BEGIN
381:
382: SELECT common_bill_sequence_id INTO l_common_bill_sequence_id
474: ,p_Event_Entity_Name IN VARCHAR2
475: ,p_Event_Entity_Parent_Id IN NUMBER
476: ,p_Event_Name IN VARCHAR2)
477: IS
478: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
479: BEGIN
480:
481: Bom_Business_Event_PKG.Add_Parameter_To_List
482: ( p_parameter_name => 'EVENT_TYPE'
523: ,p_created_by IN NUMBER DEFAULT NULL
524: ,p_last_update_login IN NUMBER DEFAULT NULL
525: )
526: IS
527: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
528: BEGIN
529:
530: Bom_Business_Event_PKG.Add_Parameter_To_List
531: ( p_parameter_name => 'EVENT_TYPE'
601: p_last_update_login IN NUMBER DEFAULT NULL
602: )
603:
604: IS
605: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
606: BEGIN
607:
608: Bom_Business_Event_PKG.Add_Parameter_To_List
609: ( p_parameter_name => 'OBJ_NAME'
692: PROCEDURE Raise_Bill_Event --4306013
693: (p_Request_Identifier IN NUMBER
694: ,p_Event_Name IN VARCHAR2)
695: IS
696: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
697: BEGIN
698:
699: Bom_Business_Event_PKG.Add_Parameter_To_List
700: (p_parameter_name => 'REQUEST_IDENTIFIER'
710: -- Bug 5244896
711: PROCEDURE raise_str_cpy_complete_event
712: ( p_copy_request_id IN NUMBER )
713: IS
714: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
715: BEGIN
716: bom_business_event_pkg.add_parameter_to_list
717: (p_parameter_name => 'COPY_REQUEST_ID'
718: ,p_value => p_copy_request_id