APPS.IGS_CO_VAL_LPT dependencies on IGS_CO_S_LTR_PARAM

Line 12: -- IGS_CO_S_LTR_PARAM = 'LETTERTEXT'. IGS_CO_LTR_PARAM_TYPE.letter_text

8: RETURN BOOLEAN AS
9:
10: BEGIN -- corp_val_lpt_ltr_txt
11: -- Validate IGS_CO_LTR_PARAM_TYPE.letter_text can not be null if
12: -- IGS_CO_S_LTR_PARAM = 'LETTERTEXT'. IGS_CO_LTR_PARAM_TYPE.letter_text
13: -- is mandatory if the IGS_CO_S_LTR_PARAM = 'LETTERTEXT'.
14: DECLARE
15: BEGIN
16: p_message_name :=Null;

Line 13: -- is mandatory if the IGS_CO_S_LTR_PARAM = 'LETTERTEXT'.

9:
10: BEGIN -- corp_val_lpt_ltr_txt
11: -- Validate IGS_CO_LTR_PARAM_TYPE.letter_text can not be null if
12: -- IGS_CO_S_LTR_PARAM = 'LETTERTEXT'. IGS_CO_LTR_PARAM_TYPE.letter_text
13: -- is mandatory if the IGS_CO_S_LTR_PARAM = 'LETTERTEXT'.
14: DECLARE
15: BEGIN
16: p_message_name :=Null;
17: IF (p_s_letter_parameter_type = 'LETTERTEXT') THEN

Line 40: -- Validate if IGS_CO_S_LTR_PARAM is closed.

36: p_message_name OUT NOCOPY VARCHAR2 )
37: RETURN BOOLEAN AS
38:
39: BEGIN -- corp_val_slpt_closed
40: -- Validate if IGS_CO_S_LTR_PARAM is closed.
41: DECLARE
42: v_closed_ind IGS_CO_S_LTR_PARAM.closed_ind%TYPE DEFAULT NULL;
43: CURSOR c_slpt IS
44: SELECT closed_ind

Line 42: v_closed_ind IGS_CO_S_LTR_PARAM.closed_ind%TYPE DEFAULT NULL;

38:
39: BEGIN -- corp_val_slpt_closed
40: -- Validate if IGS_CO_S_LTR_PARAM is closed.
41: DECLARE
42: v_closed_ind IGS_CO_S_LTR_PARAM.closed_ind%TYPE DEFAULT NULL;
43: CURSOR c_slpt IS
44: SELECT closed_ind
45: FROM IGS_CO_S_LTR_PARAM
46: WHERE s_letter_parameter_type = p_s_letter_parameter_type;

Line 45: FROM IGS_CO_S_LTR_PARAM

41: DECLARE
42: v_closed_ind IGS_CO_S_LTR_PARAM.closed_ind%TYPE DEFAULT NULL;
43: CURSOR c_slpt IS
44: SELECT closed_ind
45: FROM IGS_CO_S_LTR_PARAM
46: WHERE s_letter_parameter_type = p_s_letter_parameter_type;
47: BEGIN
48: p_message_name := Null;
49: OPEN c_slpt;