APPS.IGS_UC_PROC_COM_INST_DATA dependencies on IGS_UC_CRSE_DETS

Line 1523: FROM igs_uc_crse_dets crdet

1519: CURSOR old_crse_cur (p_course igs_uc_ccrse_ints.course%TYPE, p_campus igs_uc_ccrse_ints.campus%TYPE,
1520: p_inst igs_uc_ccrse_ints.inst%TYPE, p_system_code igs_uc_ccrse_ints.system_code%TYPE) IS
1521: SELECT crdet.rowid,
1522: crdet.*
1523: FROM igs_uc_crse_dets crdet
1524: WHERE crdet.ucas_program_code = p_course
1525: AND crdet.institute = p_inst
1526: AND crdet.ucas_campus = p_campus
1527: AND crdet.system_code = p_system_code;

Line 1540: FROM igs_uc_crse_dets a, igs_uc_ucrsvop_ints b

1536: -- Those records which are present in uvcoursevacoptions)
1537: CURSOR crse_vacops_cur IS
1538: SELECT a.ROWID row_id,
1539: a.*
1540: FROM igs_uc_crse_dets a, igs_uc_ucrsvop_ints b
1541: WHERE a.ucas_program_code = b.course
1542: AND a.ucas_campus = b.campus
1543: AND a.institute = g_crnt_institute
1544: AND a.system_code = 'U'

Line 1609: igs_uc_crse_dets_pkg.insert_row -- IGSXI14B.pls

1605: IF old_crse_rec.rowid IS NULL THEN
1606:
1607: BEGIN
1608: -- insert a new record in the main table
1609: igs_uc_crse_dets_pkg.insert_row -- IGSXI14B.pls
1610: (
1611: x_rowid => old_crse_rec.rowid
1612: ,x_ucas_program_code => new_cvcrse_rec.course
1613: ,x_oss_program_code => NULL

Line 1665: igs_uc_crse_dets_pkg.update_row -- IGSXI14B.pls

1661: ELSE -- update
1662:
1663: BEGIN
1664: -- update a new record in the main table
1665: igs_uc_crse_dets_pkg.update_row -- IGSXI14B.pls
1666: (
1667: x_rowid => old_crse_rec.rowid
1668: ,x_ucas_program_code => old_crse_rec.ucas_program_code
1669: ,x_oss_program_code => old_crse_rec.oss_program_code

Line 1780: igs_uc_crse_dets_pkg.update_row -- IGSXI14B.pls

1776: FOR crse_vacops_rec IN crse_vacops_cur
1777: LOOP
1778:
1779: BEGIN
1780: igs_uc_crse_dets_pkg.update_row -- IGSXI14B.pls
1781: (
1782: x_rowid => crse_vacops_rec.row_id
1783: ,x_ucas_program_code => crse_vacops_rec.ucas_program_code
1784: ,x_oss_program_code => crse_vacops_rec.oss_program_code

Line 1874: p_inst igs_uc_ccrse_ints.inst%TYPE, p_system igs_uc_crse_dets.system_code%TYPE) IS

1870: -- check whether corresponding record already exists.
1871: -- Currently since only FTUG is supported over Hercules and no course data for other systems come from UCAS,
1872: -- the system code has been hardcoded to U for 'FTUG'.
1873: CURSOR old_ucrse_cur (p_course igs_uc_ccrse_ints.course%TYPE, p_campus igs_uc_ccrse_ints.campus%TYPE,
1874: p_inst igs_uc_ccrse_ints.inst%TYPE, p_system igs_uc_crse_dets.system_code%TYPE) IS
1875: SELECT ucrdet.rowid,
1876: ucrdet.*
1877: FROM igs_uc_crse_dets ucrdet
1878: WHERE ucrdet.ucas_program_code = p_course

Line 1877: FROM igs_uc_crse_dets ucrdet

1873: CURSOR old_ucrse_cur (p_course igs_uc_ccrse_ints.course%TYPE, p_campus igs_uc_ccrse_ints.campus%TYPE,
1874: p_inst igs_uc_ccrse_ints.inst%TYPE, p_system igs_uc_crse_dets.system_code%TYPE) IS
1875: SELECT ucrdet.rowid,
1876: ucrdet.*
1877: FROM igs_uc_crse_dets ucrdet
1878: WHERE ucrdet.ucas_program_code = p_course
1879: AND ucrdet.institute = p_inst
1880: AND ucrdet.ucas_campus = p_campus
1881: AND ucrdet.system_code = p_system;

Line 1933: igs_uc_crse_dets_pkg.update_row -- IGSXI14B.pls

1929: ELSE -- update
1930:
1931: BEGIN
1932: -- update a new record in the main table
1933: igs_uc_crse_dets_pkg.update_row -- IGSXI14B.pls
1934: (
1935: x_rowid => old_ucrse_rec.rowid
1936: ,x_ucas_program_code => old_ucrse_rec.ucas_program_code
1937: ,x_oss_program_code => old_ucrse_rec.oss_program_code

Line 2119: p_system igs_uc_crse_dets.system_code%TYPE) IS

2115: AND ucrvop.system_code = p_system;
2116:
2117: -- validate the the UCAS program details are valid i.e exist in Course details table.
2118: CURSOR validate_crse_cur (p_course igs_uc_ucrsvac_ints.course%TYPE, p_campus igs_uc_ucrsvac_ints.campus%TYPE,
2119: p_system igs_uc_crse_dets.system_code%TYPE) IS
2120: SELECT ucrdet.rowid
2121: FROM igs_uc_crse_dets ucrdet
2122: WHERE ucrdet.ucas_program_code = p_course
2123: AND ucrdet.institute = g_crnt_institute

Line 2121: FROM igs_uc_crse_dets ucrdet

2117: -- validate the the UCAS program details are valid i.e exist in Course details table.
2118: CURSOR validate_crse_cur (p_course igs_uc_ucrsvac_ints.course%TYPE, p_campus igs_uc_ucrsvac_ints.campus%TYPE,
2119: p_system igs_uc_crse_dets.system_code%TYPE) IS
2120: SELECT ucrdet.rowid
2121: FROM igs_uc_crse_dets ucrdet
2122: WHERE ucrdet.ucas_program_code = p_course
2123: AND ucrdet.institute = g_crnt_institute
2124: AND ucrdet.ucas_campus = p_campus
2125: AND ucrdet.system_code = p_system;