eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_GEN_018 dependencies on IGS_CA_INST

Line 436: CURSOR c_get_teach_cal_dtls(cp_load_cal_type igs_ca_inst.cal_type%TYPE,

432: AND cttol.teach_ci_sequence_number=ttol.teach_ci_sequence_number)
433: ORDER BY ttol.load_start_dt;
434:
435: --Fetches the Teach calendar details
436: CURSOR c_get_teach_cal_dtls(cp_load_cal_type igs_ca_inst.cal_type%TYPE,
437: cp_load_seq_num igs_ca_inst.sequence_number%TYPE
438: ) IS
439: SELECT teach_cal_type,
440: teach_ci_sequence_number,

Line 437: cp_load_seq_num igs_ca_inst.sequence_number%TYPE

433: ORDER BY ttol.load_start_dt;
434:
435: --Fetches the Teach calendar details
436: CURSOR c_get_teach_cal_dtls(cp_load_cal_type igs_ca_inst.cal_type%TYPE,
437: cp_load_seq_num igs_ca_inst.sequence_number%TYPE
438: ) IS
439: SELECT teach_cal_type,
440: teach_ci_sequence_number,
441: teach_alternate_code

Line 451: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,

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,
453: cp_teach_alternate_cd igs_ca_inst.alternate_code%TYPE
454: ) IS
455: SELECT sui.upload_id,

Line 452: cp_teach_seq_num igs_ca_inst.sequence_number%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,
453: cp_teach_alternate_cd igs_ca_inst.alternate_code%TYPE
454: ) IS
455: SELECT sui.upload_id,
456: sui.unit_cd,

Line 453: cp_teach_alternate_cd igs_ca_inst.alternate_code%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,
453: cp_teach_alternate_cd igs_ca_inst.alternate_code%TYPE
454: ) IS
455: SELECT sui.upload_id,
456: sui.unit_cd,
457: sui.unit_ver_num,

Line 502: -- replaced view igs_ca_inst with igs_ca_inst_all for perf bug#4961316

498: AND unit_attempt_status IN ('ENROLLED','UNCONFIRM','WAITLISTED');
499:
500:
501: --Retrieves the interface records with invalid teach alt codes
502: -- replaced view igs_ca_inst with igs_ca_inst_all for perf bug#4961316
503: CURSOR c_invalid_teach (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE) IS
504: SELECT sui.upload_id, sui.alternate_cd alt_cd
505: FROM igs_en_blk_sua_ints sui,igs_ca_inst_all cal
506: WHERE sui.batch_id=cp_batch_id

Line 505: FROM igs_en_blk_sua_ints sui,igs_ca_inst_all cal

501: --Retrieves the interface records with invalid teach alt codes
502: -- replaced view igs_ca_inst with igs_ca_inst_all for perf bug#4961316
503: CURSOR c_invalid_teach (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE) IS
504: SELECT sui.upload_id, sui.alternate_cd alt_cd
505: FROM igs_en_blk_sua_ints sui,igs_ca_inst_all cal
506: WHERE sui.batch_id=cp_batch_id
507: AND status_flag IN ('U','R')
508: AND cal.alternate_code(+)=sui.alternate_cd
509: AND cal.alternate_code IS NULL;

Line 515: igs_ca_inst cal

