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_SPA_TERMS_API dependencies on IGS_EN_SPA_TERMS

Line 1: PACKAGE BODY IGS_EN_SPA_TERMS_API AS

1: PACKAGE BODY IGS_EN_SPA_TERMS_API AS
2: /* $Header: IGSENB1B.pls 120.14 2005/11/28 02:26:46 appldev noship $ */
3:
4: CURSOR c_term_exists(cp_person_id IGS_PE_PERSON.person_id%TYPE,
5: cp_program_cd IGS_PS_VER.course_cd%TYPE,

Line 10: FROM IGS_EN_SPA_TERMS spat, igs_ps_ver cv1

6: cp_program_version IGS_PS_VER.version_number%TYPE,
7: cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
8: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
9: SELECT spat.term_record_id
10: FROM IGS_EN_SPA_TERMS spat, igs_ps_ver cv1
11: WHERE spat.person_id = cp_person_id
12: AND spat.term_cal_type = cp_term_cal_type
13: AND spat.term_sequence_number = cp_term_sequence_number
14: AND cv1.course_cd = spat.program_cd

Line 97: select program_cd from igs_en_spa_terms where person_id = p_person_id

93: p_term_sequence_number IN igs_ca_inst.sequence_number%TYPE) RETURN VARCHAR2
94: AS
95: -- Check if key term record exists for the passed in term calendar
96: cursor c_key_record_exists IS
97: select program_cd from igs_en_spa_terms where person_id = p_person_id
98: and key_program_flag = 'Y'
99: and term_cal_type = p_term_cal_type
100: and term_sequence_number = p_term_sequence_number;
101:

Line 105: FROM igs_en_spa_terms spat, igs_ca_inst ca1

101:
102: -- Check the oldest key term record in terms table
103: CURSOR c_oldest_term IS
104: SELECT program_cd, acad_cal_type
105: FROM igs_en_spa_terms spat, igs_ca_inst ca1
106: WHERE person_id = p_person_id
107: AND spat.term_cal_type = ca1.cal_type
108: AND spat.term_sequence_number = ca1.sequence_number
109: AND spat.key_program_flag = 'Y'

Line 114: select program_cd, acad_cal_type from igs_en_spa_terms spat, igs_ca_inst ca1, igs_ca_inst ca2

110: ORDER BY ca1.start_dt ASC;
111:
112: -- Check the key term record before this term
113: CURSOR c_key_from_prev_term IS
114: select program_cd, acad_cal_type from igs_en_spa_terms spat, igs_ca_inst ca1, igs_ca_inst ca2
115: where key_program_flag = 'Y'
116: and person_id = p_person_id
117: and ca1.cal_type = term_cal_type
118: and ca1.sequence_number = term_sequence_number

Line 175: SELECT * from igs_en_spa_terms

171: p_term_sequence_number IN NUMBER, p_term_rec OUT NOCOPY EN_SPAT_REC_TYPE%TYPE) AS
172:
173: -- ## Get the term details information for the effective term
174: CURSOR c_term IS
175: SELECT * from igs_en_spa_terms
176: WHERE person_id = p_person_id
177: AND program_cd = p_program_cd
178: AND term_cal_type = p_term_cal_type
179: AND term_sequence_number = p_term_sequence_number;

Line 186: IGS_EN_SPA_TERMS SPAT,

182: CURSOR c_prev_term IS
183: SELECT
184: SPAT.*
185: FROM
186: IGS_EN_SPA_TERMS SPAT,
187: IGS_CA_INST CI1,
188: IGS_CA_INST CI2
189: WHERE
190: SPAT.PERSON_ID = p_person_id AND

Line 405: FROM IGS_EN_SPA_TERMS spat, igs_ps_ver cv1

401: cp_program_version IGS_PS_VER.version_number%TYPE,
402: cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
403: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
404: SELECT spat.term_record_id
405: FROM IGS_EN_SPA_TERMS spat, igs_ps_ver cv1
406: WHERE spat.person_id = cp_person_id
407: AND spat.term_cal_type = cp_term_cal_type
408: AND spat.term_sequence_number = cp_term_sequence_number
409: AND cv1.course_cd = spat.program_cd

Line 461: l_term_record_id IGS_EN_SPA_TERMS.TERM_RECORD_ID%TYPE;

457: -- defailt TRUE
458: v_insert_rec BOOLEAN;
459:
460: l_rowid VARCHAR2(25);
461: l_term_record_id IGS_EN_SPA_TERMS.TERM_RECORD_ID%TYPE;
462:
463:
464: -- cursor to fetch rowid for given term record details
465: -- used in updating an existing term record

Line 468: FROM IGS_EN_SPA_TERMS spat

