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_AV_GEN_001 dependencies on IGS_AV_STND_UNIT_LVL

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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);