APPS.IBU_SUBS_EMAIL_PKG dependencies on DUAL

Line 105: -- get_seq varchar2(50) := 'select ' || 'IBU_NOTIFICATION_S' || '.nextval from dual';

101: cnt number := 0;
102: l_user varchar2(50);
103: seq number := 0;
104: create_seq varchar2(50) := 'create sequence IBU_NOTIFICATION_S';
105: -- get_seq varchar2(50) := 'select ' || 'IBU_NOTIFICATION_S' || '.nextval from dual';
106: get_seq varchar2(50) := 'select ' || 'IBU_WF_ITEM_KEY_S' || '.nextval from dual';
107: TYPE IBU_STRING_ARRAY IS VARRAY(10) OF VARCHAR2(32767); -- mk changed from 4000 to 32767
108: arr IBU_STRING_ARRAY;
109: l_content varchar2(32766);

Line 106: get_seq varchar2(50) := 'select ' || 'IBU_WF_ITEM_KEY_S' || '.nextval from dual';

102: l_user varchar2(50);
103: seq number := 0;
104: create_seq varchar2(50) := 'create sequence IBU_NOTIFICATION_S';
105: -- get_seq varchar2(50) := 'select ' || 'IBU_NOTIFICATION_S' || '.nextval from dual';
106: get_seq varchar2(50) := 'select ' || 'IBU_WF_ITEM_KEY_S' || '.nextval from dual';
107: TYPE IBU_STRING_ARRAY IS VARRAY(10) OF VARCHAR2(32767); -- mk changed from 4000 to 32767
108: arr IBU_STRING_ARRAY;
109: l_content varchar2(32766);
110:

Line 118: select user into l_user from dual;

114:
115: begin
116:
117: /* Get schema name */
118: select user into l_user from dual;
119:
120: /* Get sequence for item key to be unique */
121: /* select count(*)
122: into cnt