APPS.IGS_UC_PROC_COM_INST_DATA dependencies on IGS_UC_CRSE_KEYWRDS

Line 2077: p_system igs_uc_crse_keywrds.system_code%TYPE ) IS

2073: -- which are to be deleted before inserting fresh records.
2074: CURSOR old_crskwd_del_cur (p_course igs_uc_ucrskwd_ints.course%TYPE,
2075: p_campus igs_uc_ucrskwd_ints.campus%TYPE,
2076: p_opt_code igs_uc_ucrskwd_ints.optioncode%TYPE,
2077: p_system igs_uc_crse_keywrds.system_code%TYPE ) IS
2078: SELECT ucrvop.rowid, ucrvop.keyword
2079: FROM igs_uc_crse_keywrds ucrvop
2080: WHERE ucrvop.ucas_program_code = p_course
2081: AND ucrvop.institute = g_crnt_institute

Line 2079: FROM igs_uc_crse_keywrds ucrvop

2075: p_campus igs_uc_ucrskwd_ints.campus%TYPE,
2076: p_opt_code igs_uc_ucrskwd_ints.optioncode%TYPE,
2077: p_system igs_uc_crse_keywrds.system_code%TYPE ) IS
2078: SELECT ucrvop.rowid, ucrvop.keyword
2079: FROM igs_uc_crse_keywrds ucrvop
2080: WHERE ucrvop.ucas_program_code = p_course
2081: AND ucrvop.institute = g_crnt_institute
2082: AND ucrvop.ucas_campus = p_campus
2083: AND ucrvop.option_code = p_opt_code

Line 2106: p_system igs_uc_crse_keywrds.system_code%TYPE ) IS

2102: CURSOR old_crskwd_cur (p_course igs_uc_ucrskwd_ints.course%TYPE,
2103: p_campus igs_uc_ucrskwd_ints.campus%TYPE,
2104: p_opt_code igs_uc_ucrskwd_ints.optioncode%TYPE,
2105: p_keyword igs_uc_ucrskwd_ints.keyword%TYPE,
2106: p_system igs_uc_crse_keywrds.system_code%TYPE ) IS
2107: SELECT ucrvop.rowid,
2108: ucrvop.*
2109: FROM igs_uc_crse_keywrds ucrvop
2110: WHERE ucrvop.ucas_program_code = p_course

Line 2109: FROM igs_uc_crse_keywrds ucrvop

2105: p_keyword igs_uc_ucrskwd_ints.keyword%TYPE,
2106: p_system igs_uc_crse_keywrds.system_code%TYPE ) IS
2107: SELECT ucrvop.rowid,
2108: ucrvop.*
2109: FROM igs_uc_crse_keywrds ucrvop
2110: WHERE ucrvop.ucas_program_code = p_course
2111: AND ucrvop.institute = g_crnt_institute
2112: AND ucrvop.ucas_campus = p_campus
2113: AND ucrvop.option_code = p_opt_code

Line 2137: l_crse_keyword_id igs_uc_crse_keywrds.crse_keyword_id%TYPE;

2133:
2134:
2135: old_crsekwd_rec old_crskwd_cur%ROWTYPE;
2136: l_rowid VARCHAR2(26);
2137: l_crse_keyword_id igs_uc_crse_keywrds.crse_keyword_id%TYPE;
2138: l_set_level_success VARCHAR2(1);
2139:
2140: BEGIN
2141: -- initialize variables

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.