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.IGS_RE_WORKFLOW dependencies on DUAL

Line 167: FROM dual;

163: -- Gets a unique sequence number
164:
165: CURSOR c_seq_num IS
166: SELECT igs_re_retopc_s.NEXTVAL
167: FROM dual;
168:
169:
170: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
171:

Line 174: FROM dual;

170: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
171:
172: CURSOR cur_prof_value IS
173: SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
174: FROM dual;
175:
176: -- Getting the logged in User
177:
178: CURSOR cur_user_id IS

Line 180: FROM dual;

176: -- Getting the logged in User
177:
178: CURSOR cur_user_id IS
179: SELECT FND_GLOBAL.USER_ID user_id
180: FROM dual;
181:
182: l_cur_prof_value cur_prof_value%ROWTYPE;
183: l_cur_user_id cur_user_id%ROWTYPE;
184:

Line 274: FROM dual;

270: -- Gets a unique sequence number
271:
272: CURSOR c_seq_num IS
273: SELECT igs_re_thesis_s.NEXTVAL
274: FROM dual;
275:
276:
277: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
278:

Line 281: FROM dual;

277: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
278:
279: CURSOR cur_prof_value IS
280: SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
281: FROM dual;
282:
283: -- Getting the logged in User
284:
285: CURSOR cur_user_id IS

Line 287: FROM dual;

283: -- Getting the logged in User
284:
285: CURSOR cur_user_id IS
286: SELECT FND_GLOBAL.USER_ID user_id
287: FROM dual;
288:
289: -- Getting the course Code for the research canditure
290:
291: CURSOR cur_course_cd IS

Line 403: FROM dual;

399: -- Gets a unique sequence number
400:
401: CURSOR c_seq_num IS
402: SELECT igs_re_sprvsn_s.NEXTVAL
403: FROM dual;
404:
405:
406: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
407:

Line 410: FROM dual;

406: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
407:
408: CURSOR cur_prof_value IS
409: SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
410: FROM dual;
411:
412: -- Getting the logged in User
413:
414: CURSOR cur_user_id IS

Line 416: FROM dual;

412: -- Getting the logged in User
413:
414: CURSOR cur_user_id IS
415: SELECT FND_GLOBAL.USER_ID user_id
416: FROM dual;
417:
418: -- Getting the course Code for the research canditure
419:
420: CURSOR cur_course_cd IS

Line 553: FROM dual;

549: -- Gets a unique sequence number
550:
551: CURSOR c_seq_num IS
552: SELECT igs_en_ovrsub_s.NEXTVAL
553: FROM dual;
554:
555:
556: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
557:

Line 560: FROM dual;

556: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
557:
558: CURSOR cur_prof_value IS
559: SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
560: FROM dual;
561:
562: -- Getting the logged in User
563:
564: CURSOR cur_user_id IS

Line 566: FROM dual;

562: -- Getting the logged in User
563:
564: CURSOR cur_user_id IS
565: SELECT FND_GLOBAL.USER_ID user_id
566: FROM dual;
567:
568: l_cur_prof_value cur_prof_value%ROWTYPE;
569: l_cur_user_id cur_user_id%ROWTYPE;
570:

Line 1669: FROM dual;

1665: -- Gets a unique sequence number
1666:
1667: CURSOR c_seq_num IS
1668: SELECT igs_re_milstn_s.NEXTVAL
1669: FROM dual;
1670:
1671:
1672: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
1673:

Line 1676: FROM dual;

1672: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
1673:
1674: CURSOR cur_prof_value IS
1675: SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
1676: FROM dual;
1677:
1678: -- Getting the logged in User
1679:
1680: CURSOR cur_user_id IS

Line 1682: FROM dual;

1678: -- Getting the logged in User
1679:
1680: CURSOR cur_user_id IS
1681: SELECT FND_GLOBAL.USER_ID user_id
1682: FROM dual;
1683:
1684: --
1685: CURSOR cur_prog_ver ( p_person_id igs_pe_person.person_id%TYPE,
1686: p_course_cd igs_ps_ver.course_cd%TYPE)IS

Line 1846: FROM dual;

1842: -- Gets a unique sequence number
1843:
1844: CURSOR c_seq_num IS
1845: SELECT igs_re_exmsub_s.NEXTVAL
1846: FROM dual;
1847:
1848:
1849: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
1850:

Line 1853: FROM dual;

1849: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
1850:
1851: CURSOR cur_prof_value IS
1852: SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
1853: FROM dual;
1854:
1855: -- Getting the logged in User
1856:
1857: CURSOR cur_user_id IS

Line 1859: FROM dual;

1855: -- Getting the logged in User
1856:
1857: CURSOR cur_user_id IS
1858: SELECT FND_GLOBAL.USER_ID user_id
1859: FROM dual;
1860:
1861: --
1862: CURSOR cur_prog_stat ( p_person_id igs_pe_person.person_id%TYPE,
1863: p_course_cd igs_ps_ver.course_cd%TYPE)IS

Line 2005: FROM dual;

2001: -- Gets a unique sequence number
2002:
2003: CURSOR c_seq_num IS
2004: SELECT igs_re_resupd_s.NEXTVAL
2005: FROM dual;
2006:
2007:
2008: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
2009:

Line 2012: FROM dual;

2008: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
2009:
2010: CURSOR cur_prof_value IS
2011: SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
2012: FROM dual;
2013:
2014: -- Getting the logged in User
2015:
2016: CURSOR cur_user_id IS

Line 2018: FROM dual;

2014: -- Getting the logged in User
2015:
2016: CURSOR cur_user_id IS
2017: SELECT FND_GLOBAL.USER_ID user_id
2018: FROM dual;
2019:
2020:
2021:
2022: l_cur_prof_value cur_prof_value%ROWTYPE;

Line 2151: FROM dual;

2147: -- Gets a unique sequence number
2148:
2149: CURSOR c_seq_num IS
2150: SELECT igs_re_regcfm_s.NEXTVAL
2151: FROM dual;
2152:
2153:
2154: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
2155:

Line 2158: FROM dual;

2154: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
2155:
2156: CURSOR cur_prof_value IS
2157: SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
2158: FROM dual;
2159:
2160: -- Getting the logged in User
2161:
2162: CURSOR cur_user_id IS

Line 2164: FROM dual;

2160: -- Getting the logged in User
2161:
2162: CURSOR cur_user_id IS
2163: SELECT FND_GLOBAL.USER_ID user_id
2164: FROM dual;
2165:
2166:
2167: CURSOR cur_res_top (p_personid igs_pe_person_base_v.person_id%TYPE,
2168: p_programcd igs_ps_ver.course_cd%TYPE ) IS

Line 2280: FROM dual;

2276: -- Gets a unique sequence number
2277:
2278: CURSOR c_seq_num IS
2279: SELECT igs_re_milnot_s.NEXTVAL
2280: FROM dual;
2281:
2282:
2283: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
2284:

Line 2287: FROM dual;

2283: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
2284:
2285: CURSOR cur_prof_value IS
2286: SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
2287: FROM dual;
2288:
2289: -- Getting the logged in User
2290:
2291: CURSOR cur_user_id IS

Line 2293: FROM dual;

2289: -- Getting the logged in User
2290:
2291: CURSOR cur_user_id IS
2292: SELECT FND_GLOBAL.USER_ID user_id
2293: FROM dual;
2294:
2295: -- Identifying all the student program attempts which are not in the program attempt status of 'DISCONTIN' or 'LAPSED'
2296: -- and have a research record.
2297: