APPS.IGS_PS_VAL_UV dependencies on IGS_PS_UNIT_DSCP

Line 497: -- IGS_PS_UNIT_DSCP,

493: -- Perform a quality validation check on insert.
494: -- * Validate that all reference data is open and available for use
495: -- for IGS_PS_UNIT_VER records (e.g IGS_PS_UNIT_LEVEL is not closed) and also
496: -- for existing IGS_PS_UNIT_VER detail records such as:
497: -- IGS_PS_UNIT_DSCP,
498: -- IGS_PS_UNIT_CATEGORY,
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

Line 511: -- IGS_PS_UNIT_DSCP.

507: -- the records total 100% for the given IGS_PS_UNIT version. The relevant tables
508: -- are:
509: -- IGS_PS_TCH_RESP,
510: -- IGS_PS_TCH_RESP_OVRD,
511: -- IGS_PS_UNIT_DSCP.
512: -- * Validate that all referenced organisational units are active.
513: DECLARE
514: v_terminate BOOLEAN := FALSE;
515: v_uv_rec IGS_PS_UNIT_VER%ROWTYPE;

Line 526: FROM IGS_PS_UNIT_DSCP

522: WHERE unit_cd = p_unit_cd AND
523: version_number = p_version_number;
524: CURSOR c_unit_discipline IS
525: SELECT discipline_group_cd
526: FROM IGS_PS_UNIT_DSCP
527: WHERE unit_cd = p_unit_cd AND
528: version_number = p_version_number;
529: CURSOR c_course_unit_level IS
530: SELECT course_cd, course_version_number

Line 633: -- Validate the IGS_PS_UNIT_DSCP record percentage total 100%

629: IF v_ret = FALSE THEN
630: p_message_name := 'IGS_PS_PRCALLOC_TEACHRESP_100';
631: RETURN FALSE;
632: END IF;
633: -- Validate the IGS_PS_UNIT_DSCP record percentage total 100%
634: IF (IGS_PS_VAL_UD.crsp_val_ud_perc(
635: p_unit_cd,
636: p_version_number,
637: p_message_name,FALSE) = FALSE) THEN

Line 640: -- Validate the IGS_PS_UNIT_DSCP table and that the disclipline_group_cd

636: p_version_number,
637: p_message_name,FALSE) = FALSE) THEN
638: RETURN FALSE;
639: END IF;
640: -- Validate the IGS_PS_UNIT_DSCP table and that the disclipline_group_cd
641: -- is not closed.
642: FOR ud_rec IN c_unit_discipline LOOP
643: IF (IGS_PS_VAL_UD.crsp_val_ud_dg_cd(
644: ud_rec.discipline_group_cd,