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_EXPORT_HESA_TO_OSS_PKG dependencies on IGS_PE_PERSON

Line 4: PROCEDURE chk_person_present (l_per_id igs_pe_person.person_id%TYPE, l_per_present OUT NOCOPY VARCHAR2) IS

1: PACKAGE BODY igs_uc_export_hesa_to_oss_pkg AS
2: /* $Header: IGSUC25B.pls 120.3 2006/08/21 03:52:22 jbaber noship $ */
3:
4: PROCEDURE chk_person_present (l_per_id igs_pe_person.person_id%TYPE, l_per_present OUT NOCOPY VARCHAR2) IS
5: /*************************************************************
6: Created By : sowsubra
7: Date Created By : 11-FEB-2002
8: Purpose :

Line 13: igs_pe_person_base_v instead of igs_pe_person to improve performance

9: Know limitations, enhancements or remarks
10: Change History
11: Who When What
12: ayedubat 31-DEC-2002 Changed the cur_person_present_in_oss to fetch the records from
13: igs_pe_person_base_v instead of igs_pe_person to improve performance
14: for bug, 2726113
15: (reverse chronological order - newest change first)
16: ***************************************************************/
17:

Line 19: CURSOR cur_person_present_in_oss( l_per_id IGS_PE_PERSON.person_id%TYPE) IS

15: (reverse chronological order - newest change first)
16: ***************************************************************/
17:
18: /* To check if the person is present in the oss tables*/
19: CURSOR cur_person_present_in_oss( l_per_id IGS_PE_PERSON.person_id%TYPE) IS
20: SELECT COUNT(*) n_count
21: FROM igs_pe_person_base_v
22: WHERE person_id = l_per_id;
23: person_present_rec cur_person_present_in_oss%ROWTYPE;

Line 21: FROM igs_pe_person_base_v

17:
18: /* To check if the person is present in the oss tables*/
19: CURSOR cur_person_present_in_oss( l_per_id IGS_PE_PERSON.person_id%TYPE) IS
20: SELECT COUNT(*) n_count
21: FROM igs_pe_person_base_v
22: WHERE person_id = l_per_id;
23: person_present_rec cur_person_present_in_oss%ROWTYPE;
24:
25: BEGIN

Line 43: PROCEDURE pre_enrollement_process( l_person_id IGS_PE_PERSON.person_id%TYPE ,l_COURSE_CD VARCHAR2 ,l_VERSION_NUMBER NUMBER) IS

39: RAISE;
40: END chk_person_present;
41:
42:
43: PROCEDURE pre_enrollement_process( l_person_id IGS_PE_PERSON.person_id%TYPE ,l_COURSE_CD VARCHAR2 ,l_VERSION_NUMBER NUMBER) IS
44: /*************************************************************
45: Created By : sowsubra
46: Date Created By : 11-FEB-2002
47: Purpose :

Line 137: p_person_id IGS_PE_PERSON.person_id%TYPE) IS

133:
134:
135: PROCEDURE export_data(errbuf OUT NOCOPY VARCHAR2,
136: retcode OUT NOCOPY NUMBER,
137: p_person_id IGS_PE_PERSON.person_id%TYPE) IS
138: /*************************************************************
139: Created By : sowsubra
140: Date Created By : 11-FEB-2002
141: Purpose :

Line 172: CURSOR c_person ( cp_person_id igs_pe_person.person_id%TYPE ) IS

168: anwest 18-JAN-2006 Bug# 4950285 R12 Disable OSS Mandate
169: ***************************************************************/
170:
171: /* smaddali added this cursor to get the person_number to display in the log file , bug 2497516 */
172: CURSOR c_person ( cp_person_id igs_pe_person.person_id%TYPE ) IS
173: SELECT person_number
174: FROM igs_pe_person_base_v
175: WHERE person_id = cp_person_id ;
176: l_person_number igs_pe_person.person_number%TYPE := NULL ;

Line 174: FROM igs_pe_person_base_v

170:
171: /* smaddali added this cursor to get the person_number to display in the log file , bug 2497516 */
172: CURSOR c_person ( cp_person_id igs_pe_person.person_id%TYPE ) IS
173: SELECT person_number
174: FROM igs_pe_person_base_v
175: WHERE person_id = cp_person_id ;
176: l_person_number igs_pe_person.person_number%TYPE := NULL ;
177:
178: /* cursor to select all applicants and details whose details have not been exported to HESA */

Line 176: l_person_number igs_pe_person.person_number%TYPE := NULL ;

172: CURSOR c_person ( cp_person_id igs_pe_person.person_id%TYPE ) IS
173: SELECT person_number
174: FROM igs_pe_person_base_v
175: WHERE person_id = cp_person_id ;
176: l_person_number igs_pe_person.person_number%TYPE := NULL ;
177:
178: /* cursor to select all applicants and details whose details have not been exported to HESA */
179: CURSOR cur_all_applicants(cp_person_id igs_pe_person.person_id%TYPE ) IS
180: SELECT app.app_no,

