APPS.IGS_EN_WLST_GEN_PROC dependencies on DUAL

Line 209: SELECT igs_en_inform_stud_s.NEXTVAL INTO l_key FROM dual;

205: IF (RTRIM(l_wf_installed) ='Y') THEN
206: --
207: -- set the event key but before the select a number from sequenec
208: --
209: SELECT igs_en_inform_stud_s.NEXTVAL INTO l_key FROM dual;
210: --
211: -- now add the parameters to the parameter list
212: --
213: wf_event.AddParameterToList( p_Name => 'P_ORG_ID', p_Value => p_org_id, p_parameterlist =>l_wf_parameter_list_t);

Line 262: SELECT IGS_EN_WF_MAILSTUD_S.NEXTVAL INTO l_key FROM dual;

258: fnd_profile.get('IGS_WF_ENABLE',l_wf_installed);
259:
260: -- if workflow is installed then carry on with the raising an event
261: IF (RTRIM(l_wf_installed) ='Y') THEN
262: SELECT IGS_EN_WF_MAILSTUD_S.NEXTVAL INTO l_key FROM dual;
263: --
264: -- now add the parameters to the parameter list
265: --
266: wf_event.AddParameterToList(p_name => 'ORG_ID', p_value => p_org_id, p_parameterlist => l_param_list);

Line 737: SELECT igs_en_wf_be_en001_s.NEXTVAL INTO l_key FROM dual;

733:
734:
735: -- Workflow notification ------------------------------
736:
737: SELECT igs_en_wf_be_en001_s.NEXTVAL INTO l_key FROM dual;
738:
739: WF_EVENT.AddParameterToList(p_name => 'TOTAL_STDNT_COUNT',p_value =>l_tot_stud,p_parameterlist => l_param_list);
740: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.be_en001',
741: p_event_key => 'wlst_pos_change'|| l_key,