APPS.IGS_UC_EXPORT_HESA_TO_OSS_PKG dependencies on IGS_PE_SRC_TYPES_ALL

Line 75: p_source_type_id igs_pe_src_types_all.source_type_id%TYPE,

71: END pre_enrollement_process;
72:
73:
74: PROCEDURE import_process(
75: p_source_type_id igs_pe_src_types_all.source_type_id%TYPE,
76: p_batch_id NUMBER
77: ) IS
78:
79: /******************************************************************

Line 210: FROM igs_pe_src_types_all

206: -- Get the Source type ID of UCAS for admission import process
207: --smaddali modified this cursor to get the source type UCAS PER instead of UCAS APPL ,bug 2724140
208: CURSOR cur_src_type_id IS
209: SELECT source_type_id
210: FROM igs_pe_src_types_all
211: WHERE source_type = 'UCAS PER'
212: AND NVL(closed_ind,'N') = 'N';
213:
214: l_src_type_id_rec cur_src_type_id%ROWTYPE;

Line 217: CURSOR cur_pe_src_cat (cp_source_type_id igs_pe_src_types_all.source_type_id%TYPE,

213:
214: l_src_type_id_rec cur_src_type_id%ROWTYPE;
215:
216: --Check whether the Source Category of Academic History is included within the source Type "UCAS PER" or not.
217: CURSOR cur_pe_src_cat (cp_source_type_id igs_pe_src_types_all.source_type_id%TYPE,
218: cp_category IGS_AD_SOURCE_CAT.category_name%TYPE) IS
219: SELECT 'X'
220: FROM igs_ad_source_cat_v
221: WHERE source_type_id = cp_source_type_id