APPS.IGS_AD_VAL_AALP dependencies on IGS_CO_LTR_PHR

Line 13: v_closed_ind IGS_CO_LTR_PHR.closed_ind%TYPE DEFAULT 'N';

9: RETURN BOOLEAN IS
10: BEGIN -- corp_val_lpt_closed
11: -- Validate if letter_parameter_type is closed.
12: DECLARE
13: v_closed_ind IGS_CO_LTR_PHR.closed_ind%TYPE DEFAULT 'N';
14: CURSOR c_lpt IS
15: SELECT closed_ind
16: FROM IGS_CO_LTR_PARM_TYPE
17: WHERE letter_parameter_type = p_letter_parameter_type;

Line 78: -- Validate if IGS_CO_LTR_PHR is closed.

74: p_phrase_cd IN VARCHAR2 ,
75: p_message_name OUT NOCOPY VARCHAR2 )
76: RETURN BOOLEAN IS
77: BEGIN -- corp_val_ltp_closed
78: -- Validate if IGS_CO_LTR_PHR is closed.
79: DECLARE
80: v_closed_ind IGS_CO_LTR_PHR.closed_ind%TYPE DEFAULT 'N';
81: CURSOR c_ltp IS
82: SELECT closed_ind

Line 80: v_closed_ind IGS_CO_LTR_PHR.closed_ind%TYPE DEFAULT 'N';

76: RETURN BOOLEAN IS
77: BEGIN -- corp_val_ltp_closed
78: -- Validate if IGS_CO_LTR_PHR is closed.
79: DECLARE
80: v_closed_ind IGS_CO_LTR_PHR.closed_ind%TYPE DEFAULT 'N';
81: CURSOR c_ltp IS
82: SELECT closed_ind
83: FROM IGS_CO_LTR_PHR
84: WHERE phrase_cd = p_phrase_cd;

Line 83: FROM IGS_CO_LTR_PHR

79: DECLARE
80: v_closed_ind IGS_CO_LTR_PHR.closed_ind%TYPE DEFAULT 'N';
81: CURSOR c_ltp IS
82: SELECT closed_ind
83: FROM IGS_CO_LTR_PHR
84: WHERE phrase_cd = p_phrase_cd;
85: BEGIN
86: p_message_name := null;
87: OPEN c_ltp;