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_STDNT_PS_ATT_PKG dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 4: old_references IGS_EN_STDNT_PS_ATT_ALL%ROWTYPE;

1: PACKAGE BODY Igs_En_Stdnt_Ps_Att_Pkg AS
2: /* $Header: IGSEI24B.pls 120.11 2006/06/29 09:58:09 shimitta ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_STDNT_PS_ATT_ALL%ROWTYPE;
5: new_references IGS_EN_STDNT_PS_ATT_ALL%ROWTYPE;
6:
7: TYPE g_prim_prg_record_type IS RECORD(career igs_ps_ver.course_type%TYPE,program_cd igs_ps_ver.course_cd%TYPE);
8: TYPE g_prim_prg_rec_table_type IS TABLE OF g_prim_prg_record_type INDEX BY BINARY_INTEGER;

Line 5: new_references IGS_EN_STDNT_PS_ATT_ALL%ROWTYPE;

1: PACKAGE BODY Igs_En_Stdnt_Ps_Att_Pkg AS
2: /* $Header: IGSEI24B.pls 120.11 2006/06/29 09:58:09 shimitta ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_STDNT_PS_ATT_ALL%ROWTYPE;
5: new_references IGS_EN_STDNT_PS_ATT_ALL%ROWTYPE;
6:
7: TYPE g_prim_prg_record_type IS RECORD(career igs_ps_ver.course_type%TYPE,program_cd igs_ps_ver.course_cd%TYPE);
8: TYPE g_prim_prg_rec_table_type IS TABLE OF g_prim_prg_record_type INDEX BY BINARY_INTEGER;
9: g_primary_prg_rec g_prim_prg_rec_table_type;

Line 106: FROM IGS_EN_STDNT_PS_ATT_ALL

102: x_future_dated_trans_flag In VARCHAR2
103: ) AS
104: CURSOR cur_old_ref_values IS
105: SELECT *
106: FROM IGS_EN_STDNT_PS_ATT_ALL
107: WHERE ROWID = x_rowid;
108: BEGIN
109:
110: l_rowid := x_rowid;

Line 412: v_course_attempt_status IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE;

408: p_updating IN BOOLEAN,
409: p_deleting IN BOOLEAN
410: ) AS
411: v_message_name VARCHAR2(30);
412: v_course_attempt_status IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE;
413: l_last_date_of_attendance IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE;
414: l_dropped_by IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE;
415: v_course_type IGS_PS_TYPE.COURSE_TYPE%TYPE;
416:

Line 413: l_last_date_of_attendance IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE;

409: p_deleting IN BOOLEAN
410: ) AS
411: v_message_name VARCHAR2(30);
412: v_course_attempt_status IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE;
413: l_last_date_of_attendance IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE;
414: l_dropped_by IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE;
415: v_course_type IGS_PS_TYPE.COURSE_TYPE%TYPE;
416:
417: CURSOR c_course_type IS

Line 414: l_dropped_by IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE;

410: ) AS
411: v_message_name VARCHAR2(30);
412: v_course_attempt_status IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE;
413: l_last_date_of_attendance IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE;
414: l_dropped_by IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE;
415: v_course_type IGS_PS_TYPE.COURSE_TYPE%TYPE;
416:
417: CURSOR c_course_type IS
418: SELECT crv.course_type

Line 426: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_STDNT_PS_ATT_ALL') THEN

422:
423: BEGIN
424:
425: -- If trigger has not been disabled, perform required processing
426: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_STDNT_PS_ATT_ALL') THEN
427: -- Set course_offering_option key.
428: IF p_inserting THEN
429: IGS_PS_GEN_003.CRSP_GET_COO_KEY (
430: new_references.coo_id,

Line 594: -- Validate the IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnts_complete_dt

590: app_exception.raise_exception;
591: END IF;
592: END IF;
593: END IF;
594: -- Validate the IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnts_complete_dt
595: IF p_inserting OR
596: (p_updating AND
597: ((new_references.course_rqrmnts_complete_dt IS NULL AND
598: old_references.course_rqrmnts_complete_dt IS NOT NULL) OR

Line 693: -- table IGS_EN_STDNT_PS_ATT_ALL

689: -- Created By : jbegum
690: -- Created for : Enhancement Bug #1832130
691: -- When the program attempt status changes from ENROLLED to INACTIVE , INTERMIT , LAPSED , DISCONTIN
692: -- Compute values for fields Last_date_of_attendance and dropped_by before updating the record in the
693: -- table IGS_EN_STDNT_PS_ATT_ALL
694:
695: IF p_updating AND old_references.course_attempt_status= 'ENROLLED'
696: AND new_references.course_attempt_status IN ('INACTIVE','INTERMIT','LAPSED','DISCONTIN') THEN
697:

Line 774: r_sca IGS_EN_STDNT_PS_ATT_ALL%ROWTYPE;

770: p_deleting IN BOOLEAN
771: ) AS
772: v_message_name VARCHAR2(30);
773: v_save_row BOOLEAN := FALSE;
774: r_sca IGS_EN_STDNT_PS_ATT_ALL%ROWTYPE;
775: BEGIN
776: -- mutating table validations / end of processing activities
777: -- If trigger has not been disabled, perform required processing
778: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_STDNT_PS_ATT_ALL') THEN

Line 778: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_STDNT_PS_ATT_ALL') THEN

774: r_sca IGS_EN_STDNT_PS_ATT_ALL%ROWTYPE;
775: BEGIN
776: -- mutating table validations / end of processing activities
777: -- If trigger has not been disabled, perform required processing
778: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_STDNT_PS_ATT_ALL') THEN
779: IF(p_updating AND
780: old_references.student_confirmed_ind = 'N' AND
781: new_references.student_confirmed_ind = 'Y') OR
782: (p_inserting AND

Line 951: r_sca IGS_EN_STDNT_PS_ATT_ALL%ROWTYPE;

947: cur_pe_typ_inst_rec cur_pe_typ_inst%ROWTYPE;
948:
949: v_message_name VARCHAR2(30);
950: v_save_row BOOLEAN := FALSE;
951: r_sca IGS_EN_STDNT_PS_ATT_ALL%ROWTYPE;
952: l_method igs_pe_typ_instances.CREATE_METHOD%TYPE;
953: l_person_type igs_pe_person_types.PERSON_TYPE_CODE%TYPE;
954: l_rowid VARCHAR2(25);
955: l_TYPE_INSTANCE_ID igs_pe_typ_instances.TYPE_INSTANCE_ID%TYPE;

Line 2207: IGS_HE_ST_SPA_ALL_PKG.GET_FK_IGS_EN_STDNT_PS_ATT_ALL(

2203: old_references.course_cd
2204: );
2205:
2206: -- Added the following check chaild existance for the HESA requirment, pmarada
2207: IGS_HE_ST_SPA_ALL_PKG.GET_FK_IGS_EN_STDNT_PS_ATT_ALL(
2208: old_references.person_id,
2209: old_references.course_cd);
2210:
2211:

Line 2238: FROM igs_en_stdnt_ps_att_all

2234: -- cannot be updated.
2235:
2236: CURSOR cur_rec_exist IS
2237: SELECT course_attempt_status
2238: FROM igs_en_stdnt_ps_att_all
2239: WHERE person_id = x_person_id
2240: AND course_cd = x_course_cd;
2241:
2242: CURSOR cur_rowid IS

Line 2244: FROM IGS_EN_STDNT_PS_ATT_ALL

2240: AND course_cd = x_course_cd;
2241:
2242: CURSOR cur_rowid IS
2243: SELECT ROWID
2244: FROM IGS_EN_STDNT_PS_ATT_ALL
2245: WHERE person_id = x_person_id
2246: AND course_cd = x_course_cd
2247: FOR UPDATE NOWAIT;
2248:

Line 2250: lv_crs_att_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE;

2246: AND course_cd = x_course_cd
2247: FOR UPDATE NOWAIT;
2248:
2249: lv_rowid cur_rowid%ROWTYPE;
2250: lv_crs_att_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE;
2251:
2252: BEGIN
2253:
2254: -- Check whether a record exists for the mentioned PK and get

Line 2296: FROM IGS_EN_STDNT_PS_ATT_ALL

2292: x_progression_status IN VARCHAR2
2293: ) AS
2294: CURSOR cur_rowid IS
2295: SELECT ROWID
2296: FROM IGS_EN_STDNT_PS_ATT_ALL
2297: WHERE progression_status = x_progression_status ;
2298: lv_rowid cur_rowid%ROWTYPE;
2299: BEGIN
2300: OPEN cur_rowid;

Line 2317: FROM IGS_EN_STDNT_PS_ATT_ALL

2313: x_attendance_mode IN VARCHAR2
2314: ) AS
2315: CURSOR cur_rowid IS
2316: SELECT ROWID
2317: FROM IGS_EN_STDNT_PS_ATT_ALL
2318: WHERE derived_att_mode = x_attendance_mode ;
2319: lv_rowid cur_rowid%ROWTYPE;
2320: BEGIN
2321: OPEN cur_rowid;

Line 2338: FROM IGS_EN_STDNT_PS_ATT_ALL

2334: x_course_attempt_status IN VARCHAR2
2335: ) AS
2336: CURSOR cur_rowid IS
2337: SELECT ROWID
2338: FROM IGS_EN_STDNT_PS_ATT_ALL
2339: WHERE course_attempt_status = x_course_attempt_status ;
2340: lv_rowid cur_rowid%ROWTYPE;
2341: BEGIN
2342: OPEN cur_rowid;

Line 2362: FROM IGS_EN_STDNT_PS_ATT_ALL

2358: x_sequence_number IN NUMBER
2359: ) AS
2360: CURSOR cur_rowid IS
2361: SELECT ROWID
2362: FROM IGS_EN_STDNT_PS_ATT_ALL
2363: WHERE person_id = x_person_id
2364: AND adm_admission_appl_number = x_admission_appl_number
2365: AND adm_nominated_course_cd = x_nominated_course_cd
2366: AND adm_sequence_number = x_sequence_number ;

Line 2386: FROM IGS_EN_STDNT_PS_ATT_ALL

2382: x_attendance_type IN VARCHAR2
2383: ) AS
2384: CURSOR cur_rowid IS
2385: SELECT ROWID
2386: FROM IGS_EN_STDNT_PS_ATT_ALL
2387: WHERE derived_att_type = x_attendance_type ;
2388: lv_rowid cur_rowid%ROWTYPE;
2389: BEGIN
2390: OPEN cur_rowid;

Line 2407: FROM IGS_EN_STDNT_PS_ATT_ALL

2403: x_correspondence_cat IN VARCHAR2
2404: ) AS
2405: CURSOR cur_rowid IS
2406: SELECT ROWID
2407: FROM IGS_EN_STDNT_PS_ATT_ALL
2408: WHERE correspondence_cat = x_correspondence_cat ;
2409: lv_rowid cur_rowid%ROWTYPE;
2410: BEGIN
2411: OPEN cur_rowid;

Line 2433: FROM IGS_EN_STDNT_PS_ATT_ALL

2429: x_attendance_type IN VARCHAR2
2430: ) AS
2431: CURSOR cur_rowid IS
2432: SELECT ROWID
2433: FROM IGS_EN_STDNT_PS_ATT_ALL
2434: WHERE course_cd = x_course_cd
2435: AND version_number = x_version_number
2436: AND cal_type = x_cal_type
2437: AND location_cd = x_location_cd

Line 2459: FROM IGS_EN_STDNT_PS_ATT_ALL

2455: x_coo_id IN NUMBER
2456: ) AS
2457: CURSOR cur_rowid IS
2458: SELECT ROWID
2459: FROM IGS_EN_STDNT_PS_ATT_ALL
2460: WHERE coo_id = x_coo_id;
2461: lv_rowid cur_rowid%ROWTYPE;
2462: BEGIN
2463: OPEN cur_rowid;

Line 2482: FROM IGS_EN_STDNT_PS_ATT_ALL

2478: x_course_cd IN VARCHAR2
2479: ) AS
2480: CURSOR cur_rowid IS
2481: SELECT ROWID
2482: FROM IGS_EN_STDNT_PS_ATT_ALL
2483: WHERE course_cd = x_course_cd ;
2484: lv_rowid cur_rowid%ROWTYPE;
2485: BEGIN
2486: OPEN cur_rowid;

Line 2504: FROM IGS_EN_STDNT_PS_ATT_ALL

2500: x_version_number IN NUMBER
2501: ) AS
2502: CURSOR cur_rowid IS
2503: SELECT ROWID
2504: FROM IGS_EN_STDNT_PS_ATT_ALL
2505: WHERE course_cd = x_course_cd
2506: AND version_number = x_version_number ;
2507: lv_rowid cur_rowid%ROWTYPE;
2508: BEGIN

Line 2527: FROM IGS_EN_STDNT_PS_ATT_ALL

2523: x_fee_cat IN VARCHAR2
2524: ) AS
2525: CURSOR cur_rowid IS
2526: SELECT ROWID
2527: FROM IGS_EN_STDNT_PS_ATT_ALL
2528: WHERE fee_cat = x_fee_cat ;
2529: lv_rowid cur_rowid%ROWTYPE;
2530: BEGIN
2531: OPEN cur_rowid;

Line 2548: FROM IGS_EN_STDNT_PS_ATT_ALL

2544: x_funding_source IN VARCHAR2
2545: ) AS
2546: CURSOR cur_rowid IS
2547: SELECT ROWID
2548: FROM IGS_EN_STDNT_PS_ATT_ALL
2549: WHERE funding_source = x_funding_source ;
2550: lv_rowid cur_rowid%ROWTYPE;
2551: BEGIN
2552: OPEN cur_rowid;

Line 2569: FROM IGS_EN_STDNT_PS_ATT_ALL

2565: x_location_cd IN VARCHAR2
2566: ) AS
2567: CURSOR cur_rowid IS
2568: SELECT ROWID
2569: FROM IGS_EN_STDNT_PS_ATT_ALL
2570: WHERE exam_location_cd = x_location_cd ;
2571: lv_rowid cur_rowid%ROWTYPE;
2572: BEGIN
2573: OPEN cur_rowid;

Line 2590: FROM IGS_EN_STDNT_PS_ATT_ALL

2586: x_person_id IN NUMBER
2587: ) AS
2588: CURSOR cur_rowid IS
2589: SELECT ROWID
2590: FROM IGS_EN_STDNT_PS_ATT_ALL
2591: WHERE person_id = x_person_id ;
2592: lv_rowid cur_rowid%ROWTYPE;
2593: BEGIN
2594: OPEN cur_rowid;

Line 2613: FROM IGS_EN_STDNT_PS_ATT_ALL

2609: X_IGS_PR_CLASS_STD_ID IN NUMBER
2610: ) AS
2611: CURSOR cur_rowid IS
2612: SELECT ROWID
2613: FROM IGS_EN_STDNT_PS_ATT_ALL
2614: WHERE IGS_PR_CLASS_STD_ID = X_IGS_PR_CLASS_STD_ID;
2615:
2616: lv_cur cur_rowid%ROWTYPE;
2617:

Line 2638: FROM IGS_EN_STDNT_PS_ATT_ALL

2634: X_CATALOG_SEQ_NUM IN NUMBER
2635: ) AS
2636: CURSOR cur_rowid IS
2637: SELECT ROWID
2638: FROM IGS_EN_STDNT_PS_ATT_ALL
2639: WHERE CATALOG_CAL_TYPE = X_CATALOG_CAL_TYPE
2640: AND CATALOG_SEQ_NUM = X_CATALOG_SEQ_NUM ;
2641: lv_rowid cur_rowid%ROWTYPE;
2642:

Line 2901: PROCEDURE AFTER_DML_RECURSIVE_CALLS(p_old_references IGS_EN_STDNT_PS_ATT_ALL%ROWTYPE,

2897:
2898: END Before_DML;
2899:
2900:
2901: PROCEDURE AFTER_DML_RECURSIVE_CALLS(p_old_references IGS_EN_STDNT_PS_ATT_ALL%ROWTYPE,
2902: p_new_references IGS_EN_STDNT_PS_ATT_ALL%ROWTYPE,
2903: p_action VARCHAR2,
2904: p_skip_before_after_dml BOOLEAN DEFAULT FALSE) IS
2905:

Line 2902: p_new_references IGS_EN_STDNT_PS_ATT_ALL%ROWTYPE,

2898: END Before_DML;
2899:
2900:
2901: PROCEDURE AFTER_DML_RECURSIVE_CALLS(p_old_references IGS_EN_STDNT_PS_ATT_ALL%ROWTYPE,
2902: p_new_references IGS_EN_STDNT_PS_ATT_ALL%ROWTYPE,
2903: p_action VARCHAR2,
2904: p_skip_before_after_dml BOOLEAN DEFAULT FALSE) IS
2905:
2906: CURSOR cur_fut_dt_trnsf(cp_person_id IGS_PS_STDNT_TRN.person_id%TYPE,

Line 3434: SELECT ROWID FROM IGS_EN_STDNT_PS_ATT_ALL

3430: --sbaliga 13-feb-2002 Assigned igs_ge_gen_003.get_org_id to x_org_id
3431: -- in call to before_dml as part of SWCR006 build.
3432: -----------------------------------------------------------------------------------------------*/
3433: CURSOR C IS
3434: SELECT ROWID FROM IGS_EN_STDNT_PS_ATT_ALL
3435: WHERE PERSON_ID = X_PERSON_ID
3436: AND COURSE_CD = X_COURSE_CD;
3437: X_LAST_UPDATE_DATE DATE;
3438: X_LAST_UPDATED_BY NUMBER;

