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 IGS_RE_CANDIDATURE

Line 20: p_seq_num igs_re_candidature.sequence_number%TYPE) IS

16: in enrp_assign_timeslot procedure as a part of bug#4958173.
17: ******************************************************************/
18:
19: CURSOR c_research( p_person_id igs_pe_person.person_id%TYPE,
20: p_seq_num igs_re_candidature.sequence_number%TYPE) IS
21: SELECT sca_course_cd, research_topic
22: FROM igs_re_candidature
23: WHERE person_id = p_person_id
24: AND sequence_number = p_seq_num;

Line 22: FROM igs_re_candidature

18:
19: CURSOR c_research( p_person_id igs_pe_person.person_id%TYPE,
20: p_seq_num igs_re_candidature.sequence_number%TYPE) IS
21: SELECT sca_course_cd, research_topic
22: FROM igs_re_candidature
23: WHERE person_id = p_person_id
24: AND sequence_number = p_seq_num;
25:
26: CURSOR c_thesis ( p_person_id igs_pe_person.person_id%TYPE,

Line 293: FROM igs_re_candidature

289: -- Getting the course Code for the research canditure
290:
291: CURSOR cur_course_cd IS
292: SELECT sca_course_cd
293: FROM igs_re_candidature
294: WHERE person_id = p_personid
295: AND sequence_number = p_ca_seq_num;
296:
297: l_cur_prof_value cur_prof_value%ROWTYPE;

Line 422: FROM igs_re_candidature

418: -- Getting the course Code for the research canditure
419:
420: CURSOR cur_course_cd IS
421: SELECT sca_course_cd
422: FROM igs_re_candidature
423: WHERE person_id = p_personid
424: AND sequence_number = p_ca_seq_num;
425:
426: -- Getting the Start Date for the research Supervisor.

Line 1662: l_programcd igs_re_candidature.sca_course_cd%TYPE;

1658: l_event_t wf_event_t;
1659: l_parameter_list_t wf_parameter_list_t;
1660: l_itemKey varchar2(100);
1661: ln_seq_val NUMBER;
1662: l_programcd igs_re_candidature.sca_course_cd%TYPE;
1663: l_res_topic igs_re_candidature.research_topic%TYPE;
1664:
1665: -- Gets a unique sequence number
1666:

Line 1663: l_res_topic igs_re_candidature.research_topic%TYPE;

1659: l_parameter_list_t wf_parameter_list_t;
1660: l_itemKey varchar2(100);
1661: ln_seq_val NUMBER;
1662: l_programcd igs_re_candidature.sca_course_cd%TYPE;
1663: l_res_topic igs_re_candidature.research_topic%TYPE;
1664:
1665: -- Gets a unique sequence number
1666:
1667: CURSOR c_seq_num IS

Line 1839: l_programcd igs_re_candidature.sca_course_cd%TYPE;

1835: l_event_t wf_event_t;
1836: l_parameter_list_t wf_parameter_list_t;
1837: l_itemKey varchar2(100);
1838: ln_seq_val NUMBER;
1839: l_programcd igs_re_candidature.sca_course_cd%TYPE;
1840: l_res_topic igs_re_candidature.research_topic%TYPE;
1841:
1842: -- Gets a unique sequence number
1843:

Line 1840: l_res_topic igs_re_candidature.research_topic%TYPE;

1836: l_parameter_list_t wf_parameter_list_t;
1837: l_itemKey varchar2(100);
1838: ln_seq_val NUMBER;
1839: l_programcd igs_re_candidature.sca_course_cd%TYPE;
1840: l_res_topic igs_re_candidature.research_topic%TYPE;
1841:
1842: -- Gets a unique sequence number
1843:
1844: CURSOR c_seq_num IS

Line 1998: l_programcd igs_re_candidature.sca_course_cd%TYPE;

1994: l_event_t wf_event_t;
1995: l_parameter_list_t wf_parameter_list_t;
1996: l_itemKey varchar2(100);
1997: ln_seq_val NUMBER;
1998: l_programcd igs_re_candidature.sca_course_cd%TYPE;
1999: l_res_topic igs_re_candidature.research_topic%TYPE;
2000:
2001: -- Gets a unique sequence number
2002:

Line 1999: l_res_topic igs_re_candidature.research_topic%TYPE;

1995: l_parameter_list_t wf_parameter_list_t;
1996: l_itemKey varchar2(100);
1997: ln_seq_val NUMBER;
1998: l_programcd igs_re_candidature.sca_course_cd%TYPE;
1999: l_res_topic igs_re_candidature.research_topic%TYPE;
2000:
2001: -- Gets a unique sequence number
2002:
2003: CURSOR c_seq_num IS

Line 2144: l_programcd igs_re_candidature.sca_course_cd%TYPE;

2140: l_event_t wf_event_t;
2141: l_parameter_list_t wf_parameter_list_t;
2142: l_itemKey varchar2(100);
2143: ln_seq_val NUMBER;
2144: l_programcd igs_re_candidature.sca_course_cd%TYPE;
2145: l_res_topic igs_re_candidature.research_topic%TYPE;
2146:
2147: -- Gets a unique sequence number
2148:

Line 2145: l_res_topic igs_re_candidature.research_topic%TYPE;

2141: l_parameter_list_t wf_parameter_list_t;
2142: l_itemKey varchar2(100);
2143: ln_seq_val NUMBER;
2144: l_programcd igs_re_candidature.sca_course_cd%TYPE;
2145: l_res_topic igs_re_candidature.research_topic%TYPE;
2146:
2147: -- Gets a unique sequence number
2148:
2149: CURSOR c_seq_num IS

Line 2170: FROM igs_re_candidature

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
2169: SELECT research_topic,sequence_number
2170: FROM igs_re_candidature
2171: WHERE person_id = p_personid
2172: AND sca_course_cd = p_programcd ;
2173:
2174: CURSOR cur_course_type (p_programcd igs_ps_ver.course_cd%TYPE ) IS

Line 2300: FROM igs_en_stdnt_ps_att spa, igs_re_candidature re

2296: -- and have a research record.
2297:
2298: CURSOR cur_prog_atmpt IS
2299: SELECT spa.person_id, spa.course_cd, re.sequence_number, spa.attendance_type, re.research_topic
2300: FROM igs_en_stdnt_ps_att spa, igs_re_candidature re
2301: WHERE spa.person_id = re.person_id
2302: AND spa.course_cd = re.sca_course_cd
2303: AND spa.course_attempt_status NOT IN ('LAPSED','DISCONTIN');
2304: