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_PS_VAL_UV dependencies on IGS_PS_UNIT_OFR

Line 503: -- IGS_PS_UNIT_OFR,

499: -- IGS_PS_UNIT_LVL,
500: -- IGS_PS_UNIT_REF_CD.
501: -- If IGS_PS_UNIT version is altered from a system status of planned to
502: -- active then check:
503: -- IGS_PS_UNIT_OFR,
504: -- IGS_PS_UNIT_OFR_PAT,
505: -- IGS_PS_UNIT_OFR_OPT.
506: -- * Validate that where tables contains fields that hold percentages, that
507: -- the records total 100% for the given IGS_PS_UNIT version. The relevant tables

Line 504: -- IGS_PS_UNIT_OFR_PAT,

500: -- IGS_PS_UNIT_REF_CD.
501: -- If IGS_PS_UNIT version is altered from a system status of planned to
502: -- active then check:
503: -- IGS_PS_UNIT_OFR,
504: -- IGS_PS_UNIT_OFR_PAT,
505: -- IGS_PS_UNIT_OFR_OPT.
506: -- * Validate that where tables contains fields that hold percentages, that
507: -- the records total 100% for the given IGS_PS_UNIT version. The relevant tables
508: -- are:

Line 505: -- IGS_PS_UNIT_OFR_OPT.

501: -- If IGS_PS_UNIT version is altered from a system status of planned to
502: -- active then check:
503: -- IGS_PS_UNIT_OFR,
504: -- IGS_PS_UNIT_OFR_PAT,
505: -- IGS_PS_UNIT_OFR_OPT.
506: -- * Validate that where tables contains fields that hold percentages, that
507: -- the records total 100% for the given IGS_PS_UNIT version. The relevant tables
508: -- are:
509: -- IGS_PS_TCH_RESP,

Line 552: FROM IGS_PS_UNIT_OFR

548: FROM IGS_PS_UNIT_STAT
549: WHERE unit_status = p_old_unit_status;
550: CURSOR c_unit_offering IS
551: SELECT cal_type
552: FROM IGS_PS_UNIT_OFR
553: WHERE unit_cd = p_unit_cd AND
554: version_number = p_version_number;
555: CURSOR c_unit_offering_pattern IS
556: SELECT cal_type,

Line 558: FROM IGS_PS_UNIT_OFR_PAT

554: version_number = p_version_number;
555: CURSOR c_unit_offering_pattern IS
556: SELECT cal_type,
557: ci_sequence_number
558: FROM IGS_PS_UNIT_OFR_PAT
559: WHERE unit_cd = p_unit_cd AND
560: version_number = p_version_number
561: AND delete_flag = 'N';
562: CURSOR c_unit_offering_option IS

Line 566: FROM IGS_PS_UNIT_OFR_OPT

562: CURSOR c_unit_offering_option IS
563: SELECT location_cd,
564: unit_class,
565: unit_contact
566: FROM IGS_PS_UNIT_OFR_OPT
567: WHERE unit_cd = p_unit_cd AND
568: version_number = p_version_number;
569: CURSOR c_teach_res_ovrd IS
570: SELECT cal_type,

Line 574: FROM IGS_PS_UNIT_OFR_OPT

570: SELECT cal_type,
571: ci_sequence_number,
572: location_cd,
573: unit_class
574: FROM IGS_PS_UNIT_OFR_OPT
575: WHERE unit_cd = p_unit_cd AND
576: version_number = p_version_number;
577: BEGIN
578: p_message_name := NULL;

Line 702: -- Validate if IGS_PS_UNIT_OFR records exist, then the IGS_CA_TYPE is not closed

698: RETURN FALSE;
699: END IF;
700: CLOSE c_get_s_unit_status;
701: IF (v_s_unit_status = 'PLANNED') THEN
702: -- Validate if IGS_PS_UNIT_OFR records exist, then the IGS_CA_TYPE is not closed
703: FOR uo_rec IN c_unit_offering LOOP
704: -- As part of the bug# 1956374 changed to the below call from IGS_PS_VAL_UO.crsp_val_uo_cal_type
705: IF (IGS_AS_VAL_UAI.crsp_val_uo_cal_type(
706: uo_rec.cal_type,

Line 729: -- Validate that if IGS_PS_UNIT_OFR_OPT records exist, then

725: END LOOP;
726: IF (v_terminate = TRUE) THEN
727: RETURN FALSE;
728: END IF;
729: -- Validate that if IGS_PS_UNIT_OFR_OPT records exist, then
730: -- check that location_cd and IGS_AS_UNIT_CLASS is not closed.
731: FOR uoo_rec IN c_unit_offering_option LOOP
732: IF (IGS_PS_VAL_UOo.crsp_val_loc_cd(
733: uoo_rec.location_cd,

Line 1224: p_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.uoo_id%TYPE,

1220: END crsp_val_uv_ttl_ovrd;
1221:
1222:
1223: PROCEDURE get_cp_values(
1224: p_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.uoo_id%TYPE,
1225: p_enrolled_cp OUT NOCOPY IGS_PS_USEC_CPS.enrolled_credit_points%TYPE,
1226: p_billable_cp OUT NOCOPY IGS_PS_USEC_CPS.billing_hrs%TYPE,
1227: p_audit_cp OUT NOCOPY IGS_PS_USEC_CPS.billing_credit_points%TYPE) AS
1228: /***********************************************************************************************

Line 1245: CURSOR c_uv(cp_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.uoo_id%TYPE) IS

1241: l_uoo_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
1242: l_uoo_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
1243:
1244: -- fetches Enrolled, Audit and Billable credit point values from unit version table for given uoo_id
1245: CURSOR c_uv(cp_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.uoo_id%TYPE) IS
1246: SELECT
1247: uv.enrolled_credit_points,
1248: uv.billing_hrs,
1249: uv.billing_credit_points

Line 1252: IGS_PS_UNIT_OFR_OPT uoo

1248: uv.billing_hrs,
1249: uv.billing_credit_points
1250: FROM
1251: IGS_PS_UNIT_VER uv,
1252: IGS_PS_UNIT_OFR_OPT uoo
1253: WHERE
1254: uoo.uoo_id = cp_uoo_id AND
1255: uoo.unit_cd = uv.unit_cd AND
1256: uoo.version_number = uv.version_number;

Line 1259: CURSOR c_uoo(cp_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.uoo_id%TYPE) IS

1255: uoo.unit_cd = uv.unit_cd AND
1256: uoo.version_number = uv.version_number;
1257:
1258: -- fetches Enrolled, Audit and Billable credit point values from unit section table for given uoo_id
1259: CURSOR c_uoo(cp_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.uoo_id%TYPE) IS
1260: SELECT
1261: us.enrolled_credit_points,
1262: us.billing_hrs,
1263: us.billing_credit_points