APPS.IGS_PR_VAL_PRA dependencies on IGS_PR_RULE

Line 149: p_message_name := 'IGS_PR_RULE_CAT_CLOSED';

145: OPEN c_prgc;
146: FETCH c_prgc INTO v_dummy;
147: IF c_prgc%NOTFOUND THEN
148: CLOSE c_prgc;
149: p_message_name := 'IGS_PR_RULE_CAT_CLOSED';
150: RETURN FALSE;
151: END IF;
152: CLOSE c_prgc;
153: p_message_name := null;

Line 170: -- Validate that the IGS_PR_RULE is not closed.

166: --IGS_GE_MSG_STACK.ADD;
167:
168: END prgp_val_prgc_closed;
169: --
170: -- Validate that the IGS_PR_RULE is not closed.
171: FUNCTION prgp_val_prr_closed(
172: p_progression_rule_cd IN VARCHAR2 ,
173: p_message_name OUT NOCOPY VARCHAR2 )
174: RETURN BOOLEAN AS

Line 177: -- Validate the IGS_PR_RULE is not closed

173: p_message_name OUT NOCOPY VARCHAR2 )
174: RETURN BOOLEAN AS
175: gv_other_detail VARCHAR2(255);
176: BEGIN -- prgp_val_prr_closed
177: -- Validate the IGS_PR_RULE is not closed
178: DECLARE
179: v_dummy VARCHAR2(1);
180: CURSOR c_prr IS
181: SELECT 'X'

Line 182: FROM IGS_PR_RULE prr

178: DECLARE
179: v_dummy VARCHAR2(1);
180: CURSOR c_prr IS
181: SELECT 'X'
182: FROM IGS_PR_RULE prr
183: WHERE prr.progression_rule_cd = p_progression_rule_cd AND
184: prr.closed_ind = 'N';
185: BEGIN
186: IF p_progression_rule_cd IS NULL THEN

Line 194: p_message_name := 'IGS_PR_RULE_CLOSED';

190: OPEN c_prr;
191: FETCH c_prr INTO v_dummy;
192: IF c_prr%NOTFOUND THEN
193: CLOSE c_prr;
194: p_message_name := 'IGS_PR_RULE_CLOSED';
195: RETURN FALSE;
196: END IF;
197: CLOSE c_prr;
198: p_message_name := null;