APPS.IGS_UC_PROC_REFERENCE_DATA dependencies on IGS_UC_REF_AWRDBDY

Line 224: CURSOR old_awdbdy_cur (p_year igs_uc_ref_awrdbdy.year%TYPE,

220: FROM igs_uc_crawdbd_ints
221: WHERE record_status = 'N';
222:
223: -- check whether corresponding record already exists.
224: CURSOR old_awdbdy_cur (p_year igs_uc_ref_awrdbdy.year%TYPE,
225: p_sitting igs_uc_ref_awrdbdy.sitting%TYPE,
226: p_awd_body igs_uc_ref_awrdbdy.awarding_body%TYPE) IS
227: SELECT awd.rowid
228: FROM igs_uc_ref_awrdbdy awd

Line 225: p_sitting igs_uc_ref_awrdbdy.sitting%TYPE,

221: WHERE record_status = 'N';
222:
223: -- check whether corresponding record already exists.
224: CURSOR old_awdbdy_cur (p_year igs_uc_ref_awrdbdy.year%TYPE,
225: p_sitting igs_uc_ref_awrdbdy.sitting%TYPE,
226: p_awd_body igs_uc_ref_awrdbdy.awarding_body%TYPE) IS
227: SELECT awd.rowid
228: FROM igs_uc_ref_awrdbdy awd
229: WHERE awd.year = p_year

Line 226: p_awd_body igs_uc_ref_awrdbdy.awarding_body%TYPE) IS

222:
223: -- check whether corresponding record already exists.
224: CURSOR old_awdbdy_cur (p_year igs_uc_ref_awrdbdy.year%TYPE,
225: p_sitting igs_uc_ref_awrdbdy.sitting%TYPE,
226: p_awd_body igs_uc_ref_awrdbdy.awarding_body%TYPE) IS
227: SELECT awd.rowid
228: FROM igs_uc_ref_awrdbdy awd
229: WHERE awd.year = p_year
230: AND awd.sitting = p_sitting

Line 228: FROM igs_uc_ref_awrdbdy awd

224: CURSOR old_awdbdy_cur (p_year igs_uc_ref_awrdbdy.year%TYPE,
225: p_sitting igs_uc_ref_awrdbdy.sitting%TYPE,
226: p_awd_body igs_uc_ref_awrdbdy.awarding_body%TYPE) IS
227: SELECT awd.rowid
228: FROM igs_uc_ref_awrdbdy awd
229: WHERE awd.year = p_year
230: AND awd.sitting = p_sitting
231: AND awd.awarding_body = p_awd_body;
232:

Line 274: igs_uc_ref_awrdbdy_pkg.insert_row --IGSXI25B.pls

270:
271: -- If not found then insert
272: IF l_rowid IS NULL THEN
273: BEGIN
274: igs_uc_ref_awrdbdy_pkg.insert_row --IGSXI25B.pls
275: (
276: x_rowid => l_rowid
277: ,x_year => new_awdbdy_rec.year
278: ,x_sitting => new_awdbdy_rec.sitting

Line 295: igs_uc_ref_awrdbdy_pkg.update_row --IGSXI25B.pls

291: END;
292:
293: ELSE -- update
294: BEGIN
295: igs_uc_ref_awrdbdy_pkg.update_row --IGSXI25B.pls
296: (
297: x_rowid => l_rowid
298: ,x_year => new_awdbdy_rec.year
299: ,x_sitting => new_awdbdy_rec.sitting