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_VAL_ASU 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: -- nalkumar 11-Sep-2001 Added Parameter 'p_adv_stnd_trans' in advp_val_as_dates, advp_val_expiry_dt
14: -- advp_val_status_dts functions.
15: -- These changes has been done as per the Career Impact DLD.
16: -- Bug# 2027984.
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: --
20: --nalkumar 09-Sept-2002 Removed the references to the 'igs_av_stnd_conf_all.adv_stnd_cutoff_dt_alias' coulmn.
21: -- This column has been obsoleted as part of the Bug# 2446569.

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: -- advp_val_status_dts functions.
15: -- These changes has been done as per the Career Impact DLD.
16: -- Bug# 2027984.
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: --
20: --nalkumar 09-Sept-2002 Removed the references to the 'igs_av_stnd_conf_all.adv_stnd_cutoff_dt_alias' coulmn.
21: -- This column has been obsoleted as part of the Bug# 2446569.
22: -- Modified the 'advp_get_ua_del_alwd' function and removed the validations related to the obsoleted column.

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

25: --svenkata 27-Nov-02 The routine 'adv_Credit_pts' has been modified to check the value of the fetched parameter l_adv_credits.s_adv_stnd_granting_status
26: -- instead of the IN parameter , which is incorrect.
27: -- kdande 08-Oct-03 Bug# 3154803; Changed the select to handle NULL values
28: --
29: -- nalkumar 10-Dec-2003 Bug# 3270446 RECR50 Build; Obsoleted the IGS_AV_STND_UNIT.CREDIT_PERCENTAGE column.
30: -- lkaki 05-Apr-2005 Bug# 4135171 The check for looking whether the computed value of 'v_total_exmptn_perc_grntd' is
31: -- changed to include values beyond 999.
32: -- swaghmar 25-Nov-2005 Bug# 4754378 Modified the cursor C_ADV_CP_PER
33: -- shimitta 07-Mar-2006 BUg# 5068233

Line 59: -- Validate that exemption_institution_cd (IGS_AV_STND_UNIT or IGS_AV_STND_UNIT_LVL

55: WHERE lk.lookup_type = 'OR_INSTITUTION_ADVSTEX'
56: AND lk.enabled_flag = 'Y'
57: AND lk.lookup_code = cp_exempt_inst;
58: BEGIN
59: -- Validate that exemption_institution_cd (IGS_AV_STND_UNIT or IGS_AV_STND_UNIT_LVL
60: -- ) is valid.
61: -- The status is not considered, as it is allowable to select an inactive
62: -- IGS_OR_INSTITUTION for advanced standing basis details.
63:

Line 118: -- This checks the IGS_AV_STND_UNIT.adv_stnd_granting

114: -- IGS_PS_UNIT can be granted.
115: -- IGS_GE_NOTE : this does not include IGS_PE_PERSON encumbrance
116: -- checks and IGS_PS_COURSE version advanced standing limit
117: -- checks.
118: -- This checks the IGS_AV_STND_UNIT.adv_stnd_granting
119: -- status maps to APPROVED, the IGS_EN_STDNT_PS_ATT
120: -- exists and has an attempt status of enrolled, inactive or
121: -- intermit and the IGS_EN_STDNT_PS_ATT version matches
122: -- the advanced standing approved.

Line 347: -- Validate that approved_dt(adv-stnd_unit OR IGS_AV_STND_UNIT_LVL) is not

343: )
344: RETURN BOOLEAN IS
345: gv_other_detail VARCHAR2 (255);
346: BEGIN -- advp_val_as_aprvd_dt
347: -- Validate that approved_dt(adv-stnd_unit OR IGS_AV_STND_UNIT_LVL) is not
348: -- less than the granted_dt, cancelled_dt OR revoked_dt for the same record
349: DECLARE
350: v_ret_val BOOLEAN := TRUE;
351: BEGIN

Line 386: BEGIN -- Validate that IGS_AV_STND_UNIT.approved_dt is less