Line 179: CURSOR cur_all_applicants(cp_person_id igs_pe_person.person_id%TYPE ) IS

175: WHERE person_id = cp_person_id ;
176: l_person_number igs_pe_person.person_number%TYPE := NULL ;
177:
178: /* cursor to select all applicants and details whose details have not been exported to HESA */
179: CURSOR cur_all_applicants(cp_person_id igs_pe_person.person_id%TYPE ) IS
180: SELECT app.app_no,
181: app.app_id,
182: app.oss_person_id,
183: TO_CHAR(app.domicile_apr) domicile_apr,

Line 196: CURSOR cur_ucas_setup ( cp_person_id igs_pe_person.person_id%TYPE ) IS

192: AND stat.sent_to_hesa = 'N'
193: ORDER BY app.system_code, app.app_no ;
194:
195: --Check whether the UCAS setup is defined or not for the Default prev_inst_left_date value.
196: CURSOR cur_ucas_setup ( cp_person_id igs_pe_person.person_id%TYPE ) IS
197: SELECT system_code
198: FROM igs_uc_defaults
199: WHERE prev_inst_left_date IS NULL
200: AND system_code IN ( SELECT DISTINCT app.system_code

Line 233: CURSOR get_had_details (l_per_id igs_pe_person.person_id%TYPE) IS

229: FROM igs_he_code_map_val
230: WHERE association_code = cp_association_code
231: AND map1 = cp_map1 ;
232:
233: CURSOR get_had_details (l_per_id igs_pe_person.person_id%TYPE) IS
234: SELECT had.ROWID ,had.*
235: FROM igs_he_ad_dtl_all had
236: WHERE person_id = l_per_id;
237:

Line 238: CURSOR get_st_spa_details( l_per_id igs_pe_person.person_id%TYPE) IS

234: SELECT had.ROWID ,had.*
235: FROM igs_he_ad_dtl_all had
236: WHERE person_id = l_per_id;
237:
238: CURSOR get_st_spa_details( l_per_id igs_pe_person.person_id%TYPE) IS
239: SELECT course_cd, version_number
240: FROM igs_he_st_spa_all hestspa
241: WHERE person_id = l_per_id;
242:

Line 254: CURSOR cur_ad_appl_inst (p_per_id igs_pe_person.person_id%TYPE) IS

250: SELECT apst.ROWID , apst.*
251: FROM igs_uc_app_stats apst
252: WHERE apst.app_id = p_app_id ;
253:
254: CURSOR cur_ad_appl_inst (p_per_id igs_pe_person.person_id%TYPE) IS
255: SELECT admission_appl_number,
256: nominated_course_cd,
257: sequence_number
258: FROM igs_ad_ps_appl_inst_all

Line 261: CURSOR cur_he_ad_dtl_all(p_per_id igs_pe_person.person_id%TYPE) IS

257: sequence_number
258: FROM igs_ad_ps_appl_inst_all
259: WHERE person_id = p_per_id;
260:
261: CURSOR cur_he_ad_dtl_all(p_per_id igs_pe_person.person_id%TYPE) IS
262: SELECT COUNT(*)
263: FROM igs_he_ad_dtl_all
264: WHERE person_id = p_per_id;
265:

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

268: SELECT igs_ad_interface_batch_id_s.NEXTVAL
269: FROM dual;
270:
271: -- Get the Person number for the passed person id.
272: CURSOR c_person_info (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
273: SELECT person_number, last_name surname, first_name given_names, gender sex, birth_date birth_dt
274: FROM igs_pe_person_base_v
275: WHERE person_id = cp_person_id;
276: l_person_info_rec c_person_info%ROWTYPE;

Line 274: FROM igs_pe_person_base_v

270:
271: -- Get the Person number for the passed person id.
272: CURSOR c_person_info (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
273: SELECT person_number, last_name surname, first_name given_names, gender sex, birth_date birth_dt
274: FROM igs_pe_person_base_v
275: WHERE person_id = cp_person_id;
276: l_person_info_rec c_person_info%ROWTYPE;
277:
278: -- Get the admission application instance interface records whose import has failed

Line 286: CURSOR cur_sys_ethnic(cp_person_id igs_pe_person.person_id%TYPE ) IS

282: WHERE a.batch_id = cp_batch_id
283: AND ( a.status IN ('2','3') OR a.record_status='3' ) ;
284:
285: -- to fetch the system code in the order U,S,N,G in case there are multiple ethnic data
286: CURSOR cur_sys_ethnic(cp_person_id igs_pe_person.person_id%TYPE ) IS
287: SELECT app.system_code,app.app_no
288: FROM igs_uc_applicants app, igs_uc_app_stats stat
289: WHERE app.app_no = stat.app_no
290: AND oss_person_id = cp_person_id