DBA Data[Home] [Help]

APPS.FLM_EKB_BUSINESS_EVENT_PKG dependencies on WF_EVENT

Line 65: wf_event.AddParameterToList(p_name=>'organization_id',

61: raise too_many_match;
62: end if;
63: CLOSE c_pullSequence;
64:
65: wf_event.AddParameterToList(p_name=>'organization_id',
66: p_value=>l_pull_sequence.organization_id,
67: p_parameterlist=>l_parameter_list);
68: wf_event.AddParameterToList(p_name=>'pull_sequence_id',
69: p_value=>p_pull_Sequence_id,

Line 68: wf_event.AddParameterToList(p_name=>'pull_sequence_id',

64:
65: wf_event.AddParameterToList(p_name=>'organization_id',
66: p_value=>l_pull_sequence.organization_id,
67: p_parameterlist=>l_parameter_list);
68: wf_event.AddParameterToList(p_name=>'pull_sequence_id',
69: p_value=>p_pull_Sequence_id,
70: p_parameterlist=>l_parameter_list);
71: wf_event.AddParameterToList(p_name=>'inventory_item_id',
72: p_value=>l_pull_sequence.inventory_item_id,

Line 71: wf_event.AddParameterToList(p_name=>'inventory_item_id',

67: p_parameterlist=>l_parameter_list);
68: wf_event.AddParameterToList(p_name=>'pull_sequence_id',
69: p_value=>p_pull_Sequence_id,
70: p_parameterlist=>l_parameter_list);
71: wf_event.AddParameterToList(p_name=>'inventory_item_id',
72: p_value=>l_pull_sequence.inventory_item_id,
73: p_parameterlist=>l_parameter_list);
74: wf_event.AddParameterToList(p_name=>'subinventory_name',
75: p_value=>l_pull_sequence.subinventory_name,

Line 74: wf_event.AddParameterToList(p_name=>'subinventory_name',

70: p_parameterlist=>l_parameter_list);
71: wf_event.AddParameterToList(p_name=>'inventory_item_id',
72: p_value=>l_pull_sequence.inventory_item_id,
73: p_parameterlist=>l_parameter_list);
74: wf_event.AddParameterToList(p_name=>'subinventory_name',
75: p_value=>l_pull_sequence.subinventory_name,
76: p_parameterlist=>l_parameter_list);
77: wf_event.AddParameterToList(p_name=>'locator_id',
78: p_value=>l_pull_sequence.locator_id,

Line 77: wf_event.AddParameterToList(p_name=>'locator_id',

73: p_parameterlist=>l_parameter_list);
74: wf_event.AddParameterToList(p_name=>'subinventory_name',
75: p_value=>l_pull_sequence.subinventory_name,
76: p_parameterlist=>l_parameter_list);
77: wf_event.AddParameterToList(p_name=>'locator_id',
78: p_value=>l_pull_sequence.locator_id,
79: p_parameterlist=>l_parameter_list);
80: wf_event.AddParameterToList(p_name=>'source_type',
81: p_value=>l_pull_sequence.source_type,

Line 80: wf_event.AddParameterToList(p_name=>'source_type',

76: p_parameterlist=>l_parameter_list);
77: wf_event.AddParameterToList(p_name=>'locator_id',
78: p_value=>l_pull_sequence.locator_id,
79: p_parameterlist=>l_parameter_list);
80: wf_event.AddParameterToList(p_name=>'source_type',
81: p_value=>l_pull_sequence.source_type,
82: p_parameterlist=>l_parameter_list);
83: wf_event.AddParameterToList(p_name=>'kanban_size',
84: p_value=>l_pull_sequence.kanban_size,

Line 83: wf_event.AddParameterToList(p_name=>'kanban_size',

79: p_parameterlist=>l_parameter_list);
80: wf_event.AddParameterToList(p_name=>'source_type',
81: p_value=>l_pull_sequence.source_type,
82: p_parameterlist=>l_parameter_list);
83: wf_event.AddParameterToList(p_name=>'kanban_size',
84: p_value=>l_pull_sequence.kanban_size,
85: p_parameterlist=>l_parameter_list);
86: wf_event.AddParameterToList(p_name=>'number_of_cards',
87: p_value=>l_pull_sequence.number_of_cards,

Line 86: wf_event.AddParameterToList(p_name=>'number_of_cards',

82: p_parameterlist=>l_parameter_list);
83: wf_event.AddParameterToList(p_name=>'kanban_size',
84: p_value=>l_pull_sequence.kanban_size,
85: p_parameterlist=>l_parameter_list);
86: wf_event.AddParameterToList(p_name=>'number_of_cards',
87: p_value=>l_pull_sequence.number_of_cards,
88: p_parameterlist=>l_parameter_list);
89:
90: if( l_event_name = 'oracle.apps.flm.ekanban.pullSeqUpdate') then

Line 91: wf_event.AddParameterToList(p_name=>'update_from_planning',

87: p_value=>l_pull_sequence.number_of_cards,
88: p_parameterlist=>l_parameter_list);
89:
90: if( l_event_name = 'oracle.apps.flm.ekanban.pullSeqUpdate') then
91: wf_event.AddParameterToList(p_name=>'update_from_planning',
92: p_value=>p_from_planning,
93: p_parameterlist=>l_parameter_list);
94: end if;
95:

Line 96: WF_EVENT.Raise( p_event_name => l_event_name

92: p_value=>p_from_planning,
93: p_parameterlist=>l_parameter_list);
94: end if;
95:
96: WF_EVENT.Raise( p_event_name => l_event_name
97: ,p_event_key => l_event_key
98: ,p_event_data => l_event_data
99: ,p_parameters => l_parameter_list
100: ,p_send_date => l_send_date);

Line 185: wf_event.AddParameterToList(p_name=>'kanban_card_id',

181:
182: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual;
183: l_event_key := SUBSTRB(l_event_name, 1, 255) || '-' || l_event_num;
184:
185: wf_event.AddParameterToList(p_name=>'kanban_card_id',
186: p_value=>p_kanban_card_id,
187: p_parameterlist=>l_parameter_list);
188: wf_event.AddParameterToList(p_name=>'organization_id',
189: p_value=>l_kanban_card.organization_id,

Line 188: wf_event.AddParameterToList(p_name=>'organization_id',

184:
185: wf_event.AddParameterToList(p_name=>'kanban_card_id',
186: p_value=>p_kanban_card_id,
187: p_parameterlist=>l_parameter_list);
188: wf_event.AddParameterToList(p_name=>'organization_id',
189: p_value=>l_kanban_card.organization_id,
190: p_parameterlist=>l_parameter_list);
191: wf_event.AddParameterToList(p_name=>'kanban_card_number',
192: p_value=>l_kanban_card.kanban_card_number,

Line 191: wf_event.AddParameterToList(p_name=>'kanban_card_number',

187: p_parameterlist=>l_parameter_list);
188: wf_event.AddParameterToList(p_name=>'organization_id',
189: p_value=>l_kanban_card.organization_id,
190: p_parameterlist=>l_parameter_list);
191: wf_event.AddParameterToList(p_name=>'kanban_card_number',
192: p_value=>l_kanban_card.kanban_card_number,
193: p_parameterlist=>l_parameter_list);
194: wf_event.AddParameterToList(p_name=>'pull_sequence_id',
195: p_value=>l_kanban_card.pull_sequence_id,

Line 194: wf_event.AddParameterToList(p_name=>'pull_sequence_id',

190: p_parameterlist=>l_parameter_list);
191: wf_event.AddParameterToList(p_name=>'kanban_card_number',
192: p_value=>l_kanban_card.kanban_card_number,
193: p_parameterlist=>l_parameter_list);
194: wf_event.AddParameterToList(p_name=>'pull_sequence_id',
195: p_value=>l_kanban_card.pull_sequence_id,
196: p_parameterlist=>l_parameter_list);
197:
198:

Line 199: WF_EVENT.Raise( p_event_name => l_event_name

195: p_value=>l_kanban_card.pull_sequence_id,
196: p_parameterlist=>l_parameter_list);
197:
198:
199: WF_EVENT.Raise( p_event_name => l_event_name
200: ,p_event_key => l_event_key
201: ,p_event_data => l_event_data
202: ,p_parameters => l_parameter_list
203: ,p_send_date => l_send_date);

Line 283: wf_event.AddParameterToList(p_name=>'kanban_card_id',

279: raise too_many_match;
280: end if;
281: CLOSE c_kanbanCard;
282:
283: wf_event.AddParameterToList(p_name=>'kanban_card_id',
284: p_value=>p_kanban_card_id,
285: p_parameterlist=>l_parameter_list);
286: wf_event.AddParameterToList(p_name=>'kanban_card_number',
287: p_value=>l_kanban_card.kanban_card_number,

Line 286: wf_event.AddParameterToList(p_name=>'kanban_card_number',

282:
283: wf_event.AddParameterToList(p_name=>'kanban_card_id',
284: p_value=>p_kanban_card_id,
285: p_parameterlist=>l_parameter_list);
286: wf_event.AddParameterToList(p_name=>'kanban_card_number',
287: p_value=>l_kanban_card.kanban_card_number,
288: p_parameterlist=>l_parameter_list);
289: wf_event.AddParameterToList(p_name=>'pull_sequence_id',
290: p_value=>l_kanban_card.pull_sequence_id,

Line 289: wf_event.AddParameterToList(p_name=>'pull_sequence_id',

285: p_parameterlist=>l_parameter_list);
286: wf_event.AddParameterToList(p_name=>'kanban_card_number',
287: p_value=>l_kanban_card.kanban_card_number,
288: p_parameterlist=>l_parameter_list);
289: wf_event.AddParameterToList(p_name=>'pull_sequence_id',
290: p_value=>l_kanban_card.pull_sequence_id,
291: p_parameterlist=>l_parameter_list);
292: wf_event.AddParameterToList(p_name=>'old_card_status',
293: p_value=>p_from_status,

Line 292: wf_event.AddParameterToList(p_name=>'old_card_status',

288: p_parameterlist=>l_parameter_list);
289: wf_event.AddParameterToList(p_name=>'pull_sequence_id',
290: p_value=>l_kanban_card.pull_sequence_id,
291: p_parameterlist=>l_parameter_list);
292: wf_event.AddParameterToList(p_name=>'old_card_status',
293: p_value=>p_from_status,
294: p_parameterlist=>l_parameter_list);
295: wf_event.AddParameterToList(p_name=>'new_card_status',
296: p_value=>p_to_status,

Line 295: wf_event.AddParameterToList(p_name=>'new_card_status',

291: p_parameterlist=>l_parameter_list);
292: wf_event.AddParameterToList(p_name=>'old_card_status',
293: p_value=>p_from_status,
294: p_parameterlist=>l_parameter_list);
295: wf_event.AddParameterToList(p_name=>'new_card_status',
296: p_value=>p_to_status,
297: p_parameterlist=>l_parameter_list);
298:
299:

Line 300: WF_EVENT.Raise( p_event_name => l_event_name

296: p_value=>p_to_status,
297: p_parameterlist=>l_parameter_list);
298:
299:
300: WF_EVENT.Raise( p_event_name => l_event_name
301: ,p_event_key => l_event_key
302: ,p_event_data => l_event_data
303: ,p_parameters => l_parameter_list
304: ,p_send_date => l_send_date);

Line 341: p_event in out NOCOPY WF_EVENT_T) return varchar2 is

337:
338: /*For testing supscription and sending notificaiton internally. Need to remove it later*/
339:
340: function test_business_event (p_subscription_guid in raw,
341: p_event in out NOCOPY WF_EVENT_T) return varchar2 is
342: PRAGMA AUTONOMOUS_TRANSACTION;
343: l_return_status VARCHAR2(10);
344: l_msg_count NUMBER;
345: l_msg_data VARCHAR2(1000);

Line 371: WF_EVENT.setErrorInfo(p_event, 'ERROR');

367: exception
368: when others then
369: WF_CORE.CONTEXT('FLM_EKB_BUSINESS_EVENT_PKG', 'test_business_event',
370: p_event.getEventName( ), p_subscription_guid);
371: WF_EVENT.setErrorInfo(p_event, 'ERROR');
372: return 'ERROR';
373: end;
374:
375: /*For testing supscription and sending notificaiton internally. Need to remove it later*/