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_UC_QUAL_DETS_IMP_PKG dependencies on IGS_UC_COM_EBL_SUBJ

Line 37: FROM IGS_UC_COM_EBL_SUBJ

33: CURSOR Cur_UCAS_interface IS
34: SELECT ROWID, Subject_id, year, sitting, Awarding_body,
35: external_ref, UPPER(TRIM(Exam_level)) exam_level, Title,
36: UPPER(TRIM(Subject_code)) subject_code, Imported
37: FROM IGS_UC_COM_EBL_SUBJ
38: WHERE subject_id IN ( SELECT DISTINCT subject_id FROM IGS_UC_APP_RESULTS ) ;
39:
40: /* This is to get the person id from the oss table for the corresponding person number */
41: --smaddali 27-jun-2002 added condition that oss_person_id should be not null for bug 2430139

Line 69: l_year igs_uc_com_ebl_subj.year%TYPE,

65: --smaddali 18-jul-02 interchanged position of parameters exam_level and subject_code for bug 2430139
66: CURSOR Cur_check_uniqueness ( l_person_id igs_uc_qual_dets.person_id%TYPE,
67: l_exam_level igs_uc_qual_dets.exam_level%TYPE,
68: l_subject_code igs_uc_qual_dets.subject_code%TYPE,
69: l_year igs_uc_com_ebl_subj.year%TYPE,
70: l_sitting igs_uc_com_ebl_subj.sitting%TYPE,
71: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE ,
72: l_approved_result igs_uc_qual_dets.approved_result%TYPE ) IS
73: SELECT imported_flag

Line 70: l_sitting igs_uc_com_ebl_subj.sitting%TYPE,

66: CURSOR Cur_check_uniqueness ( l_person_id igs_uc_qual_dets.person_id%TYPE,
67: l_exam_level igs_uc_qual_dets.exam_level%TYPE,
68: l_subject_code igs_uc_qual_dets.subject_code%TYPE,
69: l_year igs_uc_com_ebl_subj.year%TYPE,
70: l_sitting igs_uc_com_ebl_subj.sitting%TYPE,
71: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE ,
72: l_approved_result igs_uc_qual_dets.approved_result%TYPE ) IS
73: SELECT imported_flag
74: FROM igs_uc_qual_dets

Line 71: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE ,

67: l_exam_level igs_uc_qual_dets.exam_level%TYPE,
68: l_subject_code igs_uc_qual_dets.subject_code%TYPE,
69: l_year igs_uc_com_ebl_subj.year%TYPE,
70: l_sitting igs_uc_com_ebl_subj.sitting%TYPE,
71: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE ,
72: l_approved_result igs_uc_qual_dets.approved_result%TYPE ) IS
73: SELECT imported_flag
74: FROM igs_uc_qual_dets
75: WHERE person_id = l_person_id

Line 84: CURSOR Cur_Awarding_body (l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE) IS

80: AND ((awarding_body = l_awarding_body) OR (awarding_body IS NULL AND l_awarding_body IS NULL))
81: AND ( (approved_result = l_approved_result) OR (approved_result IS NULL AND l_approved_result IS NULL) ) ;
82:
83: /* this will pickup data from HESA table for Awarding body, based in the association code */
84: CURSOR Cur_Awarding_body (l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE) IS
85: SELECT Map2 FROM Igs_he_code_map_val
86: WHERE Association_code = 'UCAS_OSS_AWD_BDY_ASSOC'
87: AND Map1 = l_awarding_body;
88:

Line 90: CURSOR Cur_subject_code (l_subject_code igs_uc_com_ebl_subj.subject_code%TYPE) IS

86: WHERE Association_code = 'UCAS_OSS_AWD_BDY_ASSOC'
87: AND Map1 = l_awarding_body;
88:
89: /* this will pickup data from HESA table for Subject code, based in the association code */
90: CURSOR Cur_subject_code (l_subject_code igs_uc_com_ebl_subj.subject_code%TYPE) IS
91: SELECT Map2 FROM Igs_he_code_map_val
92: WHERE Association_code = 'UCAS_OSS_SBJ_ASSOC'
93: AND Map1 = l_subject_code;
94:

Line 96: CURSOR Cur_exam_level (l_exam_level igs_uc_com_ebl_subj.exam_level%TYPE) IS

92: WHERE Association_code = 'UCAS_OSS_SBJ_ASSOC'
93: AND Map1 = l_subject_code;
94:
95: /* this will pickup data from HESA table for Exam_level, based in the association code */
96: CURSOR Cur_exam_level (l_exam_level igs_uc_com_ebl_subj.exam_level%TYPE) IS
97: SELECT Map2 FROM Igs_he_code_map_val
98: WHERE Association_code = 'UCAS_OSS_AWD_ASSOC'
99: AND Map1 = l_exam_level;
100:

Line 105: l_year igs_uc_com_ebl_subj.year%TYPE,

101: /* this is to get values from igs_uc_qual_dets table for updation when manually entered */
102: CURSOR Cur_qual_dets (l_person_id igs_uc_qual_dets.person_id%TYPE,
103: l_exam_level igs_uc_qual_dets.exam_level%TYPE,
104: l_subject_code igs_uc_qual_dets.subject_code%TYPE,
105: l_year igs_uc_com_ebl_subj.year%TYPE,
106: l_sitting igs_uc_com_ebl_subj.sitting%TYPE,
107: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE) IS
108: SELECT ROWID, Qual_dets_id, Person_id, Exam_level, Subject_code, Year, Sitting, Awarding_body,
109: Grading_schema_cd, Version_number, Predicted_result, Approved_result, Claimed_result,

