APPS.IGS_PS_VAL_UV dependencies on IGS_PS_UNIT_CATEGORY

Line 498: -- IGS_PS_UNIT_CATEGORY,

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
502: -- active then check:

Line 536: FROM IGS_PS_UNIT_CATEGORY

532: WHERE unit_cd = p_unit_cd AND
533: version_number = p_version_number;
534: CURSOR c_unit_categorisation IS
535: SELECT unit_cat
536: FROM IGS_PS_UNIT_CATEGORY
537: WHERE unit_cd = p_unit_cd AND
538: version_number = p_version_number;
539:
540: -- ijeddy 03-nov-2003 Bug# 3181938; Modified this object as per Summary Measurement Of Attainment FD.

Line 666: -- Validate the IGS_PS_UNIT_CATEGORY table and that IGS_PS_UNIT_CAT is not closed

662: END LOOP;
663: IF (v_terminate = TRUE) THEN
664: RETURN FALSE;
665: END IF;
666: -- Validate the IGS_PS_UNIT_CATEGORY table and that IGS_PS_UNIT_CAT is not closed
667: FOR uc_rec IN c_unit_categorisation LOOP
668: IF (IGS_PS_VAL_UC.crsp_val_uc_unit_cat(
669: uc_rec.unit_cat,
670: p_message_name) = FALSE) THEN