eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_OR_VAL_OA dependencies on IGS_OR_ADDR

Line 41: FROM IGS_OR_ADDR oa

37: CURSOR c_oa IS
38: SELECT oa.addr_type,
39: oa.start_dt,
40: oa.end_dt
41: FROM IGS_OR_ADDR oa
42: WHERE oa.org_unit_cd = p_org_unit_cd AND
43: oa.status = 'A' AND
44: oa.ou_start_dt = p_ou_start_dt AND
45: oa.addr_type <> p_addr_type AND

Line 61: -- set. Now loop through the IGS_OR_ADDR records for the IGS_AD_LOCATION to

57: IF v_oa_count = 0 THEN
58: RETURN TRUE;
59: END IF;
60: -- The addr_type passed in as a parameter has the correspondence_ind
61: -- set. Now loop through the IGS_OR_ADDR records for the IGS_AD_LOCATION to
62: -- determine if they have any other active records with an IGS_CO_ADDR_TYPE
63: -- (apart from the IGS_CO_ADDR_TYPE passed in as a parameter) which also has
64: -- the correspondence_ind set. If so set the error message.
65: FOR v_oa IN c_oa LOOP

Line 150: FROM IGS_OR_ADDR oa

146: DECLARE
147: v_count NUMBER(5);
148: CURSOR c_oa IS
149: SELECT count(*)
150: FROM IGS_OR_ADDR oa
151: WHERE oa.org_unit_cd = p_org_unit_cd AND
152: oa.ou_start_dt = p_ou_start_dt AND
153: oa.status = 'A' AND
154: oa.start_dt <> p_start_dt AND

Line 158: --Validate the IGS_OR_ADDR table to ensure that only one record is open

154: oa.start_dt <> p_start_dt AND
155: oa.addr_type = p_addr_type AND
156: oa.end_dt IS NULL;
157: BEGIN
158: --Validate the IGS_OR_ADDR table to ensure that only one record is open
159: --(ie; has a null end date).
160: --- Set the default message number
161: p_message_name := NULL;
162: OPEN c_oa;

Line 193: cp_org_unit_cd IGS_OR_ADDR.org_unit_cd%TYPE,

189: gv_other_detail VARCHAR2(255);
190: BEGIN
191: DECLARE
192: CURSOR c_oa (
193: cp_org_unit_cd IGS_OR_ADDR.org_unit_cd%TYPE,
194: cp_ou_start_dt IGS_OR_ADDR.ou_start_dt%TYPE,
195: cp_addr_type IGS_OR_ADDR.addr_type%TYPE) IS
196: SELECT oa.start_dt,
197: oa.end_dt

Line 194: cp_ou_start_dt IGS_OR_ADDR.ou_start_dt%TYPE,

190: BEGIN
191: DECLARE
192: CURSOR c_oa (
193: cp_org_unit_cd IGS_OR_ADDR.org_unit_cd%TYPE,
194: cp_ou_start_dt IGS_OR_ADDR.ou_start_dt%TYPE,
195: cp_addr_type IGS_OR_ADDR.addr_type%TYPE) IS
196: SELECT oa.start_dt,
197: oa.end_dt
198: FROM IGS_OR_ADDR oa

Line 195: cp_addr_type IGS_OR_ADDR.addr_type%TYPE) IS

191: DECLARE
192: CURSOR c_oa (
193: cp_org_unit_cd IGS_OR_ADDR.org_unit_cd%TYPE,
194: cp_ou_start_dt IGS_OR_ADDR.ou_start_dt%TYPE,
195: cp_addr_type IGS_OR_ADDR.addr_type%TYPE) IS
196: SELECT oa.start_dt,
197: oa.end_dt
198: FROM IGS_OR_ADDR oa
199: WHERE oa.org_unit_cd = cp_org_unit_cd AND

Line 198: FROM IGS_OR_ADDR oa

194: cp_ou_start_dt IGS_OR_ADDR.ou_start_dt%TYPE,
195: cp_addr_type IGS_OR_ADDR.addr_type%TYPE) IS
196: SELECT oa.start_dt,
197: oa.end_dt
198: FROM IGS_OR_ADDR oa
199: WHERE oa.org_unit_cd = cp_org_unit_cd AND
200: oa.ou_start_dt = cp_ou_start_dt AND
201: oa.addr_type = cp_addr_type AND
202: oa.status = 'A' AND

Line 204: v_end_dt IGS_OR_ADDR.end_dt%TYPE;

200: oa.ou_start_dt = cp_ou_start_dt AND
201: oa.addr_type = cp_addr_type AND
202: oa.status = 'A' AND
203: oa.start_dt <> p_start_dt;
204: v_end_dt IGS_OR_ADDR.end_dt%TYPE;
205: BEGIN
206: -- This module checks that the IGS_OR_ADDR record, which is being
207: -- created or updated, does not overlap with an existing adress
208: -- record of the same type for the organisational IGS_PS_UNIT.

Line 206: -- This module checks that the IGS_OR_ADDR record, which is being

202: oa.status = 'A' AND
203: oa.start_dt <> p_start_dt;
204: v_end_dt IGS_OR_ADDR.end_dt%TYPE;
205: BEGIN
206: -- This module checks that the IGS_OR_ADDR record, which is being
207: -- created or updated, does not overlap with an existing adress
208: -- record of the same type for the organisational IGS_PS_UNIT.
209: -- Set the default message number
210: p_message_name := NULL;

Line 217: -- Loop through the selected IGS_OR_ADDR records,

213: v_end_dt := IGS_GE_DATE.IGSDATE('9999/01/01');
214: ELSE
215: v_end_dt := p_end_dt;
216: END IF;
217: -- Loop through the selected IGS_OR_ADDR records,
218: -- validating each record for date overlaps.
219: -- Do not validate against the record passed in.
220: -- Validation will fail if any of the following are true -
221: -- a. The current start date is between an existing date range.