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_GEN_002 dependencies on IGS_RE_THESIS

Line 47: FROM IGS_RE_THESIS the

43: v_mil_dummy_rec VARCHAR2(1);
44: v_sch_dummy_rec VARCHAR2(1);
45: CURSOR c_the IS
46: SELECT 'X'
47: FROM IGS_RE_THESIS the
48: WHERE the.person_id = p_person_id AND
49: the.ca_sequence_number = p_ca_sequence_number AND
50: the.logical_delete_dt IS NULL;
51: CURSOR c_cafos IS

Line 88: --Validate for the existence of IGS_RE_THESIS details

84: p_supervisor_exists := FALSE;
85: p_milestone_exists := FALSE;
86: p_scholarship_exists := FALSE;
87: IF p_check_thesis THEN
88: --Validate for the existence of IGS_RE_THESIS details
89: OPEN c_the;
90: FETCH c_the INTO v_the_dummy_rec;
91: IF (c_the%FOUND) THEN
92: CLOSE c_the;

Line 992: -- specified IGS_RE_THESIS.

988: AS
989: BEGIN -- resp_get_the_exists
990: -- This modulew returns output oarameters indicating whether
991: -- or not data exists on IGS_RE_CANDIDATURE detail tables for the
992: -- specified IGS_RE_THESIS.
993: DECLARE
994: v_the_found VARCHAR2(1);
995: v_mil_found VARCHAR2(1);
996: CURSOR c_the IS

Line 998: FROM IGS_RE_THESIS_EXAM tex

994: v_the_found VARCHAR2(1);
995: v_mil_found VARCHAR2(1);
996: CURSOR c_the IS
997: SELECT 'x'
998: FROM IGS_RE_THESIS_EXAM tex
999: WHERE tex.person_id = p_person_id AND
1000: tex.ca_sequence_number = p_ca_sequence_number AND
1001: tex.the_sequence_number = p_the_sequence_number;
1002: CURSOR c_mil IS

Line 1011: -- Check IGS_RE_THESIS exam

1007: BEGIN
1008: -- Initialise output parameters.
1009: p_thesis_exam_exists := FALSE;
1010: p_milestone_exists := FALSE;
1011: -- Check IGS_RE_THESIS exam
1012: IF p_check_thesis_exam THEN
1013: OPEN c_the;
1014: FETCH c_the INTO v_the_found;
1015: IF c_the%FOUND THEN

Line 1060: -- Get the IGS_RE_THESIS status.

1056: p_logical_delete_dt IN DATE ,
1057: p_thesis_result_cd IN VARCHAR2 )
1058: RETURN VARCHAR2 AS
1059: BEGIN -- resp_get_the_status
1060: -- Get the IGS_RE_THESIS status.
1061: -- Values are:
1062: -- PENDING - IGS_RE_THESIS detail has been keyed, but has not yet been submitted
1063: -- SUBMITTED - IGS_RE_THESIS has been submitted and is being processed in some way
1064: -- EXAMINED - IGS_RE_THESIS has been submitted and examined and a final outcome

Line 1062: -- PENDING - IGS_RE_THESIS detail has been keyed, but has not yet been submitted

1058: RETURN VARCHAR2 AS
1059: BEGIN -- resp_get_the_status
1060: -- Get the IGS_RE_THESIS status.
1061: -- Values are:
1062: -- PENDING - IGS_RE_THESIS detail has been keyed, but has not yet been submitted
1063: -- SUBMITTED - IGS_RE_THESIS has been submitted and is being processed in some way
1064: -- EXAMINED - IGS_RE_THESIS has been submitted and examined and a final outcome
1065: -- entered.
1066: -- DELETED - IGS_RE_THESIS has been logically deleted and no longer applies to the

Line 1063: -- SUBMITTED - IGS_RE_THESIS has been submitted and is being processed in some way

