APPS.IGS_CO_VAL_LP dependencies on IGS_CO_LTR_PARM_TYPE

Line 19: -- Validates that the IGS_CO_LTR_PARM_TYPE is able to be used

15: p_correspondence_type IN VARCHAR2 ,
16: p_message_name OUT NOCOPY varchar2 )
17: RETURN BOOLEAN AS
18: BEGIN -- corp_val_lptr_rstrn
19: -- Validates that the IGS_CO_LTR_PARM_TYPE is able to be used
20: -- within the IGS_CO_TYPE and that no restrictions exist
21: -- that deny the IGS_CO_LTR_PARM_TYPE being able to be assigned
22: -- within the IGS_CO_TYPE.
23: DECLARE

Line 21: -- that deny the IGS_CO_LTR_PARM_TYPE being able to be assigned

17: RETURN BOOLEAN AS
18: BEGIN -- corp_val_lptr_rstrn
19: -- Validates that the IGS_CO_LTR_PARM_TYPE is able to be used
20: -- within the IGS_CO_TYPE and that no restrictions exist
21: -- that deny the IGS_CO_LTR_PARM_TYPE being able to be assigned
22: -- within the IGS_CO_TYPE.
23: DECLARE
24: CURSOR c_lptr IS
25: SELECT CORRESPONDENCE_TYPE

Line 30: FROM IGS_CO_LTR_PARM_TYPE

26: FROM IGS_CO_LTR_PR_RSTCN
27: WHERE letter_parameter_type = p_letter_parameter_type;
28: CURSOR c_lpt IS
29: SELECT s_letter_parameter_type
30: FROM IGS_CO_LTR_PARM_TYPE
31: WHERE letter_parameter_type = p_letter_parameter_type;
32: v_lpt_rec c_lpt%ROWTYPE;
33: v_valid_correspondence_type BOOLEAN DEFAULT TRUE;
34: v_message_name varchar2(30);