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.

[Home] [Help]

APPS.IGS_AV_GEN_001 dependencies on IGS_AV_STND_UNIT

Line 17: nalkumar 05-June-2002 Replaced the referances of the igs_av_stnd_unit/unit_lvl.(PREV_UNIT_CD and TEST_DETAILS_ID) columns

13: p_legacy. Bug#2661533
14: nalkumar 12-July-2002 Modify the 'ADVP_UPD_AS_GRANT' procedure to grant only the advanced standing which is of 'CREDIT' type.
15: Modified the 'ADVP_UPD_AS_PE_EXPRY' procedure to expire only the Advanced Standing which is not of 'PRECLUSION' type.
16: this is as per Bug# 2441175.
17: nalkumar 05-June-2002 Replaced the referances of the igs_av_stnd_unit/unit_lvl.(PREV_UNIT_CD and TEST_DETAILS_ID) columns
18: to igs_av_stnd_unit/unit_lvl.(unit_details_id and tst_rslt_dtls_id) columns. This is as per Bug# 2401170
19: nalkumar 28-May-2002 Bug# 2382566. Added the call to the repeat logic.
20: kdande 20-Mar-2002 Bug # 2241710. Changed all references of 'IGS_PS_UNIT ' to 'UNIT ' and
21: 'IGS_PS_UNIT LEVEL' to 'UNIT LEVEL'

Line 18: to igs_av_stnd_unit/unit_lvl.(unit_details_id and tst_rslt_dtls_id) columns. This is as per Bug# 2401170

14: nalkumar 12-July-2002 Modify the 'ADVP_UPD_AS_GRANT' procedure to grant only the advanced standing which is of 'CREDIT' type.
15: Modified the 'ADVP_UPD_AS_PE_EXPRY' procedure to expire only the Advanced Standing which is not of 'PRECLUSION' type.
16: this is as per Bug# 2441175.
17: nalkumar 05-June-2002 Replaced the referances of the igs_av_stnd_unit/unit_lvl.(PREV_UNIT_CD and TEST_DETAILS_ID) columns
18: to igs_av_stnd_unit/unit_lvl.(unit_details_id and tst_rslt_dtls_id) columns. This is as per Bug# 2401170
19: nalkumar 28-May-2002 Bug# 2382566. Added the call to the repeat logic.
20: kdande 20-Mar-2002 Bug # 2241710. Changed all references of 'IGS_PS_UNIT ' to 'UNIT ' and
21: 'IGS_PS_UNIT LEVEL' to 'UNIT LEVEL'
22: nalkumar 04-Mar-2002 Modified the advp_upd_as_pe_grant procedure to fix the Bug# 2121621

