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_SS_ENROLL_PKG dependencies on IGS_CA_INST

Line 431: from igs_ps_unit_ofr_opt a,igs_ca_inst b

427: sysdate,
428: p_person_id,
429: sysdate,
430: p_enrolled_cp
431: from igs_ps_unit_ofr_opt a,igs_ca_inst b
432: where a.uoo_id = p_uoo_id
433: and b.sequence_number = a.ci_sequence_number
434: and b.cal_type = a.cal_type ;
435: if sql%rowcount = 0

Line 525: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

521: --Who When What
522: -------------------------------------------------------------------
523:
524: l_acad_year_flag igs_en_ss_disp_stps.academic_year_flag%TYPE;
525: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
526: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
527: l_message VARCHAR2(300);
528: BEGIN
529:

Line 526: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

522: -------------------------------------------------------------------
523:
524: l_acad_year_flag igs_en_ss_disp_stps.academic_year_flag%TYPE;
525: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
526: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
527: l_message VARCHAR2(300);
528: BEGIN
529:
530: -- Get the superior academic calendar instance

Line 574: FROM igs_ca_inst ci,

570:
571: -- Get the first Term calendar
572: CURSOR c_first_term_acad(cp_acad_cal_type VARCHAR2,cp_acad_ci_sequence_number NUMBER) IS
573: SELECT ci.sequence_number||ci.cal_type
574: FROM igs_ca_inst ci,
575: igs_ca_inst_rel cir,
576: igs_ca_type ct,
577: igs_ca_stat cs
578: WHERE ci.cal_type = cir.sub_cal_type AND

Line 575: igs_ca_inst_rel cir,

571: -- Get the first Term calendar
572: CURSOR c_first_term_acad(cp_acad_cal_type VARCHAR2,cp_acad_ci_sequence_number NUMBER) IS
573: SELECT ci.sequence_number||ci.cal_type
574: FROM igs_ca_inst ci,
575: igs_ca_inst_rel cir,
576: igs_ca_type ct,
577: igs_ca_stat cs
578: WHERE ci.cal_type = cir.sub_cal_type AND
579: ci.sequence_number = cir.sub_ci_sequence_number AND

Line 596: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

592: WHERE person_id = cp_person_id AND
593: course_cd = cp_program_cd;
594:
595: l_acad_year_flag igs_en_ss_disp_stps.academic_year_flag%TYPE;
596: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
597: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
598: l_message VARCHAR2(300);
599: l_term_calendar VARCHAR2(30);
600: l_schedule_disp igs_en_ss_disp_stps.academic_year_flag%TYPE;

Line 597: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

593: course_cd = cp_program_cd;
594:
595: l_acad_year_flag igs_en_ss_disp_stps.academic_year_flag%TYPE;
596: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
597: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
598: l_message VARCHAR2(300);
599: l_term_calendar VARCHAR2(30);
600: l_schedule_disp igs_en_ss_disp_stps.academic_year_flag%TYPE;
601: l_load_cal_type igs_ca_inst.cal_type%TYPE;

Line 601: l_load_cal_type igs_ca_inst.cal_type%TYPE;

597: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
598: l_message VARCHAR2(300);
599: l_term_calendar VARCHAR2(30);
600: l_schedule_disp igs_en_ss_disp_stps.academic_year_flag%TYPE;
601: l_load_cal_type igs_ca_inst.cal_type%TYPE;
602: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
603: l_load_ci_alt_code igs_ca_inst.alternate_code%TYPE ;
604: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE ;
605: l_load_ci_end_dt igs_ca_inst.end_dt%TYPE ;

Line 602: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;

598: l_message VARCHAR2(300);
599: l_term_calendar VARCHAR2(30);
600: l_schedule_disp igs_en_ss_disp_stps.academic_year_flag%TYPE;
601: l_load_cal_type igs_ca_inst.cal_type%TYPE;
602: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
603: l_load_ci_alt_code igs_ca_inst.alternate_code%TYPE ;
604: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE ;
605: l_load_ci_end_dt igs_ca_inst.end_dt%TYPE ;
606:

Line 603: l_load_ci_alt_code igs_ca_inst.alternate_code%TYPE ;

599: l_term_calendar VARCHAR2(30);
600: l_schedule_disp igs_en_ss_disp_stps.academic_year_flag%TYPE;
601: l_load_cal_type igs_ca_inst.cal_type%TYPE;
602: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
603: l_load_ci_alt_code igs_ca_inst.alternate_code%TYPE ;
604: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE ;
605: l_load_ci_end_dt igs_ca_inst.end_dt%TYPE ;
606:
607: BEGIN

Line 604: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE ;

600: l_schedule_disp igs_en_ss_disp_stps.academic_year_flag%TYPE;
601: l_load_cal_type igs_ca_inst.cal_type%TYPE;
602: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
603: l_load_ci_alt_code igs_ca_inst.alternate_code%TYPE ;
604: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE ;
605: l_load_ci_end_dt igs_ca_inst.end_dt%TYPE ;
606:
607: BEGIN
608:

Line 605: l_load_ci_end_dt igs_ca_inst.end_dt%TYPE ;

601: l_load_cal_type igs_ca_inst.cal_type%TYPE;
602: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
603: l_load_ci_alt_code igs_ca_inst.alternate_code%TYPE ;
604: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE ;
605: l_load_ci_end_dt igs_ca_inst.end_dt%TYPE ;
606:
607: BEGIN
608:
609: l_schedule_disp := 'N';

Line 684: FROM igs_ca_inst ci,

