APPS.IGS_AD_VAL_APCL dependencies on IGS_CO_S_LTR

Line 18: -- Validate if IGS_CO_S_LTR is closed.

14: p_message_name OUT NOCOPY VARCHAR2 )
15: RETURN BOOLEAN IS
16: gv_other_detail VARCHAR2(255);
17: BEGIN -- corp_val_slet_closed
18: -- Validate if IGS_CO_S_LTR is closed.
19: DECLARE
20:
21: v_closed_ind IGS_CO_S_LTR.closed_ind%TYPE DEFAULT NULL;
22: CURSOR c_s_letter IS

Line 21: v_closed_ind IGS_CO_S_LTR.closed_ind%TYPE DEFAULT NULL;

17: BEGIN -- corp_val_slet_closed
18: -- Validate if IGS_CO_S_LTR is closed.
19: DECLARE
20:
21: v_closed_ind IGS_CO_S_LTR.closed_ind%TYPE DEFAULT NULL;
22: CURSOR c_s_letter IS
23: SELECT closed_ind
24: FROM IGS_CO_S_LTR
25: WHERE correspondence_type = p_correspondence_type AND

Line 24: FROM IGS_CO_S_LTR

20:
21: v_closed_ind IGS_CO_S_LTR.closed_ind%TYPE DEFAULT NULL;
22: CURSOR c_s_letter IS
23: SELECT closed_ind
24: FROM IGS_CO_S_LTR
25: WHERE correspondence_type = p_correspondence_type AND
26: letter_reference_number = p_letter_reference_number;
27:
28: BEGIN

Line 53: -- This module validates that the passed IGS_CO_S_LTR has the passed

49: p_message_name OUT NOCOPY VARCHAR2 )
50: RETURN BOOLEAN IS
51: gv_other_detail VARCHAR2(255);
52: BEGIN -- corp_val_slet_slrt
53: -- This module validates that the passed IGS_CO_S_LTR has the passed
54: -- IGS_CO_S_LTR_REF_TYPE
55: DECLARE
56: v_dummy VARCHAR2(1);
57: CURSOR c_sl IS

Line 54: -- IGS_CO_S_LTR_REF_TYPE

50: RETURN BOOLEAN IS
51: gv_other_detail VARCHAR2(255);
52: BEGIN -- corp_val_slet_slrt
53: -- This module validates that the passed IGS_CO_S_LTR has the passed
54: -- IGS_CO_S_LTR_REF_TYPE
55: DECLARE
56: v_dummy VARCHAR2(1);
57: CURSOR c_sl IS
58: SELECT 'x'

Line 59: FROM IGS_CO_S_LTR sl

55: DECLARE
56: v_dummy VARCHAR2(1);
57: CURSOR c_sl IS
58: SELECT 'x'
59: FROM IGS_CO_S_LTR sl
60: WHERE sl.correspondence_type = p_correspondence_type AND
61: sl.letter_reference_number = p_letter_reference_number AND
62: sl.s_letter_reference_type = p_s_letter_reference_type;
63: