APPS.IGS_HE_IMPORT_DATA dependencies on IGS_PE_SRC_TYPES_ALL

Line 468: p_source_type_id igs_pe_src_types_all.source_type_id%TYPE,

464:
465: END import_alternate_person_id;
466:
467: PROCEDURE populate_imp_int (
468: p_source_type_id igs_pe_src_types_all.source_type_id%TYPE,
469: p_batch_id NUMBER, -- admission import batch id
470: p_orgid NUMBER ,
471: p_person_id igs_pe_person.person_id%TYPE ,
472: p_hesa_id igs_he_ucas_imp_int.interface_hesa_id%TYPE) AS

Line 1008: p_source_type_id igs_pe_src_types_all.source_type_id%TYPE,

1004: END populate_imp_int;
1005:
1006:
1007: PROCEDURE import_process(
1008: p_source_type_id igs_pe_src_types_all.source_type_id%TYPE,
1009: p_batch_id NUMBER,
1010: p_orgid NUMBER
1011: ) IS
1012:

Line 1136: CURSOR cur_pe_src_cat (cp_source_type_id igs_pe_src_types_all.source_type_id%TYPE) IS

1132:
1133: l_altid VARCHAR2(1) ;
1134:
1135: --Check whether the Source Category of Academic History is included within the source Type "UCAS PER" or not.
1136: CURSOR cur_pe_src_cat (cp_source_type_id igs_pe_src_types_all.source_type_id%TYPE) IS
1137: SELECT 'X'
1138: FROM igs_ad_source_cat_v
1139: WHERE source_type_id = cp_source_type_id
1140: AND category_name = 'PERSON_ACADEMIC_HISTORY'

Line 1262: FROM igs_pe_src_types_all

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
1260: CURSOR c_src_type_id IS
1261: SELECT source_type_id
1262: FROM igs_pe_src_types_all
1263: WHERE source_type = 'UCAS PER'
1264: AND NVL(closed_ind,'N') = 'N';
1265:
1266: c_src_type_id_rec c_src_type_id%ROWTYPE;