383:
384: END insert_adm_appl;
385:
386: FUNCTION insert_adm_appl_prog(
387: p_person_id IN igs_pe_person.person_id%type ,
388: p_adm_appl_number IN NUMBER ,
389: p_nominated_course_cd IN VARCHAR2 ,
390: p_transfer_course_cd IN VARCHAR2,
391: p_basis_for_admission_type IN VARCHAR2 ,
706: END insert_adm_appl_prog;
707:
708:
709: FUNCTION insert_adm_appl_prog_inst(
710: p_person_id IN igs_pe_person.person_id%type ,
711: p_admission_appl_number IN NUMBER ,
712: p_acad_cal_type IN VARCHAR2 ,
713: p_acad_ci_sequence_number IN NUMBER ,
714: p_adm_cal_type IN VARCHAR2 ,
937: v_check_course_encumb VARCHAR2(1) DEFAULT 'N';
938: v_unit_set_appl_ind VARCHAR2(1) DEFAULT 'N';
939:
940: --begin apadegal adtd001 igs.m
941: l_person_type_code IGS_PE_PERSON_TYPES.person_type_code%TYPE;
942: CURSOR c_person_type_code(l_system_type IGS_PE_PERSON_TYPES.system_type%TYPE)
943: IS
944: SELECT person_type_code
945: FROM igs_pe_person_types
938: v_unit_set_appl_ind VARCHAR2(1) DEFAULT 'N';
939:
940: --begin apadegal adtd001 igs.m
941: l_person_type_code IGS_PE_PERSON_TYPES.person_type_code%TYPE;
942: CURSOR c_person_type_code(l_system_type IGS_PE_PERSON_TYPES.system_type%TYPE)
943: IS
944: SELECT person_type_code
945: FROM igs_pe_person_types
946: WHERE system_type=l_system_type;
941: l_person_type_code IGS_PE_PERSON_TYPES.person_type_code%TYPE;
942: CURSOR c_person_type_code(l_system_type IGS_PE_PERSON_TYPES.system_type%TYPE)
943: IS
944: SELECT person_type_code
945: FROM igs_pe_person_types
946: WHERE system_type=l_system_type;
947: lv_rowid2 VARCHAR2(25) ;
948: lv_type_instance_id NUMBER(15);
949: lv_sysdate DATE := TRUNC(SYSDATE);