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_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_APPLICANTS

Line 73: PROCEDURE validate_applicant (p_appno igs_uc_applicants.app_no%TYPE,

69: errbuf := fnd_message.get;
70: fnd_file.put_line(fnd_file.log, errbuf);
71: END appl_data_setup;
72:
73: PROCEDURE validate_applicant (p_appno igs_uc_applicants.app_no%TYPE,
74: p_error_cd OUT NOCOPY g_error_code%TYPE) IS
75: /******************************************************************
76: Created By : rgangara
77: Date Created By : 12-JUNE-2003

Line 85: -- For getting Application details from IGS_UC_APPLICANTS.

81: Change History
82: Who When What
83: ******************************************************************/
84:
85: -- For getting Application details from IGS_UC_APPLICANTS.
86: CURSOR get_applicant_cur IS
87: SELECT app_no,
88: oss_person_id
89: FROM igs_uc_applicants

Line 89: FROM igs_uc_applicants

85: -- For getting Application details from IGS_UC_APPLICANTS.
86: CURSOR get_applicant_cur IS
87: SELECT app_no,
88: oss_person_id
89: FROM igs_uc_applicants
90: WHERE app_no = p_appno;
91:
92: l_applicant_rec get_applicant_cur%ROWTYPE;
93:

Line 232: IGS_UC_APPLICANTS where OSS PERSON ID IS NULL

228: Created By : rgangara
229: Date Created By : 12-JUN-03
230: Purpose : LOCAL PROCEDURE called from process_IVSTARN Procedure.
231: This process picks up all the records from
232: IGS_UC_APPLICANTS where OSS PERSON ID IS NULL
233: and gets the Person ID from Alternate person ID
234: table based on Alternate Person ID which is the
235: type as that of the system to which the App belongs.
236: Known limitations,enhancements,remarks:

Line 245: FROM igs_uc_applicants ucap

241: -- get all the records with NULL Person ID
242: CURSOR ucas_app_person_cur IS
243: SELECT ucap.rowid,
244: ucap.*
245: FROM igs_uc_applicants ucap
246: WHERE oss_person_id IS NULL;
247:
248:
249: -- get all the records with NULL Person ID

Line 258: l_oss_person_id igs_uc_applicants.oss_person_id%TYPE;

254: WHERE api_person_id = p_ucas_appno
255: AND person_id_type = p_ucas_system;
256:
257:
258: l_oss_person_id igs_uc_applicants.oss_person_id%TYPE;
259: l_system_type igs_pe_alt_pers_id.person_id_type%TYPE;
260:
261: BEGIN
262:

Line 309: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls

305: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
306:
307: -- update UCAS Applicants table with Person ID.
308: BEGIN
309: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls
310: (
311: x_rowid => ucas_app_person_rec.rowid
312: ,x_app_id => ucas_app_person_rec.app_id
313: ,x_app_no => ucas_app_person_rec.app_no

Line 548: in IGS_UC_APPLICANTS table and does not in App Names.

544: Change History
545: Who When What
546: rgangara 29-APR-04 Bug# 3601118. Modified processing of IVSTARN record to flag|
547: and generate Adm Imp Batch ID even when the APPNO rec exists
548: in IGS_UC_APPLICANTS table and does not in App Names.
549: jchakrab 27-JUL-04 Modified for UCFD308 - UCAS - 2005 Regulatory Changes
550: jbaber 11-JUL-06 Modified for UCFD325 - UCAS - 2007 Regulatory Changes
551: ******************************************************************/
552:

Line 570: CURSOR old_appl_cur(p_appno igs_uc_applicants.app_no%TYPE) IS

566: WHERE uapn.app_no = p_appno;
567:
568:
569: -- check for corresponding record in UCAS Applicants table.
570: CURSOR old_appl_cur(p_appno igs_uc_applicants.app_no%TYPE) IS
571: SELECT ucap.rowid,
572: ucap.*
573: FROM igs_uc_applicants ucap
574: WHERE ucap.app_no = p_appno;

Line 573: FROM igs_uc_applicants ucap

569: -- check for corresponding record in UCAS Applicants table.
570: CURSOR old_appl_cur(p_appno igs_uc_applicants.app_no%TYPE) IS
571: SELECT ucap.rowid,
572: ucap.*
573: FROM igs_uc_applicants ucap
574: WHERE ucap.app_no = p_appno;
575:
576:
577: appl_rec old_appl_cur%ROWTYPE;

Line 852: igs_uc_applicants_pkg.insert_row -- IGSXI01B.pls

848: IF appl_rec.rowid IS NULL THEN
849:
850: -- since corresponding record does not exist in UCAS APplicants, Insert a record with basic details.
851: BEGIN
852: igs_uc_applicants_pkg.insert_row -- IGSXI01B.pls
853: (
854: x_rowid => appl_rec.rowid
855: ,x_app_id => appl_rec.app_id -- can be used since this rec variable would be null
856: ,x_app_no => new_ivstarn_rec.appno

Line 967: -- no update to IGS_UC_APPLICANTS from this procedure. Only insert is allowed

963: fnd_file.put_line(fnd_file.log, SQLERRM);
964: END;
965:
966: ELSE
967: -- no update to IGS_UC_APPLICANTS from this procedure. Only insert is allowed
968: -- first time to ensure that this remains the main table for all further validations
969: -- All the other field values for the above record are populated in IVSTARK.
970: NULL;
971: END IF; -- uc appliants insert check

Line 1376: -- call the procedure to populate OSS Person ID into IGS_UC_APPLICANTS.

1372: -- call the process to check for successful person creation and update the Inteface record status accordingly.
1373: proc_update_ivstarn_status;
1374:
1375:
1376: -- call the procedure to populate OSS Person ID into IGS_UC_APPLICANTS.
1377: -- processing continues even if some unhandled excpetion is raised in the called procedure.
1378: proc_populate_oss_person;
1379:
1380:

Line 1404: the sent_to_oss flag in IGS_UC_APPLICANTS has to be reset to 'N'.

1400: Known limitations,enhancements,remarks:
1401: Change History
1402: Who When What
1403: dsridhar 25-AUG-2003 Bug No: 3108562. Since the Address data has changed,
1404: the sent_to_oss flag in IGS_UC_APPLICANTS has to be reset to 'N'.
1405: jbaber 11-Jul-2006 Added mobile, countrycode and homecountrycode for UCAS 2007 Support
1406: ******************************************************************/
1407:
1408: CURSOR new_ivstara_cur IS

Line 1415: CURSOR old_stara_cur(p_appno igs_uc_applicants.app_no%TYPE) IS

1411: FROM igs_uc_istara_ints ivsta
1412: WHERE record_status = 'N';
1413:
1414:
1415: CURSOR old_stara_cur(p_appno igs_uc_applicants.app_no%TYPE) IS
1416: SELECT appaddr.rowid,
1417: appaddr.*
1418: FROM igs_uc_app_addreses appaddr
1419: WHERE appaddr.app_no = p_appno;

Line 1421: CURSOR appl_details (cp_appno igs_uc_applicants.app_no%TYPE) IS

1417: appaddr.*
1418: FROM igs_uc_app_addreses appaddr
1419: WHERE appaddr.app_no = p_appno;
1420:
1421: CURSOR appl_details (cp_appno igs_uc_applicants.app_no%TYPE) IS
1422: SELECT app.rowid, app.*
1423: FROM igs_uc_applicants app
1424: WHERE app.app_no = cp_appno;
1425:

Line 1423: FROM igs_uc_applicants app

1419: WHERE appaddr.app_no = p_appno;
1420:
1421: CURSOR appl_details (cp_appno igs_uc_applicants.app_no%TYPE) IS
1422: SELECT app.rowid, app.*
1423: FROM igs_uc_applicants app
1424: WHERE app.app_no = cp_appno;
1425:
1426: -- To validate against Country code.
1427: CURSOR validate_country_cur (p_code igs_uc_ref_country.country_code%TYPE) IS

Line 1601: -- IGS_UC_APPLICANTS has to be reset to 'N'.

1597: ,x_mode => 'R'
1598: );
1599:
1600: -- Bug No: 3108562. Since the Address data has changed, the sent_to_oss flag in
1601: -- IGS_UC_APPLICANTS has to be reset to 'N'.
1602: OPEN appl_details(old_stara_rec.app_no);
1603: FETCH appl_details INTO app_rec;
1604: CLOSE appl_details;
1605:

Line 1611: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls

1607: g_error_code := '1000';
1608: ELSE
1609:
1610: -- call the TBH to update the record setting sent to OSS as No.
1611: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls
1612: (
1613: x_rowid => app_rec.rowid
1614: ,x_app_id => app_rec.app_id
1615: ,x_app_no => app_rec.app_no

Line 1794: smaddali 8-aug-03 Modified igs_uc_applicants.update call to update ni_number, criminal_conv,ukentry_date fields,bug#3088436

1790: Purpose : For processing Applicant info. details from UCAS.
1791: Known limitations,enhancements,remarks:
1792: Change History
1793: Who When What
1794: smaddali 8-aug-03 Modified igs_uc_applicants.update call to update ni_number, criminal_conv,ukentry_date fields,bug#3088436
1795: rgangara 05-FEB-04 Added update to App Stats table for Sent_to_HESA flag as the Domicile data comes in *K transaction but
1796: is exported to OSS along with App Stats data. Without this, the Modified Domicile data cannot be exported
1797: since the process picks only when the said flag is 'N'. Bug# 3405245
1798: jchakrab 23-AUG-04 Modified for Bug#3838781 - Update the system code for existing SWAS applicants in igs_uc_applicants

Line 1798: jchakrab 23-AUG-04 Modified for Bug#3838781 - Update the system code for existing SWAS applicants in igs_uc_applicants

1794: smaddali 8-aug-03 Modified igs_uc_applicants.update call to update ni_number, criminal_conv,ukentry_date fields,bug#3088436
1795: rgangara 05-FEB-04 Added update to App Stats table for Sent_to_HESA flag as the Domicile data comes in *K transaction but
1796: is exported to OSS along with App Stats data. Without this, the Modified Domicile data cannot be exported
1797: since the process picks only when the said flag is 'N'. Bug# 3405245
1798: jchakrab 23-AUG-04 Modified for Bug#3838781 - Update the system code for existing SWAS applicants in igs_uc_applicants
1799: when applications are re-sent by UCAS, as SWAS applicants need to be identified as FTUG applicants for
1800: ucas_cycle > 2004.
1801: jbaber 15-Sep-05 Modified for bug 4589994 - do not update routeb with NULL value
1802: jchakrab 06-Sep-06 Modified for bug 5481963 - update app-choice records when IVSTARK withdrawn value is W or C

Line 1812: CURSOR old_stark_cur(p_appno igs_uc_applicants.app_no%TYPE) IS

1808: FROM igs_uc_istark_ints ivstk
1809: WHERE record_status = 'N';
1810:
1811:
1812: CURSOR old_stark_cur(p_appno igs_uc_applicants.app_no%TYPE) IS
1813: SELECT appl.rowid,
1814: appl.*
1815: FROM igs_uc_applicants appl
1816: WHERE appl.app_no = p_appno;

Line 1815: FROM igs_uc_applicants appl

1811:
1812: CURSOR old_stark_cur(p_appno igs_uc_applicants.app_no%TYPE) IS
1813: SELECT appl.rowid,
1814: appl.*
1815: FROM igs_uc_applicants appl
1816: WHERE appl.app_no = p_appno;
1817:
1818: -- To validate SPECIALNEEDS, RESCAT, FEEPAYER, STATUS against Reference codes.
1819: CURSOR validate_refcodes_cur (p_type igs_uc_ref_codes.code_type%TYPE,

Line 1872: l_system_code igs_uc_applicants.system_code%TYPE;

1868: old_stark_rec old_stark_cur%ROWTYPE ;
1869: l_valid VARCHAR2(1); -- for holding fetch from cursors for rec exists check.
1870:
1871: -- jchakrab added for deriving system_code - Bug# 3838781 - 23-Aug-2004
1872: l_system_code igs_uc_applicants.system_code%TYPE;
1873: BEGIN
1874:
1875: -- initialize variables
1876: g_success_rec_cnt := 0;

Line 1907: -- This is because record gets inserted into IGS_UC_APPLICANTS as part of

1903:
1904: -- appno validation
1905: IF g_error_code IS NULL THEN
1906: -- validate Applicant record details in UCAS Applicants table.
1907: -- This is because record gets inserted into IGS_UC_APPLICANTS as part of
1908: -- IVSTARN processing and hence at this stage the record must exist.
1909: validate_applicant (new_ivstark_rec.appno, g_error_code);
1910: END IF;
1911:

Line 2186: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls

2182:
2183: BEGIN
2184: -- call the TBH to update the record
2185: -- smaddali updating criminal_conv, ukentrydate,ni_number with interface record values as per bug#3088436
2186: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls
2187: (
2188: x_rowid => old_stark_rec.rowid
2189: ,x_app_id => old_stark_rec.app_id
2190: ,x_app_no => old_stark_rec.app_no

Line 2536: CURSOR get_appl_dets (p_appno igs_uc_applicants.app_no%TYPE) IS

2532: AND appl.choice_no = p_choiceno
2533: AND appl.ucas_cycle = p_cycle;
2534:
2535: -- get the system and app_id to be populated into App Choices
2536: CURSOR get_appl_dets (p_appno igs_uc_applicants.app_no%TYPE) IS
2537: SELECT app_id,
2538: system_code
2539: FROM igs_uc_applicants
2540: WHERE app_no = p_appno;

Line 2539: FROM igs_uc_applicants

2535: -- get the system and app_id to be populated into App Choices
2536: CURSOR get_appl_dets (p_appno igs_uc_applicants.app_no%TYPE) IS
2537: SELECT app_id,
2538: system_code
2539: FROM igs_uc_applicants
2540: WHERE app_no = p_appno;
2541:
2542:
2543: -- validate institution value

Line 2550: CURSOR get_control_entry_year (p_system igs_uc_applicants.system_code%TYPE, p_cycle igs_uc_istarc_ints.ucas_cycle%TYPE) IS

2546: FROM igs_uc_com_inst
2547: WHERE inst = p_inst;
2548:
2549: -- get entry year from UCAS Control.
2550: CURSOR get_control_entry_year (p_system igs_uc_applicants.system_code%TYPE, p_cycle igs_uc_istarc_ints.ucas_cycle%TYPE) IS
2551: SELECT entry_year
2552: FROM igs_uc_ucas_control
2553: WHERE system_code = p_system
2554: AND ucas_cycle = p_cycle;

Line 3027: ,x_system_code => get_appl_dets_rec.system_code -- update with current system_code in igs_uc_applicants -Bug#3838781

3023: ,x_error_code => NULL
3024: ,x_request_id => NULL
3025: ,x_batch_id => NULL
3026: ,x_extra_round_nbr => new_ivstarc_rec.extraround
3027: ,x_system_code => get_appl_dets_rec.system_code -- update with current system_code in igs_uc_applicants -Bug#3838781
3028: ,x_part_time => old_starc_9_rec.part_time
3029: ,x_interview => old_starc_9_rec.interview
3030: ,x_late_application => old_starc_9_rec.late_application
3031: ,x_modular => old_starc_9_rec.modular

Line 3147: ,x_system_code => get_appl_dets_rec.system_code -- update with current system_code in igs_uc_applicants -Bug#3838781

3143: ,x_error_code => NULL
3144: ,x_request_id => NULL
3145: ,x_batch_id => NULL
3146: ,x_extra_round_nbr => new_ivstarc_rec.extraround
3147: ,x_system_code => get_appl_dets_rec.system_code -- update with current system_code in igs_uc_applicants -Bug#3838781
3148: ,x_part_time => old_starc_rec.part_time
3149: ,x_interview => old_starc_rec.interview
3150: ,x_late_application => old_starc_rec.late_application
3151: ,x_modular => old_starc_rec.modular

Line 3273: CURSOR get_appl_dets (p_appno igs_uc_applicants.app_no%TYPE) IS

3269: AND appl.choice_no = p_choiceno
3270: AND appl.ucas_cycle = p_cycle;
3271:
3272: -- get the system and app_id to be populated into App Choices
3273: CURSOR get_appl_dets (p_appno igs_uc_applicants.app_no%TYPE) IS
3274: SELECT ucap.rowid,
3275: ucap.*
3276: FROM igs_uc_applicants ucap
3277: WHERE app_no = p_appno;

Line 3276: FROM igs_uc_applicants ucap

3272: -- get the system and app_id to be populated into App Choices
3273: CURSOR get_appl_dets (p_appno igs_uc_applicants.app_no%TYPE) IS
3274: SELECT ucap.rowid,
3275: ucap.*
3276: FROM igs_uc_applicants ucap
3277: WHERE app_no = p_appno;
3278:
3279:
3280: -- validate institution value

Line 3287: CURSOR get_control_entry_year (p_system igs_uc_applicants.system_code%TYPE, p_cycle igs_uc_istarg_ints.ucas_cycle%TYPE) IS

3283: FROM igs_uc_com_inst
3284: WHERE inst = p_inst;
3285:
3286: -- get entry year from UCAS Control.
3287: CURSOR get_control_entry_year (p_system igs_uc_applicants.system_code%TYPE, p_cycle igs_uc_istarg_ints.ucas_cycle%TYPE) IS
3288: SELECT entry_year
3289: FROM igs_uc_ucas_control
3290: WHERE system_code = p_system
3291: AND ucas_cycle = p_cycle;

Line 3430: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls

3426: -- update Applicants record for some fields
3427: -- (gcse_eng, gcse_match, degree_subject, degree_status, degree_class, gcse_csi).
3428: BEGIN
3429: -- call the TBH to update the record
3430: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls
3431: (
3432: x_rowid => get_appl_dets_rec.rowid
3433: ,x_app_id => get_appl_dets_rec.app_id
3434: ,x_app_no => get_appl_dets_rec.app_no

Line 4067: FROM igs_uc_applicants ucap

4063:
4064: CURSOR old_start_cur(p_appno igs_uc_app_choices.app_no%TYPE) IS
4065: SELECT ucap.rowid,
4066: ucap.*
4067: FROM igs_uc_applicants ucap
4068: WHERE ucap.app_no = p_appno;
4069:
4070: old_start_rec old_start_cur%ROWTYPE;
4071:

Line 4130: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls

4126:
4127:
4128: BEGIN
4129: -- call the TBH to update the record
4130: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls
4131: (
4132: x_rowid => old_start_rec.rowid
4133: ,x_app_id => old_start_rec.app_id
4134: ,x_app_no => old_start_rec.app_no

Line 4326: FROM igs_uc_applicants ucap

4322:
4323: CURSOR old_qual_cur(p_appno igs_uc_app_choices.app_no%TYPE) IS
4324: SELECT ucap.rowid,
4325: ucap.*
4326: FROM igs_uc_applicants ucap
4327: WHERE ucap.app_no = p_appno;
4328:
4329: old_qual_rec old_qual_cur%ROWTYPE;
4330:

Line 4387: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls

4383:
4384:
4385: BEGIN
4386: -- call the TBH to update the record
4387: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls
4388: (
4389: x_rowid => old_qual_rec.rowid
4390: ,x_app_id => old_qual_rec.app_id
4391: ,x_app_no => old_qual_rec.app_no

Line 4587: FROM igs_uc_applicants ucap

4583:
4584: CURSOR old_stmt_cur(p_appno igs_uc_app_choices.app_no%TYPE) IS
4585: SELECT ucap.rowid,
4586: ucap.*
4587: FROM igs_uc_applicants ucap
4588: WHERE ucap.app_no = p_appno;
4589:
4590: old_stmt_rec old_stmt_cur%ROWTYPE;
4591:

Line 4658: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls

4654: IF old_stmt_rec.personal_statement IS NULL AND new_ivstmt_rec.statement IS NOT NULL THEN
4655:
4656: -- update the statement as the existing value is null
4657: BEGIN
4658: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls
4659: (
4660: x_rowid => old_stmt_rec.rowid
4661: ,x_app_id => old_stmt_rec.app_id
4662: ,x_app_no => old_stmt_rec.app_no

Line 5099: CURSOR get_appl_dets (p_appno igs_uc_applicants.app_no%TYPE) IS

5095: WHERE code_type = 'PC'
5096: AND code = p_socialclass;
5097:
5098: -- get the system and app_id to be populated into App Choices
5099: CURSOR get_appl_dets (p_appno igs_uc_applicants.app_no%TYPE) IS
5100: SELECT app_id,
5101: system_code
5102: FROM igs_uc_applicants
5103: WHERE app_no = p_appno;

Line 5102: FROM igs_uc_applicants

5098: -- get the system and app_id to be populated into App Choices
5099: CURSOR get_appl_dets (p_appno igs_uc_applicants.app_no%TYPE) IS
5100: SELECT app_id,
5101: system_code
5102: FROM igs_uc_applicants
5103: WHERE app_no = p_appno;
5104:
5105: appl_det_rec get_appl_dets%ROWTYPE;
5106: old_starx_rec old_starx_cur%ROWTYPE;

Line 5408: CURSOR get_appl_dets (p_appno igs_uc_applicants.app_no%TYPE) IS

5404: WHERE code_type = 'PC'
5405: AND code = p_socialclass;
5406:
5407: -- get the system and app_id to be populated into App Choices
5408: CURSOR get_appl_dets (p_appno igs_uc_applicants.app_no%TYPE) IS
5409: SELECT app_id,
5410: system_code
5411: FROM igs_uc_applicants
5412: WHERE app_no = p_appno;

Line 5411: FROM igs_uc_applicants

5407: -- get the system and app_id to be populated into App Choices
5408: CURSOR get_appl_dets (p_appno igs_uc_applicants.app_no%TYPE) IS
5409: SELECT app_id,
5410: system_code
5411: FROM igs_uc_applicants
5412: WHERE app_no = p_appno;
5413:
5414: appl_det_rec get_appl_dets%ROWTYPE;
5415: old_starh_rec old_starh_cur%ROWTYPE;

Line 5731: CURSOR get_appl_dets (p_appno igs_uc_applicants.app_no%TYPE) IS

5727: AND system_code = p_system;
5728:
5729:
5730: -- get the system and app_id to be populated into App Choices
5731: CURSOR get_appl_dets (p_appno igs_uc_applicants.app_no%TYPE) IS
5732: SELECT app_id,
5733: system_code
5734: FROM igs_uc_applicants
5735: WHERE app_no = p_appno;

Line 5734: FROM igs_uc_applicants

5730: -- get the system and app_id to be populated into App Choices
5731: CURSOR get_appl_dets (p_appno igs_uc_applicants.app_no%TYPE) IS
5732: SELECT app_id,
5733: system_code
5734: FROM igs_uc_applicants
5735: WHERE app_no = p_appno;
5736:
5737:
5738:

Line 6283: CURSOR get_appl_dets (p_appno igs_uc_applicants.app_no%TYPE) IS

6279:
6280:
6281:
6282: -- get the system and app_id to be populated into App Choices
6283: CURSOR get_appl_dets (p_appno igs_uc_applicants.app_no%TYPE) IS
6284: SELECT app_id,
6285: system_code
6286: FROM igs_uc_applicants
6287: WHERE app_no = p_appno;

Line 6286: FROM igs_uc_applicants

6282: -- get the system and app_id to be populated into App Choices
6283: CURSOR get_appl_dets (p_appno igs_uc_applicants.app_no%TYPE) IS
6284: SELECT app_id,
6285: system_code
6286: FROM igs_uc_applicants
6287: WHERE app_no = p_appno;
6288:
6289:
6290:

Line 7373: CURSOR get_appl_dets (p_appno igs_uc_applicants.app_no%TYPE) IS

7369: AND uapr.subject_id = p_sub_id;
7370:
7371:
7372: -- get the system and app_id for the Application from UCAS Applicants table.
7373: CURSOR get_appl_dets (p_appno igs_uc_applicants.app_no%TYPE) IS
7374: SELECT app_id,
7375: system_code
7376: FROM igs_uc_applicants
7377: WHERE app_no = p_appno;

Line 7376: FROM igs_uc_applicants

7372: -- get the system and app_id for the Application from UCAS Applicants table.
7373: CURSOR get_appl_dets (p_appno igs_uc_applicants.app_no%TYPE) IS
7374: SELECT app_id,
7375: system_code
7376: FROM igs_uc_applicants
7377: WHERE app_no = p_appno;
7378:
7379: -- get the unique list of appno that would be processed
7380: CURSOR new_appl_cur IS