382: p_message_name OUT NOCOPY VARCHAR2
383: )
384: RETURN BOOLEAN IS
385: gv_other_detail VARCHAR2 (255);
386: BEGIN -- Validate that IGS_AV_STND_UNIT.approved_dt is less
387: -- than or equal to IGS_AV_STND_UNIT.expiry_dt
388: DECLARE
389: BEGIN
390: p_message_name := NULL;

Line 387: -- than or equal to IGS_AV_STND_UNIT.expiry_dt

383: )
384: RETURN BOOLEAN IS
385: gv_other_detail VARCHAR2 (255);
386: BEGIN -- Validate that IGS_AV_STND_UNIT.approved_dt is less
387: -- than or equal to IGS_AV_STND_UNIT.expiry_dt
388: DECLARE
389: BEGIN
390: p_message_name := NULL;
391:

Line 424: BEGIN -- Validate that IGS_AV_STND_UNIT.expiry_dt

420: p_adv_stnd_trans IN VARCHAR2
421: ) -- This parameter has been added for Career Impact DLD.
422: RETURN BOOLEAN IS
423: gv_other_detail VARCHAR2 (255);
424: BEGIN -- Validate that IGS_AV_STND_UNIT.expiry_dt
425: -- is greater than the current date
426: DECLARE
427: BEGIN
428: p_message_name := NULL;

Line 544: cp_person_id igs_av_stnd_unit.person_id%TYPE,

540: FROM igs_or_institution ins
541: WHERE ins.institution_cd = cp_ins_cd;
542:
543: CURSOR c_adv_stnd_unit_details (
544: cp_person_id igs_av_stnd_unit.person_id%TYPE,
545: cp_course_cd igs_av_stnd_unit.as_course_cd%TYPE,
546: cp_version_number igs_av_stnd_unit.as_version_number%TYPE
547: ) IS
548: SELECT /* asu.credit_percentage, */

Line 545: cp_course_cd igs_av_stnd_unit.as_course_cd%TYPE,

541: WHERE ins.institution_cd = cp_ins_cd;
542:
543: CURSOR c_adv_stnd_unit_details (
544: cp_person_id igs_av_stnd_unit.person_id%TYPE,
545: cp_course_cd igs_av_stnd_unit.as_course_cd%TYPE,
546: cp_version_number igs_av_stnd_unit.as_version_number%TYPE
547: ) IS
548: SELECT /* asu.credit_percentage, */
549: asu.exemption_institution_cd,

Line 546: cp_version_number igs_av_stnd_unit.as_version_number%TYPE

542:
543: CURSOR c_adv_stnd_unit_details (
544: cp_person_id igs_av_stnd_unit.person_id%TYPE,
545: cp_course_cd igs_av_stnd_unit.as_course_cd%TYPE,
546: cp_version_number igs_av_stnd_unit.as_version_number%TYPE
547: ) IS
548: SELECT /* asu.credit_percentage, */
549: asu.exemption_institution_cd,
550: asu.s_adv_stnd_granting_status,

Line 557: FROM igs_av_stnd_unit asu

553: -- asu.prev_unit_cd,
554: asu.unit_details_id,
555: -- asu.test_segment_id
556: asu.tst_rslt_dtls_id
557: FROM igs_av_stnd_unit asu
558: WHERE asu.person_id = cp_person_id
559: AND asu.as_course_cd = cp_course_cd
560: AND asu.as_version_number = cp_version_number
561: AND asu.s_adv_stnd_granting_status IN (cst_approved, cst_granted)

Line 566: cp_person_id igs_av_stnd_unit_lvl.person_id%TYPE,

562: AND asu.s_adv_stnd_recognition_type = cst_credit;
563:
564:
565: CURSOR c_adv_stnd_unit_level (
566: cp_person_id igs_av_stnd_unit_lvl.person_id%TYPE,
567: cp_course_cd igs_av_stnd_unit_lvl.as_course_cd%TYPE,
568: cp_version_num igs_av_stnd_unit_lvl.as_version_number%TYPE
569: ) IS
570: SELECT NVL (asul.credit_points, 0) credit_points,

