APPS.IGS_EN_GEN_018 dependencies on IGS_PE_PERSON

Line 406: CURSOR c_bulk_programs (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE, cp_person_number igs_pe_person.person_number%TYPE) IS

402: AND status_flag IN ('U','R')
403: ORDER BY person_number;
404:
405: --Fetches the distinct program attempts for the person
406: CURSOR c_bulk_programs (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE, cp_person_number igs_pe_person.person_number%TYPE) IS
407: SELECT DISTINCT program_cd, program_ver_num
408: FROM igs_en_blk_sua_ints
409: WHERE batch_id=cp_batch_id
410: AND person_number=cp_person_number

Line 417: cp_person_number igs_pe_person.person_number%TYPE,

413:
414: --Fetches the relevant load calendars depending upon the teach alt codes specified
415: --int the interface table. The person and program attempt are in the context.
416: CURSOR c_bulk_load (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE,
417: cp_person_number igs_pe_person.person_number%TYPE,
418: cp_program_cd igs_ps_ofr_opt.course_cd%TYPE,
419: cp_program_ver_num igs_en_blk_sua_ints.program_ver_num%TYPE) IS
420: SELECT DISTINCT ttol.load_cal_type cal_type, ttol.load_ci_sequence_number
421: seq_num, ttol.load_alternate_code alt_cd,ttol.load_start_dt

Line 448: cp_person_number igs_pe_person.person_number%TYPE,

444: AND ttol.load_ci_sequence_number=cp_load_seq_num;
445:
446: --Fetches the induvidual sua records from the interface table
447: CURSOR c_bulk_suas (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE,
448: cp_person_number igs_pe_person.person_number%TYPE,
449: cp_program_cd igs_ps_ofr_opt.course_cd%TYPE,
450: cp_program_ver_num igs_en_blk_sua_ints.program_ver_num%TYPE,
451: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
452: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE,

Line 482: CURSOR c_stdnt_ps_att (cp_person_id igs_pe_person.person_id%TYPE,

478: ORDER BY uoo_info DESC;
479:
480:
481: --Used to check if the student has the relevant program attempt
482: CURSOR c_stdnt_ps_att (cp_person_id igs_pe_person.person_id%TYPE,
483: cp_program_cd igs_ps_ofr_opt.course_cd%TYPE,
484: cp_program_ver_num igs_en_blk_sua_ints.program_ver_num%TYPE) IS
485: SELECT course_attempt_status, primary_program_type FROM igs_en_stdnt_ps_att
486: WHERE person_id = cp_person_id

Line 491: CURSOR c_sua_exists (cp_person_id igs_pe_person.person_id%TYPE,

487: AND course_cd = cp_program_cd
488: AND version_number= cp_program_ver_num;
489:
490: --Checks if the student has already attempted the specified uoo
491: CURSOR c_sua_exists (cp_person_id igs_pe_person.person_id%TYPE,
492: cp_program_cd igs_ps_ofr_opt.course_cd%TYPE,
493: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
494: SELECT 'Y' FROM igs_en_su_attempt
495: WHERE person_id =cp_person_id

Line 546: l_person_id igs_pe_person.person_id%TYPE;

542: cst_cancelled VARCHAR2(40):='CANCELLED';
543: cst_notofr VARCHAR2(40):='NOT_OFFERED';
544: cst_primary VARCHAR2(40):='PRIMARY';
545:
546: l_person_id igs_pe_person.person_id%TYPE;
547: l_person_type VARCHAR2(30);
548: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
549: l_rel_type igs_ps_unit_ofr_opt.relation_type%TYPE;
550: l_usec_status igs_ps_unit_ver.unit_status%TYPE;