Line 106: l_sitting igs_uc_com_ebl_subj.sitting%TYPE,

102: CURSOR Cur_qual_dets (l_person_id igs_uc_qual_dets.person_id%TYPE,
103: l_exam_level igs_uc_qual_dets.exam_level%TYPE,
104: l_subject_code igs_uc_qual_dets.subject_code%TYPE,
105: l_year igs_uc_com_ebl_subj.year%TYPE,
106: l_sitting igs_uc_com_ebl_subj.sitting%TYPE,
107: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE) IS
108: SELECT ROWID, Qual_dets_id, Person_id, Exam_level, Subject_code, Year, Sitting, Awarding_body,
109: Grading_schema_cd, Version_number, Predicted_result, Approved_result, Claimed_result,
110: UCAS_tariff, Imported_flag, Imported_date

Line 107: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE) IS

103: l_exam_level igs_uc_qual_dets.exam_level%TYPE,
104: l_subject_code igs_uc_qual_dets.subject_code%TYPE,
105: l_year igs_uc_com_ebl_subj.year%TYPE,
106: l_sitting igs_uc_com_ebl_subj.sitting%TYPE,
107: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE) IS
108: SELECT ROWID, Qual_dets_id, Person_id, Exam_level, Subject_code, Year, Sitting, Awarding_body,
109: Grading_schema_cd, Version_number, Predicted_result, Approved_result, Claimed_result,
110: UCAS_tariff, Imported_flag, Imported_date
111: FROM igs_uc_qual_dets

Line 154: FROM igs_uc_com_ebl_subj

150: FROM igs_uc_applicants
151: WHERE oss_person_id = cp_person_id
152: )
153: AND apr.subject_id IN ( SELECT subject_id
154: FROM igs_uc_com_ebl_subj
155: WHERE subject_code IN ( SELECT msbj.map1
156: FROM igs_he_code_map_val msbj
157: WHERE msbj.association_code = 'UCAS_OSS_SBJ_ASSOC'
158: AND msbj.map2 = cp_subject_code )

Line 182: l_year igs_uc_com_ebl_subj.year%TYPE;

178: l_oss_exam_level igs_uc_qual_dets.exam_level%TYPE;
179: l_person_id igs_uc_qual_dets.person_id%TYPE;
180: l_exam_level igs_uc_qual_dets.exam_level%TYPE;
181: l_subject_code igs_uc_qual_dets.subject_code%TYPE;
182: l_year igs_uc_com_ebl_subj.year%TYPE;
183: l_sitting igs_uc_com_ebl_subj.sitting%TYPE;
184: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE;
185: l_imported igs_uc_qual_dets.imported_flag%TYPE;
186: l_qual_dets_id igs_uc_qual_dets.Qual_dets_id%TYPE;

Line 183: l_sitting igs_uc_com_ebl_subj.sitting%TYPE;

179: l_person_id igs_uc_qual_dets.person_id%TYPE;
180: l_exam_level igs_uc_qual_dets.exam_level%TYPE;
181: l_subject_code igs_uc_qual_dets.subject_code%TYPE;
182: l_year igs_uc_com_ebl_subj.year%TYPE;
183: l_sitting igs_uc_com_ebl_subj.sitting%TYPE;
184: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE;
185: l_imported igs_uc_qual_dets.imported_flag%TYPE;
186: l_qual_dets_id igs_uc_qual_dets.Qual_dets_id%TYPE;
187: igs_uc_he_not_enabled_excep EXCEPTION;

Line 184: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE;

180: l_exam_level igs_uc_qual_dets.exam_level%TYPE;
181: l_subject_code igs_uc_qual_dets.subject_code%TYPE;
182: l_year igs_uc_com_ebl_subj.year%TYPE;
183: l_sitting igs_uc_com_ebl_subj.sitting%TYPE;
184: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE;
185: l_imported igs_uc_qual_dets.imported_flag%TYPE;
186: l_qual_dets_id igs_uc_qual_dets.Qual_dets_id%TYPE;
187: igs_uc_he_not_enabled_excep EXCEPTION;
188:

Line 296: /* Picking up records from igs_uc_com_ebl_subj table for Importing in to qual dets table */

292: fnd_message.set_name('IGS','IGS_UC_IMP_QUAL_DETS');
293: fnd_file.put_line(fnd_file.log, fnd_message.get);
294: fnd_file.put_line(fnd_file.log,' ' );
295:
296: /* Picking up records from igs_uc_com_ebl_subj table for Importing in to qual dets table */
297: FOR I IN cur_ucas_interface LOOP
298:
299: -- initializing the local variables
300: l_oss_exam_level := NULL ;

Line 557: END LOOP; -- igs_uc_com_ebl_subj Records Loop

553: l_msg_count := NULL;
554:
555: END LOOP; -- Insert/Update Igs_uc_qual_dets looop
556:
557: END LOOP; -- igs_uc_com_ebl_subj Records Loop
558:
559: fnd_file.put_line(fnd_file.log,' ' );
560: fnd_file.put_line(fnd_file.log,RPAD('-',22,'-'));
561: fnd_file.put_line(fnd_file.log,SUBSTR(fnd_message.get_string('IGS','IGS_UC_INS_REC_STAT_INT'), 29, 22));