eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_PROCESS_CLEARANCE_PVT dependencies on WF_EVENT

Line 382: IF(WF_EVENT.TEST(l_status_pending_event) <> 'NONE') THEN

378: AND (l_old_wc_header_rec.system_status <>l_work_clearance_header_rec.system_status)
379: )
380: ) THEN
381:
382: IF(WF_EVENT.TEST(l_status_pending_event) <> 'NONE') THEN
383:
384: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Calling Wkflow required check API...') ; END IF;
385:
386:

Line 636: l_wf_event_seq NUMBER;

632: l_status_pending_event VARCHAR2(240);
633: l_event_name VARCHAR2(240);
634: l_parameter_list wf_parameter_list_t;
635: l_event_key VARCHAR2(200);
636: l_wf_event_seq NUMBER;
637: l_return_status VARCHAR2(1);
638: l_msg_count NUMBER;
639: BEGIN
640:

Line 646: IF( p_approval_required AND (WF_EVENT.TEST(l_status_pending_event) <> 'NONE')) THEN

642: l_status_pending_event := 'oracle.apps.eam.clearance.status.change.pending';
643:
644:
645: --if status change needs approval
646: IF( p_approval_required AND (WF_EVENT.TEST(l_status_pending_event) <> 'NONE')) THEN
647:
648: SELECT EAM_SAFETYWORKFLOW_EVENT_S.NEXTVAL
649: INTO l_wf_event_seq
650: FROM DUAL;

Line 649: INTO l_wf_event_seq

645: --if status change needs approval
646: IF( p_approval_required AND (WF_EVENT.TEST(l_status_pending_event) <> 'NONE')) THEN
647:
648: SELECT EAM_SAFETYWORKFLOW_EVENT_S.NEXTVAL
649: INTO l_wf_event_seq
650: FROM DUAL;
651:
652: l_parameter_list := wf_parameter_list_t();
653: l_event_name := l_status_pending_event;

Line 655: l_event_key := TO_CHAR(l_wf_event_seq);

651:
652: l_parameter_list := wf_parameter_list_t();
653: l_event_name := l_status_pending_event;
654:
655: l_event_key := TO_CHAR(l_wf_event_seq);
656:
657: INSERT INTO EAM_SAFETY_WORKFLOWS
658: (OBJECT_ID,TRANSACTION_ID,WORKFLOW_TYPE,LAST_UPDATE_DATE,LAST_UPDATED_BY,
659: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)