464: -- cursor to fetch rowid for given term record details
465: -- used in updating an existing term record
466: Cursor cur_spat (cp_term_record_id IN NUMBER) IS
467: SELECT spat.rowid, spat.program_cd, spat.acad_cal_type
468: FROM IGS_EN_SPA_TERMS spat
469: WHERE spat.term_record_id = cp_term_record_id;
470:
471: vc_cur_spat_rec cur_spat%ROWTYPE;
472: CURSOR c_check_planning_sheet (p_person_id IGS_EN_PLAN_UNITS.PERSON_ID%TYPE,

Line 486: l_plan_sht_status IGS_EN_SPA_TERMS.PLAN_SHT_STATUS%TYPE;

482: AND term_ci_sequence_number = p_term_ci_sequence
483: AND cart_error_flag = 'N';
484:
485: v_planning_sheet_rec c_check_planning_sheet%ROWTYPE;
486: l_plan_sht_status IGS_EN_SPA_TERMS.PLAN_SHT_STATUS%TYPE;
487: BEGIN
488:
489: OPEN c_term_exists (p_term_rec.person_id,p_term_rec.program_cd,
490: p_term_rec.program_version,p_term_rec.term_cal_type,

Line 507: IGS_EN_SPA_TERMS_PKG.insert_row(

503: -- call table handler to insert new term record details
504: l_term_record_id := NULL;
505: l_rowid := NULL;
506:
507: IGS_EN_SPA_TERMS_PKG.insert_row(
508: x_rowid => l_rowid,
509: x_term_record_id => l_term_record_id,
510: x_person_id => p_term_rec.person_id,
511: x_program_cd => p_term_rec.program_cd,

Line 591: IGS_EN_SPA_TERMS_PKG.update_row(

587: -- term record details exist and will be updated
588: -- call table handler to update term record details
589:
590:
591: IGS_EN_SPA_TERMS_PKG.update_row(
592: x_rowid => vc_cur_spat_rec.rowid,
593: x_term_record_id => p_term_rec.term_record_id,
594: x_person_id => p_term_rec.person_id,
595: x_program_cd => p_term_rec.program_cd,

Line 660: FROM IGS_EN_SPA_TERMS spat,

656: CURSOR c_future_terms (cp_chk_othr_prms VARCHAR2,
657: cp_program_version NUMBER,
658: cp_acad_cal_type igs_ca_inst.cal_type%TYPE) IS
659: SELECT spat.*
660: FROM IGS_EN_SPA_TERMS spat,
661: IGS_CA_INST_REL cr,
662: IGS_CA_INST_REL cr2,
663: IGS_CA_INST ci,
664: IGS_PS_VER cv

Line 759: v_person_id IGS_EN_SPA_TERMS.PERSON_ID%TYPE;

755: v_context_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
756: v_next_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
757: v_next_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
758:
759: v_person_id IGS_EN_SPA_TERMS.PERSON_ID%TYPE;
760: v_program_cd IGS_EN_SPA_TERMS.PROGRAM_CD%TYPE;
761: v_program_version IGS_EN_SPA_TERMS.PROGRAM_VERSION%TYPE;
762: v_coo_id IGS_EN_SPA_TERMS.COO_ID%TYPE;
763: v_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE;

Line 760: v_program_cd IGS_EN_SPA_TERMS.PROGRAM_CD%TYPE;

756: v_next_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
757: v_next_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
758:
759: v_person_id IGS_EN_SPA_TERMS.PERSON_ID%TYPE;
760: v_program_cd IGS_EN_SPA_TERMS.PROGRAM_CD%TYPE;
761: v_program_version IGS_EN_SPA_TERMS.PROGRAM_VERSION%TYPE;
762: v_coo_id IGS_EN_SPA_TERMS.COO_ID%TYPE;
763: v_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE;
764: v_key_program_flag IGS_EN_SPA_TERMS.KEY_PROGRAM_FLAG%TYPE;

Line 761: v_program_version IGS_EN_SPA_TERMS.PROGRAM_VERSION%TYPE;

757: v_next_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
758:
759: v_person_id IGS_EN_SPA_TERMS.PERSON_ID%TYPE;
760: v_program_cd IGS_EN_SPA_TERMS.PROGRAM_CD%TYPE;
761: v_program_version IGS_EN_SPA_TERMS.PROGRAM_VERSION%TYPE;
762: v_coo_id IGS_EN_SPA_TERMS.COO_ID%TYPE;
763: v_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE;
764: v_key_program_flag IGS_EN_SPA_TERMS.KEY_PROGRAM_FLAG%TYPE;
765: v_location_cd IGS_EN_SPA_TERMS.LOCATION_CD%TYPE;

Line 762: v_coo_id IGS_EN_SPA_TERMS.COO_ID%TYPE;

758:
759: v_person_id IGS_EN_SPA_TERMS.PERSON_ID%TYPE;
760: v_program_cd IGS_EN_SPA_TERMS.PROGRAM_CD%TYPE;
761: v_program_version IGS_EN_SPA_TERMS.PROGRAM_VERSION%TYPE;
762: v_coo_id IGS_EN_SPA_TERMS.COO_ID%TYPE;
763: v_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE;
764: v_key_program_flag IGS_EN_SPA_TERMS.KEY_PROGRAM_FLAG%TYPE;
765: v_location_cd IGS_EN_SPA_TERMS.LOCATION_CD%TYPE;
766: v_attendance_mode IGS_EN_SPA_TERMS.ATTENDANCE_MODE%TYPE;

Line 763: v_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE;

759: v_person_id IGS_EN_SPA_TERMS.PERSON_ID%TYPE;
760: v_program_cd IGS_EN_SPA_TERMS.PROGRAM_CD%TYPE;
761: v_program_version IGS_EN_SPA_TERMS.PROGRAM_VERSION%TYPE;
762: v_coo_id IGS_EN_SPA_TERMS.COO_ID%TYPE;
763: v_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE;
764: v_key_program_flag IGS_EN_SPA_TERMS.KEY_PROGRAM_FLAG%TYPE;
765: v_location_cd IGS_EN_SPA_TERMS.LOCATION_CD%TYPE;
766: v_attendance_mode IGS_EN_SPA_TERMS.ATTENDANCE_MODE%TYPE;
767: v_attendance_type IGS_EN_SPA_TERMS.ATTENDANCE_TYPE%TYPE;

Line 764: v_key_program_flag IGS_EN_SPA_TERMS.KEY_PROGRAM_FLAG%TYPE;

760: v_program_cd IGS_EN_SPA_TERMS.PROGRAM_CD%TYPE;
761: v_program_version IGS_EN_SPA_TERMS.PROGRAM_VERSION%TYPE;
762: v_coo_id IGS_EN_SPA_TERMS.COO_ID%TYPE;
763: v_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE;
764: v_key_program_flag IGS_EN_SPA_TERMS.KEY_PROGRAM_FLAG%TYPE;
765: v_location_cd IGS_EN_SPA_TERMS.LOCATION_CD%TYPE;
766: v_attendance_mode IGS_EN_SPA_TERMS.ATTENDANCE_MODE%TYPE;
767: v_attendance_type IGS_EN_SPA_TERMS.ATTENDANCE_TYPE%TYPE;
768: v_fee_cat IGS_EN_SPA_TERMS.FEE_CAT%TYPE;

Line 765: v_location_cd IGS_EN_SPA_TERMS.LOCATION_CD%TYPE;

761: v_program_version IGS_EN_SPA_TERMS.PROGRAM_VERSION%TYPE;
762: v_coo_id IGS_EN_SPA_TERMS.COO_ID%TYPE;
763: v_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE;
764: v_key_program_flag IGS_EN_SPA_TERMS.KEY_PROGRAM_FLAG%TYPE;
765: v_location_cd IGS_EN_SPA_TERMS.LOCATION_CD%TYPE;
766: v_attendance_mode IGS_EN_SPA_TERMS.ATTENDANCE_MODE%TYPE;
767: v_attendance_type IGS_EN_SPA_TERMS.ATTENDANCE_TYPE%TYPE;
768: v_fee_cat IGS_EN_SPA_TERMS.FEE_CAT%TYPE;
769: v_class_standing_id IGS_EN_SPA_TERMS.CLASS_STANDING_ID%TYPE;

Line 766: v_attendance_mode IGS_EN_SPA_TERMS.ATTENDANCE_MODE%TYPE;

762: v_coo_id IGS_EN_SPA_TERMS.COO_ID%TYPE;
763: v_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE;
764: v_key_program_flag IGS_EN_SPA_TERMS.KEY_PROGRAM_FLAG%TYPE;
765: v_location_cd IGS_EN_SPA_TERMS.LOCATION_CD%TYPE;
766: v_attendance_mode IGS_EN_SPA_TERMS.ATTENDANCE_MODE%TYPE;
767: v_attendance_type IGS_EN_SPA_TERMS.ATTENDANCE_TYPE%TYPE;
768: v_fee_cat IGS_EN_SPA_TERMS.FEE_CAT%TYPE;
769: v_class_standing_id IGS_EN_SPA_TERMS.CLASS_STANDING_ID%TYPE;
770:

Line 767: v_attendance_type IGS_EN_SPA_TERMS.ATTENDANCE_TYPE%TYPE;

763: v_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE;
764: v_key_program_flag IGS_EN_SPA_TERMS.KEY_PROGRAM_FLAG%TYPE;
765: v_location_cd IGS_EN_SPA_TERMS.LOCATION_CD%TYPE;
766: v_attendance_mode IGS_EN_SPA_TERMS.ATTENDANCE_MODE%TYPE;
767: v_attendance_type IGS_EN_SPA_TERMS.ATTENDANCE_TYPE%TYPE;
768: v_fee_cat IGS_EN_SPA_TERMS.FEE_CAT%TYPE;
769: v_class_standing_id IGS_EN_SPA_TERMS.CLASS_STANDING_ID%TYPE;
770:
771: -- cursor to fetch backward term gaps

Line 768: v_fee_cat IGS_EN_SPA_TERMS.FEE_CAT%TYPE;

764: v_key_program_flag IGS_EN_SPA_TERMS.KEY_PROGRAM_FLAG%TYPE;
765: v_location_cd IGS_EN_SPA_TERMS.LOCATION_CD%TYPE;
766: v_attendance_mode IGS_EN_SPA_TERMS.ATTENDANCE_MODE%TYPE;
767: v_attendance_type IGS_EN_SPA_TERMS.ATTENDANCE_TYPE%TYPE;
768: v_fee_cat IGS_EN_SPA_TERMS.FEE_CAT%TYPE;
769: v_class_standing_id IGS_EN_SPA_TERMS.CLASS_STANDING_ID%TYPE;
770:
771: -- cursor to fetch backward term gaps
772: CURSOR c_backward_gap(cp_context_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

Line 769: v_class_standing_id IGS_EN_SPA_TERMS.CLASS_STANDING_ID%TYPE;

765: v_location_cd IGS_EN_SPA_TERMS.LOCATION_CD%TYPE;
766: v_attendance_mode IGS_EN_SPA_TERMS.ATTENDANCE_MODE%TYPE;
767: v_attendance_type IGS_EN_SPA_TERMS.ATTENDANCE_TYPE%TYPE;
768: v_fee_cat IGS_EN_SPA_TERMS.FEE_CAT%TYPE;
769: v_class_standing_id IGS_EN_SPA_TERMS.CLASS_STANDING_ID%TYPE;
770:
771: -- cursor to fetch backward term gaps
772: CURSOR c_backward_gap(cp_context_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
773: cp_context_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE,

Line 836: FROM IGS_EN_SPA_TERMS SPT,

832: SPT.ATTENDANCE_MODE,
833: SPT.ATTENDANCE_TYPE,
834: SPT.FEE_CAT,
835: SPT.CLASS_STANDING_ID
836: FROM IGS_EN_SPA_TERMS SPT,
837: IGS_PS_VER CV,
838: IGS_CA_INST CI,
839: IGS_CA_INST CI2
840: WHERE SPT.PERSON_ID = :1

Line 882: FROM IGS_EN_SPA_TERMS SPT,

878: SPT.ATTENDANCE_MODE,
879: SPT.ATTENDANCE_TYPE,
880: SPT.FEE_CAT,
881: SPT.CLASS_STANDING_ID
882: FROM IGS_EN_SPA_TERMS SPT,
883: IGS_CA_INST CI,
884: IGS_CA_INST CI2
885: WHERE SPT.PERSON_ID = :1
886: AND SPT.PROGRAM_CD = :2

Line 986: vn_person_id IGS_EN_SPA_TERMS.PERSON_ID%TYPE;

982: vn_curr_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
983: vc_next_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
984: vn_next_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
985:
986: vn_person_id IGS_EN_SPA_TERMS.PERSON_ID%TYPE;
987: vc_program_cd IGS_EN_SPA_TERMS.PROGRAM_CD%TYPE;
988: vn_program_version IGS_EN_SPA_TERMS.PROGRAM_VERSION%TYPE;
989: vn_coo_id IGS_EN_SPA_TERMS.COO_ID%TYPE;
990: vc_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE;

Line 987: vc_program_cd IGS_EN_SPA_TERMS.PROGRAM_CD%TYPE;

983: vc_next_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
984: vn_next_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
985:
986: vn_person_id IGS_EN_SPA_TERMS.PERSON_ID%TYPE;
987: vc_program_cd IGS_EN_SPA_TERMS.PROGRAM_CD%TYPE;
988: vn_program_version IGS_EN_SPA_TERMS.PROGRAM_VERSION%TYPE;
989: vn_coo_id IGS_EN_SPA_TERMS.COO_ID%TYPE;
990: vc_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE;
991: vc_key_program_flag IGS_EN_SPA_TERMS.KEY_PROGRAM_FLAG%TYPE;

Line 988: vn_program_version IGS_EN_SPA_TERMS.PROGRAM_VERSION%TYPE;

984: vn_next_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
985:
986: vn_person_id IGS_EN_SPA_TERMS.PERSON_ID%TYPE;
987: vc_program_cd IGS_EN_SPA_TERMS.PROGRAM_CD%TYPE;
988: vn_program_version IGS_EN_SPA_TERMS.PROGRAM_VERSION%TYPE;
989: vn_coo_id IGS_EN_SPA_TERMS.COO_ID%TYPE;
990: vc_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE;
991: vc_key_program_flag IGS_EN_SPA_TERMS.KEY_PROGRAM_FLAG%TYPE;
992: vc_location_cd IGS_EN_SPA_TERMS.LOCATION_CD%TYPE;

Line 989: vn_coo_id IGS_EN_SPA_TERMS.COO_ID%TYPE;

985:
986: vn_person_id IGS_EN_SPA_TERMS.PERSON_ID%TYPE;
987: vc_program_cd IGS_EN_SPA_TERMS.PROGRAM_CD%TYPE;
988: vn_program_version IGS_EN_SPA_TERMS.PROGRAM_VERSION%TYPE;
989: vn_coo_id IGS_EN_SPA_TERMS.COO_ID%TYPE;
990: vc_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE;
991: vc_key_program_flag IGS_EN_SPA_TERMS.KEY_PROGRAM_FLAG%TYPE;
992: vc_location_cd IGS_EN_SPA_TERMS.LOCATION_CD%TYPE;
993: vc_attendance_mode IGS_EN_SPA_TERMS.ATTENDANCE_MODE%TYPE;

Line 990: vc_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE;

986: vn_person_id IGS_EN_SPA_TERMS.PERSON_ID%TYPE;
987: vc_program_cd IGS_EN_SPA_TERMS.PROGRAM_CD%TYPE;
988: vn_program_version IGS_EN_SPA_TERMS.PROGRAM_VERSION%TYPE;
989: vn_coo_id IGS_EN_SPA_TERMS.COO_ID%TYPE;
990: vc_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE;
991: vc_key_program_flag IGS_EN_SPA_TERMS.KEY_PROGRAM_FLAG%TYPE;
992: vc_location_cd IGS_EN_SPA_TERMS.LOCATION_CD%TYPE;
993: vc_attendance_mode IGS_EN_SPA_TERMS.ATTENDANCE_MODE%TYPE;
994: vc_attendance_type IGS_EN_SPA_TERMS.ATTENDANCE_TYPE%TYPE;

Line 991: vc_key_program_flag IGS_EN_SPA_TERMS.KEY_PROGRAM_FLAG%TYPE;

987: vc_program_cd IGS_EN_SPA_TERMS.PROGRAM_CD%TYPE;
988: vn_program_version IGS_EN_SPA_TERMS.PROGRAM_VERSION%TYPE;
989: vn_coo_id IGS_EN_SPA_TERMS.COO_ID%TYPE;
990: vc_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE;
991: vc_key_program_flag IGS_EN_SPA_TERMS.KEY_PROGRAM_FLAG%TYPE;
992: vc_location_cd IGS_EN_SPA_TERMS.LOCATION_CD%TYPE;
993: vc_attendance_mode IGS_EN_SPA_TERMS.ATTENDANCE_MODE%TYPE;
994: vc_attendance_type IGS_EN_SPA_TERMS.ATTENDANCE_TYPE%TYPE;
995: vc_fee_cat IGS_EN_SPA_TERMS.FEE_CAT%TYPE;

Line 992: vc_location_cd IGS_EN_SPA_TERMS.LOCATION_CD%TYPE;

988: vn_program_version IGS_EN_SPA_TERMS.PROGRAM_VERSION%TYPE;
989: vn_coo_id IGS_EN_SPA_TERMS.COO_ID%TYPE;
990: vc_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE;
991: vc_key_program_flag IGS_EN_SPA_TERMS.KEY_PROGRAM_FLAG%TYPE;
992: vc_location_cd IGS_EN_SPA_TERMS.LOCATION_CD%TYPE;
993: vc_attendance_mode IGS_EN_SPA_TERMS.ATTENDANCE_MODE%TYPE;
994: vc_attendance_type IGS_EN_SPA_TERMS.ATTENDANCE_TYPE%TYPE;
995: vc_fee_cat IGS_EN_SPA_TERMS.FEE_CAT%TYPE;
996: vc_class_standing_id IGS_EN_SPA_TERMS.CLASS_STANDING_ID%TYPE;

Line 993: vc_attendance_mode IGS_EN_SPA_TERMS.ATTENDANCE_MODE%TYPE;

989: vn_coo_id IGS_EN_SPA_TERMS.COO_ID%TYPE;
990: vc_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE;
991: vc_key_program_flag IGS_EN_SPA_TERMS.KEY_PROGRAM_FLAG%TYPE;
992: vc_location_cd IGS_EN_SPA_TERMS.LOCATION_CD%TYPE;
993: vc_attendance_mode IGS_EN_SPA_TERMS.ATTENDANCE_MODE%TYPE;
994: vc_attendance_type IGS_EN_SPA_TERMS.ATTENDANCE_TYPE%TYPE;
995: vc_fee_cat IGS_EN_SPA_TERMS.FEE_CAT%TYPE;
996: vc_class_standing_id IGS_EN_SPA_TERMS.CLASS_STANDING_ID%TYPE;
997:

Line 994: vc_attendance_type IGS_EN_SPA_TERMS.ATTENDANCE_TYPE%TYPE;

990: vc_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE;
991: vc_key_program_flag IGS_EN_SPA_TERMS.KEY_PROGRAM_FLAG%TYPE;
992: vc_location_cd IGS_EN_SPA_TERMS.LOCATION_CD%TYPE;
993: vc_attendance_mode IGS_EN_SPA_TERMS.ATTENDANCE_MODE%TYPE;
994: vc_attendance_type IGS_EN_SPA_TERMS.ATTENDANCE_TYPE%TYPE;
995: vc_fee_cat IGS_EN_SPA_TERMS.FEE_CAT%TYPE;
996: vc_class_standing_id IGS_EN_SPA_TERMS.CLASS_STANDING_ID%TYPE;
997:
998: CURSOR c_forward_gap (cp_next_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

Line 995: vc_fee_cat IGS_EN_SPA_TERMS.FEE_CAT%TYPE;

991: vc_key_program_flag IGS_EN_SPA_TERMS.KEY_PROGRAM_FLAG%TYPE;
992: vc_location_cd IGS_EN_SPA_TERMS.LOCATION_CD%TYPE;
993: vc_attendance_mode IGS_EN_SPA_TERMS.ATTENDANCE_MODE%TYPE;
994: vc_attendance_type IGS_EN_SPA_TERMS.ATTENDANCE_TYPE%TYPE;
995: vc_fee_cat IGS_EN_SPA_TERMS.FEE_CAT%TYPE;
996: vc_class_standing_id IGS_EN_SPA_TERMS.CLASS_STANDING_ID%TYPE;
997:
998: CURSOR c_forward_gap (cp_next_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
999: cp_next_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE,

Line 996: vc_class_standing_id IGS_EN_SPA_TERMS.CLASS_STANDING_ID%TYPE;

992: vc_location_cd IGS_EN_SPA_TERMS.LOCATION_CD%TYPE;
993: vc_attendance_mode IGS_EN_SPA_TERMS.ATTENDANCE_MODE%TYPE;
994: vc_attendance_type IGS_EN_SPA_TERMS.ATTENDANCE_TYPE%TYPE;
995: vc_fee_cat IGS_EN_SPA_TERMS.FEE_CAT%TYPE;
996: vc_class_standing_id IGS_EN_SPA_TERMS.CLASS_STANDING_ID%TYPE;
997:
998: CURSOR c_forward_gap (cp_next_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
999: cp_next_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE,
1000: cp_curr_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

Line 1038: FROM IGS_EN_SPA_TERMS

1034: CURSOR c_other_recs ( cp_term_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1035: cp_term_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE,
1036: cp_program_cd IGS_PS_VER.COURSE_CD%TYPE) IS
1037: SELECT *
1038: FROM IGS_EN_SPA_TERMS
1039: WHERE person_id = p_term_rec.person_id
1040: AND program_cd <> cp_program_cd
1041: AND term_cal_type = cp_term_cal_type
1042: AND term_sequence_number = cp_term_sequence_number

Line 1062: FROM IGS_EN_SPA_TERMS SPT,

1058: v_forward_gap_exists_stmt := 'SELECT CI2.CAL_TYPE,
1059: CI2.SEQUENCE_NUMBER,
1060: CI.CAL_TYPE,
1061: CI.SEQUENCE_NUMBER
1062: FROM IGS_EN_SPA_TERMS SPT,
1063: IGS_PS_VER CV,
1064: IGS_CA_INST CI,
1065: IGS_CA_INST CI2
1066: WHERE SPT.PERSON_ID = :1

Line 1089: FROM IGS_EN_SPA_TERMS SPT,

1085: v_forward_gap_exists_stmt := 'SELECT CI2.CAL_TYPE,
1086: CI2.SEQUENCE_NUMBER,
1087: CI.CAL_TYPE,
1088: CI.SEQUENCE_NUMBER
1089: FROM IGS_EN_SPA_TERMS SPT,
1090: IGS_CA_INST CI,
1091: IGS_CA_INST CI2
1092: WHERE SPT.PERSON_ID = :1
1093: AND SPT.PROGRAM_CD = :2

Line 1192: l_term_id IGS_EN_SPA_TERMS.term_record_id%TYPE;

1188: and ct.s_cal_cat = 'LOAD';
1189:
1190:
1191: l_dummy VARCHAR2(1);
1192: l_term_id IGS_EN_SPA_TERMS.term_record_id%TYPE;
1193: l_insert_rec BOOLEAN;
1194: new_term_rec EN_SPAT_REC_TYPE%TYPE;
1195: old_term_rec EN_SPAT_REC_TYPE%TYPE;
1196: l_username VARCHAR2(20);

Line 1311: FROM igs_en_spa_terms spat, igs_ca_inst ca1, igs_ca_inst ca2

1307: p_term_rec IN EN_SPAT_REC_TYPE%TYPE) AS
1308:
1309: CURSOR c_future_key_terms IS
1310: SELECT spat.rowid, spat.*
1311: FROM igs_en_spa_terms spat, igs_ca_inst ca1, igs_ca_inst ca2
1312: WHERE ca1.cal_type = spat.term_cal_type
1313: AND ca1.sequence_number = spat.term_sequence_number
1314: AND ca2.cal_type = p_term_cal_type
1315: AND ca2.sequence_number = p_term_sequence_number

Line 1322: FROM igs_en_spa_terms spat, igs_ca_inst ca, igs_ca_inst_rel cir

1318: AND spat.key_program_flag = 'Y';
1319:
1320: CURSOR c_latest_term_in_acad IS -- check if the latest term in acad is for this program
1321: SELECT spat.rowid, spat.program_cd, term_cal_type, term_sequence_number
1322: FROM igs_en_spa_terms spat, igs_ca_inst ca, igs_ca_inst_rel cir
1323: WHERE spat.person_id = p_person_id
1324: AND ca.cal_type = spat.term_cal_type
1325: AND ca.sequence_number = spat.term_sequence_number
1326: AND cir.sub_cal_type = p_term_cal_type

Line 1333: FROM igs_en_spa_terms spat

1329: ORDER BY ca.start_dt DESC;
1330:
1331: CURSOR c_dest_term IS
1332: SELECT spat.rowid, spat.term_record_id
1333: FROM igs_en_spa_terms spat
1334: WHERE person_id = p_person_id
1335: AND program_cd = p_program_cd
1336: AND term_cal_type = p_term_cal_type
1337: AND term_sequence_number = p_term_sequence_number;

Line 1341: FROM IGS_EN_SPA_TERMS spat,

1337: AND term_sequence_number = p_term_sequence_number;
1338:
1339: CURSOR c_dest_fut_terms IS
1340: SELECT spat.rowid,spat.*
1341: FROM IGS_EN_SPA_TERMS spat,
1342: IGS_CA_INST_REL cr,
1343: IGS_CA_INST_REL cr2,
1344: IGS_CA_INST ci,
1345: IGS_PS_VER cv

Line 1369: l_term_id IGS_EN_SPA_TERMS.term_record_id%TYPE;

1365: l_term_seq IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1366: l_message_name VARCHAR2(2000);
1367: l_term_rec EN_SPAT_REC_TYPE%TYPE;
1368: l_rowid ROWID;
1369: l_term_id IGS_EN_SPA_TERMS.term_record_id%TYPE;
1370: l_program_cd IGS_PS_VER.COURSE_CD%TYPE;
1371:
1372: BEGIN
1373: l_term_rec := p_term_rec;

Line 1377: IGS_EN_SPA_TERMS_PKG.update_row(

1373: l_term_rec := p_term_rec;
1374: -- Reset all future key term records as Non-Key
1375: FOR rec_future_key_terms IN c_future_key_terms LOOP
1376:
1377: IGS_EN_SPA_TERMS_PKG.update_row(
1378: x_rowid => rec_future_key_terms.rowid,
1379: x_term_record_id => rec_future_key_terms.term_record_id,
1380: x_person_id => rec_future_key_terms.person_id,
1381: x_program_cd => rec_future_key_terms.program_cd,

Line 1422: IGS_EN_SPA_TERMS_PKG.update_row(

1418: OPEN c_dest_term;
1419: FETCH c_dest_term INTO l_rowid, l_term_id;
1420: CLOSE c_dest_term;
1421: -- Update the destination term record as Key
1422: IGS_EN_SPA_TERMS_PKG.update_row(
1423: x_rowid => l_rowid,
1424: x_term_record_id => l_term_id,
1425: x_person_id => l_term_rec.person_id,
1426: x_program_cd => l_term_rec.program_cd,

Line 1466: IGS_EN_SPA_TERMS_PKG.update_row(

1462: FOR rec_dest_fut_terms IN c_dest_fut_terms LOOP
1463:
1464: -- Set all destination future terms as Key terms.
1465:
1466: IGS_EN_SPA_TERMS_PKG.update_row(
1467: x_rowid => rec_dest_fut_terms.rowid,
1468: x_term_record_id => rec_dest_fut_terms.term_record_id,
1469: x_person_id => rec_dest_fut_terms.person_id,
1470: x_program_cd => rec_dest_fut_terms.program_cd,

Line 1521: SELECT fee_cat from igs_en_spa_terms

1517: ) RETURN VARCHAR2
1518: AS
1519: -- ## Get the term details information for the effective term
1520: CURSOR c_term IS
1521: SELECT fee_cat from igs_en_spa_terms
1522: WHERE person_id = p_person_id
1523: AND program_cd = p_program_cd
1524: AND term_cal_type = p_term_cal_type
1525: AND term_sequence_number = p_term_sequence_number;

Line 1532: IGS_EN_SPA_TERMS SPAT,

1528: CURSOR c_prev_term IS
1529: SELECT
1530: SPAT.fee_cat
1531: FROM
1532: IGS_EN_SPA_TERMS SPAT,
1533: IGS_CA_INST CI1,
1534: IGS_CA_INST CI2
1535: WHERE
1536: SPAT.PERSON_ID = p_person_id AND

Line 1556: l_fee_cat igs_en_spa_terms.fee_cat%TYPE;

1552: FROM igs_en_stdnt_ps_att
1553: WHERE person_id = p_person_id
1554: AND course_cd = p_program_cd;
1555:
1556: l_fee_cat igs_en_spa_terms.fee_cat%TYPE;
1557:
1558: BEGIN
1559: --## 1. If term record exists for the effective term then get the attribute details
1560: --## from it, set in EN_SPAT_REC_TYPE and exit

Line 1599: SELECT class_standing_id from igs_en_spa_terms

1595: AS
1596:
1597: -- ## Get the term details information for the effective term
1598: CURSOR c_term IS
1599: SELECT class_standing_id from igs_en_spa_terms
1600: WHERE person_id = p_person_id
1601: AND program_cd = p_program_cd
1602: AND term_cal_type = p_term_cal_type
1603: AND term_sequence_number = p_term_sequence_number;

Line 1610: IGS_EN_SPA_TERMS SPAT,

1606: CURSOR c_prev_term IS
1607: SELECT
1608: SPAT.class_standing_id
1609: FROM
1610: IGS_EN_SPA_TERMS SPAT,
1611: IGS_CA_INST CI1,
1612: IGS_CA_INST CI2
1613: WHERE
1614: SPAT.PERSON_ID = p_person_id AND

Line 1634: l_class_standing igs_en_spa_terms.class_standing_id%TYPE;

1630: FROM igs_en_stdnt_ps_att
1631: WHERE person_id = p_person_id
1632: AND course_cd = p_program_cd;
1633:
1634: l_class_standing igs_en_spa_terms.class_standing_id%TYPE;
1635:
1636: BEGIN
1637: --## 1. If term record exists for the effective term then get the attribute details
1638: --## from it, set in EN_SPAT_REC_TYPE and exit

Line 1677: SELECT coo_id from igs_en_spa_terms

1673: AS
1674:
1675: -- ## Get the term details information for the effective term
1676: CURSOR c_term IS
1677: SELECT coo_id from igs_en_spa_terms
1678: WHERE person_id = p_person_id
1679: AND program_cd = p_program_cd
1680: AND term_cal_type = p_term_cal_type
1681: AND term_sequence_number = p_term_sequence_number;

Line 1688: IGS_EN_SPA_TERMS SPAT,

1684: CURSOR c_prev_term IS
1685: SELECT
1686: SPAT.coo_id
1687: FROM
1688: IGS_EN_SPA_TERMS SPAT,
1689: IGS_CA_INST CI1,
1690: IGS_CA_INST CI2
1691: WHERE
1692: SPAT.PERSON_ID = p_person_id AND

Line 1712: l_coo_id igs_en_spa_terms.coo_id%TYPE;

1708: FROM igs_en_stdnt_ps_att
1709: WHERE person_id = p_person_id
1710: AND course_cd = p_program_cd;
1711:
1712: l_coo_id igs_en_spa_terms.coo_id%TYPE;
1713:
1714: BEGIN
1715: --## 1. If term record exists for the effective term then get the attribute details
1716: --## from it, set in EN_SPAT_REC_TYPE and exit

Line 1755: SELECT attendance_type from igs_en_spa_terms

1751: AS
1752:
1753: -- ## Get the term details information for the effective term
1754: CURSOR c_term IS
1755: SELECT attendance_type from igs_en_spa_terms
1756: WHERE person_id = p_person_id
1757: AND program_cd = p_program_cd
1758: AND term_cal_type = p_term_cal_type
1759: AND term_sequence_number = p_term_sequence_number;

Line 1766: IGS_EN_SPA_TERMS SPAT,

1762: CURSOR c_prev_term IS
1763: SELECT
1764: SPAT.attendance_type
1765: FROM
1766: IGS_EN_SPA_TERMS SPAT,
1767: IGS_CA_INST CI1,
1768: IGS_CA_INST CI2
1769: WHERE
1770: SPAT.PERSON_ID = p_person_id AND

Line 1790: l_attendance_type igs_en_spa_terms.attendance_type%TYPE;

1786: FROM igs_en_stdnt_ps_att
1787: WHERE person_id = p_person_id
1788: AND course_cd = p_program_cd;
1789:
1790: l_attendance_type igs_en_spa_terms.attendance_type%TYPE;
1791:
1792: BEGIN
1793: --## 1. If term record exists for the effective term then get the attribute details
1794: --## from it, set in EN_SPAT_REC_TYPE and exit

Line 1833: SELECT attendance_mode from igs_en_spa_terms

1829: AS
1830:
1831: -- ## Get the term details information for the effective term
1832: CURSOR c_term IS
1833: SELECT attendance_mode from igs_en_spa_terms
1834: WHERE person_id = p_person_id
1835: AND program_cd = p_program_cd
1836: AND term_cal_type = p_term_cal_type
1837: AND term_sequence_number = p_term_sequence_number;

Line 1844: IGS_EN_SPA_TERMS SPAT,

1840: CURSOR c_prev_term IS
1841: SELECT
1842: SPAT.attendance_mode
1843: FROM
1844: IGS_EN_SPA_TERMS SPAT,
1845: IGS_CA_INST CI1,
1846: IGS_CA_INST CI2
1847: WHERE
1848: SPAT.PERSON_ID = p_person_id AND

Line 1868: l_attendance_mode igs_en_spa_terms.attendance_mode%TYPE;

1864: FROM igs_en_stdnt_ps_att
1865: WHERE person_id = p_person_id
1866: AND course_cd = p_program_cd;
1867:
1868: l_attendance_mode igs_en_spa_terms.attendance_mode%TYPE;
1869:
1870: BEGIN
1871: --## 1. If term record exists for the effective term then get the attribute details
1872: --## from it, set in EN_SPAT_REC_TYPE and exit

Line 1911: SELECT location_cd from igs_en_spa_terms

1907: AS
1908:
1909: -- ## Get the term details information for the effective term
1910: CURSOR c_term IS
1911: SELECT location_cd from igs_en_spa_terms
1912: WHERE person_id = p_person_id
1913: AND program_cd = p_program_cd
1914: AND term_cal_type = p_term_cal_type
1915: AND term_sequence_number = p_term_sequence_number;

Line 1922: IGS_EN_SPA_TERMS SPAT,

1918: CURSOR c_prev_term IS
1919: SELECT
1920: SPAT.location_cd
1921: FROM
1922: IGS_EN_SPA_TERMS SPAT,
1923: IGS_CA_INST CI1,
1924: IGS_CA_INST CI2
1925: WHERE
1926: SPAT.PERSON_ID = p_person_id AND

Line 1946: l_location_cd igs_en_spa_terms.location_cd%TYPE;

1942: FROM igs_en_stdnt_ps_att
1943: WHERE person_id = p_person_id
1944: AND course_cd = p_program_cd;
1945:
1946: l_location_cd igs_en_spa_terms.location_cd%TYPE;
1947:
1948: BEGIN
1949: --## 1. If term record exists for the effective term then get the attribute details
1950: --## from it, set in EN_SPAT_REC_TYPE and exit

Line 1989: SELECT program_version from igs_en_spa_terms

1985: AS
1986:
1987: -- ## Get the term details information for the effective term
1988: CURSOR c_term IS
1989: SELECT program_version from igs_en_spa_terms
1990: WHERE person_id = p_person_id
1991: AND program_cd = p_program_cd
1992: AND term_cal_type = p_term_cal_type
1993: AND term_sequence_number = p_term_sequence_number;

Line 2000: IGS_EN_SPA_TERMS SPAT,

1996: CURSOR c_prev_term IS
1997: SELECT
1998: SPAT.program_version
1999: FROM
2000: IGS_EN_SPA_TERMS SPAT,
2001: IGS_CA_INST CI1,
2002: IGS_CA_INST CI2
2003: WHERE
2004: SPAT.PERSON_ID = p_person_id AND

Line 2024: l_program_version igs_en_spa_terms.program_version%TYPE;

2020: FROM igs_en_stdnt_ps_att
2021: WHERE person_id = p_person_id
2022: AND course_cd = p_program_cd;
2023:
2024: l_program_version igs_en_spa_terms.program_version%TYPE;
2025:
2026: BEGIN
2027: --## 1. If term record exists for the effective term then get the attribute details
2028: --## from it, set in EN_SPAT_REC_TYPE and exit

Line 2070: from igs_en_spa_terms spat, igs_ca_inst c1, igs_ca_inst c2

2066: l_load_ci_end_dt DATE;
2067: l_message_name VARCHAR2(200);
2068: CURSOR c_future_terms(cp_term_cal_type IGS_CA_INST.cal_type%TYPE, cp_term_seq_num IGS_CA_INST.sequence_number%TYPE) IS
2069: select spat.rowid, spat.person_id, spat.program_cd, spat.term_cal_type,spat.term_sequence_number, spat.fee_cat
2070: from igs_en_spa_terms spat, igs_ca_inst c1, igs_ca_inst c2
2071: where person_id = p_person_id
2072: and program_cd = p_program_cd
2073: and term_cal_type = c1.cal_type
2074: and term_sequence_number = c1.sequence_number

Line 2110: igs_en_spa_terms_pkg.delete_row(rec_future_terms.rowid);

2106: p_v_status => l_fee_assessed,
2107: p_v_message => l_message);
2108: IF l_fee_assessed = 'N' THEN
2109: --
2110: igs_en_spa_terms_pkg.delete_row(rec_future_terms.rowid);
2111: END IF;
2112:
2113:
2114: END LOOP;

Line 2238: FROM igs_en_spa_terms spat

2234:
2235: -- cursor to check whether program is a term record
2236: CURSOR cur_c1 IS
2237: SELECT 'x'
2238: FROM igs_en_spa_terms spat
2239: WHERE
2240: spat.person_id = p_person_id AND
2241: spat.program_cd = p_program_cd AND
2242: spat.term_cal_type = p_term_cal_type AND

Line 2260: FROM igs_en_spa_terms spat

2256: -- cursor to check whether term record exists for some other program
2257: -- for the student in same career
2258: CURSOR cur_c3(p_program_type IN VARCHAR2) IS
2259: SELECT 'x'
2260: FROM igs_en_spa_terms spat
2261: WHERE spat.person_id = p_person_id AND
2262: p_program_type = (SELECT course_type FROM igs_ps_ver
2263: WHERE course_cd = spat.program_cd
2264: AND version_number = spat.program_version)

Line 2275: CURSOR cur_c3prev (cp_person_id igs_en_spa_terms.person_id%TYPE,

2271: FROM IGS_CA_INST
2272: WHERE cal_type = cp_cal_type
2273: AND sequence_number = cp_ci_Sequence_number;
2274:
2275: CURSOR cur_c3prev (cp_person_id igs_en_spa_terms.person_id%TYPE,
2276: cp_program_type igs_ps_ver.course_type%TYPE,
2277: cp_start_dt IGS_CA_INST.START_DT%TYPE) IS
2278: SELECT
2279: SPAT.PROGRAM_CD

Line 2281: IGS_EN_SPA_TERMS SPAT,

2277: cp_start_dt IGS_CA_INST.START_DT%TYPE) IS
2278: SELECT
2279: SPAT.PROGRAM_CD
2280: FROM
2281: IGS_EN_SPA_TERMS SPAT,
2282: IGS_CA_INST CI2
2283: WHERE
2284: SPAT.PERSON_ID = cp_person_id AND
2285: cp_program_type = (SELECT course_type

Line 2408: FROM IGS_EN_SPA_TERMS

2404:
2405: -- cursor to fetch distinct term records for given person id
2406: CURSOR c_distinct_terms IS
2407: SELECT DISTINCT term_cal_type, term_sequence_number
2408: FROM IGS_EN_SPA_TERMS
2409: WHERE person_id = p_person_id;
2410:
2411: -- cursor to fetch number of terms containing key program for given
2412: -- person id, term cal type and sequence number

Line 2417: FROM IGS_EN_SPA_TERMS

2413: CURSOR c_count_key (cp_term_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2414: cp_term_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE)
2415: IS
2416: SELECT COUNT(key_program_flag)
2417: FROM IGS_EN_SPA_TERMS
2418: WHERE person_id = p_person_id
2419: AND term_cal_type = cp_term_cal_type
2420: AND term_sequence_number = cp_term_sequence_number
2421: AND key_program_flag = 'Y';

Line 2644: SELECT acad_cal_type from igs_en_spa_terms

2640: p_term_sequence_NUMBER IN NUMBER
2641: ) RETURN VARCHAR2 AS
2642: -- ## Get the term details information for the effective term
2643: CURSOR c_term IS
2644: SELECT acad_cal_type from igs_en_spa_terms
2645: WHERE person_id = p_person_id
2646: AND program_cd = p_program_cd
2647: AND term_cal_type = p_term_cal_type
2648: AND term_sequence_number = p_term_sequence_number;

Line 2655: IGS_EN_SPA_TERMS SPAT,

2651: CURSOR c_prev_term IS
2652: SELECT
2653: SPAT.acad_cal_type
2654: FROM
2655: IGS_EN_SPA_TERMS SPAT,
2656: IGS_CA_INST CI1,
2657: IGS_CA_INST CI2
2658: WHERE
2659: SPAT.PERSON_ID = p_person_id AND

Line 2679: l_acad_cal_type igs_en_spa_terms.acad_cal_type%TYPE;

2675: FROM igs_en_stdnt_ps_att
2676: WHERE person_id = p_person_id
2677: AND course_cd = p_program_cd;
2678:
2679: l_acad_cal_type igs_en_spa_terms.acad_cal_type%TYPE;
2680:
2681: BEGIN
2682: --## 1. If term record exists for the effective term then get the attribute details
2683: --## from it, set in EN_SPAT_REC_TYPE and exit

Line 2714: END IGS_EN_SPA_TERMS_API;

2710: RETURN l_acad_cal_type;
2711: END get_spat_acad_cal_type;
2712:
2713:
2714: END IGS_EN_SPA_TERMS_API;