1059: BEGIN -- resp_get_the_status
1060: -- Get the IGS_RE_THESIS status.
1061: -- Values are:
1062: -- PENDING - IGS_RE_THESIS detail has been keyed, but has not yet been submitted
1063: -- SUBMITTED - IGS_RE_THESIS has been submitted and is being processed in some way
1064: -- EXAMINED - IGS_RE_THESIS has been submitted and examined and a final outcome
1065: -- entered.
1066: -- DELETED - IGS_RE_THESIS has been logically deleted and no longer applies to the
1067: -- research

Line 1064: -- EXAMINED - IGS_RE_THESIS has been submitted and examined and a final outcome

1060: -- Get the IGS_RE_THESIS status.
1061: -- Values are:
1062: -- PENDING - IGS_RE_THESIS detail has been keyed, but has not yet been submitted
1063: -- SUBMITTED - IGS_RE_THESIS has been submitted and is being processed in some way
1064: -- EXAMINED - IGS_RE_THESIS has been submitted and examined and a final outcome
1065: -- entered.
1066: -- DELETED - IGS_RE_THESIS has been logically deleted and no longer applies to the
1067: -- research
1068: DECLARE

Line 1066: -- DELETED - IGS_RE_THESIS has been logically deleted and no longer applies to the

1062: -- PENDING - IGS_RE_THESIS detail has been keyed, but has not yet been submitted
1063: -- SUBMITTED - IGS_RE_THESIS has been submitted and is being processed in some way
1064: -- EXAMINED - IGS_RE_THESIS has been submitted and examined and a final outcome
1065: -- entered.
1066: -- DELETED - IGS_RE_THESIS has been logically deleted and no longer applies to the
1067: -- research
1068: DECLARE
1069: cst_deleted CONSTANT VARCHAR2(10) := 'DELETED';
1070: cst_examined CONSTANT VARCHAR2(10) := 'EXAMINED';

Line 1076: FROM IGS_RE_THESIS thes

1072: cst_pending CONSTANT VARCHAR2(10) := 'PENDING';
1073: CURSOR c_the IS
1074: SELECT thes.logical_delete_dt,
1075: thes.thesis_result_cd
1076: FROM IGS_RE_THESIS thes
1077: WHERE thes.person_id = p_person_id AND
1078: thes.ca_sequence_number = p_ca_sequence_number AND
1079: thes.sequence_number = p_the_sequence_number;
1080: v_the_rec c_the%ROWTYPE;

Line 1083: FROM IGS_RE_THESIS_EXAM tex

1079: thes.sequence_number = p_the_sequence_number;
1080: v_the_rec c_the%ROWTYPE;
1081: CURSOR c_tex IS
1082: SELECT 'x'
1083: FROM IGS_RE_THESIS_EXAM tex
1084: WHERE person_id = p_person_id AND
1085: ca_sequence_number = p_ca_sequence_number AND
1086: the_sequence_number = p_the_sequence_number AND
1087: submission_dt IS NOT NULL;

Line 1091: --Select details from the IGS_RE_THESIS table.

1087: submission_dt IS NOT NULL;
1088: v_tex_exists VARCHAR2(1);
1089: BEGIN
1090: IF p_details_passed_ind = 'N' THEN
1091: --Select details from the IGS_RE_THESIS table.
1092: OPEN c_the;
1093: FETCH c_the INTO v_the_rec;
1094: IF c_the%NOTFOUND THEN
1095: CLOSE c_the;

Line 1111: --Select detail from the IGS_RE_THESIS examinations section

1107: --If final outcome exists then return examined-any submissions are irrelevant
1108: IF v_the_rec.thesis_result_cd IS NOT NULL THEN
1109: RETURN cst_examined;
1110: END IF;
1111: --Select detail from the IGS_RE_THESIS examinations section
1112: OPEN c_tex;
1113: FETCH c_tex INTO v_tex_exists;
1114: IF c_tex%FOUND THEN
1115: CLOSE c_tex;