APPS.IGS_PS_VAL_UV dependencies on IGS_PS_UNIT_LEVEL

Line 32: -- Validate the IGS_PS_UNIT level

28: -- additional parameter value 'FALSE'. for Bug # 2696207
29: --bdeviset 21-JUL-2004 Added a new procedure GET_CP_VALUES for Bug # 3782329
30: -------------------------------------------------------------------------------------------*/
31: --
32: -- Validate the IGS_PS_UNIT level
33: FUNCTION crsp_val_unit_lvl(
34: p_unit_level IN CHAR ,
35: p_message_name OUT NOCOPY VARCHAR2 )
36: RETURN BOOLEAN AS

Line 37: v_closed_ind IGS_PS_UNIT_LEVEL.closed_ind%TYPE;

33: FUNCTION crsp_val_unit_lvl(
34: p_unit_level IN CHAR ,
35: p_message_name OUT NOCOPY VARCHAR2 )
36: RETURN BOOLEAN AS
37: v_closed_ind IGS_PS_UNIT_LEVEL.closed_ind%TYPE;
38: CURSOR c_unit_lvl_closed_ind IS
39: SELECT closed_ind
40: FROM IGS_PS_UNIT_LEVEL
41: WHERE unit_level = p_unit_level AND

Line 40: FROM IGS_PS_UNIT_LEVEL

36: RETURN BOOLEAN AS
37: v_closed_ind IGS_PS_UNIT_LEVEL.closed_ind%TYPE;
38: CURSOR c_unit_lvl_closed_ind IS
39: SELECT closed_ind
40: FROM IGS_PS_UNIT_LEVEL
41: WHERE unit_level = p_unit_level AND
42: closed_ind = 'Y';
43: BEGIN
44: OPEN c_unit_lvl_closed_ind;

Line 495: -- for IGS_PS_UNIT_VER records (e.g IGS_PS_UNIT_LEVEL is not closed) and also

491: RETURN BOOLEAN AS
492: BEGIN -- crsp_val_uv_quality
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,

Line 587: -- Validate that the IGS_PS_UNIT_LEVEL is not closed

583: p_message_name := 'IGS_GE_VAL_DOES_NOT_XS';
584: RETURN FALSE;
585: END IF;
586: CLOSE c_unit_version;
587: -- Validate that the IGS_PS_UNIT_LEVEL is not closed
588: IF (IGS_PS_VAL_UV.crsp_val_unit_lvl(
589: v_uv_rec.unit_level,
590: p_message_name) = FALSE) THEN
591: RETURN FALSE;