APPS.IGS_HE_IMPORT_DATA dependencies on IGS_AD_INTERFACE

Line 588: INSERT INTO igs_ad_interface(person_number,

584:
585: -- Create an interface record for this person
586: -- Since this person already exists in oss and the person identifier is known , matching can be skipped
587: -- and directly the person record can be updated ,hence match_ind is set to 15
588: INSERT INTO igs_ad_interface(person_number,
589: interface_id,
590: batch_id,
591: org_id,
592: source_type_id,

Line 610: igs_ad_interface_s.NEXTVAL,

606: program_application_id,
607: program_id,
608: program_update_date )
609: VALUES(c_interface_rec.person_number,
610: igs_ad_interface_s.NEXTVAL,
611: p_batch_id,
612: p_orgid,
613: p_source_type_id,
614: c_pe_det_rec.person_id,

Line 1030: l_interface_run_id igs_ad_interface_ctl.interface_run_id%TYPE;

1026: FROM igs_pe_match_sets
1027: WHERE source_type_id = p_source_type_id;
1028: match_set_rec cur_match_set%ROWTYPE;
1029:
1030: l_interface_run_id igs_ad_interface_ctl.interface_run_id%TYPE;
1031: l_errbuff VARCHAR2(100) ;
1032: l_retcode NUMBER ;
1033:
1034: BEGIN

Line 1103: l_imp_batch_id igs_ad_interface.batch_id%TYPE ;

1099:
1100: IGS_UC_HE_NOT_ENABLED_EXCEP EXCEPTION;
1101: l_no_setup BOOLEAN ;
1102: l_rep_request_id NUMBER ;
1103: l_imp_batch_id igs_ad_interface.batch_id%TYPE ;
1104: l_ins_tariff BOOLEAN ;
1105: l_upd_spa BOOLEAN ;
1106: l_upd_susa BOOLEAN ;
1107: l_upd_person BOOLEAN ;

Line 1255: SELECT igs_ad_interface_batch_id_s.NEXTVAL

1251: ORDER BY a.field_of_study ;
1252:
1253: -- Get the Batch ID for admission application import process
1254: CURSOR c_bat_id IS
1255: SELECT igs_ad_interface_batch_id_s.NEXTVAL
1256: FROM dual;
1257:
1258: -- Get the Source type ID of UCAS for admission import process
1259: --smaddali modified this cursor to get the source type UCAS PER instead of UCAS APPL ,bug 2724140

Line 1321: CURSOR c_adm_int_id( cp_batch_id igs_ad_interface_all.batch_id%TYPE,

1317: l_person_info_rec c_person_info%ROWTYPE;
1318:
1319: -- Get the Admission Interface ID while populating Acad Hisotry Interface table
1320: -- if it is already created as part of Person details import or not.
1321: CURSOR c_adm_int_id( cp_batch_id igs_ad_interface_all.batch_id%TYPE,
1322: cp_person_id igs_ad_interface_all.person_id%TYPE ) IS
1323: SELECT a.interface_id
1324: FROM igs_ad_interface_all a
1325: WHERE a.batch_id = cp_batch_id

Line 1322: cp_person_id igs_ad_interface_all.person_id%TYPE ) IS

1318:
1319: -- Get the Admission Interface ID while populating Acad Hisotry Interface table
1320: -- if it is already created as part of Person details import or not.
1321: CURSOR c_adm_int_id( cp_batch_id igs_ad_interface_all.batch_id%TYPE,
1322: cp_person_id igs_ad_interface_all.person_id%TYPE ) IS
1323: SELECT a.interface_id
1324: FROM igs_ad_interface_all a
1325: WHERE a.batch_id = cp_batch_id
1326: AND a.person_id= cp_person_id

Line 1324: FROM igs_ad_interface_all a

1320: -- if it is already created as part of Person details import or not.
1321: CURSOR c_adm_int_id( cp_batch_id igs_ad_interface_all.batch_id%TYPE,
1322: cp_person_id igs_ad_interface_all.person_id%TYPE ) IS
1323: SELECT a.interface_id
1324: FROM igs_ad_interface_all a
1325: WHERE a.batch_id = cp_batch_id
1326: AND a.person_id= cp_person_id
1327: AND a.status = '2'
1328: AND a.record_status='2';

Line 1329: l_interface_id igs_ad_interface_all.interface_id%TYPE ;

1325: WHERE a.batch_id = cp_batch_id
1326: AND a.person_id= cp_person_id
1327: AND a.status = '2'
1328: AND a.record_status='2';
1329: l_interface_id igs_ad_interface_all.interface_id%TYPE ;
1330:
1331: -- Get the admission application instance interface records whose import has failed
1332: CURSOR c_adm_int( cp_batch_id igs_ad_interface.batch_id%TYPE,
1333: cp_person_number igs_pe_person.person_number%TYPE ) IS

Line 1332: CURSOR c_adm_int( cp_batch_id igs_ad_interface.batch_id%TYPE,

1328: AND a.record_status='2';
1329: l_interface_id igs_ad_interface_all.interface_id%TYPE ;
1330:
1331: -- Get the admission application instance interface records whose import has failed
1332: CURSOR c_adm_int( cp_batch_id igs_ad_interface.batch_id%TYPE,
1333: cp_person_number igs_pe_person.person_number%TYPE ) IS
1334: SELECT a.person_number, a.interface_id
1335: FROM igs_ad_interface a
1336: WHERE a.batch_id = cp_batch_id AND

Line 1335: FROM igs_ad_interface a

1331: -- Get the admission application instance interface records whose import has failed
1332: CURSOR c_adm_int( cp_batch_id igs_ad_interface.batch_id%TYPE,
1333: cp_person_number igs_pe_person.person_number%TYPE ) IS
1334: SELECT a.person_number, a.interface_id
1335: FROM igs_ad_interface a
1336: WHERE a.batch_id = cp_batch_id AND
1337: a.person_number= cp_person_number AND
1338: ( a.status IN ('2','3') OR a.record_status='3' ) ;
1339: c_adm_int_rec c_adm_int%ROWTYPE ;