APPS.IGS_UC_EXPORT_HESA_TO_OSS_PKG dependencies on IGS_AD_INTERFACE

Line 96: l_interface_run_id igs_ad_interface_ctl.interface_run_id%TYPE;

92: FROM igs_pe_match_sets
93: WHERE source_type_id = p_source_type_id;
94: match_set_rec cur_match_set%ROWTYPE;
95:
96: l_interface_run_id igs_ad_interface_ctl.interface_run_id%TYPE;
97: l_errbuff VARCHAR2(100) ;
98: l_retcode NUMBER ;
99:
100: BEGIN

Line 268: SELECT igs_ad_interface_batch_id_s.NEXTVAL

264: WHERE person_id = p_per_id;
265:
266: -- Get the Batch ID for admission application import process
267: CURSOR c_bat_id 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

Line 279: CURSOR c_adm_int( cp_batch_id igs_ad_interface.batch_id%TYPE) IS

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
279: CURSOR c_adm_int( cp_batch_id igs_ad_interface.batch_id%TYPE) IS
280: SELECT a.person_number, a.interface_id
281: FROM igs_ad_interface a
282: WHERE a.batch_id = cp_batch_id
283: AND ( a.status IN ('2','3') OR a.record_status='3' ) ;

Line 281: FROM igs_ad_interface a

277:
278: -- Get the admission application instance interface records whose import has failed
279: CURSOR c_adm_int( cp_batch_id igs_ad_interface.batch_id%TYPE) IS
280: SELECT a.person_number, a.interface_id
281: FROM igs_ad_interface a
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

Line 301: l_imp_batch_id igs_ad_interface_all.batch_id%TYPE ;

297: WHERE a.interface_id = cp_interface_id
298: AND a.status = '3';
299: l_interface_stat_rec c_stat_int%ROWTYPE ;
300:
301: l_imp_batch_id igs_ad_interface_all.batch_id%TYPE ;
302: l_interface_id igs_ad_interface_all.interface_id%TYPE ;
303: l_interface_stat_id igs_ad_stat_int_all.interface_stat_id%TYPE;
304: l_chk_per_present VARCHAR2(1) := 'Y';
305: l_col_ad_null VARCHAR2(1) := 'Y';

Line 302: l_interface_id igs_ad_interface_all.interface_id%TYPE ;

298: AND a.status = '3';
299: l_interface_stat_rec c_stat_int%ROWTYPE ;
300:
301: l_imp_batch_id igs_ad_interface_all.batch_id%TYPE ;
302: l_interface_id igs_ad_interface_all.interface_id%TYPE ;
303: l_interface_stat_id igs_ad_stat_int_all.interface_stat_id%TYPE;
304: l_chk_per_present VARCHAR2(1) := 'Y';
305: l_col_ad_null VARCHAR2(1) := 'Y';
306: l_col_spa_null VARCHAR2(1) := 'Y';

Line 664: INSERT INTO igs_ad_interface(person_number,

660:
661: IF l_interface_id IS NULL THEN
662:
663:
664: INSERT INTO igs_ad_interface(person_number,
665: interface_id,
666: batch_id,
667: source_type_id,
668: person_id,

Line 686: igs_ad_interface_s.NEXTVAL,

682: program_application_id,
683: program_update_date,
684: program_id)
685: VALUES(l_person_info_rec.person_number,
686: igs_ad_interface_s.NEXTVAL,
687: l_imp_batch_id,
688: l_src_type_id_rec.source_type_id,
689: all_appl_rec.oss_person_id,
690: l_person_info_rec.surname,