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_AD_IMP_028 dependencies on IGS_UC_QUAL_INTS

Line 68: l_interface_qual_id igs_uc_qual_ints.interface_qual_id%TYPE;

64: l_qual_dets_id igs_uc_qual_dets.qual_dets_id%TYPE;
65: l_status VARCHAR2(1);
66: l_error_code VARCHAR2(30);
67: l_error_text VARCHAR2(2000);
68: l_interface_qual_id igs_uc_qual_ints.interface_qual_id%TYPE;
69: l_person_id igs_ad_interface_all.person_id%TYPE;
70: l_person_id_errored igs_ad_interface_all.person_id%TYPE;
71:
72: l_prog_label VARCHAR2(100);

Line 96: UPDATE IGS_UC_QUAL_INTS qints

92: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
93: END IF;
94: -- Error out all the interface records, if the corrospending person already having qualification details
95: --- in ths OSS transaction table.
96: UPDATE IGS_UC_QUAL_INTS qints
97: SET error_code = 'E683'
98: ,error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E683', 8405)
99: , status ='3'
100: WHERE STATUS = '2'

Line 107: UPDATE IGS_UC_QUAL_INTS qints

103: WHERE person_id = qints.person_id);
104:
105: COMMIT;
106: -- Check for duplicates among interface records. If exists error out all the such records.
107: UPDATE IGS_UC_QUAL_INTS qints
108: SET error_code = 'E684'
109: ,error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E684', 8405)
110: , status ='3'
111: WHERE STATUS = '2'

Line 113: AND EXISTS (SELECT 1 FROM IGS_UC_QUAL_INTS qints2

109: ,error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E684', 8405)
110: , status ='3'
111: WHERE STATUS = '2'
112: AND interface_run_id = p_interface_run_id
113: AND EXISTS (SELECT 1 FROM IGS_UC_QUAL_INTS qints2
114: WHERE qints2.person_id = qints.person_id
115: AND qints2.exam_level = qints.exam_level
116: AND NVL(qints2.subject_code, '-1') = NVL(qints.subject_code, '-1')
117: AND NVL(qints2.awarding_body,'-1') = NVL(qints.awarding_body,'-1')

Line 126: UPDATE IGS_UC_QUAL_INTS qints

122: AND qints2.interface_run_id = p_interface_run_id
123: AND qints2.status ='2' );
124: COMMIT;
125: -- Error out all interface records if the any interface record with same person_id is errored out.
126: UPDATE IGS_UC_QUAL_INTS qints
127: SET error_code = 'E684'
128: ,error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E684', 8405)
129: , status ='3'
130: WHERE STATUS = '2'

Line 132: AND EXISTS (SELECT 1 FROM IGS_UC_QUAL_INTS qints2

128: ,error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E684', 8405)
129: , status ='3'
130: WHERE STATUS = '2'
131: AND interface_run_id = p_interface_run_id
132: AND EXISTS (SELECT 1 FROM IGS_UC_QUAL_INTS qints2
133: WHERE STATUS = '3'
134: AND qints2.person_id = qints.person_id
135: AND qints2.interface_run_id = p_interface_run_id) ;
136:

Line 178: UPDATE igs_uc_qual_ints

174: x_ucas_tariff => uc_qual_rec.ucas_tariff,
175: x_imported_flag => uc_qual_rec.imported_flag,
176: x_imported_date => TRUNC(uc_qual_rec.imported_date),
177: x_mode => 'R');
178: UPDATE igs_uc_qual_ints
179: SET status = cst_s_val_1,
180: error_code = cst_ec_val_NULL
181: WHERE interface_qual_id = uc_qual_rec.interface_qual_id;
182: -- If the all qulaificaton records with same person_id are processed , then commit;

Line 189: UPDATE igs_uc_qual_ints

185: EXCEPTION
186: WHEN invalid_record THEN
187: ROLLBACK;
188: l_person_id_errored := uc_qual_rec.person_id ;
189: UPDATE igs_uc_qual_ints
190: SET status = cst_s_val_3,
191: error_code = l_error_code,
192: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405)
193: WHERE interface_qual_id = uc_qual_rec.interface_qual_id;

Line 196: igs_ad_imp_001.logerrormessage(uc_qual_rec.interface_qual_id,l_error_code,'IGS_UC_QUAL_INTS');

192: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405)
193: WHERE interface_qual_id = uc_qual_rec.interface_qual_id;
194:
195: IF p_enable_log = 'Y' THEN
196: igs_ad_imp_001.logerrormessage(uc_qual_rec.interface_qual_id,l_error_code,'IGS_UC_QUAL_INTS');
197: END IF;
198: l_error_code := 'E685';
199: UPDATE igs_uc_qual_ints
200: SET status = cst_s_val_3

Line 199: UPDATE igs_uc_qual_ints

195: IF p_enable_log = 'Y' THEN
196: igs_ad_imp_001.logerrormessage(uc_qual_rec.interface_qual_id,l_error_code,'IGS_UC_QUAL_INTS');
197: END IF;
198: l_error_code := 'E685';
199: UPDATE igs_uc_qual_ints
200: SET status = cst_s_val_3
201: , error_code = l_error_code
202: , error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405)
203: WHERE person_id = uc_qual_rec.person_id

Line 221: igs_ad_imp_001.logerrormessage(uc_qual_rec.interface_qual_id,l_msg_data,'IGS_UC_QUAL_INTS');

217: l_error_text := l_msg_data;
218: l_error_Code := 'E322';
219:
220: IF p_enable_log = 'Y' THEN
221: igs_ad_imp_001.logerrormessage(uc_qual_rec.interface_qual_id,l_msg_data,'IGS_UC_QUAL_INTS');
222: END IF;
223: ELSE
224: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);
225: l_error_Code := 'E518';

Line 246: UPDATE igs_uc_qual_ints

242: END IF;
243:
244:
245: l_person_id_errored := uc_qual_rec.person_id ;
246: UPDATE igs_uc_qual_ints
247: SET status = cst_s_val_3, error_code = l_error_code, error_text = l_error_text
248: WHERE interface_qual_id = uc_qual_rec.interface_qual_id;
249:
250: l_error_code := 'E685';

Line 251: UPDATE igs_uc_qual_ints

247: SET status = cst_s_val_3, error_code = l_error_code, error_text = l_error_text
248: WHERE interface_qual_id = uc_qual_rec.interface_qual_id;
249:
250: l_error_code := 'E685';
251: UPDATE igs_uc_qual_ints
252: SET status = cst_s_val_3,
253: error_code = l_error_code,
254: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405)
255: WHERE person_id = uc_qual_rec.person_id