DBA Data[Home] [Help]

APPS.EAM_OP_COMP dependencies on WF_EVENT

Line 105: l_wf_event_seq NUMBER;

101: l_workflow_type NUMBER;
102: l_is_last_operation VARCHAR2(1);
103: l_parameter_list wf_parameter_list_t;
104: l_event_key VARCHAR2(200);
105: l_wf_event_seq NUMBER;
106: l_op_sched_end_date DATE;
107: l_wip_entity_name VARCHAR2(240);
108:
109: --bug 3572376: pass following parameters to EAM_ASSET_STATUS_HISTORY

Line 535: AND (Wf_Event.TEST(l_op_completed_event)<>'NONE' ) ) THEN

531: l_workflow_enabled:= Is_Workflow_Enabled(l_maint_obj_source,l_organization_id);
532: l_op_completed_event := 'oracle.apps.eam.workorder.operation.completed';
533:
534: IF(l_workflow_enabled='Y' AND (p_transaction_type = 1)
535: AND (Wf_Event.TEST(l_op_completed_event)<>'NONE' ) ) THEN
536:
537: l_is_last_operation := 'N';
538: select DECODE(count(won.next_operation),0,'Y','N')
539: INTO l_is_last_operation

Line 545: INTO l_wf_event_seq

541: where won.wip_entity_id = p_wip_entity_id and
542: won.prior_operation =p_operation_seq_num;
543:
544: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
545: INTO l_wf_event_seq
546: FROM DUAL;
547:
548: l_parameter_list := wf_parameter_list_t();
549:

Line 550: l_event_key := TO_CHAR(l_wf_event_seq);

546: FROM DUAL;
547:
548: l_parameter_list := wf_parameter_list_t();
549:
550: l_event_key := TO_CHAR(l_wf_event_seq);
551: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Op Completed event','Building parameter list');
552: -- Add Parameters
553: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
554: p_value => TO_CHAR(p_wip_entity_id),

Line 553: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',

549:
550: l_event_key := TO_CHAR(l_wf_event_seq);
551: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Op Completed event','Building parameter list');
552: -- Add Parameters
553: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
554: p_value => TO_CHAR(p_wip_entity_id),
555: p_parameterlist => l_parameter_list);
556: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
557: p_value =>l_wip_entity_name,

Line 556: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',

552: -- Add Parameters
553: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
554: p_value => TO_CHAR(p_wip_entity_id),
555: p_parameterlist => l_parameter_list);
556: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
557: p_value =>l_wip_entity_name,
558: p_parameterlist => l_parameter_list);
559: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
560: p_value => TO_CHAR(l_organization_id),

Line 559: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',

555: p_parameterlist => l_parameter_list);
556: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
557: p_value =>l_wip_entity_name,
558: p_parameterlist => l_parameter_list);
559: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
560: p_value => TO_CHAR(l_organization_id),
561: p_parameterlist => l_parameter_list);
562: Wf_Event.AddParameterToList(p_name =>'ACTUAL_COMPLETION_DATE',
563: p_value => TO_CHAR(p_actual_end_date),

Line 562: Wf_Event.AddParameterToList(p_name =>'ACTUAL_COMPLETION_DATE',

558: p_parameterlist => l_parameter_list);
559: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
560: p_value => TO_CHAR(l_organization_id),
561: p_parameterlist => l_parameter_list);
562: Wf_Event.AddParameterToList(p_name =>'ACTUAL_COMPLETION_DATE',
563: p_value => TO_CHAR(p_actual_end_date),
564: p_parameterlist => l_parameter_list);
565: Wf_Event.AddParameterToList(p_name =>'SCHEDULED_COMPLETION_DATE',
566: p_value => TO_CHAR(l_op_sched_end_date),

Line 565: Wf_Event.AddParameterToList(p_name =>'SCHEDULED_COMPLETION_DATE',

561: p_parameterlist => l_parameter_list);
562: Wf_Event.AddParameterToList(p_name =>'ACTUAL_COMPLETION_DATE',
563: p_value => TO_CHAR(p_actual_end_date),
564: p_parameterlist => l_parameter_list);
565: Wf_Event.AddParameterToList(p_name =>'SCHEDULED_COMPLETION_DATE',
566: p_value => TO_CHAR(l_op_sched_end_date),
567: p_parameterlist => l_parameter_list);
568: Wf_Event.AddParameterToList(p_name =>'IS_LAST_OPERATION',
569: p_value => l_is_last_operation,

Line 568: Wf_Event.AddParameterToList(p_name =>'IS_LAST_OPERATION',

564: p_parameterlist => l_parameter_list);
565: Wf_Event.AddParameterToList(p_name =>'SCHEDULED_COMPLETION_DATE',
566: p_value => TO_CHAR(l_op_sched_end_date),
567: p_parameterlist => l_parameter_list);
568: Wf_Event.AddParameterToList(p_name =>'IS_LAST_OPERATION',
569: p_value => l_is_last_operation,
570: p_parameterlist => l_parameter_list);
571: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
572: p_value => TO_CHAR(l_workflow_type),

Line 571: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',

567: p_parameterlist => l_parameter_list);
568: Wf_Event.AddParameterToList(p_name =>'IS_LAST_OPERATION',
569: p_value => l_is_last_operation,
570: p_parameterlist => l_parameter_list);
571: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
572: p_value => TO_CHAR(l_workflow_type),
573: p_parameterlist => l_parameter_list);
574: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
575: p_value =>FND_GLOBAL.USER_NAME ,

Line 574: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',

570: p_parameterlist => l_parameter_list);
571: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
572: p_value => TO_CHAR(l_workflow_type),
573: p_parameterlist => l_parameter_list);
574: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
575: p_value =>FND_GLOBAL.USER_NAME ,
576: p_parameterlist => l_parameter_list);
577: --start of bug 10393826
578: Wf_Event.AddParameterToList(p_name =>'WIP_OP_SEQ_NUM',

Line 578: Wf_Event.AddParameterToList(p_name =>'WIP_OP_SEQ_NUM',

574: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
575: p_value =>FND_GLOBAL.USER_NAME ,
576: p_parameterlist => l_parameter_list);
577: --start of bug 10393826
578: Wf_Event.AddParameterToList(p_name =>'WIP_OP_SEQ_NUM',
579: p_value =>p_operation_seq_num,
580: p_parameterlist => l_parameter_list);
581: --end of bug 10393826
582: Wf_Event.Raise( p_event_name => l_op_completed_event,

Line 582: Wf_Event.Raise( p_event_name => l_op_completed_event,

578: Wf_Event.AddParameterToList(p_name =>'WIP_OP_SEQ_NUM',
579: p_value =>p_operation_seq_num,
580: p_parameterlist => l_parameter_list);
581: --end of bug 10393826
582: Wf_Event.Raise( p_event_name => l_op_completed_event,
583: p_event_key => l_event_key,
584: p_parameters => l_parameter_list);
585: l_parameter_list.DELETE;
586: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Operation Completed Event','After raising event');