680:
681: -- Get the first Term calendar
682: CURSOR c_first_term_acad(cp_acad_cal_type VARCHAR2,cp_acad_ci_sequence_number NUMBER) IS
683: SELECT ci.start_dt
684: FROM igs_ca_inst ci,
685: igs_ca_inst_rel cir,
686: igs_ca_type ct,
687: igs_ca_stat cs
688: WHERE ci.cal_type = cir.sub_cal_type AND

Line 685: igs_ca_inst_rel cir,

681: -- Get the first Term calendar
682: CURSOR c_first_term_acad(cp_acad_cal_type VARCHAR2,cp_acad_ci_sequence_number NUMBER) IS
683: SELECT ci.start_dt
684: FROM igs_ca_inst ci,
685: igs_ca_inst_rel cir,
686: igs_ca_type ct,
687: igs_ca_stat cs
688: WHERE ci.cal_type = cir.sub_cal_type AND
689: ci.sequence_number = cir.sub_ci_sequence_number AND

Line 706: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

702: WHERE person_id = cp_person_id AND
703: course_cd = cp_program_cd;
704:
705: l_acad_year_flag igs_en_ss_disp_stps.academic_year_flag%TYPE;
706: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
707: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
708: l_message VARCHAR2(300);
709: l_schedule_disp igs_en_ss_disp_stps.academic_year_flag%TYPE;
710: l_term_start_dt DATE ;

Line 707: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

703: course_cd = cp_program_cd;
704:
705: l_acad_year_flag igs_en_ss_disp_stps.academic_year_flag%TYPE;
706: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
707: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
708: l_message VARCHAR2(300);
709: l_schedule_disp igs_en_ss_disp_stps.academic_year_flag%TYPE;
710: l_term_start_dt DATE ;
711:

Line 712: l_load_cal_type igs_ca_inst.cal_type%TYPE;

708: l_message VARCHAR2(300);
709: l_schedule_disp igs_en_ss_disp_stps.academic_year_flag%TYPE;
710: l_term_start_dt DATE ;
711:
712: l_load_cal_type igs_ca_inst.cal_type%TYPE;
713: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
714: l_load_ci_alt_code igs_ca_inst.alternate_code%TYPE ;
715: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE ;
716: l_load_ci_end_dt igs_ca_inst.end_dt%TYPE ;

Line 713: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;

709: l_schedule_disp igs_en_ss_disp_stps.academic_year_flag%TYPE;
710: l_term_start_dt DATE ;
711:
712: l_load_cal_type igs_ca_inst.cal_type%TYPE;
713: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
714: l_load_ci_alt_code igs_ca_inst.alternate_code%TYPE ;
715: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE ;
716: l_load_ci_end_dt igs_ca_inst.end_dt%TYPE ;
717:

Line 714: l_load_ci_alt_code igs_ca_inst.alternate_code%TYPE ;

710: l_term_start_dt DATE ;
711:
712: l_load_cal_type igs_ca_inst.cal_type%TYPE;
713: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
714: l_load_ci_alt_code igs_ca_inst.alternate_code%TYPE ;
715: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE ;
716: l_load_ci_end_dt igs_ca_inst.end_dt%TYPE ;
717:
718: BEGIN

Line 715: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE ;

711:
712: l_load_cal_type igs_ca_inst.cal_type%TYPE;
713: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
714: l_load_ci_alt_code igs_ca_inst.alternate_code%TYPE ;
715: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE ;
716: l_load_ci_end_dt igs_ca_inst.end_dt%TYPE ;
717:
718: BEGIN
719: l_term_start_dt := SYSDATE;

Line 716: l_load_ci_end_dt igs_ca_inst.end_dt%TYPE ;

712: l_load_cal_type igs_ca_inst.cal_type%TYPE;
713: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
714: l_load_ci_alt_code igs_ca_inst.alternate_code%TYPE ;
715: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE ;
716: l_load_ci_end_dt igs_ca_inst.end_dt%TYPE ;
717:
718: BEGIN
719: l_term_start_dt := SYSDATE;
720: l_schedule_disp := 'N';

Line 1015: FROM igs_ca_inst

1011: --
1012: -------------------------------------------------------------------
1013: CURSOR cur_cal_desc IS
1014: SELECT description
1015: FROM igs_ca_inst
1016: WHERE cal_type = p_cal_type
1017: AND sequence_number = p_sequence_number;
1018: l_c_description igs_ca_inst.description%TYPE;
1019: BEGIN

Line 1018: l_c_description igs_ca_inst.description%TYPE;

1014: SELECT description
1015: FROM igs_ca_inst
1016: WHERE cal_type = p_cal_type
1017: AND sequence_number = p_sequence_number;
1018: l_c_description igs_ca_inst.description%TYPE;
1019: BEGIN
1020: OPEN cur_cal_desc;
1021: FETCH cur_cal_desc INTO l_c_description;
1022: CLOSE cur_cal_desc;

Line 1045: l_c_acad_cal_type igs_ca_inst.cal_type%TYPE;

1041: --Who When What
1042: --
1043: -------------------------------------------------------------------
1044: l_c_result VARCHAR2(1000);
1045: l_c_acad_cal_type igs_ca_inst.cal_type%TYPE;
1046: l_n_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1047: l_d_acad_ci_start_dt DATE;
1048: l_d_acad_ci_end_dt DATE;
1049: l_c_message_name fnd_new_messages.message_name%TYPE;

Line 1046: l_n_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

1042: --
1043: -------------------------------------------------------------------
1044: l_c_result VARCHAR2(1000);
1045: l_c_acad_cal_type igs_ca_inst.cal_type%TYPE;
1046: l_n_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1047: l_d_acad_ci_start_dt DATE;
1048: l_d_acad_ci_end_dt DATE;
1049: l_c_message_name fnd_new_messages.message_name%TYPE;
1050: BEGIN