Line 3563: INSERT INTO IGS_EN_STDNT_PS_ATT_ALL (

3559:
3560: IF (x_mode = 'S') THEN
3561: igs_sc_gen_001.set_ctx('R');
3562: END IF;
3563: INSERT INTO IGS_EN_STDNT_PS_ATT_ALL (
3564: org_id,
3565: ADVANCED_STANDING_IND,
3566: FEE_CAT,
3567: CORRESPONDENCE_CAT,

Line 3911: FROM IGS_EN_STDNT_PS_ATT_ALL

3907: ATTRIBUTE17,
3908: ATTRIBUTE18,
3909: ATTRIBUTE19,
3910: ATTRIBUTE20
3911: FROM IGS_EN_STDNT_PS_ATT_ALL
3912: WHERE ROWID = X_ROWID FOR UPDATE NOWAIT;
3913: tlinfo c1%ROWTYPE;
3914: BEGIN
3915: OPEN c1;

Line 4321: UPDATE IGS_EN_STDNT_PS_ATT_ALL SET

4317:
4318: IF (x_mode = 'S') THEN
4319: igs_sc_gen_001.set_ctx('R');
4320: END IF;
4321: UPDATE IGS_EN_STDNT_PS_ATT_ALL SET
4322: ADVANCED_STANDING_IND = NEW_REFERENCES.ADVANCED_STANDING_IND,
4323: FEE_CAT = NEW_REFERENCES.FEE_CAT,
4324: CORRESPONDENCE_CAT = NEW_REFERENCES.CORRESPONDENCE_CAT,
4325: SELF_HELP_GROUP_IND = NEW_REFERENCES.SELF_HELP_GROUP_IND,

Line 4509: CURSOR c1 IS SELECT ROWID FROM IGS_EN_STDNT_PS_ATT_ALL

4505: X_ATTRIBUTE19 IN VARCHAR2,
4506: x_ATTRIBUTE20 IN VARCHAR2,
4507: X_FUTURE_DATED_TRANS_FLAG IN VARCHAR2
4508: ) AS
4509: CURSOR c1 IS SELECT ROWID FROM IGS_EN_STDNT_PS_ATT_ALL
4510: WHERE PERSON_ID = X_PERSON_ID
4511: AND COURSE_CD = X_COURSE_CD;
4512: BEGIN
4513: OPEN c1;

Line 4687: DELETE FROM IGS_EN_STDNT_PS_ATT_ALL

4683: );
4684: IF (x_mode = 'S') THEN
4685: igs_sc_gen_001.set_ctx('R');
4686: END IF;
4687: DELETE FROM IGS_EN_STDNT_PS_ATT_ALL
4688: WHERE ROWID = X_ROWID;
4689: IF (SQL%NOTFOUND) THEN
4690: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
4691: igs_ge_msg_stack.add;