Line 24: IGS_AV_STND_UNIT_LVL_PKG (Bug# 2233334)

20: kdande 20-Mar-2002 Bug # 2241710. Changed all references of 'IGS_PS_UNIT ' to 'UNIT ' and
21: 'IGS_PS_UNIT LEVEL' to 'UNIT LEVEL'
22: nalkumar 04-Mar-2002 Modified the advp_upd_as_pe_grant procedure to fix the Bug# 2121621
23: prraj 21-Feb-2002 Added column QUAL_DETS_ID to the tbh calls of pkg
24: IGS_AV_STND_UNIT_LVL_PKG (Bug# 2233334)
25: pmarada 27-Nov-2001 Added the AV_STND_UNIT_ID column in igs_av_stnd_unit_pkg and
26: AV_STND_UNIT_LVL_ID column in igs_av_stnd_unit_lvl_pkg.
27: sarakshi 21-SEP-2001 Removes all logic of deleting/updating the units enrollemnts due to advance standing
28: records processing.Also changes the percentage logic as mentioned in the dld Acedemic

Line 25: pmarada 27-Nov-2001 Added the AV_STND_UNIT_ID column in igs_av_stnd_unit_pkg and

21: 'IGS_PS_UNIT LEVEL' to 'UNIT LEVEL'
22: nalkumar 04-Mar-2002 Modified the advp_upd_as_pe_grant procedure to fix the Bug# 2121621
23: prraj 21-Feb-2002 Added column QUAL_DETS_ID to the tbh calls of pkg
24: IGS_AV_STND_UNIT_LVL_PKG (Bug# 2233334)
25: pmarada 27-Nov-2001 Added the AV_STND_UNIT_ID column in igs_av_stnd_unit_pkg and
26: AV_STND_UNIT_LVL_ID column in igs_av_stnd_unit_lvl_pkg.
27: sarakshi 21-SEP-2001 Removes all logic of deleting/updating the units enrollemnts due to advance standing
28: records processing.Also changes the percentage logic as mentioned in the dld Acedemic
29: Records Maintanence Build(bug no:1960126)

Line 26: AV_STND_UNIT_LVL_ID column in igs_av_stnd_unit_lvl_pkg.

22: nalkumar 04-Mar-2002 Modified the advp_upd_as_pe_grant procedure to fix the Bug# 2121621
23: prraj 21-Feb-2002 Added column QUAL_DETS_ID to the tbh calls of pkg
24: IGS_AV_STND_UNIT_LVL_PKG (Bug# 2233334)
25: pmarada 27-Nov-2001 Added the AV_STND_UNIT_ID column in igs_av_stnd_unit_pkg and
26: AV_STND_UNIT_LVL_ID column in igs_av_stnd_unit_lvl_pkg.
27: sarakshi 21-SEP-2001 Removes all logic of deleting/updating the units enrollemnts due to advance standing
28: records processing.Also changes the percentage logic as mentioned in the dld Acedemic
29: Records Maintanence Build(bug no:1960126)
30: knaraset 02-May-03 Modified the function advp_upd_sua_advstnd to pass uoo_id to internal function enrpl_delete_sua_recs

Line 35: nalkumar 10-Dec-2003 Bug# 3270446 RECR50 Build; Obsoleted the IGS_AV_STND_UNIT.CREDIT_PERCENTAGE column.

31: as part of MUS build bug 2829262
32: rvivekan 09-sep-2003 Modified the behaviour of repeatable_ind column in igs_ps_unit_ver table. PSP integration build #3052433
33: stutta 27-Oct-2003 Modified funcion advp_upd_sua_advstnd by removing calls to functions IGS_EN_VAL_SUA.enrp_val_sca_supunit,
34: IGS_EN_VAL_SUA.enrp_val_sca_subunit as part of build #3052438
35: nalkumar 10-Dec-2003 Bug# 3270446 RECR50 Build; Obsoleted the IGS_AV_STND_UNIT.CREDIT_PERCENTAGE column.
36: swaghmar 15-Jun-2005 Bug# 4377816. Changed the cursor queries to pick party_number from igs_pe_hz_parties instead of hz_parties
37: sgurusam 17-Jun-2005 Modified to pass aditional parameter p_calling_obj = 'JOB' in the calls to
38: igs_en_elgbl_unit.eval_unit_repeat
39: jhanda 10-july-05 Build 4327991 BUILD FOR RE105 TRANSFER EVALUATION UI ENHANCEMENTS

Line 65: FROM IGS_AV_STND_UNIT asu

61: v_constraint user_constraints.constraint_name%TYPE;
62: v_ri_check_failed BOOLEAN DEFAULT FALSE;
63: CURSOR c_asu IS
64: SELECT 'X'
65: FROM IGS_AV_STND_UNIT asu
66: WHERE asu.person_id = p_person_id AND
67: asu.as_course_cd = p_course_cd AND
68: asu.s_adv_stnd_granting_status <> cst_approved;
69: CURSOR c_asul IS

Line 71: FROM IGS_AV_STND_UNIT_LVL asul

67: asu.as_course_cd = p_course_cd AND
68: asu.s_adv_stnd_granting_status <> cst_approved;
69: CURSOR c_asul IS
70: SELECT 'X'
71: FROM IGS_AV_STND_UNIT_LVL asul
72: WHERE asul.person_id = p_person_id AND
73: asul.as_course_cd = p_course_cd AND
74: asul.s_adv_stnd_granting_status <> cst_approved;
75:

Line 78: FROM IGS_AV_STND_UNIT_ALL asua

74: asul.s_adv_stnd_granting_status <> cst_approved;
75:
76: CURSOR c_unit_all IS
77: SELECT rowid,av_stnd_unit_id
78: FROM IGS_AV_STND_UNIT_ALL asua
79: WHERE asua.person_id = p_person_id AND
80: asua.as_course_cd = p_course_cd ;
81:
82: CURSOR c_adv_all IS

Line 90: FROM IGS_AV_STND_UNIT_LVL_ALL aslvl

86: asal.course_cd = p_course_cd;
87:
88: CURSOR c_unit_lvl_all IS
89: SELECT rowid,av_stnd_unit_lvl_id
90: FROM IGS_AV_STND_UNIT_LVL_ALL aslvl
91: WHERE aslvl.person_id = p_person_id AND
92: aslvl.as_course_cd = p_course_cd;
93:
94: CURSOR c_unit_basis_all(cp_unit_id IGS_AV_STD_UNT_BASIS_ALL.av_stnd_unit_id%TYPE) IS

Line 153: igs_av_stnd_unit_pkg.DELETE_ROW (

149: X_ROWID => v_alt_unt_all.rowid );
150: END LOOP;
151:
152:
153: igs_av_stnd_unit_pkg.DELETE_ROW (
154: X_ROWID => v_unit_all.rowid );
155:
156:
157: IF (fnd_log.level_statement >=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 177: igs_av_stnd_unit_lvl_pkg.DELETE_ROW (

173: IF (fnd_log.level_statement >=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
174: fnd_log.string( fnd_log.level_statement, 'igs.plsql.IGS_AV_GEN_001.advp_del_adv_stnd','Deleted unit level basis'||v_unit_lvl_all.av_stnd_unit_lvl_id);
175: END IF;
176:
177: igs_av_stnd_unit_lvl_pkg.DELETE_ROW (
178: X_ROWID => v_unit_lvl_all.rowid );
179:
180:
181: IF (fnd_log.level_statement >=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 245: FROM igs_av_stnd_unit asu,igs_ps_unit_ver puv WHERE

241: CURSOR c_adv_cp_sum IS
242: SELECT SUM(NVL(asu.achievable_credit_points,0)) advance_standing_credits,
243: SUM(NVL(puv.achievable_Credit_points,puv.enrolled_Credit_points)) enrolled_cp ,
244: asu.unit_cd,asu.version_number
245: FROM igs_av_stnd_unit asu,igs_ps_unit_ver puv WHERE
246: asu.person_id = p_person_id AND
247: asu.as_course_cd = p_course_cd AND
248: puv.unit_cd = asu.unit_cd AND
249: puv.version_number = asu.version_number AND

Line 255: CURSOR c_adv_cp_per(cp_unit_cd igs_av_stnd_unit.unit_cd%TYPE,

251: asu.s_adv_stnd_recognition_type = 'CREDIT' AND
252: (p_effective_dt IS NULL OR asu.granted_dt <= TRUNC(p_effective_dt))
253: GROUP BY asu.unit_cd,asu.version_number;
254:
255: CURSOR c_adv_cp_per(cp_unit_cd igs_av_stnd_unit.unit_cd%TYPE,
256: cp_version_number igs_av_stnd_unit.version_number%TYPE) IS
257: SELECT NVL(puv.achievable_Credit_points,puv.enrolled_Credit_points) enrolled_credits
258: FROM igs_av_stnd_unit asu,igs_ps_unit_ver puv
259: WHERE asu.person_id = p_person_id

Line 256: cp_version_number igs_av_stnd_unit.version_number%TYPE) IS

252: (p_effective_dt IS NULL OR asu.granted_dt <= TRUNC(p_effective_dt))
253: GROUP BY asu.unit_cd,asu.version_number;
254:
255: CURSOR c_adv_cp_per(cp_unit_cd igs_av_stnd_unit.unit_cd%TYPE,
256: cp_version_number igs_av_stnd_unit.version_number%TYPE) IS
257: SELECT NVL(puv.achievable_Credit_points,puv.enrolled_Credit_points) enrolled_credits
258: FROM igs_av_stnd_unit asu,igs_ps_unit_ver puv
259: WHERE asu.person_id = p_person_id
260: AND asu.as_course_cd = p_course_cd

Line 258: FROM igs_av_stnd_unit asu,igs_ps_unit_ver puv

254:
255: CURSOR c_adv_cp_per(cp_unit_cd igs_av_stnd_unit.unit_cd%TYPE,
256: cp_version_number igs_av_stnd_unit.version_number%TYPE) IS
257: SELECT NVL(puv.achievable_Credit_points,puv.enrolled_Credit_points) enrolled_credits
258: FROM igs_av_stnd_unit asu,igs_ps_unit_ver puv
259: WHERE asu.person_id = p_person_id
260: AND asu.as_course_cd = p_course_cd
261: AND asu.unit_cd = cp_unit_cd
262: AND asu.version_number = cp_version_number

Line 308: cst_granted CONSTANT IGS_AV_STND_UNIT.s_adv_stnd_granting_status%TYPE := 'GRANTED';

304: DECLARE
305: v_adv_total NUMBER;
306: v_asu_uv_sum NUMBER;
307: v_asul_sum NUMBER;
308: cst_granted CONSTANT IGS_AV_STND_UNIT.s_adv_stnd_granting_status%TYPE := 'GRANTED';
309:
310: CURSOR c_asul IS
311: SELECT SUM(credit_points)
312: FROM IGS_AV_STND_UNIT_LVL asul

Line 312: FROM IGS_AV_STND_UNIT_LVL asul

308: cst_granted CONSTANT IGS_AV_STND_UNIT.s_adv_stnd_granting_status%TYPE := 'GRANTED';
309:
310: CURSOR c_asul IS
311: SELECT SUM(credit_points)
312: FROM IGS_AV_STND_UNIT_LVL asul
313: WHERE asul.person_id = p_person_id AND
314: asul.as_course_cd = p_course_cd AND
315: asul.s_adv_stnd_granting_status = cst_granted AND
316: (p_effective_dt IS NULL OR

Line 387: cst_approved CONSTANT IGS_AV_STND_UNIT.s_adv_stnd_granting_status%TYPE := 'APPROVED';

383: DECLARE
384: v_ret_value BOOLEAN;
385: v_s_log_type IGS_GE_S_LOG.s_log_type%TYPE DEFAULT NULL;
386: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE DEFAULT NULL;
387: cst_approved CONSTANT IGS_AV_STND_UNIT.s_adv_stnd_granting_status%TYPE := 'APPROVED';
388: cst_credit CONSTANT IGS_AV_STND_UNIT.s_adv_stnd_recognition_type%TYPE := 'CREDIT';
389: v_message_name VARCHAR2(30) DEFAULT NULL ;
390: -- Counters
391: tot_rec_process NUMBER DEFAULT 0;

Line 388: cst_credit CONSTANT IGS_AV_STND_UNIT.s_adv_stnd_recognition_type%TYPE := 'CREDIT';

384: v_ret_value BOOLEAN;
385: v_s_log_type IGS_GE_S_LOG.s_log_type%TYPE DEFAULT NULL;
386: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE DEFAULT NULL;
387: cst_approved CONSTANT IGS_AV_STND_UNIT.s_adv_stnd_granting_status%TYPE := 'APPROVED';
388: cst_credit CONSTANT IGS_AV_STND_UNIT.s_adv_stnd_recognition_type%TYPE := 'CREDIT';
389: v_message_name VARCHAR2(30) DEFAULT NULL ;
390: -- Counters
391: tot_rec_process NUMBER DEFAULT 0;
392: v_ret_false NUMBER DEFAULT 0;

Line 398: FROM IGS_AV_STND_UNIT_ALL

394: V_MESSAGE2 VARCHAR2(50);
395: V_MESSAGE3 VARCHAR2(50);
396: CURSOR c_adv_stnd_unit IS
397: SELECT person_id
398: FROM IGS_AV_STND_UNIT_ALL
399: WHERE s_adv_stnd_granting_status = cst_approved AND
400: s_adv_stnd_recognition_type = cst_credit
401: UNION
402: SELECT person_id

Line 403: FROM IGS_AV_STND_UNIT_LVL_ALL

399: WHERE s_adv_stnd_granting_status = cst_approved AND
400: s_adv_stnd_recognition_type = cst_credit
401: UNION
402: SELECT person_id
403: FROM IGS_AV_STND_UNIT_LVL_ALL
404: WHERE s_adv_stnd_granting_status = cst_approved;
405: BEGIN
406: FOR v_adv_stnd_unit IN c_adv_stnd_unit LOOP
407: IF NOT advp_upd_as_pe_grant(

Line 458: v_exemption_institution_cd IGS_AV_STND_UNIT_CREDIT_V.exemption_institution_cd%TYPE;

454: DECLARE
455: e_resource_busy EXCEPTION;
456: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);
457: v_major_exmpt_inst VARCHAR2(64);
458: v_exemption_institution_cd IGS_AV_STND_UNIT_CREDIT_V.exemption_institution_cd%TYPE;
459: v_max_credit NUMBER(5);
460: v_check CHAR;
461: v_advanced_standing IGS_AV_ADV_STANDING%ROWTYPE;
462: CURSOR c_ascv IS

Line 470: FROM igs_av_stnd_unit_all asu,

466: asu.as_course_cd course_cd,
467: asu.as_version_number version_number,
468: asu.exemption_institution_cd exemption_institution_cd,
469: uv.achievable_credit_points credit
470: FROM igs_av_stnd_unit_all asu,
471: igs_ps_unit_ver_all uv
472: WHERE asu.unit_cd = uv.unit_cd
473: AND asu.version_number = uv.version_number
474: AND asu.s_adv_stnd_recognition_type = 'CREDIT'

Line 482: FROM igs_av_stnd_unit_lvl_all asule

478: asule.as_course_cd,
479: asule.as_version_number,
480: asule.exemption_institution_cd,
481: asule.credit_points credit
482: FROM igs_av_stnd_unit_lvl_all asule
483: WHERE asule.s_adv_stnd_granting_status = 'GRANTED') suc
484: WHERE suc.person_id = p_person_id
485: AND suc.course_cd = p_course_cd
486: AND suc.version_number = p_version_number

Line 621: v_skip_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';

617: v_check CHAR;
618: v_key IGS_GE_S_LOG.key%TYPE;
619: v_s_log_type IGS_GE_S_LOG.s_log_type%TYPE;
620: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
621: v_skip_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';
622: v_skip_course_cd1 IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';
623: v_skip_version_number IGS_AV_STND_UNIT.as_version_number%TYPE DEFAULT 0;
624: v_last_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';
625: v_last_version_number IGS_AV_STND_UNIT.as_version_number%TYPE DEFAULT 0;

Line 622: v_skip_course_cd1 IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';

618: v_key IGS_GE_S_LOG.key%TYPE;
619: v_s_log_type IGS_GE_S_LOG.s_log_type%TYPE;
620: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
621: v_skip_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';
622: v_skip_course_cd1 IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';
623: v_skip_version_number IGS_AV_STND_UNIT.as_version_number%TYPE DEFAULT 0;
624: v_last_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';
625: v_last_version_number IGS_AV_STND_UNIT.as_version_number%TYPE DEFAULT 0;
626: v_message_name VARCHAR2(30) DEFAULT NULL;

Line 623: v_skip_version_number IGS_AV_STND_UNIT.as_version_number%TYPE DEFAULT 0;

619: v_s_log_type IGS_GE_S_LOG.s_log_type%TYPE;
620: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
621: v_skip_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';
622: v_skip_course_cd1 IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';
623: v_skip_version_number IGS_AV_STND_UNIT.as_version_number%TYPE DEFAULT 0;
624: v_last_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';
625: v_last_version_number IGS_AV_STND_UNIT.as_version_number%TYPE DEFAULT 0;
626: v_message_name VARCHAR2(30) DEFAULT NULL;
627: v_message_key VARCHAR2(255);

Line 624: v_last_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';

620: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
621: v_skip_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';
622: v_skip_course_cd1 IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';
623: v_skip_version_number IGS_AV_STND_UNIT.as_version_number%TYPE DEFAULT 0;
624: v_last_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';
625: v_last_version_number IGS_AV_STND_UNIT.as_version_number%TYPE DEFAULT 0;
626: v_message_name VARCHAR2(30) DEFAULT NULL;
627: v_message_key VARCHAR2(255);
628: v_update_flag BOOLEAN DEFAULT TRUE;

Line 625: v_last_version_number IGS_AV_STND_UNIT.as_version_number%TYPE DEFAULT 0;

621: v_skip_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';
622: v_skip_course_cd1 IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';
623: v_skip_version_number IGS_AV_STND_UNIT.as_version_number%TYPE DEFAULT 0;
624: v_last_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';
625: v_last_version_number IGS_AV_STND_UNIT.as_version_number%TYPE DEFAULT 0;
626: v_message_name VARCHAR2(30) DEFAULT NULL;
627: v_message_key VARCHAR2(255);
628: v_update_flag BOOLEAN DEFAULT TRUE;
629:

Line 640: FROM IGS_AV_STND_UNIT

636: creation_dt = cp_creation_dt;
637:
638: CURSOR c_asu (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
639: SELECT *
640: FROM IGS_AV_STND_UNIT
641: WHERE
642: s_adv_stnd_granting_status = cst_approved AND
643: s_adv_stnd_recognition_type = cst_credit AND
644: person_id = cp_person_id

Line 655: FROM IGS_AV_STND_UNIT_LVL

651: -- FOR UPDATE NOWAIT;
652:
653: CURSOR c_asul (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
654: SELECT *
655: FROM IGS_AV_STND_UNIT_LVL
656: WHERE
657: s_adv_stnd_granting_status = cst_approved AND
658: person_id = cp_person_id
659: ORDER BY

Line 714: -- Update approved IGS_AV_STND_UNIT

710: v_s_log_type := p_s_log_type;
711: v_creation_dt := p_creation_dt;
712: END IF;
713: CLOSE c_sl;
714: -- Update approved IGS_AV_STND_UNIT
715: p_message_name := 'IGS_AV_UNIT_UPD_ANOTHER_PRC';
716:
717:
718: FOR v_asu_rec IN c_asu(p_person_id) LOOP

Line 726: NULL; -- do nothing, continue IGS_AV_STND_UNIT

722: (v_asu_rec.as_course_cd = v_skip_course_cd) OR
723: (v_asu_rec.as_course_cd = v_skip_course_cd1 AND
724: v_asu_rec.as_version_number = v_skip_version_number)
725: THEN
726: NULL; -- do nothing, continue IGS_AV_STND_UNIT
727: ELSE
728: -- For each IGS_AV_STND_UNIT.as_course_cd
729: -- Validate that person/course is not excluded from advanced standing
730: IF (IGS_EN_VAL_ENCMB.enrp_val_excld_prsn(

Line 728: -- For each IGS_AV_STND_UNIT.as_course_cd

724: v_asu_rec.as_version_number = v_skip_version_number)
725: THEN
726: NULL; -- do nothing, continue IGS_AV_STND_UNIT
727: ELSE
728: -- For each IGS_AV_STND_UNIT.as_course_cd
729: -- Validate that person/course is not excluded from advanced standing
730: IF (IGS_EN_VAL_ENCMB.enrp_val_excld_prsn(
731: v_asu_rec.person_id,
732: v_asu_rec.as_course_cd,

Line 736: -- Do not process any more IGS_AV_STND_UNIT for this course

732: v_asu_rec.as_course_cd,
733: v_granted_dt,
734: v_message_name) = FALSE) THEN
735: -- Insert into messages for reporting
736: -- Do not process any more IGS_AV_STND_UNIT for this course
737: v_message_key := 'UNIT ' || '|' ||
738: TO_CHAR(v_asu_rec.person_id) || '|' ||
739: v_asu_rec.as_course_cd || '|' ||
740: TO_CHAR(v_asu_rec.as_version_number) || '|' ||

Line 753: -- For each IGS_AV_STND_UNIT.as_course_cd/as_version_number

749: '');
750: v_skip_course_cd := v_asu_rec.as_course_cd;
751: GOTO continue;
752: END IF;
753: -- For each IGS_AV_STND_UNIT.as_course_cd/as_version_number
754: -- Validate advanced standing course version
755: IF (v_asu_rec.as_course_cd = v_last_course_cd AND
756: v_asu_rec.as_version_number = v_last_version_number) THEN
757: NULL; -- do nothing, continue IGS_AV_STND_UNIT

Line 757: NULL; -- do nothing, continue IGS_AV_STND_UNIT

753: -- For each IGS_AV_STND_UNIT.as_course_cd/as_version_number
754: -- Validate advanced standing course version
755: IF (v_asu_rec.as_course_cd = v_last_course_cd AND
756: v_asu_rec.as_version_number = v_last_version_number) THEN
757: NULL; -- do nothing, continue IGS_AV_STND_UNIT
758: ELSE
759: v_last_course_cd := v_asu_rec.as_course_cd;
760: v_last_version_number := v_asu_rec.as_version_number;
761: IF (IGS_AV_VAL_ASU.advp_val_as_grant(

Line 768: -- Do not process any more IGS_AV_STND_UNIT for this course version

764: v_asu_rec.as_version_number,
765: v_asu_rec.s_adv_stnd_granting_status,
766: v_message_name) = FALSE) THEN
767: -- Insert into messages for reporting
768: -- Do not process any more IGS_AV_STND_UNIT for this course version
769: v_message_key := 'UNIT ' || '|' ||
770: TO_CHAR(v_asu_rec.person_id) || '|' ||
771: v_asu_rec.as_course_cd || '|' ||
772: TO_CHAR(v_asu_rec.as_version_number) || '|' ||

Line 796: '', -- IGS_AV_STND_UNIT_LVL.unit_level

792: TRUE,
793: v_asu_rec.unit_cd,
794: v_asu_rec.version_number,
795: cst_granted,
796: '', -- IGS_AV_STND_UNIT_LVL.unit_level
797: '', -- IGS_AV_STND_UNIT_LVL.exemption_institution_cd
798: '', -- IGS_AV_STND_UNIT_LVL.s_adv_stnd_granting_status
799: v_total_exmptn_approved,
800: v_total_exmptn_granted,

Line 797: '', -- IGS_AV_STND_UNIT_LVL.exemption_institution_cd

793: v_asu_rec.unit_cd,
794: v_asu_rec.version_number,
795: cst_granted,
796: '', -- IGS_AV_STND_UNIT_LVL.unit_level
797: '', -- IGS_AV_STND_UNIT_LVL.exemption_institution_cd
798: '', -- IGS_AV_STND_UNIT_LVL.s_adv_stnd_granting_status
799: v_total_exmptn_approved,
800: v_total_exmptn_granted,
801: v_total_exmptn_perc_grntd,

Line 798: '', -- IGS_AV_STND_UNIT_LVL.s_adv_stnd_granting_status

794: v_asu_rec.version_number,
795: cst_granted,
796: '', -- IGS_AV_STND_UNIT_LVL.unit_level
797: '', -- IGS_AV_STND_UNIT_LVL.exemption_institution_cd
798: '', -- IGS_AV_STND_UNIT_LVL.s_adv_stnd_granting_status
799: v_total_exmptn_approved,
800: v_total_exmptn_granted,
801: v_total_exmptn_perc_grntd,
802: v_message_name,

Line 807: -- Do not process any more IGS_AV_STND_UNIT for this course

803: v_asu_rec.unit_details_id,
804: v_asu_rec.tst_rslt_dtls_id,
805: v_asu_rec.exemption_institution_cd) = FALSE) THEN
806: -- Insert into messages for reporting
807: -- Do not process any more IGS_AV_STND_UNIT for this course
808: v_message_key := 'UNIT ' || '|' ||
809: TO_CHAR(v_asu_rec.person_id) || '|' ||
810: v_asu_rec.as_course_cd || '|' ||
811: TO_CHAR(v_asu_rec.as_version_number) || '|' ||

Line 825: -- For each IGS_AV_STND_UNIT.unit_cd/version_number

821: v_skip_course_cd1 := v_asu_rec.as_course_cd;
822: v_skip_version_number := v_asu_rec.as_version_number;
823: GOTO continue;
824: END IF;
825: -- For each IGS_AV_STND_UNIT.unit_cd/version_number
826: -- Update student enrolment
827: IF ( v_asu_rec.s_adv_stnd_recognition_type = cst_credit AND
828: (v_asu_rec.achievable_credit_points > 0 )) THEN
829: v_message_name := NULL;

Line 838: -- Do not update IGS_AV_STND_UNIT

834: v_asu_rec.version_number,
835: v_granted_dt,
836: v_message_name) = FALSE) THEN
837: -- Insert into messages for reporting
838: -- Do not update IGS_AV_STND_UNIT
839: v_message_key := 'UNIT ' || '|' ||
840: TO_CHAR(v_asu_rec.person_id) || '|' ||
841: v_asu_rec.as_course_cd || '|' ||
842: TO_CHAR(v_asu_rec.as_version_number) || '|' ||

Line 864: -- Update IGS_AV_STND_UNIT

860: END IF;
861: END IF;
862:
863: IF (v_update_flag = TRUE) THEN
864: -- Update IGS_AV_STND_UNIT
865: -- *****************************************************************************************
866: DECLARE
867: /* Cursor to select rowid and all columns of the table */
868: CURSOR Cur_IGS_AV_STND_UNIT IS

Line 868: CURSOR Cur_IGS_AV_STND_UNIT IS

864: -- Update IGS_AV_STND_UNIT
865: -- *****************************************************************************************
866: DECLARE
867: /* Cursor to select rowid and all columns of the table */
868: CURSOR Cur_IGS_AV_STND_UNIT IS
869: SELECT rowid, IGS_AV_STND_UNIT.*
870: FROM IGS_AV_STND_UNIT
871: WHERE person_id = p_person_id
872: AND as_course_cd = v_asu_rec.as_course_cd

Line 869: SELECT rowid, IGS_AV_STND_UNIT.*

865: -- *****************************************************************************************
866: DECLARE
867: /* Cursor to select rowid and all columns of the table */
868: CURSOR Cur_IGS_AV_STND_UNIT IS
869: SELECT rowid, IGS_AV_STND_UNIT.*
870: FROM IGS_AV_STND_UNIT
871: WHERE person_id = p_person_id
872: AND as_course_cd = v_asu_rec.as_course_cd
873: AND as_version_number = v_asu_rec.as_version_number

Line 870: FROM IGS_AV_STND_UNIT

866: DECLARE
867: /* Cursor to select rowid and all columns of the table */
868: CURSOR Cur_IGS_AV_STND_UNIT IS
869: SELECT rowid, IGS_AV_STND_UNIT.*
870: FROM IGS_AV_STND_UNIT
871: WHERE person_id = p_person_id
872: AND as_course_cd = v_asu_rec.as_course_cd
873: AND as_version_number = v_asu_rec.as_version_number
874: AND unit_cd = v_asu_rec.unit_cd

Line 885: FOR IGS_AV_STND_UNIT_rec in Cur_IGS_AV_STND_UNIT LOOP

881: l_cur_get_person_num cur_get_person_num%ROWTYPE;
882: l_message_name fnd_new_messages.message_name%TYPE;
883: l_repeat_tag VARCHAR2(100);
884: BEGIN
885: FOR IGS_AV_STND_UNIT_rec in Cur_IGS_AV_STND_UNIT LOOP
886: /* For the column to be updated, modify the record variable value fetched */
887: IGS_AV_STND_UNIT_rec.granted_dt := v_granted_dt;
888: IGS_AV_STND_UNIT_rec.s_adv_stnd_granting_status := cst_granted;
889: /* Call server side TBH package procedure */

Line 887: IGS_AV_STND_UNIT_rec.granted_dt := v_granted_dt;

883: l_repeat_tag VARCHAR2(100);
884: BEGIN
885: FOR IGS_AV_STND_UNIT_rec in Cur_IGS_AV_STND_UNIT LOOP
886: /* For the column to be updated, modify the record variable value fetched */
887: IGS_AV_STND_UNIT_rec.granted_dt := v_granted_dt;
888: IGS_AV_STND_UNIT_rec.s_adv_stnd_granting_status := cst_granted;
889: /* Call server side TBH package procedure */
890: --
891: -- To check the repeat logic. Added as per the Bug# 2382566.

Line 888: IGS_AV_STND_UNIT_rec.s_adv_stnd_granting_status := cst_granted;

884: BEGIN
885: FOR IGS_AV_STND_UNIT_rec in Cur_IGS_AV_STND_UNIT LOOP
886: /* For the column to be updated, modify the record variable value fetched */
887: IGS_AV_STND_UNIT_rec.granted_dt := v_granted_dt;
888: IGS_AV_STND_UNIT_rec.s_adv_stnd_granting_status := cst_granted;
889: /* Call server side TBH package procedure */
890: --
891: -- To check the repeat logic. Added as per the Bug# 2382566.
892: -- Start of new code.

Line 901: p_person_id => igs_av_stnd_unit_rec.person_id,

897: -- it also returns true when the unit has "Repeat set to None" and For Reenroll
898: --
899:
900: IF eval_unit_repeat (
901: p_person_id => igs_av_stnd_unit_rec.person_id,
902: p_load_cal_type => igs_av_stnd_unit_rec.cal_type,
903: p_load_cal_seq_number => igs_av_stnd_unit_rec.ci_sequence_number,
904: p_uoo_id => null,
905: p_program_cd => igs_av_stnd_unit_rec.as_course_cd,

Line 902: p_load_cal_type => igs_av_stnd_unit_rec.cal_type,

898: --
899:
900: IF eval_unit_repeat (
901: p_person_id => igs_av_stnd_unit_rec.person_id,
902: p_load_cal_type => igs_av_stnd_unit_rec.cal_type,
903: p_load_cal_seq_number => igs_av_stnd_unit_rec.ci_sequence_number,
904: p_uoo_id => null,
905: p_program_cd => igs_av_stnd_unit_rec.as_course_cd,
906: p_program_version => igs_av_stnd_unit_rec.as_version_number,

Line 903: p_load_cal_seq_number => igs_av_stnd_unit_rec.ci_sequence_number,

899:
900: IF eval_unit_repeat (
901: p_person_id => igs_av_stnd_unit_rec.person_id,
902: p_load_cal_type => igs_av_stnd_unit_rec.cal_type,
903: p_load_cal_seq_number => igs_av_stnd_unit_rec.ci_sequence_number,
904: p_uoo_id => null,
905: p_program_cd => igs_av_stnd_unit_rec.as_course_cd,
906: p_program_version => igs_av_stnd_unit_rec.as_version_number,
907: p_message => l_message_name,

Line 905: p_program_cd => igs_av_stnd_unit_rec.as_course_cd,

901: p_person_id => igs_av_stnd_unit_rec.person_id,
902: p_load_cal_type => igs_av_stnd_unit_rec.cal_type,
903: p_load_cal_seq_number => igs_av_stnd_unit_rec.ci_sequence_number,
904: p_uoo_id => null,
905: p_program_cd => igs_av_stnd_unit_rec.as_course_cd,
906: p_program_version => igs_av_stnd_unit_rec.as_version_number,
907: p_message => l_message_name,
908: p_deny_warn => 'DENY',
909: p_repeat_tag => l_repeat_tag,

Line 906: p_program_version => igs_av_stnd_unit_rec.as_version_number,

902: p_load_cal_type => igs_av_stnd_unit_rec.cal_type,
903: p_load_cal_seq_number => igs_av_stnd_unit_rec.ci_sequence_number,
904: p_uoo_id => null,
905: p_program_cd => igs_av_stnd_unit_rec.as_course_cd,
906: p_program_version => igs_av_stnd_unit_rec.as_version_number,
907: p_message => l_message_name,
908: p_deny_warn => 'DENY',
909: p_repeat_tag => l_repeat_tag,
910: p_unit_cd => igs_av_stnd_unit_rec.unit_cd,

Line 910: p_unit_cd => igs_av_stnd_unit_rec.unit_cd,

906: p_program_version => igs_av_stnd_unit_rec.as_version_number,
907: p_message => l_message_name,
908: p_deny_warn => 'DENY',
909: p_repeat_tag => l_repeat_tag,
910: p_unit_cd => igs_av_stnd_unit_rec.unit_cd,
911: p_unit_version => igs_av_stnd_unit_rec.version_number,
912: p_calling_obj => 'JOB') = 'N' THEN
913:
914: OPEN cur_get_person_num;

Line 911: p_unit_version => igs_av_stnd_unit_rec.version_number,

907: p_message => l_message_name,
908: p_deny_warn => 'DENY',
909: p_repeat_tag => l_repeat_tag,
910: p_unit_cd => igs_av_stnd_unit_rec.unit_cd,
911: p_unit_version => igs_av_stnd_unit_rec.version_number,
912: p_calling_obj => 'JOB') = 'N' THEN
913:
914: OPEN cur_get_person_num;
915: FETCH cur_get_person_num INTO l_cur_get_person_num;

Line 918: fnd_message.set_token('UNIT',igs_av_stnd_unit_rec.unit_cd);

914: OPEN cur_get_person_num;
915: FETCH cur_get_person_num INTO l_cur_get_person_num;
916: CLOSE cur_get_person_num;
917: fnd_message.set_name( 'IGS', 'IGS_AV_REPEAT_FAIL');
918: fnd_message.set_token('UNIT',igs_av_stnd_unit_rec.unit_cd);
919: fnd_message.set_token('PERSON',l_cur_get_person_num.party_number);
920: fnd_file.put_line(fnd_file.log,fnd_message.get());
921: fnd_file.put_line(FND_FILE.LOG,' ');
922: v_message_key := 'UNIT ' || '|' ||

Line 939: IGS_AV_STND_UNIT_PKG.Update_Row (

935: ELSE -- otherwise grant advanced standing.
936: --
937: -- End of new code which was added as per the Bug# 2382566.
938: --
939: IGS_AV_STND_UNIT_PKG.Update_Row (
940: X_Rowid => IGS_AV_STND_UNIT_rec.rowid,
941: X_PERSON_ID => IGS_AV_STND_UNIT_rec.PERSON_ID,
942: X_AS_COURSE_CD => IGS_AV_STND_UNIT_rec.AS_COURSE_CD,
943: X_AS_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.AS_VERSION_NUMBER,

Line 940: X_Rowid => IGS_AV_STND_UNIT_rec.rowid,

936: --
937: -- End of new code which was added as per the Bug# 2382566.
938: --
939: IGS_AV_STND_UNIT_PKG.Update_Row (
940: X_Rowid => IGS_AV_STND_UNIT_rec.rowid,
941: X_PERSON_ID => IGS_AV_STND_UNIT_rec.PERSON_ID,
942: X_AS_COURSE_CD => IGS_AV_STND_UNIT_rec.AS_COURSE_CD,
943: X_AS_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.AS_VERSION_NUMBER,
944: X_S_ADV_STND_TYPE => IGS_AV_STND_UNIT_rec.S_ADV_STND_TYPE,

Line 941: X_PERSON_ID => IGS_AV_STND_UNIT_rec.PERSON_ID,

937: -- End of new code which was added as per the Bug# 2382566.
938: --
939: IGS_AV_STND_UNIT_PKG.Update_Row (
940: X_Rowid => IGS_AV_STND_UNIT_rec.rowid,
941: X_PERSON_ID => IGS_AV_STND_UNIT_rec.PERSON_ID,
942: X_AS_COURSE_CD => IGS_AV_STND_UNIT_rec.AS_COURSE_CD,
943: X_AS_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.AS_VERSION_NUMBER,
944: X_S_ADV_STND_TYPE => IGS_AV_STND_UNIT_rec.S_ADV_STND_TYPE,
945: X_UNIT_CD => IGS_AV_STND_UNIT_rec.UNIT_CD,

Line 942: X_AS_COURSE_CD => IGS_AV_STND_UNIT_rec.AS_COURSE_CD,

938: --
939: IGS_AV_STND_UNIT_PKG.Update_Row (
940: X_Rowid => IGS_AV_STND_UNIT_rec.rowid,
941: X_PERSON_ID => IGS_AV_STND_UNIT_rec.PERSON_ID,
942: X_AS_COURSE_CD => IGS_AV_STND_UNIT_rec.AS_COURSE_CD,
943: X_AS_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.AS_VERSION_NUMBER,
944: X_S_ADV_STND_TYPE => IGS_AV_STND_UNIT_rec.S_ADV_STND_TYPE,
945: X_UNIT_CD => IGS_AV_STND_UNIT_rec.UNIT_CD,
946: X_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.VERSION_NUMBER,

Line 943: X_AS_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.AS_VERSION_NUMBER,

939: IGS_AV_STND_UNIT_PKG.Update_Row (
940: X_Rowid => IGS_AV_STND_UNIT_rec.rowid,
941: X_PERSON_ID => IGS_AV_STND_UNIT_rec.PERSON_ID,
942: X_AS_COURSE_CD => IGS_AV_STND_UNIT_rec.AS_COURSE_CD,
943: X_AS_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.AS_VERSION_NUMBER,
944: X_S_ADV_STND_TYPE => IGS_AV_STND_UNIT_rec.S_ADV_STND_TYPE,
945: X_UNIT_CD => IGS_AV_STND_UNIT_rec.UNIT_CD,
946: X_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.VERSION_NUMBER,
947: X_S_ADV_STND_GRANTING_STATUS => IGS_AV_STND_UNIT_rec.S_ADV_STND_GRANTING_STATUS,

Line 944: X_S_ADV_STND_TYPE => IGS_AV_STND_UNIT_rec.S_ADV_STND_TYPE,

940: X_Rowid => IGS_AV_STND_UNIT_rec.rowid,
941: X_PERSON_ID => IGS_AV_STND_UNIT_rec.PERSON_ID,
942: X_AS_COURSE_CD => IGS_AV_STND_UNIT_rec.AS_COURSE_CD,
943: X_AS_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.AS_VERSION_NUMBER,
944: X_S_ADV_STND_TYPE => IGS_AV_STND_UNIT_rec.S_ADV_STND_TYPE,
945: X_UNIT_CD => IGS_AV_STND_UNIT_rec.UNIT_CD,
946: X_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.VERSION_NUMBER,
947: X_S_ADV_STND_GRANTING_STATUS => IGS_AV_STND_UNIT_rec.S_ADV_STND_GRANTING_STATUS,
948: X_CREDIT_PERCENTAGE => NULL,

Line 945: X_UNIT_CD => IGS_AV_STND_UNIT_rec.UNIT_CD,

941: X_PERSON_ID => IGS_AV_STND_UNIT_rec.PERSON_ID,
942: X_AS_COURSE_CD => IGS_AV_STND_UNIT_rec.AS_COURSE_CD,
943: X_AS_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.AS_VERSION_NUMBER,
944: X_S_ADV_STND_TYPE => IGS_AV_STND_UNIT_rec.S_ADV_STND_TYPE,
945: X_UNIT_CD => IGS_AV_STND_UNIT_rec.UNIT_CD,
946: X_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.VERSION_NUMBER,
947: X_S_ADV_STND_GRANTING_STATUS => IGS_AV_STND_UNIT_rec.S_ADV_STND_GRANTING_STATUS,
948: X_CREDIT_PERCENTAGE => NULL,
949: X_S_ADV_STND_RECOGNITION_TYPE => IGS_AV_STND_UNIT_rec.S_ADV_STND_RECOGNITION_TYPE,

Line 946: X_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.VERSION_NUMBER,

942: X_AS_COURSE_CD => IGS_AV_STND_UNIT_rec.AS_COURSE_CD,
943: X_AS_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.AS_VERSION_NUMBER,
944: X_S_ADV_STND_TYPE => IGS_AV_STND_UNIT_rec.S_ADV_STND_TYPE,
945: X_UNIT_CD => IGS_AV_STND_UNIT_rec.UNIT_CD,
946: X_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.VERSION_NUMBER,
947: X_S_ADV_STND_GRANTING_STATUS => IGS_AV_STND_UNIT_rec.S_ADV_STND_GRANTING_STATUS,
948: X_CREDIT_PERCENTAGE => NULL,
949: X_S_ADV_STND_RECOGNITION_TYPE => IGS_AV_STND_UNIT_rec.S_ADV_STND_RECOGNITION_TYPE,
950: X_APPROVED_DT => IGS_AV_STND_UNIT_rec.APPROVED_DT,

Line 947: X_S_ADV_STND_GRANTING_STATUS => IGS_AV_STND_UNIT_rec.S_ADV_STND_GRANTING_STATUS,

943: X_AS_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.AS_VERSION_NUMBER,
944: X_S_ADV_STND_TYPE => IGS_AV_STND_UNIT_rec.S_ADV_STND_TYPE,
945: X_UNIT_CD => IGS_AV_STND_UNIT_rec.UNIT_CD,
946: X_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.VERSION_NUMBER,
947: X_S_ADV_STND_GRANTING_STATUS => IGS_AV_STND_UNIT_rec.S_ADV_STND_GRANTING_STATUS,
948: X_CREDIT_PERCENTAGE => NULL,
949: X_S_ADV_STND_RECOGNITION_TYPE => IGS_AV_STND_UNIT_rec.S_ADV_STND_RECOGNITION_TYPE,
950: X_APPROVED_DT => IGS_AV_STND_UNIT_rec.APPROVED_DT,
951: X_AUTHORISING_PERSON_ID => IGS_AV_STND_UNIT_rec.AUTHORISING_PERSON_ID,

Line 949: X_S_ADV_STND_RECOGNITION_TYPE => IGS_AV_STND_UNIT_rec.S_ADV_STND_RECOGNITION_TYPE,

945: X_UNIT_CD => IGS_AV_STND_UNIT_rec.UNIT_CD,
946: X_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.VERSION_NUMBER,
947: X_S_ADV_STND_GRANTING_STATUS => IGS_AV_STND_UNIT_rec.S_ADV_STND_GRANTING_STATUS,
948: X_CREDIT_PERCENTAGE => NULL,
949: X_S_ADV_STND_RECOGNITION_TYPE => IGS_AV_STND_UNIT_rec.S_ADV_STND_RECOGNITION_TYPE,
950: X_APPROVED_DT => IGS_AV_STND_UNIT_rec.APPROVED_DT,
951: X_AUTHORISING_PERSON_ID => IGS_AV_STND_UNIT_rec.AUTHORISING_PERSON_ID,
952: X_CRS_GROUP_IND => IGS_AV_STND_UNIT_rec.CRS_GROUP_IND,
953: X_EXEMPTION_INSTITUTION_CD => IGS_AV_STND_UNIT_rec.EXEMPTION_INSTITUTION_CD,

Line 950: X_APPROVED_DT => IGS_AV_STND_UNIT_rec.APPROVED_DT,

946: X_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.VERSION_NUMBER,
947: X_S_ADV_STND_GRANTING_STATUS => IGS_AV_STND_UNIT_rec.S_ADV_STND_GRANTING_STATUS,
948: X_CREDIT_PERCENTAGE => NULL,
949: X_S_ADV_STND_RECOGNITION_TYPE => IGS_AV_STND_UNIT_rec.S_ADV_STND_RECOGNITION_TYPE,
950: X_APPROVED_DT => IGS_AV_STND_UNIT_rec.APPROVED_DT,
951: X_AUTHORISING_PERSON_ID => IGS_AV_STND_UNIT_rec.AUTHORISING_PERSON_ID,
952: X_CRS_GROUP_IND => IGS_AV_STND_UNIT_rec.CRS_GROUP_IND,
953: X_EXEMPTION_INSTITUTION_CD => IGS_AV_STND_UNIT_rec.EXEMPTION_INSTITUTION_CD,
954: X_GRANTED_DT => IGS_AV_STND_UNIT_rec.granted_dt,

Line 951: X_AUTHORISING_PERSON_ID => IGS_AV_STND_UNIT_rec.AUTHORISING_PERSON_ID,

947: X_S_ADV_STND_GRANTING_STATUS => IGS_AV_STND_UNIT_rec.S_ADV_STND_GRANTING_STATUS,
948: X_CREDIT_PERCENTAGE => NULL,
949: X_S_ADV_STND_RECOGNITION_TYPE => IGS_AV_STND_UNIT_rec.S_ADV_STND_RECOGNITION_TYPE,
950: X_APPROVED_DT => IGS_AV_STND_UNIT_rec.APPROVED_DT,
951: X_AUTHORISING_PERSON_ID => IGS_AV_STND_UNIT_rec.AUTHORISING_PERSON_ID,
952: X_CRS_GROUP_IND => IGS_AV_STND_UNIT_rec.CRS_GROUP_IND,
953: X_EXEMPTION_INSTITUTION_CD => IGS_AV_STND_UNIT_rec.EXEMPTION_INSTITUTION_CD,
954: X_GRANTED_DT => IGS_AV_STND_UNIT_rec.granted_dt,
955: X_EXPIRY_DT => IGS_AV_STND_UNIT_rec.EXPIRY_DT,

Line 952: X_CRS_GROUP_IND => IGS_AV_STND_UNIT_rec.CRS_GROUP_IND,

948: X_CREDIT_PERCENTAGE => NULL,
949: X_S_ADV_STND_RECOGNITION_TYPE => IGS_AV_STND_UNIT_rec.S_ADV_STND_RECOGNITION_TYPE,
950: X_APPROVED_DT => IGS_AV_STND_UNIT_rec.APPROVED_DT,
951: X_AUTHORISING_PERSON_ID => IGS_AV_STND_UNIT_rec.AUTHORISING_PERSON_ID,
952: X_CRS_GROUP_IND => IGS_AV_STND_UNIT_rec.CRS_GROUP_IND,
953: X_EXEMPTION_INSTITUTION_CD => IGS_AV_STND_UNIT_rec.EXEMPTION_INSTITUTION_CD,
954: X_GRANTED_DT => IGS_AV_STND_UNIT_rec.granted_dt,
955: X_EXPIRY_DT => IGS_AV_STND_UNIT_rec.EXPIRY_DT,
956: X_CANCELLED_DT => IGS_AV_STND_UNIT_rec.CANCELLED_DT,

Line 953: X_EXEMPTION_INSTITUTION_CD => IGS_AV_STND_UNIT_rec.EXEMPTION_INSTITUTION_CD,

949: X_S_ADV_STND_RECOGNITION_TYPE => IGS_AV_STND_UNIT_rec.S_ADV_STND_RECOGNITION_TYPE,
950: X_APPROVED_DT => IGS_AV_STND_UNIT_rec.APPROVED_DT,
951: X_AUTHORISING_PERSON_ID => IGS_AV_STND_UNIT_rec.AUTHORISING_PERSON_ID,
952: X_CRS_GROUP_IND => IGS_AV_STND_UNIT_rec.CRS_GROUP_IND,
953: X_EXEMPTION_INSTITUTION_CD => IGS_AV_STND_UNIT_rec.EXEMPTION_INSTITUTION_CD,
954: X_GRANTED_DT => IGS_AV_STND_UNIT_rec.granted_dt,
955: X_EXPIRY_DT => IGS_AV_STND_UNIT_rec.EXPIRY_DT,
956: X_CANCELLED_DT => IGS_AV_STND_UNIT_rec.CANCELLED_DT,
957: X_REVOKED_DT => IGS_AV_STND_UNIT_rec.REVOKED_DT,

Line 954: X_GRANTED_DT => IGS_AV_STND_UNIT_rec.granted_dt,

950: X_APPROVED_DT => IGS_AV_STND_UNIT_rec.APPROVED_DT,
951: X_AUTHORISING_PERSON_ID => IGS_AV_STND_UNIT_rec.AUTHORISING_PERSON_ID,
952: X_CRS_GROUP_IND => IGS_AV_STND_UNIT_rec.CRS_GROUP_IND,
953: X_EXEMPTION_INSTITUTION_CD => IGS_AV_STND_UNIT_rec.EXEMPTION_INSTITUTION_CD,
954: X_GRANTED_DT => IGS_AV_STND_UNIT_rec.granted_dt,
955: X_EXPIRY_DT => IGS_AV_STND_UNIT_rec.EXPIRY_DT,
956: X_CANCELLED_DT => IGS_AV_STND_UNIT_rec.CANCELLED_DT,
957: X_REVOKED_DT => IGS_AV_STND_UNIT_rec.REVOKED_DT,
958: X_COMMENTS => IGS_AV_STND_UNIT_rec.COMMENTS,

Line 955: X_EXPIRY_DT => IGS_AV_STND_UNIT_rec.EXPIRY_DT,

951: X_AUTHORISING_PERSON_ID => IGS_AV_STND_UNIT_rec.AUTHORISING_PERSON_ID,
952: X_CRS_GROUP_IND => IGS_AV_STND_UNIT_rec.CRS_GROUP_IND,
953: X_EXEMPTION_INSTITUTION_CD => IGS_AV_STND_UNIT_rec.EXEMPTION_INSTITUTION_CD,
954: X_GRANTED_DT => IGS_AV_STND_UNIT_rec.granted_dt,
955: X_EXPIRY_DT => IGS_AV_STND_UNIT_rec.EXPIRY_DT,
956: X_CANCELLED_DT => IGS_AV_STND_UNIT_rec.CANCELLED_DT,
957: X_REVOKED_DT => IGS_AV_STND_UNIT_rec.REVOKED_DT,
958: X_COMMENTS => IGS_AV_STND_UNIT_rec.COMMENTS,
959: X_AV_STND_UNIT_ID => IGS_AV_STND_UNIT_rec.AV_STND_UNIT_ID,

Line 956: X_CANCELLED_DT => IGS_AV_STND_UNIT_rec.CANCELLED_DT,

952: X_CRS_GROUP_IND => IGS_AV_STND_UNIT_rec.CRS_GROUP_IND,
953: X_EXEMPTION_INSTITUTION_CD => IGS_AV_STND_UNIT_rec.EXEMPTION_INSTITUTION_CD,
954: X_GRANTED_DT => IGS_AV_STND_UNIT_rec.granted_dt,
955: X_EXPIRY_DT => IGS_AV_STND_UNIT_rec.EXPIRY_DT,
956: X_CANCELLED_DT => IGS_AV_STND_UNIT_rec.CANCELLED_DT,
957: X_REVOKED_DT => IGS_AV_STND_UNIT_rec.REVOKED_DT,
958: X_COMMENTS => IGS_AV_STND_UNIT_rec.COMMENTS,
959: X_AV_STND_UNIT_ID => IGS_AV_STND_UNIT_rec.AV_STND_UNIT_ID,
960: X_CAL_TYPE => IGS_AV_STND_UNIT_rec.CAL_TYPE,

Line 957: X_REVOKED_DT => IGS_AV_STND_UNIT_rec.REVOKED_DT,

953: X_EXEMPTION_INSTITUTION_CD => IGS_AV_STND_UNIT_rec.EXEMPTION_INSTITUTION_CD,
954: X_GRANTED_DT => IGS_AV_STND_UNIT_rec.granted_dt,
955: X_EXPIRY_DT => IGS_AV_STND_UNIT_rec.EXPIRY_DT,
956: X_CANCELLED_DT => IGS_AV_STND_UNIT_rec.CANCELLED_DT,
957: X_REVOKED_DT => IGS_AV_STND_UNIT_rec.REVOKED_DT,
958: X_COMMENTS => IGS_AV_STND_UNIT_rec.COMMENTS,
959: X_AV_STND_UNIT_ID => IGS_AV_STND_UNIT_rec.AV_STND_UNIT_ID,
960: X_CAL_TYPE => IGS_AV_STND_UNIT_rec.CAL_TYPE,
961: X_CI_SEQUENCE_NUMBER => IGS_AV_STND_UNIT_rec.CI_SEQUENCE_NUMBER,

Line 958: X_COMMENTS => IGS_AV_STND_UNIT_rec.COMMENTS,

954: X_GRANTED_DT => IGS_AV_STND_UNIT_rec.granted_dt,
955: X_EXPIRY_DT => IGS_AV_STND_UNIT_rec.EXPIRY_DT,
956: X_CANCELLED_DT => IGS_AV_STND_UNIT_rec.CANCELLED_DT,
957: X_REVOKED_DT => IGS_AV_STND_UNIT_rec.REVOKED_DT,
958: X_COMMENTS => IGS_AV_STND_UNIT_rec.COMMENTS,
959: X_AV_STND_UNIT_ID => IGS_AV_STND_UNIT_rec.AV_STND_UNIT_ID,
960: X_CAL_TYPE => IGS_AV_STND_UNIT_rec.CAL_TYPE,
961: X_CI_SEQUENCE_NUMBER => IGS_AV_STND_UNIT_rec.CI_SEQUENCE_NUMBER,
962: X_INSTITUTION_CD => IGS_AV_STND_UNIT_rec.INSTITUTION_CD,

Line 959: X_AV_STND_UNIT_ID => IGS_AV_STND_UNIT_rec.AV_STND_UNIT_ID,

955: X_EXPIRY_DT => IGS_AV_STND_UNIT_rec.EXPIRY_DT,
956: X_CANCELLED_DT => IGS_AV_STND_UNIT_rec.CANCELLED_DT,
957: X_REVOKED_DT => IGS_AV_STND_UNIT_rec.REVOKED_DT,
958: X_COMMENTS => IGS_AV_STND_UNIT_rec.COMMENTS,
959: X_AV_STND_UNIT_ID => IGS_AV_STND_UNIT_rec.AV_STND_UNIT_ID,
960: X_CAL_TYPE => IGS_AV_STND_UNIT_rec.CAL_TYPE,
961: X_CI_SEQUENCE_NUMBER => IGS_AV_STND_UNIT_rec.CI_SEQUENCE_NUMBER,
962: X_INSTITUTION_CD => IGS_AV_STND_UNIT_rec.INSTITUTION_CD,
963: X_UNIT_DETAILS_ID => IGS_AV_STND_UNIT_rec.UNIT_DETAILS_ID,

Line 960: X_CAL_TYPE => IGS_AV_STND_UNIT_rec.CAL_TYPE,

956: X_CANCELLED_DT => IGS_AV_STND_UNIT_rec.CANCELLED_DT,
957: X_REVOKED_DT => IGS_AV_STND_UNIT_rec.REVOKED_DT,
958: X_COMMENTS => IGS_AV_STND_UNIT_rec.COMMENTS,
959: X_AV_STND_UNIT_ID => IGS_AV_STND_UNIT_rec.AV_STND_UNIT_ID,
960: X_CAL_TYPE => IGS_AV_STND_UNIT_rec.CAL_TYPE,
961: X_CI_SEQUENCE_NUMBER => IGS_AV_STND_UNIT_rec.CI_SEQUENCE_NUMBER,
962: X_INSTITUTION_CD => IGS_AV_STND_UNIT_rec.INSTITUTION_CD,
963: X_UNIT_DETAILS_ID => IGS_AV_STND_UNIT_rec.UNIT_DETAILS_ID,
964: X_TST_RSLT_DTLS_ID => IGS_AV_STND_UNIT_rec.TST_RSLT_DTLS_ID,

Line 961: X_CI_SEQUENCE_NUMBER => IGS_AV_STND_UNIT_rec.CI_SEQUENCE_NUMBER,

957: X_REVOKED_DT => IGS_AV_STND_UNIT_rec.REVOKED_DT,
958: X_COMMENTS => IGS_AV_STND_UNIT_rec.COMMENTS,
959: X_AV_STND_UNIT_ID => IGS_AV_STND_UNIT_rec.AV_STND_UNIT_ID,
960: X_CAL_TYPE => IGS_AV_STND_UNIT_rec.CAL_TYPE,
961: X_CI_SEQUENCE_NUMBER => IGS_AV_STND_UNIT_rec.CI_SEQUENCE_NUMBER,
962: X_INSTITUTION_CD => IGS_AV_STND_UNIT_rec.INSTITUTION_CD,
963: X_UNIT_DETAILS_ID => IGS_AV_STND_UNIT_rec.UNIT_DETAILS_ID,
964: X_TST_RSLT_DTLS_ID => IGS_AV_STND_UNIT_rec.TST_RSLT_DTLS_ID,
965: X_GRADING_SCHEMA_CD => IGS_AV_STND_UNIT_rec.GRADING_SCHEMA_CD,

Line 962: X_INSTITUTION_CD => IGS_AV_STND_UNIT_rec.INSTITUTION_CD,

958: X_COMMENTS => IGS_AV_STND_UNIT_rec.COMMENTS,
959: X_AV_STND_UNIT_ID => IGS_AV_STND_UNIT_rec.AV_STND_UNIT_ID,
960: X_CAL_TYPE => IGS_AV_STND_UNIT_rec.CAL_TYPE,
961: X_CI_SEQUENCE_NUMBER => IGS_AV_STND_UNIT_rec.CI_SEQUENCE_NUMBER,
962: X_INSTITUTION_CD => IGS_AV_STND_UNIT_rec.INSTITUTION_CD,
963: X_UNIT_DETAILS_ID => IGS_AV_STND_UNIT_rec.UNIT_DETAILS_ID,
964: X_TST_RSLT_DTLS_ID => IGS_AV_STND_UNIT_rec.TST_RSLT_DTLS_ID,
965: X_GRADING_SCHEMA_CD => IGS_AV_STND_UNIT_rec.GRADING_SCHEMA_CD,
966: X_GRD_SCH_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.GRD_SCH_VERSION_NUMBER,

Line 963: X_UNIT_DETAILS_ID => IGS_AV_STND_UNIT_rec.UNIT_DETAILS_ID,

959: X_AV_STND_UNIT_ID => IGS_AV_STND_UNIT_rec.AV_STND_UNIT_ID,
960: X_CAL_TYPE => IGS_AV_STND_UNIT_rec.CAL_TYPE,
961: X_CI_SEQUENCE_NUMBER => IGS_AV_STND_UNIT_rec.CI_SEQUENCE_NUMBER,
962: X_INSTITUTION_CD => IGS_AV_STND_UNIT_rec.INSTITUTION_CD,
963: X_UNIT_DETAILS_ID => IGS_AV_STND_UNIT_rec.UNIT_DETAILS_ID,
964: X_TST_RSLT_DTLS_ID => IGS_AV_STND_UNIT_rec.TST_RSLT_DTLS_ID,
965: X_GRADING_SCHEMA_CD => IGS_AV_STND_UNIT_rec.GRADING_SCHEMA_CD,
966: X_GRD_SCH_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.GRD_SCH_VERSION_NUMBER,
967: X_GRADE => IGS_AV_STND_UNIT_rec.GRADE,

Line 964: X_TST_RSLT_DTLS_ID => IGS_AV_STND_UNIT_rec.TST_RSLT_DTLS_ID,

960: X_CAL_TYPE => IGS_AV_STND_UNIT_rec.CAL_TYPE,
961: X_CI_SEQUENCE_NUMBER => IGS_AV_STND_UNIT_rec.CI_SEQUENCE_NUMBER,
962: X_INSTITUTION_CD => IGS_AV_STND_UNIT_rec.INSTITUTION_CD,
963: X_UNIT_DETAILS_ID => IGS_AV_STND_UNIT_rec.UNIT_DETAILS_ID,
964: X_TST_RSLT_DTLS_ID => IGS_AV_STND_UNIT_rec.TST_RSLT_DTLS_ID,
965: X_GRADING_SCHEMA_CD => IGS_AV_STND_UNIT_rec.GRADING_SCHEMA_CD,
966: X_GRD_SCH_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.GRD_SCH_VERSION_NUMBER,
967: X_GRADE => IGS_AV_STND_UNIT_rec.GRADE,
968: X_ACHIEVABLE_CREDIT_POINTS => IGS_AV_STND_UNIT_rec.ACHIEVABLE_CREDIT_POINTS,

Line 965: X_GRADING_SCHEMA_CD => IGS_AV_STND_UNIT_rec.GRADING_SCHEMA_CD,

961: X_CI_SEQUENCE_NUMBER => IGS_AV_STND_UNIT_rec.CI_SEQUENCE_NUMBER,
962: X_INSTITUTION_CD => IGS_AV_STND_UNIT_rec.INSTITUTION_CD,
963: X_UNIT_DETAILS_ID => IGS_AV_STND_UNIT_rec.UNIT_DETAILS_ID,
964: X_TST_RSLT_DTLS_ID => IGS_AV_STND_UNIT_rec.TST_RSLT_DTLS_ID,
965: X_GRADING_SCHEMA_CD => IGS_AV_STND_UNIT_rec.GRADING_SCHEMA_CD,
966: X_GRD_SCH_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.GRD_SCH_VERSION_NUMBER,
967: X_GRADE => IGS_AV_STND_UNIT_rec.GRADE,
968: X_ACHIEVABLE_CREDIT_POINTS => IGS_AV_STND_UNIT_rec.ACHIEVABLE_CREDIT_POINTS,
969: X_MODE => 'R');

Line 966: X_GRD_SCH_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.GRD_SCH_VERSION_NUMBER,

962: X_INSTITUTION_CD => IGS_AV_STND_UNIT_rec.INSTITUTION_CD,
963: X_UNIT_DETAILS_ID => IGS_AV_STND_UNIT_rec.UNIT_DETAILS_ID,
964: X_TST_RSLT_DTLS_ID => IGS_AV_STND_UNIT_rec.TST_RSLT_DTLS_ID,
965: X_GRADING_SCHEMA_CD => IGS_AV_STND_UNIT_rec.GRADING_SCHEMA_CD,
966: X_GRD_SCH_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.GRD_SCH_VERSION_NUMBER,
967: X_GRADE => IGS_AV_STND_UNIT_rec.GRADE,
968: X_ACHIEVABLE_CREDIT_POINTS => IGS_AV_STND_UNIT_rec.ACHIEVABLE_CREDIT_POINTS,
969: X_MODE => 'R');
970: END IF;

Line 967: X_GRADE => IGS_AV_STND_UNIT_rec.GRADE,

963: X_UNIT_DETAILS_ID => IGS_AV_STND_UNIT_rec.UNIT_DETAILS_ID,
964: X_TST_RSLT_DTLS_ID => IGS_AV_STND_UNIT_rec.TST_RSLT_DTLS_ID,
965: X_GRADING_SCHEMA_CD => IGS_AV_STND_UNIT_rec.GRADING_SCHEMA_CD,
966: X_GRD_SCH_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.GRD_SCH_VERSION_NUMBER,
967: X_GRADE => IGS_AV_STND_UNIT_rec.GRADE,
968: X_ACHIEVABLE_CREDIT_POINTS => IGS_AV_STND_UNIT_rec.ACHIEVABLE_CREDIT_POINTS,
969: X_MODE => 'R');
970: END IF;
971: END LOOP;

Line 968: X_ACHIEVABLE_CREDIT_POINTS => IGS_AV_STND_UNIT_rec.ACHIEVABLE_CREDIT_POINTS,

964: X_TST_RSLT_DTLS_ID => IGS_AV_STND_UNIT_rec.TST_RSLT_DTLS_ID,
965: X_GRADING_SCHEMA_CD => IGS_AV_STND_UNIT_rec.GRADING_SCHEMA_CD,
966: X_GRD_SCH_VERSION_NUMBER => IGS_AV_STND_UNIT_rec.GRD_SCH_VERSION_NUMBER,
967: X_GRADE => IGS_AV_STND_UNIT_rec.GRADE,
968: X_ACHIEVABLE_CREDIT_POINTS => IGS_AV_STND_UNIT_rec.ACHIEVABLE_CREDIT_POINTS,
969: X_MODE => 'R');
970: END IF;
971: END LOOP;
972: END;

Line 1012: END LOOP; -- process IGS_AV_STND_UNIT

1008: p_message_name := NULL;
1009: END IF; -- p_process_type = cst_course
1010: <> -- simulate C continue statement
1011: NULL; -- just make the compiler happy
1012: END LOOP; -- process IGS_AV_STND_UNIT
1013:
1014: v_skip_course_cd := 'ISNULL';
1015: v_skip_course_cd1 := 'ISNULL';
1016: v_skip_version_number := 0;

Line 1019: -- UPDATE APPROVED IGS_AV_STND_UNIT_LVL

1015: v_skip_course_cd1 := 'ISNULL';
1016: v_skip_version_number := 0;
1017: v_last_course_cd := 'ISNULL';
1018: v_last_version_number := 0;
1019: -- UPDATE APPROVED IGS_AV_STND_UNIT_LVL
1020: p_message_name := 'IGS_AV_UNITLVL_UPDANOTHER_PRC';
1021:
1022: FOR v_asul_rec IN c_asul(p_person_id) LOOP
1023: IF (p_process_type = cst_course AND

Line 1030: -- Do nothing, continue IGS_AV_STND_UNIT_LVL

1026: (v_asul_rec.as_course_cd = v_skip_course_cd) OR
1027: (v_asul_rec.as_course_cd = v_skip_course_cd1 AND
1028: v_asul_rec.as_version_number = v_skip_version_number)
1029: THEN
1030: -- Do nothing, continue IGS_AV_STND_UNIT_LVL
1031: NULL;
1032: ELSE
1033: -- For each IGS_AV_STND_UNIT_LVL.as_course_cd
1034: -- Validate that person/course is not excluded from advanced standing

Line 1033: -- For each IGS_AV_STND_UNIT_LVL.as_course_cd

1029: THEN
1030: -- Do nothing, continue IGS_AV_STND_UNIT_LVL
1031: NULL;
1032: ELSE
1033: -- For each IGS_AV_STND_UNIT_LVL.as_course_cd
1034: -- Validate that person/course is not excluded from advanced standing
1035: IF (IGS_EN_VAL_ENCMB.enrp_val_excld_prsn(
1036: v_asul_rec.person_id,
1037: v_asul_rec.as_course_cd,

Line 1041: -- Do not process any more IGS_AV_STND_UNIT_LVL for this course

1037: v_asul_rec.as_course_cd,
1038: v_granted_dt,
1039: v_message_name) = FALSE) THEN
1040: -- Insert into messages for reporting
1041: -- Do not process any more IGS_AV_STND_UNIT_LVL for this course
1042: v_message_key := 'UNIT LEVEL'|| '|' ||
1043: TO_CHAR(v_asul_rec.person_id) || '|' ||
1044: v_asul_rec.as_course_cd || '|' ||
1045: TO_CHAR(v_asul_rec.as_version_number) || '|' ||

Line 1059: -- For each IGS_AV_STND_UNIT_LVL.as_course_cd/as_version_number

1055: '');
1056: v_skip_course_cd := v_asul_rec.as_course_cd;
1057: GOTO continue1;
1058: END IF;
1059: -- For each IGS_AV_STND_UNIT_LVL.as_course_cd/as_version_number
1060: -- Validate advanced standing course version
1061: IF (v_asul_rec.as_course_cd = v_last_course_cd AND
1062: v_asul_rec.as_version_number = v_last_version_number) THEN
1063: NULL; -- do nothing, continue IGS_AV_STND_UNIT

Line 1063: NULL; -- do nothing, continue IGS_AV_STND_UNIT

1059: -- For each IGS_AV_STND_UNIT_LVL.as_course_cd/as_version_number
1060: -- Validate advanced standing course version
1061: IF (v_asul_rec.as_course_cd = v_last_course_cd AND
1062: v_asul_rec.as_version_number = v_last_version_number) THEN
1063: NULL; -- do nothing, continue IGS_AV_STND_UNIT
1064: ELSE
1065: v_last_course_cd := v_asul_rec.as_course_cd;
1066: v_last_version_number := v_asul_rec.as_version_number;
1067: IF (IGS_AV_VAL_ASU.advp_val_as_grant(

Line 1074: -- Do not process any more IGS_AV_STND_UNIT_LVL for this course

1070: v_asul_rec.as_version_number,
1071: v_asul_rec.s_adv_stnd_granting_status,
1072: v_message_name) = FALSE) THEN
1073: -- Insert into messages for reporting
1074: -- Do not process any more IGS_AV_STND_UNIT_LVL for this course
1075: v_message_key := 'UNIT LEVEL'|| '|' ||
1076: TO_CHAR(v_asul_rec.person_id) || '|' ||
1077: v_asul_rec.as_course_cd || '|' ||
1078: TO_CHAR(v_asul_rec.as_version_number) || '|' ||

Line 1100: '', -- IGS_AV_STND_UNIT.unit_cd

1096: v_asul_rec.person_id,
1097: v_asul_rec.as_course_cd,
1098: v_asul_rec.as_version_number,
1099: TRUE,
1100: '', -- IGS_AV_STND_UNIT.unit_cd
1101: '', -- IGS_AV_STND_UNIT.version_number
1102: '', -- IGS_AV_STND_UNIT.s_adv_stnd_granting_status
1103: v_asul_rec.unit_level,
1104: v_asul_rec.exemption_institution_cd,

Line 1101: '', -- IGS_AV_STND_UNIT.version_number

1097: v_asul_rec.as_course_cd,
1098: v_asul_rec.as_version_number,
1099: TRUE,
1100: '', -- IGS_AV_STND_UNIT.unit_cd
1101: '', -- IGS_AV_STND_UNIT.version_number
1102: '', -- IGS_AV_STND_UNIT.s_adv_stnd_granting_status
1103: v_asul_rec.unit_level,
1104: v_asul_rec.exemption_institution_cd,
1105: cst_granted,

Line 1102: '', -- IGS_AV_STND_UNIT.s_adv_stnd_granting_status

1098: v_asul_rec.as_version_number,
1099: TRUE,
1100: '', -- IGS_AV_STND_UNIT.unit_cd
1101: '', -- IGS_AV_STND_UNIT.version_number
1102: '', -- IGS_AV_STND_UNIT.s_adv_stnd_granting_status
1103: v_asul_rec.unit_level,
1104: v_asul_rec.exemption_institution_cd,
1105: cst_granted,
1106: v_total_exmptn_approved,

Line 1114: -- Do not process any more IGS_AV_STND_UNIT_LVL for this course

1110: v_asul_rec.unit_details_id,
1111: v_asul_rec.tst_rslt_dtls_id,
1112: NULL) = FALSE) THEN
1113: -- Insert into messages for reporting
1114: -- Do not process any more IGS_AV_STND_UNIT_LVL for this course
1115: v_message_key := 'UNIT LEVEL'|| '|' ||
1116: TO_CHAR(v_asul_rec.person_id) || '|' ||
1117: v_asul_rec.as_course_cd || '|' ||
1118: TO_CHAR(v_asul_rec.as_version_number) || '|' ||

Line 1133: -- Update IGS_AV_STND_UNIT_LVL

1129: v_skip_course_cd1 := v_asul_rec.as_course_cd;
1130: v_skip_version_number := v_asul_rec.as_version_number;
1131: GOTO continue1;
1132: END IF;
1133: -- Update IGS_AV_STND_UNIT_LVL
1134: -- ********************************************************************************************
1135: DECLARE
1136: /* Cursor to select rowid and all columns of the table */
1137: CURSOR Cur_IGS_AV_STND_UNIT_lvl IS

Line 1137: CURSOR Cur_IGS_AV_STND_UNIT_lvl IS

1133: -- Update IGS_AV_STND_UNIT_LVL
1134: -- ********************************************************************************************
1135: DECLARE
1136: /* Cursor to select rowid and all columns of the table */
1137: CURSOR Cur_IGS_AV_STND_UNIT_lvl IS
1138: SELECT rowid, IGS_AV_STND_UNIT_lvl.*
1139: FROM IGS_AV_STND_UNIT_lvl
1140: WHERE person_id = p_person_id
1141: AND as_course_cd = v_asul_rec.as_course_cd

Line 1138: SELECT rowid, IGS_AV_STND_UNIT_lvl.*

1134: -- ********************************************************************************************
1135: DECLARE
1136: /* Cursor to select rowid and all columns of the table */
1137: CURSOR Cur_IGS_AV_STND_UNIT_lvl IS
1138: SELECT rowid, IGS_AV_STND_UNIT_lvl.*
1139: FROM IGS_AV_STND_UNIT_lvl
1140: WHERE person_id = p_person_id
1141: AND as_course_cd = v_asul_rec.as_course_cd
1142: AND as_version_number = v_asul_rec.as_version_number

Line 1139: FROM IGS_AV_STND_UNIT_lvl

1135: DECLARE
1136: /* Cursor to select rowid and all columns of the table */
1137: CURSOR Cur_IGS_AV_STND_UNIT_lvl IS
1138: SELECT rowid, IGS_AV_STND_UNIT_lvl.*
1139: FROM IGS_AV_STND_UNIT_lvl
1140: WHERE person_id = p_person_id
1141: AND as_course_cd = v_asul_rec.as_course_cd
1142: AND as_version_number = v_asul_rec.as_version_number
1143: AND unit_level = v_asul_rec.unit_level

Line 1147: FOR IGS_AV_STND_UNIT_lvl_rec IN Cur_IGS_AV_STND_UNIT_LVL LOOP

1143: AND unit_level = v_asul_rec.unit_level
1144: AND crs_group_ind = v_asul_rec.crs_group_ind
1145: AND exemption_institution_cd = v_asul_rec.exemption_institution_cd;
1146: BEGIN
1147: FOR IGS_AV_STND_UNIT_lvl_rec IN Cur_IGS_AV_STND_UNIT_LVL LOOP
1148: /* For the column to be updated, modify the record variable value fetched */
1149: IGS_AV_STND_UNIT_lvl_rec.granted_dt := v_granted_dt;
1150: IGS_AV_STND_UNIT_lvl_rec.s_adv_stnd_granting_status := cst_granted;
1151: /* Call server side TBH package procedure */

Line 1149: IGS_AV_STND_UNIT_lvl_rec.granted_dt := v_granted_dt;

1145: AND exemption_institution_cd = v_asul_rec.exemption_institution_cd;
1146: BEGIN
1147: FOR IGS_AV_STND_UNIT_lvl_rec IN Cur_IGS_AV_STND_UNIT_LVL LOOP
1148: /* For the column to be updated, modify the record variable value fetched */
1149: IGS_AV_STND_UNIT_lvl_rec.granted_dt := v_granted_dt;
1150: IGS_AV_STND_UNIT_lvl_rec.s_adv_stnd_granting_status := cst_granted;
1151: /* Call server side TBH package procedure */
1152: IGS_AV_STND_UNIT_LVL_PKG.update_row(
1153: X_Rowid => IGS_AV_STND_UNIT_LVL_rec.rowid,

Line 1150: IGS_AV_STND_UNIT_lvl_rec.s_adv_stnd_granting_status := cst_granted;

1146: BEGIN
1147: FOR IGS_AV_STND_UNIT_lvl_rec IN Cur_IGS_AV_STND_UNIT_LVL LOOP
1148: /* For the column to be updated, modify the record variable value fetched */
1149: IGS_AV_STND_UNIT_lvl_rec.granted_dt := v_granted_dt;
1150: IGS_AV_STND_UNIT_lvl_rec.s_adv_stnd_granting_status := cst_granted;
1151: /* Call server side TBH package procedure */
1152: IGS_AV_STND_UNIT_LVL_PKG.update_row(
1153: X_Rowid => IGS_AV_STND_UNIT_LVL_rec.rowid,
1154: X_PERSON_ID => IGS_AV_STND_UNIT_LVL_rec.PERSON_ID ,

Line 1152: IGS_AV_STND_UNIT_LVL_PKG.update_row(

1148: /* For the column to be updated, modify the record variable value fetched */
1149: IGS_AV_STND_UNIT_lvl_rec.granted_dt := v_granted_dt;
1150: IGS_AV_STND_UNIT_lvl_rec.s_adv_stnd_granting_status := cst_granted;
1151: /* Call server side TBH package procedure */
1152: IGS_AV_STND_UNIT_LVL_PKG.update_row(
1153: X_Rowid => IGS_AV_STND_UNIT_LVL_rec.rowid,
1154: X_PERSON_ID => IGS_AV_STND_UNIT_LVL_rec.PERSON_ID ,
1155: X_AS_COURSE_CD => IGS_AV_STND_UNIT_LVL_rec.AS_COURSE_CD ,
1156: X_AS_VERSION_NUMBER => IGS_AV_STND_UNIT_LVL_rec.AS_VERSION_NUMBER ,

Line 1153: X_Rowid => IGS_AV_STND_UNIT_LVL_rec.rowid,

1149: IGS_AV_STND_UNIT_lvl_rec.granted_dt := v_granted_dt;
1150: IGS_AV_STND_UNIT_lvl_rec.s_adv_stnd_granting_status := cst_granted;
1151: /* Call server side TBH package procedure */
1152: IGS_AV_STND_UNIT_LVL_PKG.update_row(
1153: X_Rowid => IGS_AV_STND_UNIT_LVL_rec.rowid,
1154: X_PERSON_ID => IGS_AV_STND_UNIT_LVL_rec.PERSON_ID ,
1155: X_AS_COURSE_CD => IGS_AV_STND_UNIT_LVL_rec.AS_COURSE_CD ,
1156: X_AS_VERSION_NUMBER => IGS_AV_STND_UNIT_LVL_rec.AS_VERSION_NUMBER ,
1157: X_S_ADV_STND_TYPE => IGS_AV_STND_UNIT_LVL_rec.S_ADV_STND_TYPE ,

Line 1154: X_PERSON_ID => IGS_AV_STND_UNIT_LVL_rec.PERSON_ID ,

1150: IGS_AV_STND_UNIT_lvl_rec.s_adv_stnd_granting_status := cst_granted;
1151: /* Call server side TBH package procedure */
1152: IGS_AV_STND_UNIT_LVL_PKG.update_row(
1153: X_Rowid => IGS_AV_STND_UNIT_LVL_rec.rowid,
1154: X_PERSON_ID => IGS_AV_STND_UNIT_LVL_rec.PERSON_ID ,
1155: X_AS_COURSE_CD => IGS_AV_STND_UNIT_LVL_rec.AS_COURSE_CD ,
1156: X_AS_VERSION_NUMBER => IGS_AV_STND_UNIT_LVL_rec.AS_VERSION_NUMBER ,
1157: X_S_ADV_STND_TYPE => IGS_AV_STND_UNIT_LVL_rec.S_ADV_STND_TYPE ,
1158: X_UNIT_LEVEL => IGS_AV_STND_UNIT_LVL_rec.UNIT_LEVEL ,

Line 1155: X_AS_COURSE_CD => IGS_AV_STND_UNIT_LVL_rec.AS_COURSE_CD ,

1151: /* Call server side TBH package procedure */
1152: IGS_AV_STND_UNIT_LVL_PKG.update_row(
1153: X_Rowid => IGS_AV_STND_UNIT_LVL_rec.rowid,
1154: X_PERSON_ID => IGS_AV_STND_UNIT_LVL_rec.PERSON_ID ,
1155: X_AS_COURSE_CD => IGS_AV_STND_UNIT_LVL_rec.AS_COURSE_CD ,
1156: X_AS_VERSION_NUMBER => IGS_AV_STND_UNIT_LVL_rec.AS_VERSION_NUMBER ,
1157: X_S_ADV_STND_TYPE => IGS_AV_STND_UNIT_LVL_rec.S_ADV_STND_TYPE ,
1158: X_UNIT_LEVEL => IGS_AV_STND_UNIT_LVL_rec.UNIT_LEVEL ,
1159: X_CRS_GROUP_IND => IGS_AV_STND_UNIT_LVL_rec.CRS_GROUP_IND ,

Line 1156: X_AS_VERSION_NUMBER => IGS_AV_STND_UNIT_LVL_rec.AS_VERSION_NUMBER ,

1152: IGS_AV_STND_UNIT_LVL_PKG.update_row(
1153: X_Rowid => IGS_AV_STND_UNIT_LVL_rec.rowid,
1154: X_PERSON_ID => IGS_AV_STND_UNIT_LVL_rec.PERSON_ID ,
1155: X_AS_COURSE_CD => IGS_AV_STND_UNIT_LVL_rec.AS_COURSE_CD ,
1156: X_AS_VERSION_NUMBER => IGS_AV_STND_UNIT_LVL_rec.AS_VERSION_NUMBER ,
1157: X_S_ADV_STND_TYPE => IGS_AV_STND_UNIT_LVL_rec.S_ADV_STND_TYPE ,
1158: X_UNIT_LEVEL => IGS_AV_STND_UNIT_LVL_rec.UNIT_LEVEL ,
1159: X_CRS_GROUP_IND => IGS_AV_STND_UNIT_LVL_rec.CRS_GROUP_IND ,
1160: X_EXEMPTION_INSTITUTION_CD => IGS_AV_STND_UNIT_LVL_rec.EXEMPTION_INSTITUTION_CD ,

Line 1157: X_S_ADV_STND_TYPE => IGS_AV_STND_UNIT_LVL_rec.S_ADV_STND_TYPE ,

1153: X_Rowid => IGS_AV_STND_UNIT_LVL_rec.rowid,
1154: X_PERSON_ID => IGS_AV_STND_UNIT_LVL_rec.PERSON_ID ,
1155: X_AS_COURSE_CD => IGS_AV_STND_UNIT_LVL_rec.AS_COURSE_CD ,
1156: X_AS_VERSION_NUMBER => IGS_AV_STND_UNIT_LVL_rec.AS_VERSION_NUMBER ,
1157: X_S_ADV_STND_TYPE => IGS_AV_STND_UNIT_LVL_rec.S_ADV_STND_TYPE ,
1158: X_UNIT_LEVEL => IGS_AV_STND_UNIT_LVL_rec.UNIT_LEVEL ,
1159: X_CRS_GROUP_IND => IGS_AV_STND_UNIT_LVL_rec.CRS_GROUP_IND ,
1160: X_EXEMPTION_INSTITUTION_CD => IGS_AV_STND_UNIT_LVL_rec.EXEMPTION_INSTITUTION_CD ,
1161: X_S_ADV_STND_GRANTING_STATUS => IGS_AV_STND_UNIT_LVL_rec.S_ADV_STND_GRANTING_STATUS ,

Line 1158: X_UNIT_LEVEL => IGS_AV_STND_UNIT_LVL_rec.UNIT_LEVEL ,

1154: X_PERSON_ID => IGS_AV_STND_UNIT_LVL_rec.PERSON_ID ,
1155: X_AS_COURSE_CD => IGS_AV_STND_UNIT_LVL_rec.AS_COURSE_CD ,
1156: X_AS_VERSION_NUMBER => IGS_AV_STND_UNIT_LVL_rec.AS_VERSION_NUMBER ,
1157: X_S_ADV_STND_TYPE => IGS_AV_STND_UNIT_LVL_rec.S_ADV_STND_TYPE ,
1158: X_UNIT_LEVEL => IGS_AV_STND_UNIT_LVL_rec.UNIT_LEVEL ,
1159: X_CRS_GROUP_IND => IGS_AV_STND_UNIT_LVL_rec.CRS_GROUP_IND ,
1160: X_EXEMPTION_INSTITUTION_CD => IGS_AV_STND_UNIT_LVL_rec.EXEMPTION_INSTITUTION_CD ,
1161: X_S_ADV_STND_GRANTING_STATUS => IGS_AV_STND_UNIT_LVL_rec.S_ADV_STND_GRANTING_STATUS ,
1162: X_CREDIT_POINTS => IGS_AV_STND_UNIT_LVL_rec.CREDIT_POINTS ,

Line 1159: X_CRS_GROUP_IND => IGS_AV_STND_UNIT_LVL_rec.CRS_GROUP_IND ,

1155: X_AS_COURSE_CD => IGS_AV_STND_UNIT_LVL_rec.AS_COURSE_CD ,
1156: X_AS_VERSION_NUMBER => IGS_AV_STND_UNIT_LVL_rec.AS_VERSION_NUMBER ,
1157: X_S_ADV_STND_TYPE => IGS_AV_STND_UNIT_LVL_rec.S_ADV_STND_TYPE ,
1158: X_UNIT_LEVEL => IGS_AV_STND_UNIT_LVL_rec.UNIT_LEVEL ,
1159: X_CRS_GROUP_IND => IGS_AV_STND_UNIT_LVL_rec.CRS_GROUP_IND ,
1160: X_EXEMPTION_INSTITUTION_CD => IGS_AV_STND_UNIT_LVL_rec.EXEMPTION_INSTITUTION_CD ,
1161: X_S_ADV_STND_GRANTING_STATUS => IGS_AV_STND_UNIT_LVL_rec.S_ADV_STND_GRANTING_STATUS ,
1162: X_CREDIT_POINTS => IGS_AV_STND_UNIT_LVL_rec.CREDIT_POINTS ,
1163: X_APPROVED_DT => IGS_AV_STND_UNIT_LVL_rec.APPROVED_DT ,

Line 1160: X_EXEMPTION_INSTITUTION_CD => IGS_AV_STND_UNIT_LVL_rec.EXEMPTION_INSTITUTION_CD ,

1156: X_AS_VERSION_NUMBER => IGS_AV_STND_UNIT_LVL_rec.AS_VERSION_NUMBER ,
1157: X_S_ADV_STND_TYPE => IGS_AV_STND_UNIT_LVL_rec.S_ADV_STND_TYPE ,
1158: X_UNIT_LEVEL => IGS_AV_STND_UNIT_LVL_rec.UNIT_LEVEL ,
1159: X_CRS_GROUP_IND => IGS_AV_STND_UNIT_LVL_rec.CRS_GROUP_IND ,
1160: X_EXEMPTION_INSTITUTION_CD => IGS_AV_STND_UNIT_LVL_rec.EXEMPTION_INSTITUTION_CD ,
1161: X_S_ADV_STND_GRANTING_STATUS => IGS_AV_STND_UNIT_LVL_rec.S_ADV_STND_GRANTING_STATUS ,
1162: X_CREDIT_POINTS => IGS_AV_STND_UNIT_LVL_rec.CREDIT_POINTS ,
1163: X_APPROVED_DT => IGS_AV_STND_UNIT_LVL_rec.APPROVED_DT ,
1164: X_AUTHORISING_PERSON_ID => IGS_AV_STND_UNIT_LVL_rec.AUTHORISING_PERSON_ID ,

Line 1161: X_S_ADV_STND_GRANTING_STATUS => IGS_AV_STND_UNIT_LVL_rec.S_ADV_STND_GRANTING_STATUS ,

1157: X_S_ADV_STND_TYPE => IGS_AV_STND_UNIT_LVL_rec.S_ADV_STND_TYPE ,
1158: X_UNIT_LEVEL => IGS_AV_STND_UNIT_LVL_rec.UNIT_LEVEL ,
1159: X_CRS_GROUP_IND => IGS_AV_STND_UNIT_LVL_rec.CRS_GROUP_IND ,
1160: X_EXEMPTION_INSTITUTION_CD => IGS_AV_STND_UNIT_LVL_rec.EXEMPTION_INSTITUTION_CD ,
1161: X_S_ADV_STND_GRANTING_STATUS => IGS_AV_STND_UNIT_LVL_rec.S_ADV_STND_GRANTING_STATUS ,
1162: X_CREDIT_POINTS => IGS_AV_STND_UNIT_LVL_rec.CREDIT_POINTS ,
1163: X_APPROVED_DT => IGS_AV_STND_UNIT_LVL_rec.APPROVED_DT ,
1164: X_AUTHORISING_PERSON_ID => IGS_AV_STND_UNIT_LVL_rec.AUTHORISING_PERSON_ID ,
1165: X_GRANTED_DT => IGS_AV_STND_UNIT_LVL_rec.GRANTED_DT ,

Line 1162: X_CREDIT_POINTS => IGS_AV_STND_UNIT_LVL_rec.CREDIT_POINTS ,

1158: X_UNIT_LEVEL => IGS_AV_STND_UNIT_LVL_rec.UNIT_LEVEL ,
1159: X_CRS_GROUP_IND => IGS_AV_STND_UNIT_LVL_rec.CRS_GROUP_IND ,
1160: X_EXEMPTION_INSTITUTION_CD => IGS_AV_STND_UNIT_LVL_rec.EXEMPTION_INSTITUTION_CD ,
1161: X_S_ADV_STND_GRANTING_STATUS => IGS_AV_STND_UNIT_LVL_rec.S_ADV_STND_GRANTING_STATUS ,
1162: X_CREDIT_POINTS => IGS_AV_STND_UNIT_LVL_rec.CREDIT_POINTS ,
1163: X_APPROVED_DT => IGS_AV_STND_UNIT_LVL_rec.APPROVED_DT ,
1164: X_AUTHORISING_PERSON_ID => IGS_AV_STND_UNIT_LVL_rec.AUTHORISING_PERSON_ID ,
1165: X_GRANTED_DT => IGS_AV_STND_UNIT_LVL_rec.GRANTED_DT ,
1166: X_EXPIRY_DT => IGS_AV_STND_UNIT_LVL_rec.EXPIRY_DT ,

Line 1163: X_APPROVED_DT => IGS_AV_STND_UNIT_LVL_rec.APPROVED_DT ,

1159: X_CRS_GROUP_IND => IGS_AV_STND_UNIT_LVL_rec.CRS_GROUP_IND ,
1160: X_EXEMPTION_INSTITUTION_CD => IGS_AV_STND_UNIT_LVL_rec.EXEMPTION_INSTITUTION_CD ,
1161: X_S_ADV_STND_GRANTING_STATUS => IGS_AV_STND_UNIT_LVL_rec.S_ADV_STND_GRANTING_STATUS ,
1162: X_CREDIT_POINTS => IGS_AV_STND_UNIT_LVL_rec.CREDIT_POINTS ,
1163: X_APPROVED_DT => IGS_AV_STND_UNIT_LVL_rec.APPROVED_DT ,
1164: X_AUTHORISING_PERSON_ID => IGS_AV_STND_UNIT_LVL_rec.AUTHORISING_PERSON_ID ,
1165: X_GRANTED_DT => IGS_AV_STND_UNIT_LVL_rec.GRANTED_DT ,
1166: X_EXPIRY_DT => IGS_AV_STND_UNIT_LVL_rec.EXPIRY_DT ,
1167: X_CANCELLED_DT => IGS_AV_STND_UNIT_LVL_rec.CANCELLED_DT ,

Line 1164: X_AUTHORISING_PERSON_ID => IGS_AV_STND_UNIT_LVL_rec.AUTHORISING_PERSON_ID ,

1160: X_EXEMPTION_INSTITUTION_CD => IGS_AV_STND_UNIT_LVL_rec.EXEMPTION_INSTITUTION_CD ,
1161: X_S_ADV_STND_GRANTING_STATUS => IGS_AV_STND_UNIT_LVL_rec.S_ADV_STND_GRANTING_STATUS ,
1162: X_CREDIT_POINTS => IGS_AV_STND_UNIT_LVL_rec.CREDIT_POINTS ,
1163: X_APPROVED_DT => IGS_AV_STND_UNIT_LVL_rec.APPROVED_DT ,
1164: X_AUTHORISING_PERSON_ID => IGS_AV_STND_UNIT_LVL_rec.AUTHORISING_PERSON_ID ,
1165: X_GRANTED_DT => IGS_AV_STND_UNIT_LVL_rec.GRANTED_DT ,
1166: X_EXPIRY_DT => IGS_AV_STND_UNIT_LVL_rec.EXPIRY_DT ,
1167: X_CANCELLED_DT => IGS_AV_STND_UNIT_LVL_rec.CANCELLED_DT ,
1168: X_REVOKED_DT => IGS_AV_STND_UNIT_LVL_rec.REVOKED_DT ,

Line 1165: X_GRANTED_DT => IGS_AV_STND_UNIT_LVL_rec.GRANTED_DT ,

1161: X_S_ADV_STND_GRANTING_STATUS => IGS_AV_STND_UNIT_LVL_rec.S_ADV_STND_GRANTING_STATUS ,
1162: X_CREDIT_POINTS => IGS_AV_STND_UNIT_LVL_rec.CREDIT_POINTS ,
1163: X_APPROVED_DT => IGS_AV_STND_UNIT_LVL_rec.APPROVED_DT ,
1164: X_AUTHORISING_PERSON_ID => IGS_AV_STND_UNIT_LVL_rec.AUTHORISING_PERSON_ID ,
1165: X_GRANTED_DT => IGS_AV_STND_UNIT_LVL_rec.GRANTED_DT ,
1166: X_EXPIRY_DT => IGS_AV_STND_UNIT_LVL_rec.EXPIRY_DT ,
1167: X_CANCELLED_DT => IGS_AV_STND_UNIT_LVL_rec.CANCELLED_DT ,
1168: X_REVOKED_DT => IGS_AV_STND_UNIT_LVL_rec.REVOKED_DT ,
1169: X_COMMENTS => IGS_AV_STND_UNIT_LVL_rec.COMMENTS ,

Line 1166: X_EXPIRY_DT => IGS_AV_STND_UNIT_LVL_rec.EXPIRY_DT ,

1162: X_CREDIT_POINTS => IGS_AV_STND_UNIT_LVL_rec.CREDIT_POINTS ,
1163: X_APPROVED_DT => IGS_AV_STND_UNIT_LVL_rec.APPROVED_DT ,
1164: X_AUTHORISING_PERSON_ID => IGS_AV_STND_UNIT_LVL_rec.AUTHORISING_PERSON_ID ,
1165: X_GRANTED_DT => IGS_AV_STND_UNIT_LVL_rec.GRANTED_DT ,
1166: X_EXPIRY_DT => IGS_AV_STND_UNIT_LVL_rec.EXPIRY_DT ,
1167: X_CANCELLED_DT => IGS_AV_STND_UNIT_LVL_rec.CANCELLED_DT ,
1168: X_REVOKED_DT => IGS_AV_STND_UNIT_LVL_rec.REVOKED_DT ,
1169: X_COMMENTS => IGS_AV_STND_UNIT_LVL_rec.COMMENTS ,
1170: X_AV_STND_UNIT_LVL_ID => IGS_AV_STND_UNIT_LVL_rec.AV_STND_UNIT_LVL_ID ,

Line 1167: X_CANCELLED_DT => IGS_AV_STND_UNIT_LVL_rec.CANCELLED_DT ,

1163: X_APPROVED_DT => IGS_AV_STND_UNIT_LVL_rec.APPROVED_DT ,
1164: X_AUTHORISING_PERSON_ID => IGS_AV_STND_UNIT_LVL_rec.AUTHORISING_PERSON_ID ,
1165: X_GRANTED_DT => IGS_AV_STND_UNIT_LVL_rec.GRANTED_DT ,
1166: X_EXPIRY_DT => IGS_AV_STND_UNIT_LVL_rec.EXPIRY_DT ,
1167: X_CANCELLED_DT => IGS_AV_STND_UNIT_LVL_rec.CANCELLED_DT ,
1168: X_REVOKED_DT => IGS_AV_STND_UNIT_LVL_rec.REVOKED_DT ,
1169: X_COMMENTS => IGS_AV_STND_UNIT_LVL_rec.COMMENTS ,
1170: X_AV_STND_UNIT_LVL_ID => IGS_AV_STND_UNIT_LVL_rec.AV_STND_UNIT_LVL_ID ,
1171: X_CAL_TYPE => IGS_AV_STND_UNIT_LVL_rec.CAL_TYPE ,

Line 1168: X_REVOKED_DT => IGS_AV_STND_UNIT_LVL_rec.REVOKED_DT ,

1164: X_AUTHORISING_PERSON_ID => IGS_AV_STND_UNIT_LVL_rec.AUTHORISING_PERSON_ID ,
1165: X_GRANTED_DT => IGS_AV_STND_UNIT_LVL_rec.GRANTED_DT ,
1166: X_EXPIRY_DT => IGS_AV_STND_UNIT_LVL_rec.EXPIRY_DT ,
1167: X_CANCELLED_DT => IGS_AV_STND_UNIT_LVL_rec.CANCELLED_DT ,
1168: X_REVOKED_DT => IGS_AV_STND_UNIT_LVL_rec.REVOKED_DT ,
1169: X_COMMENTS => IGS_AV_STND_UNIT_LVL_rec.COMMENTS ,
1170: X_AV_STND_UNIT_LVL_ID => IGS_AV_STND_UNIT_LVL_rec.AV_STND_UNIT_LVL_ID ,
1171: X_CAL_TYPE => IGS_AV_STND_UNIT_LVL_rec.CAL_TYPE ,
1172: X_CI_SEQUENCE_NUMBER => IGS_AV_STND_UNIT_LVL_rec.CI_SEQUENCE_NUMBER ,

Line 1169: X_COMMENTS => IGS_AV_STND_UNIT_LVL_rec.COMMENTS ,

1165: X_GRANTED_DT => IGS_AV_STND_UNIT_LVL_rec.GRANTED_DT ,
1166: X_EXPIRY_DT => IGS_AV_STND_UNIT_LVL_rec.EXPIRY_DT ,
1167: X_CANCELLED_DT => IGS_AV_STND_UNIT_LVL_rec.CANCELLED_DT ,
1168: X_REVOKED_DT => IGS_AV_STND_UNIT_LVL_rec.REVOKED_DT ,
1169: X_COMMENTS => IGS_AV_STND_UNIT_LVL_rec.COMMENTS ,
1170: X_AV_STND_UNIT_LVL_ID => IGS_AV_STND_UNIT_LVL_rec.AV_STND_UNIT_LVL_ID ,
1171: X_CAL_TYPE => IGS_AV_STND_UNIT_LVL_rec.CAL_TYPE ,
1172: X_CI_SEQUENCE_NUMBER => IGS_AV_STND_UNIT_LVL_rec.CI_SEQUENCE_NUMBER ,
1173: X_INSTITUTION_CD => IGS_AV_STND_UNIT_LVL_rec.INSTITUTION_CD ,

Line 1170: X_AV_STND_UNIT_LVL_ID => IGS_AV_STND_UNIT_LVL_rec.AV_STND_UNIT_LVL_ID ,

1166: X_EXPIRY_DT => IGS_AV_STND_UNIT_LVL_rec.EXPIRY_DT ,
1167: X_CANCELLED_DT => IGS_AV_STND_UNIT_LVL_rec.CANCELLED_DT ,
1168: X_REVOKED_DT => IGS_AV_STND_UNIT_LVL_rec.REVOKED_DT ,
1169: X_COMMENTS => IGS_AV_STND_UNIT_LVL_rec.COMMENTS ,
1170: X_AV_STND_UNIT_LVL_ID => IGS_AV_STND_UNIT_LVL_rec.AV_STND_UNIT_LVL_ID ,
1171: X_CAL_TYPE => IGS_AV_STND_UNIT_LVL_rec.CAL_TYPE ,
1172: X_CI_SEQUENCE_NUMBER => IGS_AV_STND_UNIT_LVL_rec.CI_SEQUENCE_NUMBER ,
1173: X_INSTITUTION_CD => IGS_AV_STND_UNIT_LVL_rec.INSTITUTION_CD ,
1174: X_UNIT_DETAILS_ID => IGS_AV_STND_UNIT_LVL_rec.UNIT_DETAILS_ID ,

Line 1171: X_CAL_TYPE => IGS_AV_STND_UNIT_LVL_rec.CAL_TYPE ,

1167: X_CANCELLED_DT => IGS_AV_STND_UNIT_LVL_rec.CANCELLED_DT ,
1168: X_REVOKED_DT => IGS_AV_STND_UNIT_LVL_rec.REVOKED_DT ,
1169: X_COMMENTS => IGS_AV_STND_UNIT_LVL_rec.COMMENTS ,
1170: X_AV_STND_UNIT_LVL_ID => IGS_AV_STND_UNIT_LVL_rec.AV_STND_UNIT_LVL_ID ,
1171: X_CAL_TYPE => IGS_AV_STND_UNIT_LVL_rec.CAL_TYPE ,
1172: X_CI_SEQUENCE_NUMBER => IGS_AV_STND_UNIT_LVL_rec.CI_SEQUENCE_NUMBER ,
1173: X_INSTITUTION_CD => IGS_AV_STND_UNIT_LVL_rec.INSTITUTION_CD ,
1174: X_UNIT_DETAILS_ID => IGS_AV_STND_UNIT_LVL_rec.UNIT_DETAILS_ID ,
1175: X_TST_RSLT_DTLS_ID => IGS_AV_STND_UNIT_LVL_rec.TST_RSLT_DTLS_ID ,

Line 1172: X_CI_SEQUENCE_NUMBER => IGS_AV_STND_UNIT_LVL_rec.CI_SEQUENCE_NUMBER ,

1168: X_REVOKED_DT => IGS_AV_STND_UNIT_LVL_rec.REVOKED_DT ,
1169: X_COMMENTS => IGS_AV_STND_UNIT_LVL_rec.COMMENTS ,
1170: X_AV_STND_UNIT_LVL_ID => IGS_AV_STND_UNIT_LVL_rec.AV_STND_UNIT_LVL_ID ,
1171: X_CAL_TYPE => IGS_AV_STND_UNIT_LVL_rec.CAL_TYPE ,
1172: X_CI_SEQUENCE_NUMBER => IGS_AV_STND_UNIT_LVL_rec.CI_SEQUENCE_NUMBER ,
1173: X_INSTITUTION_CD => IGS_AV_STND_UNIT_LVL_rec.INSTITUTION_CD ,
1174: X_UNIT_DETAILS_ID => IGS_AV_STND_UNIT_LVL_rec.UNIT_DETAILS_ID ,
1175: X_TST_RSLT_DTLS_ID => IGS_AV_STND_UNIT_LVL_rec.TST_RSLT_DTLS_ID ,
1176: X_MODE => 'R' ,

Line 1173: X_INSTITUTION_CD => IGS_AV_STND_UNIT_LVL_rec.INSTITUTION_CD ,

1169: X_COMMENTS => IGS_AV_STND_UNIT_LVL_rec.COMMENTS ,
1170: X_AV_STND_UNIT_LVL_ID => IGS_AV_STND_UNIT_LVL_rec.AV_STND_UNIT_LVL_ID ,
1171: X_CAL_TYPE => IGS_AV_STND_UNIT_LVL_rec.CAL_TYPE ,
1172: X_CI_SEQUENCE_NUMBER => IGS_AV_STND_UNIT_LVL_rec.CI_SEQUENCE_NUMBER ,
1173: X_INSTITUTION_CD => IGS_AV_STND_UNIT_LVL_rec.INSTITUTION_CD ,
1174: X_UNIT_DETAILS_ID => IGS_AV_STND_UNIT_LVL_rec.UNIT_DETAILS_ID ,
1175: X_TST_RSLT_DTLS_ID => IGS_AV_STND_UNIT_LVL_rec.TST_RSLT_DTLS_ID ,
1176: X_MODE => 'R' ,
1177: X_QUAL_DETS_ID => IGS_AV_STND_UNIT_LVL_rec.QUAL_DETS_ID -- Added column to tbh call w.r.t to ARCR032 (Bug# 2233334)

Line 1174: X_UNIT_DETAILS_ID => IGS_AV_STND_UNIT_LVL_rec.UNIT_DETAILS_ID ,

1170: X_AV_STND_UNIT_LVL_ID => IGS_AV_STND_UNIT_LVL_rec.AV_STND_UNIT_LVL_ID ,
1171: X_CAL_TYPE => IGS_AV_STND_UNIT_LVL_rec.CAL_TYPE ,
1172: X_CI_SEQUENCE_NUMBER => IGS_AV_STND_UNIT_LVL_rec.CI_SEQUENCE_NUMBER ,
1173: X_INSTITUTION_CD => IGS_AV_STND_UNIT_LVL_rec.INSTITUTION_CD ,
1174: X_UNIT_DETAILS_ID => IGS_AV_STND_UNIT_LVL_rec.UNIT_DETAILS_ID ,
1175: X_TST_RSLT_DTLS_ID => IGS_AV_STND_UNIT_LVL_rec.TST_RSLT_DTLS_ID ,
1176: X_MODE => 'R' ,
1177: X_QUAL_DETS_ID => IGS_AV_STND_UNIT_LVL_rec.QUAL_DETS_ID -- Added column to tbh call w.r.t to ARCR032 (Bug# 2233334)
1178: );

Line 1175: X_TST_RSLT_DTLS_ID => IGS_AV_STND_UNIT_LVL_rec.TST_RSLT_DTLS_ID ,

1171: X_CAL_TYPE => IGS_AV_STND_UNIT_LVL_rec.CAL_TYPE ,
1172: X_CI_SEQUENCE_NUMBER => IGS_AV_STND_UNIT_LVL_rec.CI_SEQUENCE_NUMBER ,
1173: X_INSTITUTION_CD => IGS_AV_STND_UNIT_LVL_rec.INSTITUTION_CD ,
1174: X_UNIT_DETAILS_ID => IGS_AV_STND_UNIT_LVL_rec.UNIT_DETAILS_ID ,
1175: X_TST_RSLT_DTLS_ID => IGS_AV_STND_UNIT_LVL_rec.TST_RSLT_DTLS_ID ,
1176: X_MODE => 'R' ,
1177: X_QUAL_DETS_ID => IGS_AV_STND_UNIT_LVL_rec.QUAL_DETS_ID -- Added column to tbh call w.r.t to ARCR032 (Bug# 2233334)
1178: );
1179: END LOOP;

Line 1177: X_QUAL_DETS_ID => IGS_AV_STND_UNIT_LVL_rec.QUAL_DETS_ID -- Added column to tbh call w.r.t to ARCR032 (Bug# 2233334)

1173: X_INSTITUTION_CD => IGS_AV_STND_UNIT_LVL_rec.INSTITUTION_CD ,
1174: X_UNIT_DETAILS_ID => IGS_AV_STND_UNIT_LVL_rec.UNIT_DETAILS_ID ,
1175: X_TST_RSLT_DTLS_ID => IGS_AV_STND_UNIT_LVL_rec.TST_RSLT_DTLS_ID ,
1176: X_MODE => 'R' ,
1177: X_QUAL_DETS_ID => IGS_AV_STND_UNIT_LVL_rec.QUAL_DETS_ID -- Added column to tbh call w.r.t to ARCR032 (Bug# 2233334)
1178: );
1179: END LOOP;
1180: END;
1181: -- *****************************************************************************************

Line 1202: END LOOP; -- process IGS_AV_STND_UNIT_LVL

1198: cst_granted_ge);
1199: END IF;
1200: <> -- simulate C continue statement
1201: NULL; -- just make the compiler happy
1202: END LOOP; -- process IGS_AV_STND_UNIT_LVL
1203: COMMIT;
1204: p_message_name := NULL;
1205: RETURN TRUE;
1206: END;

Line 1234: cp_person_id IGS_AV_STND_UNIT.person_id%TYPE,

1230: lv_param_values VARCHAR2(1080);
1231: BEGIN
1232: DECLARE
1233: CURSOR c_adv_stnd_details (
1234: cp_person_id IGS_AV_STND_UNIT.person_id%TYPE,
1235: cp_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE,
1236: cp_version_number IGS_AV_STND_UNIT.as_version_number%TYPE
1237: ) IS
1238: SELECT rowid , adv.*

Line 1235: cp_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE,

1231: BEGIN
1232: DECLARE
1233: CURSOR c_adv_stnd_details (
1234: cp_person_id IGS_AV_STND_UNIT.person_id%TYPE,
1235: cp_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE,
1236: cp_version_number IGS_AV_STND_UNIT.as_version_number%TYPE
1237: ) IS
1238: SELECT rowid , adv.*
1239: FROM IGS_AV_ADV_STANDING adv

Line 1236: cp_version_number IGS_AV_STND_UNIT.as_version_number%TYPE

1232: DECLARE
1233: CURSOR c_adv_stnd_details (
1234: cp_person_id IGS_AV_STND_UNIT.person_id%TYPE,
1235: cp_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE,
1236: cp_version_number IGS_AV_STND_UNIT.as_version_number%TYPE
1237: ) IS
1238: SELECT rowid , adv.*
1239: FROM IGS_AV_ADV_STANDING adv
1240: WHERE adv.person_id = cp_person_id AND

Line 1271: '', -- IGS_AV_STND_UNIT.unit_cd

1267: p_person_id,
1268: p_course_cd,
1269: p_version_number,
1270: TRUE,
1271: '', -- IGS_AV_STND_UNIT.unit_cd
1272: '', -- IGS_AV_STND_UNIT.version_number
1273: '', -- IGS_AV_STND_UNIT.s_adv_stnd_granting_status
1274: '', -- IGS_AV_STND_UNIT_LVL.unit_level
1275: p_exemption_institution_cd, -- IGS_AV_STND_UNIT_LVL.exemption_institution_cd

Line 1272: '', -- IGS_AV_STND_UNIT.version_number

1268: p_course_cd,
1269: p_version_number,
1270: TRUE,
1271: '', -- IGS_AV_STND_UNIT.unit_cd
1272: '', -- IGS_AV_STND_UNIT.version_number
1273: '', -- IGS_AV_STND_UNIT.s_adv_stnd_granting_status
1274: '', -- IGS_AV_STND_UNIT_LVL.unit_level
1275: p_exemption_institution_cd, -- IGS_AV_STND_UNIT_LVL.exemption_institution_cd
1276: '', -- IGS_AV_STND_UNIT_LVL.s_adv_stnd_granting_status

Line 1273: '', -- IGS_AV_STND_UNIT.s_adv_stnd_granting_status

1269: p_version_number,
1270: TRUE,
1271: '', -- IGS_AV_STND_UNIT.unit_cd
1272: '', -- IGS_AV_STND_UNIT.version_number
1273: '', -- IGS_AV_STND_UNIT.s_adv_stnd_granting_status
1274: '', -- IGS_AV_STND_UNIT_LVL.unit_level
1275: p_exemption_institution_cd, -- IGS_AV_STND_UNIT_LVL.exemption_institution_cd
1276: '', -- IGS_AV_STND_UNIT_LVL.s_adv_stnd_granting_status
1277: v_total_exmptn_approved,

Line 1274: '', -- IGS_AV_STND_UNIT_LVL.unit_level

1270: TRUE,
1271: '', -- IGS_AV_STND_UNIT.unit_cd
1272: '', -- IGS_AV_STND_UNIT.version_number
1273: '', -- IGS_AV_STND_UNIT.s_adv_stnd_granting_status
1274: '', -- IGS_AV_STND_UNIT_LVL.unit_level
1275: p_exemption_institution_cd, -- IGS_AV_STND_UNIT_LVL.exemption_institution_cd
1276: '', -- IGS_AV_STND_UNIT_LVL.s_adv_stnd_granting_status
1277: v_total_exmptn_approved,
1278: v_total_exmptn_granted,

Line 1275: p_exemption_institution_cd, -- IGS_AV_STND_UNIT_LVL.exemption_institution_cd

1271: '', -- IGS_AV_STND_UNIT.unit_cd
1272: '', -- IGS_AV_STND_UNIT.version_number
1273: '', -- IGS_AV_STND_UNIT.s_adv_stnd_granting_status
1274: '', -- IGS_AV_STND_UNIT_LVL.unit_level
1275: p_exemption_institution_cd, -- IGS_AV_STND_UNIT_LVL.exemption_institution_cd
1276: '', -- IGS_AV_STND_UNIT_LVL.s_adv_stnd_granting_status
1277: v_total_exmptn_approved,
1278: v_total_exmptn_granted,
1279: v_total_exmptn_perc_grntd,

Line 1276: '', -- IGS_AV_STND_UNIT_LVL.s_adv_stnd_granting_status

1272: '', -- IGS_AV_STND_UNIT.version_number
1273: '', -- IGS_AV_STND_UNIT.s_adv_stnd_granting_status
1274: '', -- IGS_AV_STND_UNIT_LVL.unit_level
1275: p_exemption_institution_cd, -- IGS_AV_STND_UNIT_LVL.exemption_institution_cd
1276: '', -- IGS_AV_STND_UNIT_LVL.s_adv_stnd_granting_status
1277: v_total_exmptn_approved,
1278: v_total_exmptn_granted,
1279: v_total_exmptn_perc_grntd,
1280: p_message_name,

Line 1292: -- select IGS_AV_STND_UNIT for parameters to determine

1288: -- setting the message number beforehand
1289: -- so if failure of the lock occurs, this
1290: -- value can be passed to the exception handler
1291: p_message_name := 'IGS_AV_UNABLE_UPD_TOTALS';
1292: -- select IGS_AV_STND_UNIT for parameters to determine
1293: -- existing totals
1294:
1295: FOR v_adv_stnd IN c_adv_stnd_details(p_person_id,
1296: p_course_cd,

Line 1772: FROM IGS_AV_STND_UNIT_ALL

1768: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);
1769:
1770: CURSOR c_person IS
1771: SELECT person_id
1772: FROM IGS_AV_STND_UNIT_ALL
1773: WHERE s_adv_stnd_granting_status = 'APPROVED' AND
1774: NVL(expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < SYSDATE
1775: UNION
1776: SELECT person_id

Line 1777: FROM IGS_AV_STND_UNIT_LVL_ALL

1773: WHERE s_adv_stnd_granting_status = 'APPROVED' AND
1774: NVL(expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < SYSDATE
1775: UNION
1776: SELECT person_id
1777: FROM IGS_AV_STND_UNIT_LVL_ALL
1778: WHERE s_adv_stnd_granting_status = 'APPROVED' AND
1779: NVL(expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < SYSDATE;
1780:
1781: CURSOR c_adv_stnd_unit (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS

Line 1782: SELECT rowid , IGS_AV_STND_UNIT.*

1778: WHERE s_adv_stnd_granting_status = 'APPROVED' AND
1779: NVL(expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < SYSDATE;
1780:
1781: CURSOR c_adv_stnd_unit (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
1782: SELECT rowid , IGS_AV_STND_UNIT.*
1783: FROM igs_av_stnd_unit
1784: WHERE s_adv_stnd_granting_status = 'APPROVED' AND
1785: NVL(expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < SYSDATE AND
1786: person_id = cp_person_id AND

Line 1783: FROM igs_av_stnd_unit

1779: NVL(expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < SYSDATE;
1780:
1781: CURSOR c_adv_stnd_unit (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
1782: SELECT rowid , IGS_AV_STND_UNIT.*
1783: FROM igs_av_stnd_unit
1784: WHERE s_adv_stnd_granting_status = 'APPROVED' AND
1785: NVL(expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < SYSDATE AND
1786: person_id = cp_person_id AND
1787: s_adv_stnd_recognition_type <> 'PRECLUSION' /* Added as per Bug# 2441175 */

Line 1795: SELECT rowid,IGS_AV_STND_UNIT_LVL.*

1791: as_version_number
1792: FOR UPDATE OF s_adv_stnd_granting_status NOWAIT;
1793:
1794: CURSOR c_adv_stnd_unit_level (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
1795: SELECT rowid,IGS_AV_STND_UNIT_LVL.*
1796: FROM IGS_AV_STND_UNIT_LVL
1797: WHERE s_adv_stnd_granting_status = 'APPROVED' AND
1798: NVL(expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < SYSDATE AND
1799: person_id = cp_person_id

Line 1796: FROM IGS_AV_STND_UNIT_LVL

1792: FOR UPDATE OF s_adv_stnd_granting_status NOWAIT;
1793:
1794: CURSOR c_adv_stnd_unit_level (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
1795: SELECT rowid,IGS_AV_STND_UNIT_LVL.*
1796: FROM IGS_AV_STND_UNIT_LVL
1797: WHERE s_adv_stnd_granting_status = 'APPROVED' AND
1798: NVL(expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < SYSDATE AND
1799: person_id = cp_person_id
1800: ORDER BY

Line 1814: IGS_AV_STND_UNIT_PKG.update_row(

1810: BEGIN
1811: FOR v_asu_rec IN c_adv_stnd_unit(v_person_rec.person_id) LOOP
1812:
1813: -- ******************************************************************************************
1814: IGS_AV_STND_UNIT_PKG.update_row(
1815: X_Rowid => v_asu_rec.rowid ,
1816: X_PERSON_ID => v_asu_rec.PERSON_ID ,
1817: X_AS_COURSE_CD => v_asu_rec.AS_COURSE_CD ,
1818: X_AS_VERSION_NUMBER => v_asu_rec.AS_VERSION_NUMBER ,

Line 1865: IGS_AV_STND_UNIT_LVL_PKG.update_row(

1861: BEGIN
1862: FOR v_asul_rec IN c_adv_stnd_unit_level(v_person_rec.person_id) LOOP
1863: -- ****************************************************************************************
1864:
1865: IGS_AV_STND_UNIT_LVL_PKG.update_row(
1866: X_Rowid => v_asul_rec.rowid ,
1867: X_PERSON_ID => v_asul_rec.PERSON_ID ,
1868: X_AS_COURSE_CD => v_asul_rec.AS_COURSE_CD ,
1869: X_AS_VERSION_NUMBER => v_asul_rec.AS_VERSION_NUMBER ,

Line 1927: select AV_STND_UNIT_ID from IGS_AV_STND_UNIT_ALL unt where

1923: p_person_id IN NUMBER ,
1924: p_course_cd IN VARCHAR2 ,
1925: p_version_number IN NUMBER ) IS
1926: CURSOR C_AV_UNT is
1927: select AV_STND_UNIT_ID from IGS_AV_STND_UNIT_ALL unt where
1928: person_id =p_person_id and
1929: as_course_cd = p_course_cd and
1930: as_version_number = p_version_number and
1931: not exists ( select 1 from IGS_AV_STD_UNT_BASIS_ALL basis where basis.AV_STND_UNIT_ID= unt.AV_STND_UNIT_ID) ;

Line 1934: select AV_STND_UNIT_LVL_ID from IGS_AV_STND_UNIT_LVL_ALL ulvl where

1930: as_version_number = p_version_number and
1931: not exists ( select 1 from IGS_AV_STD_UNT_BASIS_ALL basis where basis.AV_STND_UNIT_ID= unt.AV_STND_UNIT_ID) ;
1932:
1933: CURSOR C_AV_UNT_LVL is
1934: select AV_STND_UNIT_LVL_ID from IGS_AV_STND_UNIT_LVL_ALL ulvl where
1935: person_id =p_person_id and
1936: as_course_cd = p_course_cd and
1937: as_version_number = p_version_number and
1938: not exists ( select 1 from IGS_AV_STD_ULVLBASIS_ALL basis where basis.AV_STND_UNIT_LVL_ID= ulvl.AV_STND_UNIT_LVL_ID) ;

Line 2167: p_exemption_institution_cd igs_av_stnd_unit_all.exemption_institution_cd%TYPE

2163: l_app_val NUMBER;
2164: l_grnt_val NUMBER;
2165:
2166: CURSOR c_approved (
2167: p_exemption_institution_cd igs_av_stnd_unit_all.exemption_institution_cd%TYPE
2168: )
2169: IS
2170: SELECT nvl(SUM (cp) , 0)
2171: FROM (SELECT SUM (achievable_credit_points) cp

Line 2172: FROM igs_av_stnd_unit_all unt

2168: )
2169: IS
2170: SELECT nvl(SUM (cp) , 0)
2171: FROM (SELECT SUM (achievable_credit_points) cp
2172: FROM igs_av_stnd_unit_all unt
2173: WHERE unt.exemption_institution_cd = p_exemption_institution_cd
2174: AND unt.person_id = p_person_id
2175: AND p_course_cd = unt.as_course_cd
2176: AND p_version_number = unt.as_version_number

Line 2180: FROM igs_av_stnd_unit_lvl_all unt

2176: AND p_version_number = unt.as_version_number
2177: AND unt.s_adv_stnd_granting_status = 'APPROVED'
2178: UNION ALL
2179: SELECT SUM (credit_points) cp
2180: FROM igs_av_stnd_unit_lvl_all unt
2181: WHERE unt.exemption_institution_cd = p_exemption_institution_cd
2182: AND unt.person_id = p_person_id
2183: AND p_course_cd = unt.as_course_cd
2184: AND p_version_number = unt.as_version_number

Line 2188: p_exemption_institution_cd igs_av_stnd_unit_all.exemption_institution_cd%TYPE

2184: AND p_version_number = unt.as_version_number
2185: AND unt.s_adv_stnd_granting_status = 'APPROVED');
2186:
2187: CURSOR c_granted (
2188: p_exemption_institution_cd igs_av_stnd_unit_all.exemption_institution_cd%TYPE
2189: )
2190: IS
2191: SELECT nvl(SUM (cp),0)
2192: FROM (SELECT SUM (achievable_credit_points) cp

Line 2193: FROM igs_av_stnd_unit_all unt

2189: )
2190: IS
2191: SELECT nvl(SUM (cp),0)
2192: FROM (SELECT SUM (achievable_credit_points) cp
2193: FROM igs_av_stnd_unit_all unt
2194: WHERE unt.exemption_institution_cd = p_exemption_institution_cd
2195: AND unt.person_id = p_person_id
2196: AND p_course_cd = unt.as_course_cd
2197: AND p_version_number = unt.as_version_number

Line 2201: FROM igs_av_stnd_unit_lvl_all unt

2197: AND p_version_number = unt.as_version_number
2198: AND unt.s_adv_stnd_granting_status = 'GRANTED'
2199: UNION ALL
2200: SELECT SUM (credit_points) cp
2201: FROM igs_av_stnd_unit_lvl_all unt
2202: WHERE unt.exemption_institution_cd = p_exemption_institution_cd
2203: AND unt.person_id = p_person_id
2204: AND p_course_cd = unt.as_course_cd
2205: AND p_version_number = unt.as_version_number

Line 2294: FROM igs_av_stnd_unit_all a, igs_pe_hz_parties ipz

2290: usverno VARCHAR2
2291: )
2292: IS
2293: SELECT SUM (a.achievable_credit_points)
2294: FROM igs_av_stnd_unit_all a, igs_pe_hz_parties ipz
2295: WHERE a.s_adv_stnd_granting_status = 'GRANTED'
2296: AND a.s_adv_stnd_recognition_type = 'CREDIT'
2297: AND a.exemption_institution_cd(+) = ipz.oss_org_unit_cd
2298: AND (a.cal_type, a.ci_sequence_number) IN (

Line 2312: FROM igs_av_stnd_unit_lvl_all a, igs_pe_hz_parties ipz

2308:
2309: CURSOR c_credit_pts_3 (personid NUMBER, coursecd VARCHAR2)
2310: IS
2311: SELECT SUM (a.credit_points)
2312: FROM igs_av_stnd_unit_lvl_all a, igs_pe_hz_parties ipz
2313: WHERE a.s_adv_stnd_granting_status = 'GRANTED'
2314: AND a.exemption_institution_cd(+) = ipz.oss_org_unit_cd
2315: AND (personid = person_id)
2316: AND (coursecd = as_course_cd);