[Home] [Help]
27: cst_rstr_at_ty CONSTANT VARCHAR2(10) := 'RSTR_AT_TY';
28: v_dummy VARCHAR2(1);
29: CURSOR c_etde IS
30: SELECT 'X'
31: FROM IGS_FI_ENC_DFLT_EFT etde
32: WHERE etde.encumbrance_type = p_encumbrance_type AND
33: etde.s_encmb_effect_type = cst_rstr_at_ty;
34: BEGIN
35: -- Set the default message number
82: cst_rstr_le_cp CONSTANT VARCHAR2(10) := 'RSTR_LE_CP';
83: v_dummy VARCHAR2(1);
84: CURSOR c_etde IS
85: SELECT 'X'
86: FROM IGS_FI_ENC_DFLT_EFT etde
87: WHERE etde.encumbrance_type = p_encumbrance_type AND
88: etde.s_encmb_effect_type IN (
89: cst_rstr_ge_cp,
90: cst_rstr_le_cp);
180: FROM IGS_FI_ENCMB_TYPE et
181: WHERE et.encumbrance_type = p_encumbrance_type;
182: CURSOR c_edte IS
183: SELECT edte.s_encmb_effect_type
184: FROM IGS_FI_ENC_DFLT_EFT edte
185: WHERE edte.encumbrance_type = p_encumbrance_type;
186: BEGIN
187: -- Set the default message number
188: p_message_name := null;