DBA Data[Home] [Help]

APPS.IGS_AS_GRD_ATT_BE_PKG dependencies on DUAL

Line 43: FROM dual;

39: l_itemKey varchar2(100);
40:
41: CURSOR cur_seq IS
42: SELECT IGS_EN_WF_MAILADM_S.NEXTVAL
43: FROM dual;
44:
45: BEGIN
46: --Changing Date to Character
47: -- l_request_date := TO_CHAR(p_request_date,'DD-MON-YY');

Line 135: FROM dual;

131: l_itemKey varchar2(100);
132:
133: CURSOR cur_seq1 IS
134: SELECT IGS_EN_WF_MAILADM_S.NEXTVAL
135: FROM dual;
136:
137: BEGIN
138:
139: --

Line 208: FROM dual;

204: l_itemKey varchar2(100);
205:
206: CURSOR cur_seq3 IS
207: SELECT IGS_EN_WF_MAILADM_S.NEXTVAL
208: FROM dual;
209: BEGIN
210:
211: --
212: -- initialize the wf_event_t object

Line 277: FROM dual;

273: l_itemKey varchar2(100);
274:
275: CURSOR cur_seq4 IS
276: SELECT IGS_EN_WF_MAILADM_S.NEXTVAL
277: FROM dual;
278: BEGIN
279:
280: --
281: -- initialize the wf_event_t object

Line 347: FROM dual;

343: l_itemKey varchar2(100);
344:
345: CURSOR cur_seq5 IS
346: SELECT IGS_EN_WF_MAILADM_S.NEXTVAL
347: FROM dual;
348:
349: BEGIN
350:
351: --

Line 417: FROM dual;

413: l_itemKey varchar2(100);
414:
415: CURSOR cur_seq2 IS
416: SELECT IGS_EN_WF_MAILADM_S.NEXTVAL
417: FROM dual;
418:
419: BEGIN
420: --
421: -- initialize the wf_event_t object