Line 567: cp_course_cd igs_av_stnd_unit_lvl.as_course_cd%TYPE,

563:
564:
565: CURSOR c_adv_stnd_unit_level (
566: cp_person_id igs_av_stnd_unit_lvl.person_id%TYPE,
567: cp_course_cd igs_av_stnd_unit_lvl.as_course_cd%TYPE,
568: cp_version_num igs_av_stnd_unit_lvl.as_version_number%TYPE
569: ) IS
570: SELECT NVL (asul.credit_points, 0) credit_points,
571: asul.exemption_institution_cd,

Line 568: cp_version_num igs_av_stnd_unit_lvl.as_version_number%TYPE

564:
565: CURSOR c_adv_stnd_unit_level (
566: cp_person_id igs_av_stnd_unit_lvl.person_id%TYPE,
567: cp_course_cd igs_av_stnd_unit_lvl.as_course_cd%TYPE,
568: cp_version_num igs_av_stnd_unit_lvl.as_version_number%TYPE
569: ) IS
570: SELECT NVL (asul.credit_points, 0) credit_points,
571: asul.exemption_institution_cd,
572: asul.unit_level,

Line 574: FROM igs_av_stnd_unit_lvl asul

570: SELECT NVL (asul.credit_points, 0) credit_points,
571: asul.exemption_institution_cd,
572: asul.unit_level,
573: asul.s_adv_stnd_granting_status
574: FROM igs_av_stnd_unit_lvl asul
575: WHERE asul.person_id = cp_person_id
576: AND asul.as_course_cd = cp_course_cd
577: AND asul.as_version_number = cp_version_num
578: AND asul.s_adv_stnd_granting_status IN (cst_approved, cst_granted);

Line 581: v_adv_stnd_granting_status igs_av_stnd_unit.s_adv_stnd_granting_status%TYPE;

577: AND asul.as_version_number = cp_version_num
578: AND asul.s_adv_stnd_granting_status IN (cst_approved, cst_granted);
579:
580: v_other_detail VARCHAR2 (255);
581: v_adv_stnd_granting_status igs_av_stnd_unit.s_adv_stnd_granting_status%TYPE;
582: v_ext_adv_stnd_limit igs_ps_ver.external_adv_stnd_limit%TYPE;
583: v_int_adv_stnd_limit igs_ps_ver.internal_adv_stnd_limit%TYPE;
584: v_credit_points_reqd igs_ps_ver.credit_points_required%TYPE;
585: v_local_inst_ind igs_or_institution.institution_cd%TYPE;

Line 784: -- select IGS_AV_STND_UNIT_LVL for parameters

