DBA Data[Home] [Help]

APPS.ECEPOI dependencies on WF_EVENT

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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