APPS.IGS_AS_VAL_VEA dependencies on IGS_GR_VENUE_ADDR

Line 37: FROM IGS_GR_VENUE_ADDR vea

33: WHERE addr_type = p_addr_type;
34: CURSOR c_vea IS
35: SELECT vea.start_dt,
36: vea.end_dt
37: FROM IGS_GR_VENUE_ADDR vea
38: WHERE vea.correspondence_ind = 'Y' AND
39: vea.addr_type <> p_addr_type AND
40: vea.venue_cd = p_venue_cd;
41: BEGIN

Line 56: --Now loop through the IGS_GR_VENUE_ADDR records for the IGS_GR_VENUE to determine if they

52: RETURN return_val;
53: END IF;
54: CLOSE c_adt;
55: --The IGS_CO_ADDR_TYPE passed in as a parameter has the correspondence_ind set.
56: --Now loop through the IGS_GR_VENUE_ADDR records for the IGS_GR_VENUE to determine if they
57: --have any other active records with an IGS_CO_ADDR_TYPE
58: --(apart from the IGS_CO_ADDR_TYPE passed in as a parameter)
59: --which also has the correspondence_ind set. If so, set the error message.
60: FOR v_vea_rec IN c_vea LOOP

Line 140: -- Validate that the IGS_GR_VENUE_ADDR record being created or updated does not

136: p_message_name OUT NOCOPY VARCHAR2)
137: RETURN BOOLEAN IS
138: gv_other_detail VARCHAR2(255);
139: BEGIN -- assp_val_vea_ovrlp
140: -- Validate that the IGS_GR_VENUE_ADDR record being created or updated does not
141: -- overlap with an existing address record of the same type for the IGS_GR_VENUE.
142: DECLARE
143: v_start_dt IGS_GR_VENUE_ADDR.start_dt%TYPE;
144: v_end_dt IGS_GR_VENUE_ADDR.end_dt%TYPE;

Line 143: v_start_dt IGS_GR_VENUE_ADDR.start_dt%TYPE;

139: BEGIN -- assp_val_vea_ovrlp
140: -- Validate that the IGS_GR_VENUE_ADDR record being created or updated does not
141: -- overlap with an existing address record of the same type for the IGS_GR_VENUE.
142: DECLARE
143: v_start_dt IGS_GR_VENUE_ADDR.start_dt%TYPE;
144: v_end_dt IGS_GR_VENUE_ADDR.end_dt%TYPE;
145: v_p_end_dt IGS_GR_VENUE_ADDR.end_dt%TYPE;
146: CURSOR c_va IS
147: SELECT IGS_GR_VENUE_ADDR.start_dt,

Line 144: v_end_dt IGS_GR_VENUE_ADDR.end_dt%TYPE;

140: -- Validate that the IGS_GR_VENUE_ADDR record being created or updated does not
141: -- overlap with an existing address record of the same type for the IGS_GR_VENUE.
142: DECLARE
143: v_start_dt IGS_GR_VENUE_ADDR.start_dt%TYPE;
144: v_end_dt IGS_GR_VENUE_ADDR.end_dt%TYPE;
145: v_p_end_dt IGS_GR_VENUE_ADDR.end_dt%TYPE;
146: CURSOR c_va IS
147: SELECT IGS_GR_VENUE_ADDR.start_dt,
148: NVL(IGS_GR_VENUE_ADDR.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))

Line 145: v_p_end_dt IGS_GR_VENUE_ADDR.end_dt%TYPE;

141: -- overlap with an existing address record of the same type for the IGS_GR_VENUE.
142: DECLARE
143: v_start_dt IGS_GR_VENUE_ADDR.start_dt%TYPE;
144: v_end_dt IGS_GR_VENUE_ADDR.end_dt%TYPE;
145: v_p_end_dt IGS_GR_VENUE_ADDR.end_dt%TYPE;
146: CURSOR c_va IS
147: SELECT IGS_GR_VENUE_ADDR.start_dt,
148: NVL(IGS_GR_VENUE_ADDR.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
149: FROM IGS_GR_VENUE_ADDR

Line 147: SELECT IGS_GR_VENUE_ADDR.start_dt,

143: v_start_dt IGS_GR_VENUE_ADDR.start_dt%TYPE;
144: v_end_dt IGS_GR_VENUE_ADDR.end_dt%TYPE;
145: v_p_end_dt IGS_GR_VENUE_ADDR.end_dt%TYPE;
146: CURSOR c_va IS
147: SELECT IGS_GR_VENUE_ADDR.start_dt,
148: NVL(IGS_GR_VENUE_ADDR.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
149: FROM IGS_GR_VENUE_ADDR
150: WHERE venue_cd = p_venue_cd AND
151: addr_type = p_addr_type AND

Line 148: NVL(IGS_GR_VENUE_ADDR.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))

144: v_end_dt IGS_GR_VENUE_ADDR.end_dt%TYPE;
145: v_p_end_dt IGS_GR_VENUE_ADDR.end_dt%TYPE;
146: CURSOR c_va IS
147: SELECT IGS_GR_VENUE_ADDR.start_dt,
148: NVL(IGS_GR_VENUE_ADDR.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
149: FROM IGS_GR_VENUE_ADDR
150: WHERE venue_cd = p_venue_cd AND
151: addr_type = p_addr_type AND
152: start_dt <> p_start_dt;

Line 149: FROM IGS_GR_VENUE_ADDR

145: v_p_end_dt IGS_GR_VENUE_ADDR.end_dt%TYPE;
146: CURSOR c_va IS
147: SELECT IGS_GR_VENUE_ADDR.start_dt,
148: NVL(IGS_GR_VENUE_ADDR.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
149: FROM IGS_GR_VENUE_ADDR
150: WHERE venue_cd = p_venue_cd AND
151: addr_type = p_addr_type AND
152: start_dt <> p_start_dt;
153: BEGIN