APPS.IGS_PR_VAL_PRGC dependencies on IGS_PR_RULE

Line 60: -- there are no IGS_PR_RULE or IGS_PR_RU_APPL records linked to

56: RETURN BOOLEAN AS
57: gv_other_detail VARCHAR2(255);
58: BEGIN -- prgp_val_prgc_upd
59: -- Validate the IGS_PR_RU_CAT.s_rule_call_cd can only be updated if
60: -- there are no IGS_PR_RULE or IGS_PR_RU_APPL records linked to
61: -- this IGS_PR_RU_CAT.
62: DECLARE
63: v_dummy VARCHAR2(1);
64: CURSOR c_prr IS

Line 66: FROM IGS_PR_RULE prr

62: DECLARE
63: v_dummy VARCHAR2(1);
64: CURSOR c_prr IS
65: SELECT 'X'
66: FROM IGS_PR_RULE prr
67: WHERE prr.progression_rule_cat = p_progression_rule_cat;
68: CURSOR c_pra IS
69: SELECT 'X'
70: FROM IGS_PR_RU_APPL pra

Line 84: -- Check for any IGS_PR_RULE records using this IGS_PR_RU_CAT

80: END IF;
81: -- If the s_rule_call_cd has been changed
82: IF p_old_s_rule_call_cd <>
83: p_new_s_rule_call_cd THEN
84: -- Check for any IGS_PR_RULE records using this IGS_PR_RU_CAT
85: OPEN c_prr;
86: FETCH c_prr INTO v_dummy;
87: IF c_prr%FOUND THEN
88: CLOSE c_prr;