Line 4721: CURSOR c_spa_stat (cp_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,

4717: --Change History:
4718: --Who When What
4719: -------------------------------------------------------------------
4720:
4721: CURSOR c_spa_stat (cp_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
4722: cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE) IS
4723: SELECT course_attempt_status
4724: FROM igs_en_stdnt_ps_att_all
4725: WHERE person_id = cp_person_id

Line 4722: cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE) IS

4718: --Who When What
4719: -------------------------------------------------------------------
4720:
4721: CURSOR c_spa_stat (cp_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
4722: cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE) IS
4723: SELECT course_attempt_status
4724: FROM igs_en_stdnt_ps_att_all
4725: WHERE person_id = cp_person_id
4726: AND course_cd = cp_course_cd;

Line 4724: FROM igs_en_stdnt_ps_att_all

4720:
4721: CURSOR c_spa_stat (cp_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
4722: cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE) IS
4723: SELECT course_attempt_status
4724: FROM igs_en_stdnt_ps_att_all
4725: WHERE person_id = cp_person_id
4726: AND course_cd = cp_course_cd;
4727:
4728: lv_crs_attmpt_stat igs_en_stdnt_ps_att_all.course_attempt_status%TYPE;

Line 4728: lv_crs_attmpt_stat igs_en_stdnt_ps_att_all.course_attempt_status%TYPE;

4724: FROM igs_en_stdnt_ps_att_all
4725: WHERE person_id = cp_person_id
4726: AND course_cd = cp_course_cd;
4727:
4728: lv_crs_attmpt_stat igs_en_stdnt_ps_att_all.course_attempt_status%TYPE;
4729: BEGIN
4730:
4731: -- Deletion is allowed only in case the record has an attempt status of UNCONFIRM.
4732:

Line 4792: l_prg_completion_date igs_en_stdnt_ps_att_all.course_rqrmnts_complete_dt%TYPE;

4788: ORDER BY ci.start_dt;
4789:
4790: l_message_name VARCHAR2(100);
4791: l_create_update_term BOOLEAN;
4792: l_prg_completion_date igs_en_stdnt_ps_att_all.course_rqrmnts_complete_dt%TYPE;
4793: l_term_cal_type igs_ca_inst.cal_type%TYPE;
4794: l_term_ci_seq_num igs_ca_inst.sequence_number%TYPE;
4795:
4796: BEGIN