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_PE_PERSON

Line 19: CURSOR c_research( p_person_id igs_pe_person.person_id%TYPE,

15: ckasu 17-JAN-2006 Added igs_ge_gen_003.set_org_id(NULL)
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

Line 26: CURSOR c_thesis ( p_person_id igs_pe_person.person_id%TYPE,

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,
27: p_ca_seq_num igs_re_thesis.ca_sequence_number%TYPE,
28: p_seq_num igs_re_thesis.sequence_number%TYPE) IS
29: SELECT title, thesis_topic
30: FROM igs_re_thesis

Line 690: CURSOR c_full_name (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

686: AND ROLE_ORIG_SYSTEM_ID = 0;
687:
688: l_dup_user NUMBER :=0;
689:
690: CURSOR c_full_name (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
691: SELECT full_name
692: FROM igs_pe_person_base_v
693: WHERE person_id = cp_person_id;
694:

Line 692: FROM igs_pe_person_base_v

688: l_dup_user NUMBER :=0;
689:
690: CURSOR c_full_name (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
691: SELECT full_name
692: FROM igs_pe_person_base_v
693: WHERE person_id = cp_person_id;
694:
695: l_c_full_name c_full_name%ROWTYPE;
696:

Line 848: CURSOR c_full_name (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

844: AND ROLE_ORIG_SYSTEM_ID = 0;
845:
846: l_dup_user NUMBER :=0;
847:
848: CURSOR c_full_name (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
849: SELECT full_name
850: FROM igs_pe_person_base_v
851: WHERE person_id = cp_person_id;
852:

Line 850: FROM igs_pe_person_base_v

846: l_dup_user NUMBER :=0;
847:
848: CURSOR c_full_name (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
849: SELECT full_name
850: FROM igs_pe_person_base_v
851: WHERE person_id = cp_person_id;
852:
853: l_c_full_name c_full_name%ROWTYPE;
854:

Line 1044: CURSOR c_full_name (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

1040: AND ROLE_ORIG_SYSTEM_ID = 0;
1041:
1042: l_dup_user NUMBER :=0;
1043:
1044: CURSOR c_full_name (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1045: SELECT full_name
1046: FROM igs_pe_person_base_v
1047: WHERE person_id = cp_person_id;
1048:

Line 1046: FROM igs_pe_person_base_v

1042: l_dup_user NUMBER :=0;
1043:
1044: CURSOR c_full_name (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1045: SELECT full_name
1046: FROM igs_pe_person_base_v
1047: WHERE person_id = cp_person_id;
1048:
1049: l_c_full_name c_full_name%ROWTYPE;
1050: l_c_full_name_sup c_full_name%ROWTYPE;

Line 1380: CURSOR c_full_name (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

1376: AND ROLE_ORIG_SYSTEM_ID = 0;
1377:
1378: l_dup_user NUMBER :=0;
1379:
1380: CURSOR c_full_name (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1381: SELECT full_name
1382: FROM igs_pe_person_base_v
1383: WHERE person_id = cp_person_id;
1384:

Line 1382: FROM igs_pe_person_base_v

1378: l_dup_user NUMBER :=0;
1379:
1380: CURSOR c_full_name (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1381: SELECT full_name
1382: FROM igs_pe_person_base_v
1383: WHERE person_id = cp_person_id;
1384:
1385: l_c_full_name c_full_name%ROWTYPE;
1386:

Line 1685: CURSOR cur_prog_ver ( p_person_id igs_pe_person.person_id%TYPE,

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
1687: SELECT course_cd , version_number, attendance_type
1688: FROM igs_en_stdnt_ps_att
1689: WHERE person_id = p_person_id

Line 1862: CURSOR cur_prog_stat ( p_person_id igs_pe_person.person_id%TYPE,

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
1864: SELECT course_attempt_status
1865: FROM igs_en_stdnt_ps_att
1866: WHERE person_id = p_person_id

Line 2167: CURSOR cur_res_top (p_personid igs_pe_person_base_v.person_id%TYPE,

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
2169: SELECT research_topic,sequence_number
2170: FROM igs_re_candidature
2171: WHERE person_id = p_personid

Line 2308: CURSOR cur_achived_milestone ( p_person_id igs_pe_person_base_v.person_id%TYPE,

2304:
2305: -- For each person program attempt identified above select the milestone records, which do not have the
2306: -- status of 'ACHIEVED' and the due date is less than SYSDATE.
2307:
2308: CURSOR cur_achived_milestone ( p_person_id igs_pe_person_base_v.person_id%TYPE,
2309: p_seq_num igs_pr_milestone.ca_sequence_number%TYPE
2310: )IS
2311: SELECT a.due_dt, NVL(ovrd_ntfctn_imminent_days, b.NTFCTN_IMMINENT_DAYS) ovrd_ntfctn_imminent_days,
2312: nvl(ovrd_ntfctn_reminder_days, b.NTFCTN_REMINDER_DAYS) ovrd_ntfctn_reminder_days,

Line 2533: CURSOR c_full_name (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

2529: AND ROLE_ORIG_SYSTEM_ID = 0;
2530:
2531: l_dup_user NUMBER :=0;
2532:
2533: CURSOR c_full_name (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
2534: SELECT full_name
2535: FROM igs_pe_person_base_v
2536: WHERE person_id = cp_person_id;
2537:

Line 2535: FROM igs_pe_person_base_v

2531: l_dup_user NUMBER :=0;
2532:
2533: CURSOR c_full_name (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
2534: SELECT full_name
2535: FROM igs_pe_person_base_v
2536: WHERE person_id = cp_person_id;
2537:
2538: l_c_full_name c_full_name%ROWTYPE;
2539:

Line 2699: CURSOR c_person_info (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

2695: ) AS
2696:
2697: l_person_id VARCHAR2(50);
2698:
2699: CURSOR c_person_info (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
2700: SELECT full_name , person_number
2701: FROM igs_pe_person_base_v
2702: WHERE person_id = cp_person_id;
2703:

Line 2701: FROM igs_pe_person_base_v

2697: l_person_id VARCHAR2(50);
2698:
2699: CURSOR c_person_info (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
2700: SELECT full_name , person_number
2701: FROM igs_pe_person_base_v
2702: WHERE person_id = cp_person_id;
2703:
2704: CURSOR c_status (l_lookup_code fnd_lookups.lookup_code%TYPE)IS
2705: SELECT meaning

Line 2763: CURSOR c_person_info (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

2759: ) AS
2760:
2761: l_person_id VARCHAR2(50);
2762:
2763: CURSOR c_person_info (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
2764: SELECT full_name , person_number
2765: FROM igs_pe_person_base_v
2766: WHERE person_id = cp_person_id;
2767:

Line 2765: FROM igs_pe_person_base_v

2761: l_person_id VARCHAR2(50);
2762:
2763: CURSOR c_person_info (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
2764: SELECT full_name , person_number
2765: FROM igs_pe_person_base_v
2766: WHERE person_id = cp_person_id;
2767:
2768:
2769: l_c_person_info c_person_info%ROWTYPE;