Line 661: (p_eam_wc_rec.WORK_CLEARANCE_ID,l_wf_event_seq,2,SYSDATE,FND_GLOBAL.user_id,

657: INSERT INTO EAM_SAFETY_WORKFLOWS
658: (OBJECT_ID,TRANSACTION_ID,WORKFLOW_TYPE,LAST_UPDATE_DATE,LAST_UPDATED_BY,
659: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)
660: VALUES
661: (p_eam_wc_rec.WORK_CLEARANCE_ID,l_wf_event_seq,2,SYSDATE,FND_GLOBAL.user_id,
662: SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id
663: );
664:
665:

Line 668: Wf_Event.AddParameterToList(p_name =>'WORK_CLEARANCE_ID',

664:
665:
666: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Permit Released change event','Building parameter list');
667: -- Add Parameters
668: Wf_Event.AddParameterToList(p_name =>'WORK_CLEARANCE_ID',
669: p_value => TO_CHAR(p_eam_wc_rec.WORK_CLEARANCE_ID),
670: p_parameterlist => l_parameter_list);
671: Wf_Event.AddParameterToList(p_name =>'WORK_CLEARANCE_NAME',
672: p_value =>p_eam_wc_rec.WORK_CLEARANCE_NAME,

Line 671: Wf_Event.AddParameterToList(p_name =>'WORK_CLEARANCE_NAME',

667: -- Add Parameters
668: Wf_Event.AddParameterToList(p_name =>'WORK_CLEARANCE_ID',
669: p_value => TO_CHAR(p_eam_wc_rec.WORK_CLEARANCE_ID),
670: p_parameterlist => l_parameter_list);
671: Wf_Event.AddParameterToList(p_name =>'WORK_CLEARANCE_NAME',
672: p_value =>p_eam_wc_rec.WORK_CLEARANCE_NAME,
673: p_parameterlist => l_parameter_list);
674: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
675: p_value => TO_CHAR(p_eam_wc_rec.organization_id),

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

670: p_parameterlist => l_parameter_list);
671: Wf_Event.AddParameterToList(p_name =>'WORK_CLEARANCE_NAME',
672: p_value =>p_eam_wc_rec.WORK_CLEARANCE_NAME,
673: p_parameterlist => l_parameter_list);
674: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
675: p_value => TO_CHAR(p_eam_wc_rec.organization_id),
676: p_parameterlist => l_parameter_list);
677: Wf_Event.AddParameterToList(p_name =>'NEW_USER_STATUS',
678: p_value => TO_CHAR(p_eam_wc_rec.user_defined_status),

Line 677: Wf_Event.AddParameterToList(p_name =>'NEW_USER_STATUS',

673: p_parameterlist => l_parameter_list);
674: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
675: p_value => TO_CHAR(p_eam_wc_rec.organization_id),
676: p_parameterlist => l_parameter_list);
677: Wf_Event.AddParameterToList(p_name =>'NEW_USER_STATUS',
678: p_value => TO_CHAR(p_eam_wc_rec.user_defined_status),
679: p_parameterlist => l_parameter_list);
680: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
681: p_value => TO_CHAR(p_eam_wc_rec.SYSTEM_STATUS),

Line 680: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',

676: p_parameterlist => l_parameter_list);
677: Wf_Event.AddParameterToList(p_name =>'NEW_USER_STATUS',
678: p_value => TO_CHAR(p_eam_wc_rec.user_defined_status),
679: p_parameterlist => l_parameter_list);
680: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
681: p_value => TO_CHAR(p_eam_wc_rec.SYSTEM_STATUS),
682: p_parameterlist => l_parameter_list);
683: Wf_Event.AddParameterToList(p_name =>'OLD_USER_STATUS',
684: p_value => TO_CHAR(p_old_eam_wc_rec.user_defined_status),

Line 683: Wf_Event.AddParameterToList(p_name =>'OLD_USER_STATUS',

679: p_parameterlist => l_parameter_list);
680: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
681: p_value => TO_CHAR(p_eam_wc_rec.SYSTEM_STATUS),
682: p_parameterlist => l_parameter_list);
683: Wf_Event.AddParameterToList(p_name =>'OLD_USER_STATUS',
684: p_value => TO_CHAR(p_old_eam_wc_rec.user_defined_status),
685: p_parameterlist => l_parameter_list);
686: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
687: p_value => TO_CHAR(p_new_system_status),

Line 686: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',

682: p_parameterlist => l_parameter_list);
683: Wf_Event.AddParameterToList(p_name =>'OLD_USER_STATUS',
684: p_value => TO_CHAR(p_old_eam_wc_rec.user_defined_status),
685: p_parameterlist => l_parameter_list);
686: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
687: p_value => TO_CHAR(p_new_system_status),
688: p_parameterlist => l_parameter_list);
689: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
690: p_value => TO_CHAR(2),

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

685: p_parameterlist => l_parameter_list);
686: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
687: p_value => TO_CHAR(p_new_system_status),
688: p_parameterlist => l_parameter_list);
689: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
690: p_value => TO_CHAR(2),
691: p_parameterlist => l_parameter_list);
692: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
693: p_value =>FND_GLOBAL.USER_NAME ,

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

688: p_parameterlist => l_parameter_list);
689: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
690: p_value => TO_CHAR(2),
691: p_parameterlist => l_parameter_list);
692: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
693: p_value =>FND_GLOBAL.USER_NAME ,
694: p_parameterlist => l_parameter_list);
695: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',
696: p_value => p_workflow_name,

Line 695: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',

691: p_parameterlist => l_parameter_list);
692: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
693: p_value =>FND_GLOBAL.USER_NAME ,
694: p_parameterlist => l_parameter_list);
695: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',
696: p_value => p_workflow_name,
697: p_parameterlist => l_parameter_list);
698: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_PROCESS',
699: p_value => p_workflow_process,

Line 698: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_PROCESS',

694: p_parameterlist => l_parameter_list);
695: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',
696: p_value => p_workflow_name,
697: p_parameterlist => l_parameter_list);
698: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_PROCESS',
699: p_value => p_workflow_process,
700: p_parameterlist => l_parameter_list);
701: Wf_Core.Context('Enterprise Asset Management...','Work Clearance Released Event','Raising event');
702:

Line 703: Wf_Event.Raise( p_event_name => l_event_name,

699: p_value => p_workflow_process,
700: p_parameterlist => l_parameter_list);
701: Wf_Core.Context('Enterprise Asset Management...','Work Clearance Released Event','Raising event');
702:
703: Wf_Event.Raise( p_event_name => l_event_name,
704: p_event_key => l_event_key,
705: p_parameters => l_parameter_list);
706: l_parameter_list.DELETE;
707: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Clearance Released Event','After raising event');