DBA Data[Home] [Help]

APPS.ECEPOI dependencies on WF_EVENT

Line 374: wf_event.AddParameterToList(p_name=> 'ORDER_SOURCE_ID',

370: -----------------------------------------------------------
371: -- Non-CLN params
372: -----------------------------------------------------------
373:
374: wf_event.AddParameterToList(p_name=> 'ORDER_SOURCE_ID',
375: p_value=> p_order_source_id,
376: p_parameterlist=> l_parameter_list);
377:
378: wf_event.AddParameterToList(p_name=> 'SOLD_TO_ORG_ID',

Line 378: wf_event.AddParameterToList(p_name=> 'SOLD_TO_ORG_ID',

374: wf_event.AddParameterToList(p_name=> 'ORDER_SOURCE_ID',
375: p_value=> p_order_source_id,
376: p_parameterlist=> l_parameter_list);
377:
378: wf_event.AddParameterToList(p_name=> 'SOLD_TO_ORG_ID',
379: p_value=> p_sold_to_org_id,
380: p_parameterlist=> l_parameter_list);
381:
382: wf_event.AddParameterToList(p_name=> 'PROCESSING_STAGE',

Line 382: wf_event.AddParameterToList(p_name=> 'PROCESSING_STAGE',

378: wf_event.AddParameterToList(p_name=> 'SOLD_TO_ORG_ID',
379: p_value=> p_sold_to_org_id,
380: p_parameterlist=> l_parameter_list);
381:
382: wf_event.AddParameterToList(p_name=> 'PROCESSING_STAGE',
383: p_value=> l_processing,
384: p_parameterlist=> l_parameter_list);
385:
386: IF l_document_id IS NULL THEN

Line 391: wf_event.AddParameterToList(p_name=> 'XMLG_DOCUMENT_ID',

387: l_document_id := to_number(l_eventkey); -- reuse the eventkey if necessary
388: END IF;
389:
390: IF l_transaction_type IN ('855','865') THEN
391: wf_event.AddParameterToList(p_name=> 'XMLG_DOCUMENT_ID',
392: p_value=> l_document_id,
393: p_parameterlist=> l_parameter_list);
394: l_order_processed_flag := 'Y';
395: ELSE

Line 396: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_CONTROL_NUMBER',

392: p_value=> l_document_id,
393: p_parameterlist=> l_parameter_list);
394: l_order_processed_flag := 'Y';
395: ELSE
396: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_CONTROL_NUMBER',
397: p_value=> l_document_id,
398: p_parameterlist=> l_parameter_list);
399: l_order_processed_flag := 'N';
400: END IF;

Line 402: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_TXN_TYPE',

398: p_parameterlist=> l_parameter_list);
399: l_order_processed_flag := 'N';
400: END IF;
401:
402: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_TXN_TYPE',
403: p_value=> 'ONT',
404: p_parameterlist=> l_parameter_list);
405:
406: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_TXN_SUBTYPE',

Line 406: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_TXN_SUBTYPE',

402: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_TXN_TYPE',
403: p_value=> 'ONT',
404: p_parameterlist=> l_parameter_list);
405:
406: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_TXN_SUBTYPE',
407: p_value=> l_transaction_type,
408: p_parameterlist=> l_parameter_list);
409:
410: wf_event.AddParameterToList(p_name=> 'PARTNER_DOCUMENT_NO',

Line 410: wf_event.AddParameterToList(p_name=> 'PARTNER_DOCUMENT_NO',

406: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_TXN_SUBTYPE',
407: p_value=> l_transaction_type,
408: p_parameterlist=> l_parameter_list);
409:
410: wf_event.AddParameterToList(p_name=> 'PARTNER_DOCUMENT_NO',
411: p_value=> p_orig_sys_document_ref,
412: p_parameterlist=> l_parameter_list);
413:
414: wf_event.AddParameterToList(p_name=> 'DOCUMENT_NO',

Line 414: wf_event.AddParameterToList(p_name=> 'DOCUMENT_NO',

410: wf_event.AddParameterToList(p_name=> 'PARTNER_DOCUMENT_NO',
411: p_value=> p_orig_sys_document_ref,
412: p_parameterlist=> l_parameter_list);
413:
414: wf_event.AddParameterToList(p_name=> 'DOCUMENT_NO',
415: p_value=> l_order_number,
416: p_parameterlist=> l_parameter_list);
417:
418: wf_event.AddParameterToList(p_name=> 'DOCUMENT_REVISION_NO',

Line 418: wf_event.AddParameterToList(p_name=> 'DOCUMENT_REVISION_NO',

414: wf_event.AddParameterToList(p_name=> 'DOCUMENT_NO',
415: p_value=> l_order_number,
416: p_parameterlist=> l_parameter_list);
417:
418: wf_event.AddParameterToList(p_name=> 'DOCUMENT_REVISION_NO',
419: p_value=> p_change_sequence,
420: p_parameterlist=> l_parameter_list);
421:
422: IF l_org_id IS NULL THEN

Line 429: wf_event.AddParameterToList(p_name=> 'ORG_ID',

425: INTO l_org_id
426: FROM DUAL;
427: END IF;
428:
429: wf_event.AddParameterToList(p_name=> 'ORG_ID',
430: p_value=> l_org_id,
431: p_parameterlist=> l_parameter_list);
432:
433:

Line 434: wf_event.AddParameterToList(p_name=> 'ONT_DOC_STATUS',

430: p_value=> l_org_id,
431: p_parameterlist=> l_parameter_list);
432:
433:
434: wf_event.AddParameterToList(p_name=> 'ONT_DOC_STATUS',
435: p_value=> l_status,
436: p_parameterlist=> l_parameter_list);
437:
438: wf_event.AddParameterToList(p_name=> 'MESSAGE_TEXT',

Line 438: wf_event.AddParameterToList(p_name=> 'MESSAGE_TEXT',

434: wf_event.AddParameterToList(p_name=> 'ONT_DOC_STATUS',
435: p_value=> l_status,
436: p_parameterlist=> l_parameter_list);
437:
438: wf_event.AddParameterToList(p_name=> 'MESSAGE_TEXT',
439: p_value=> l_message_text,
440: p_parameterlist=> l_parameter_list);
441:
442: wf_event.AddParameterToList(p_name=> 'SUBSCRIBER_LIST',

Line 442: wf_event.AddParameterToList(p_name=> 'SUBSCRIBER_LIST',

438: wf_event.AddParameterToList(p_name=> 'MESSAGE_TEXT',
439: p_value=> l_message_text,
440: p_parameterlist=> l_parameter_list);
441:
442: wf_event.AddParameterToList(p_name=> 'SUBSCRIBER_LIST',
443: p_value=> 'ONT',
444: p_parameterlist=> l_parameter_list);
445:
446: wf_event.AddParameterToList(p_name=> 'ORDER_TYPE_ID',

Line 446: wf_event.AddParameterToList(p_name=> 'ORDER_TYPE_ID',

442: wf_event.AddParameterToList(p_name=> 'SUBSCRIBER_LIST',
443: p_value=> 'ONT',
444: p_parameterlist=> l_parameter_list);
445:
446: wf_event.AddParameterToList(p_name=> 'ORDER_TYPE_ID',
447: p_value=> p_order_type_id,
448: p_parameterlist=> l_parameter_list);
449:
450: wf_event.AddParameterToList(p_name=> 'HEADER_ID',

Line 450: wf_event.AddParameterToList(p_name=> 'HEADER_ID',

446: wf_event.AddParameterToList(p_name=> 'ORDER_TYPE_ID',
447: p_value=> p_order_type_id,
448: p_parameterlist=> l_parameter_list);
449:
450: wf_event.AddParameterToList(p_name=> 'HEADER_ID',
451: p_value=> p_header_id,
452: p_parameterlist=> l_parameter_list);
453:
454: wf_event.AddParameterToList(p_name=> 'ORDER_PROCESSED_FLAG',

Line 454: wf_event.AddParameterToList(p_name=> 'ORDER_PROCESSED_FLAG',

450: wf_event.AddParameterToList(p_name=> 'HEADER_ID',
451: p_value=> p_header_id,
452: p_parameterlist=> l_parameter_list);
453:
454: wf_event.AddParameterToList(p_name=> 'ORDER_PROCESSED_FLAG',
455: p_value=> l_order_processed_flag,
456: p_parameterlist=> l_parameter_list);
457:
458: wf_event.raise( p_event_name => 'oracle.apps.ont.oi.xml_int.status',

Line 458: wf_event.raise( p_event_name => 'oracle.apps.ont.oi.xml_int.status',

454: wf_event.AddParameterToList(p_name=> 'ORDER_PROCESSED_FLAG',
455: p_value=> l_order_processed_flag,
456: p_parameterlist=> l_parameter_list);
457:
458: wf_event.raise( p_event_name => 'oracle.apps.ont.oi.xml_int.status',
459: p_event_key => l_eventkey,
460: p_parameters => l_parameter_list);
461:
462: l_parameter_list.delete;