APPS.IGS_PR_VAL_PRA dependencies on IGS_PR_RU_CAT

Line 125: -- Validate that the IGS_PR_RU_CAT is not closed.

121: --IGS_GE_MSG_STACK.ADD;
122:
123: END prgp_val_pra_rqrd;
124: --
125: -- Validate that the IGS_PR_RU_CAT is not closed.
126: FUNCTION prgp_val_prgc_closed(
127: p_progression_rule_cat IN VARCHAR2 ,
128: p_message_name OUT NOCOPY VARCHAR2 )
129: RETURN BOOLEAN AS

Line 132: -- Validate the IGS_PR_RU_CAT is not closed

128: p_message_name OUT NOCOPY VARCHAR2 )
129: RETURN BOOLEAN AS
130: gv_other_detail VARCHAR2(255);
131: BEGIN -- prgp_val_prgc_closed
132: -- Validate the IGS_PR_RU_CAT is not closed
133: DECLARE
134: v_dummy VARCHAR2(1);
135: CURSOR c_prgc IS
136: SELECT 'X'

Line 137: FROM IGS_PR_RU_CAT prgc

133: DECLARE
134: v_dummy VARCHAR2(1);
135: CURSOR c_prgc IS
136: SELECT 'X'
137: FROM IGS_PR_RU_CAT prgc
138: WHERE prgc.progression_rule_cat = p_progression_rule_cat AND
139: prgc.closed_ind = 'N';
140: BEGIN
141: IF p_progression_rule_cat IS NULL THEN