8: RETURN BOOLEAN AS
9: BEGIN
10: DECLARE
11:
12: v_closed_ind IGS_FI_ENCMB_TYPE.closed_ind%TYPE;
13: CURSOR c_encum_type_ind IS
14: SELECT closed_ind
15: FROM IGS_FI_ENCMB_TYPE
16: WHERE encumbrance_type = p_encumbrance_type;
11:
12: v_closed_ind IGS_FI_ENCMB_TYPE.closed_ind%TYPE;
13: CURSOR c_encum_type_ind IS
14: SELECT closed_ind
15: FROM IGS_FI_ENCMB_TYPE
16: WHERE encumbrance_type = p_encumbrance_type;
17: BEGIN
18: -- This module checks if the IGS_FI_ENCMB_TYPE
19: -- is closed
14: SELECT closed_ind
15: FROM IGS_FI_ENCMB_TYPE
16: WHERE encumbrance_type = p_encumbrance_type;
17: BEGIN
18: -- This module checks if the IGS_FI_ENCMB_TYPE
19: -- is closed
20: p_message_name := null;
21: OPEN c_encum_type_ind;
22: FETCH c_encum_type_ind INTO v_closed_ind;
53: SELECT closed_ind
54: FROM IGS_EN_ENCMB_EFCTTYP_V
55: WHERE s_encmb_effect_type = p_s_encmb_effect_type;
56: BEGIN
57: -- This module checks if the IGS_FI_ENCMB_TYPE
58: -- is closed
59: p_message_name := null;
60: OPEN c_s_encmb_type_ind;
61: FETCH c_s_encmb_type_ind INTO v_closed_ind;