780: END LOOP;
781:
782:
783: --CLOSE v_av_cp_cur;
784: -- select IGS_AV_STND_UNIT_LVL for parameters
785: -- to add to existing totals
786:
787: FOR v_unit_level IN c_adv_stnd_unit_level (
788: p_person_id,

Line 1049: -- This checks the IGS_AV_STND_UNIT.adv_stnd_granting

1045: -- IGS_PS_UNIT can be granted.
1046: -- IGS_GE_NOTE : this does not include IGS_PE_PERSON encumbrance
1047: -- checks and IGS_PS_COURSE version advanced standing limit
1048: -- checks.
1049: -- This checks the IGS_AV_STND_UNIT.adv_stnd_granting
1050: -- status maps to APPROVED, the IGS_EN_STDNT_PS_ATT
1051: -- exists and has an attempt status of enrolled and
1052: -- the IGS_EN_STDNT_PS_ATT version matches the
1053: -- advanced standing approved.

Line 1143: FROM igs_av_stnd_unit asu,

1139: SELECT asu.achievable_credit_points advance_standing_cp,
1140: asu.exemption_institution_cd,
1141: /* asu.credit_percentage, */
1142: NVL (puv.achievable_credit_points, puv.enrolled_credit_points) enrolled_cp
1143: FROM igs_av_stnd_unit asu,
1144: igs_ps_unit_ver puv
1145: WHERE asu.person_id = p_person_id
1146: AND asu.as_course_cd = p_course_cd
1147: AND asu.as_version_number = p_version_number

Line 1163: FROM igs_av_stnd_unit asu,

1159: SELECT asu.achievable_credit_points advance_standing_cp,
1160: asu.exemption_institution_cd,
1161: /* asu.credit_percentage, */
1162: NVL (puv.achievable_credit_points, puv.enrolled_credit_points) enrolled_cp
1163: FROM igs_av_stnd_unit asu,
1164: igs_ps_unit_ver puv
1165: WHERE asu.person_id = p_person_id
1166: AND asu.as_course_cd = p_course_cd
1167: AND asu.as_version_number = p_version_number

Line 1184: -- selects achievable credit points from igs_av_stnd_unit table.If credit percentage

1180: BEGIN
1181: IF p_unit_details_id IS NOT NULL THEN
1182: -- if previous unit cd is not null then : 1. Checks whether credit points or credit
1183: -- percentage is null.If credit points is not null then
1184: -- selects achievable credit points from igs_av_stnd_unit table.If credit percentage
1185: -- equals 100 then selects achievable credit points from igs_ps_unit_ver table.
1186:
1187: OPEN c_adv_pre_unit;
1188: FETCH c_adv_pre_unit INTO l_adv_preunit;

Line 1205: -- selects achievable credit points from igs_av_stnd_unit table.If credit percentage

1201: CLOSE c_adv_pre_unit;
1202: ELSIF p_tst_rslt_dtls_id IS NOT NULL THEN
1203: -- if test segment is not null then : 1. Checks whether credit points or credit
1204: -- percentage is null.If credit points is not null then
1205: -- selects achievable credit points from igs_av_stnd_unit table.If credit percentage
1206: -- equals 100 then selects achievable credit points from igs_ps_unit_ver table.
1207:
1208: OPEN c_adv_test;
1209: FETCH c_adv_test INTO l_adv_test;

Line 1254: FROM igs_av_stnd_unit asu

1250: ) advance_standing_credits,
1251: asu.unit_cd,
1252: asu.version_number,
1253: s_adv_stnd_granting_status
1254: FROM igs_av_stnd_unit asu
1255: WHERE asu.person_id = p_person_id
1256: AND asu.as_course_cd = p_asu_course_cd
1257: AND asu.as_version_number = p_asu_version_number
1258: AND asu.unit_cd = p_unit_cd

Line 1270: FROM igs_av_stnd_unit asu

1266: );
1267:
1268: CURSOR c_adv_cp_per IS
1269: SELECT s_adv_stnd_granting_status
1270: FROM igs_av_stnd_unit asu
1271: WHERE asu.person_id = p_person_id
1272: AND asu.as_course_cd = p_asu_course_cd
1273: AND as_version_number = p_asu_version_number
1274: AND asu.unit_cd = p_unit_cd

Line 1380: FROM igs_av_stnd_unit asu

1376: ) advance_standing_credits,
1377: asu.unit_cd,
1378: asu.version_number,
1379: s_adv_stnd_granting_status
1380: FROM igs_av_stnd_unit asu
1381: WHERE asu.person_id = p_person_id
1382: AND asu.as_course_cd = p_asu_course_cd
1383: AND asu.as_version_number = p_asu_version_number
1384: AND asu.unit_cd = p_unit_cd

Line 1396: FROM igs_av_stnd_unit asu

1392: );
1393:
1394: CURSOR c_adv_cp_per IS
1395: SELECT s_adv_stnd_granting_status
1396: FROM igs_av_stnd_unit asu
1397: WHERE asu.person_id = p_person_id
1398: AND asu.as_course_cd = p_asu_course_cd
1399: AND as_version_number = p_asu_version_number
1400: AND asu.unit_cd = p_unit_cd