APPS.IGS_UC_PROC_COM_INST_DATA dependencies on IGS_UC_CRSE_KEYWRDS_PKG

Line 2175: igs_uc_crse_keywrds_pkg.delete_row (old_crskwd_del_rec.rowid);

2171: int_crseops_rec.campus,
2172: int_crseops_rec.optioncode,
2173: 'U')
2174: LOOP
2175: igs_uc_crse_keywrds_pkg.delete_row (old_crskwd_del_rec.rowid);
2176: END LOOP;
2177:
2178: -- Get all the reocords for the combination from interface table with status = 'N'
2179: FOR new_ucrsekwd_rec IN int_ucrsekwd_cur(int_crseops_rec.course,

Line 2243: igs_uc_crse_keywrds_pkg.insert_row -- IGSXI15B.pls

2239: IF old_crsekwd_rec.rowid IS NULL THEN
2240:
2241: BEGIN
2242: -- insert a new record - call the TBH
2243: igs_uc_crse_keywrds_pkg.insert_row -- IGSXI15B.pls
2244: (
2245: x_rowid => old_crsekwd_rec.rowid
2246: ,x_ucas_program_code => new_ucrsekwd_rec.course
2247: ,x_institute => g_crnt_institute

Line 2272: igs_uc_crse_keywrds_pkg.update_row -- IGSXI15B.pls

2268: ELSE -- update
2269:
2270: BEGIN
2271: -- update a new record in the main table
2272: igs_uc_crse_keywrds_pkg.update_row -- IGSXI15B.pls
2273: (
2274: x_rowid => old_crsekwd_rec.rowid
2275: ,x_ucas_program_code => old_crsekwd_rec.ucas_program_code
2276: ,x_institute => old_crsekwd_rec.institute

Line 2361: igs_uc_crse_keywrds_pkg.delete_row (old_crskwd_del_rec.rowid);

2357: int_crseops_rec.campus,
2358: int_crseops_rec.optioncode,
2359: 'U')
2360: LOOP
2361: igs_uc_crse_keywrds_pkg.delete_row (old_crskwd_del_rec.rowid);
2362: END LOOP;
2363:
2364: -- update valid INTS records for this course and campus combination to 2002
2365: -- for records which were successful but cant be processed as a set.