APPS.IBE_WFNOTIFICATION_PVT dependencies on DUAL

Line 25: select IBE_WFNOTIFICATION_S1.NEXTVAL into wf_itemkey_seq from dual;

21: -- DBMS_OUTPUT.put_line('user_name: ' || user_name );
22: -- DBMS_OUTPUT.put_line('subject: ' || subject );
23: -- DBMS_OUTPUT.put_line('body: ' || body );
24:
25: select IBE_WFNOTIFICATION_S1.NEXTVAL into wf_itemkey_seq from dual;
26: wf_itemkey := 'IBE_USER_' || wf_itemkey_seq;
27:
28: wf_engine.CreateProcess (
29: itemtype => 'IBE_USER',

Line 104: select IBE_WFNOTIFICATION_S2.NEXTVAL into wf_itemkey_seq from dual;

100: -- DBMS_OUTPUT.put_line('email_list: ' || email_list );
101: -- DBMS_OUTPUT.put_line('subject: ' || subject );
102: -- DBMS_OUTPUT.put_line('body: ' || body );
103:
104: select IBE_WFNOTIFICATION_S2.NEXTVAL into wf_itemkey_seq from dual;
105: wf_itemkey := 'IBE_MAIL_' || wf_itemkey_seq;
106:
107: role_name := 'IBE_EMAIL_LIST_' || wf_itemkey_seq ;
108: role_display_name := 'IBE_EMAIL_LIST_' || wf_itemkey_seq ;

Line 195: select IBE_WFNOTIFICATION_S2.NEXTVAL into wf_itemkey_seq from dual;

191: -- DBMS_OUTPUT.put_line('email_list: ' || email_list );
192: -- DBMS_OUTPUT.put_line('subject: ' || subject );
193: -- DBMS_OUTPUT.put_line('body: ' || body );
194:
195: select IBE_WFNOTIFICATION_S2.NEXTVAL into wf_itemkey_seq from dual;
196: wf_itemkey := 'IBE_MAIL_' || wf_itemkey_seq;
197:
198: role_name := 'IBE_EMAIL_LIST_' || wf_itemkey_seq ;
199: role_display_name := 'IBE_EMAIL_LIST_' || wf_itemkey_seq ;