511: --Retrieves the interface records with invalid teach 2 load relationship
512: CURSOR c_invalid_teach2load (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE) IS
513: SELECT sui.upload_id, sui.alternate_cd alt_cd,cal.cal_type,cal.sequence_number
514: FROM igs_en_blk_sua_ints sui,
515: igs_ca_inst cal
516: WHERE sui.alternate_cd=cal.alternate_code
517: AND batch_id=cp_batch_id
518: AND status_flag IN ('U','R')
519: AND NOT EXISTS(SELECT load_cal_type,load_ci_sequence_number

Line 551: l_acad_cal_type igs_ca_inst.cal_type%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;
551: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
552: l_acad_seq_num igs_ca_inst.sequence_number%TYPE;
553: l_acad_alt_cd igs_ca_inst.alternate_code%TYPE;
554: l_enr_cal_type igs_ca_inst.cal_type%TYPE;
555: l_enr_seq_num igs_ca_inst.sequence_number%TYPE;

Line 552: l_acad_seq_num igs_ca_inst.sequence_number%TYPE;

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;
551: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
552: l_acad_seq_num igs_ca_inst.sequence_number%TYPE;
553: l_acad_alt_cd igs_ca_inst.alternate_code%TYPE;
554: l_enr_cal_type igs_ca_inst.cal_type%TYPE;
555: l_enr_seq_num igs_ca_inst.sequence_number%TYPE;
556: l_acad_start_dt igs_ca_inst.start_dt%TYPE;

Line 553: l_acad_alt_cd igs_ca_inst.alternate_code%TYPE;

549: l_rel_type igs_ps_unit_ofr_opt.relation_type%TYPE;
550: l_usec_status igs_ps_unit_ver.unit_status%TYPE;
551: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
552: l_acad_seq_num igs_ca_inst.sequence_number%TYPE;
553: l_acad_alt_cd igs_ca_inst.alternate_code%TYPE;
554: l_enr_cal_type igs_ca_inst.cal_type%TYPE;
555: l_enr_seq_num igs_ca_inst.sequence_number%TYPE;
556: l_acad_start_dt igs_ca_inst.start_dt%TYPE;
557: l_acad_end_dt igs_ca_inst.start_dt%TYPE;

Line 554: l_enr_cal_type igs_ca_inst.cal_type%TYPE;

550: l_usec_status igs_ps_unit_ver.unit_status%TYPE;
551: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
552: l_acad_seq_num igs_ca_inst.sequence_number%TYPE;
553: l_acad_alt_cd igs_ca_inst.alternate_code%TYPE;
554: l_enr_cal_type igs_ca_inst.cal_type%TYPE;
555: l_enr_seq_num igs_ca_inst.sequence_number%TYPE;
556: l_acad_start_dt igs_ca_inst.start_dt%TYPE;
557: l_acad_end_dt igs_ca_inst.start_dt%TYPE;
558: l_enr_method VARCHAR2(100);

Line 555: l_enr_seq_num igs_ca_inst.sequence_number%TYPE;

551: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
552: l_acad_seq_num igs_ca_inst.sequence_number%TYPE;
553: l_acad_alt_cd igs_ca_inst.alternate_code%TYPE;
554: l_enr_cal_type igs_ca_inst.cal_type%TYPE;
555: l_enr_seq_num igs_ca_inst.sequence_number%TYPE;
556: l_acad_start_dt igs_ca_inst.start_dt%TYPE;
557: l_acad_end_dt igs_ca_inst.start_dt%TYPE;
558: l_enr_method VARCHAR2(100);
559: l_enr_category VARCHAR2(100);

Line 556: l_acad_start_dt igs_ca_inst.start_dt%TYPE;

552: l_acad_seq_num igs_ca_inst.sequence_number%TYPE;
553: l_acad_alt_cd igs_ca_inst.alternate_code%TYPE;
554: l_enr_cal_type igs_ca_inst.cal_type%TYPE;
555: l_enr_seq_num igs_ca_inst.sequence_number%TYPE;
556: l_acad_start_dt igs_ca_inst.start_dt%TYPE;
557: l_acad_end_dt igs_ca_inst.start_dt%TYPE;
558: l_enr_method VARCHAR2(100);
559: l_enr_category VARCHAR2(100);
560: l_commencement_type VARCHAR2(100);

Line 557: l_acad_end_dt igs_ca_inst.start_dt%TYPE;

553: l_acad_alt_cd igs_ca_inst.alternate_code%TYPE;
554: l_enr_cal_type igs_ca_inst.cal_type%TYPE;
555: l_enr_seq_num igs_ca_inst.sequence_number%TYPE;
556: l_acad_start_dt igs_ca_inst.start_dt%TYPE;
557: l_acad_end_dt igs_ca_inst.start_dt%TYPE;
558: l_enr_method VARCHAR2(100);
559: l_enr_category VARCHAR2(100);
560: l_commencement_type VARCHAR2(100);
561: l_enr_categories VARCHAR2(100);