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.

[Home] [Help]

APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_APP_CLEARING

Line 5705: CURSOR old_starz1_cur(p_appno igs_uc_app_clearing.app_no%TYPE) IS

5701: FROM igs_uc_istarz1_ints ivstz1
5702: WHERE ivstz1.record_status = 'N';
5703:
5704: -- check for corresponding record in main table.
5705: CURSOR old_starz1_cur(p_appno igs_uc_app_clearing.app_no%TYPE) IS
5706: SELECT uacl.rowid,
5707: uacl.*
5708: FROM igs_uc_app_clearing uacl
5709: WHERE uacl.app_no = p_appno;

Line 5708: FROM igs_uc_app_clearing uacl

5704: -- check for corresponding record in main table.
5705: CURSOR old_starz1_cur(p_appno igs_uc_app_clearing.app_no%TYPE) IS
5706: SELECT uacl.rowid,
5707: uacl.*
5708: FROM igs_uc_app_clearing uacl
5709: WHERE uacl.app_no = p_appno;
5710:
5711: -- validate Institution value
5712: CURSOR validate_inst (p_inst igs_uc_app_clearing.institution%TYPE) IS

Line 5712: CURSOR validate_inst (p_inst igs_uc_app_clearing.institution%TYPE) IS

5708: FROM igs_uc_app_clearing uacl
5709: WHERE uacl.app_no = p_appno;
5710:
5711: -- validate Institution value
5712: CURSOR validate_inst (p_inst igs_uc_app_clearing.institution%TYPE) IS
5713: SELECT ucas, gttr, nmas, swas
5714: FROM igs_uc_com_inst
5715: WHERE inst = p_inst;
5716:

Line 5790: l_campus_clr igs_uc_app_clearing.campus%TYPE;

5786: l_decision igs_uc_app_choices.decision%TYPE;
5787: l_reply igs_uc_app_choices.reply%TYPE;
5788:
5789: -- 02-AUG-2006 anwest Bug #5440216 URGENT - UCAS CLEARING 2006 - PART 2 - CLEARING CHOICE NUMBER NULL
5790: l_campus_clr igs_uc_app_clearing.campus%TYPE;
5791: l_campus_chc igs_uc_app_choices.campus%TYPE;
5792:
5793:
5794:

Line 5949: igs_uc_app_clearing_pkg.insert_row -- IGSXI04B.pls

5945: IF old_starz1_rec.rowid IS NULL THEN -- i.e. new record.
5946:
5947: BEGIN
5948: -- call the TBH to update the record
5949: igs_uc_app_clearing_pkg.insert_row -- IGSXI04B.pls
5950: (
5951: x_rowid => old_starz1_rec.rowid -- it would be NULL since rec not found.
5952: ,x_clearing_app_id => old_starz1_rec.clearing_app_id -- since it would be NULL as rec not found
5953: ,x_app_id => appl_det_rec.app_id

Line 5983: igs_uc_app_clearing_pkg.update_row -- IGSXI04B.pls

5979: ELSE -- update
5980:
5981: BEGIN
5982: -- call the TBH to update the record
5983: igs_uc_app_clearing_pkg.update_row -- IGSXI04B.pls
5984: (
5985: x_rowid => old_starz1_rec.rowid
5986: ,x_clearing_app_id => old_starz1_rec.clearing_app_id
5987: ,x_app_id => old_starz1_rec.app_id

Line 6292: CURSOR validate_clearing_cur(p_appno igs_uc_app_clearing.app_no%TYPE) IS

6288:
6289:
6290:
6291: -- check for corresponding Parent record in App Clearing table.
6292: CURSOR validate_clearing_cur(p_appno igs_uc_app_clearing.app_no%TYPE) IS
6293: SELECT clearing_app_id
6294: FROM igs_uc_app_clearing
6295: WHERE app_no = p_appno;
6296:

Line 6294: FROM igs_uc_app_clearing

6290:
6291: -- check for corresponding Parent record in App Clearing table.
6292: CURSOR validate_clearing_cur(p_appno igs_uc_app_clearing.app_no%TYPE) IS
6293: SELECT clearing_app_id
6294: FROM igs_uc_app_clearing
6295: WHERE app_no = p_appno;
6296:
6297:
6298: -- validate Institution value

Line 6299: CURSOR validate_inst (p_inst igs_uc_app_clearing.institution%TYPE) IS

6295: WHERE app_no = p_appno;
6296:
6297:
6298: -- validate Institution value
6299: CURSOR validate_inst (p_inst igs_uc_app_clearing.institution%TYPE) IS
6300: SELECT ucas, gttr, nmas, swas
6301: FROM igs_uc_com_inst
6302: WHERE inst = p_inst;
6303:

Line 6328: l_clearing_id igs_uc_app_clearing.clearing_app_id%TYPE; -- for holding clearing ID needed while insert

6324: validate_inst_rec validate_inst%ROWTYPE; -- Holding/validating of Institution details
6325: appl_det_rec get_appl_dets%ROWTYPE; -- Holding App ID and System Info. from UCAS Applicants.
6326: old_starz2_rec old_starz2_cur%ROWTYPE;
6327: l_valid VARCHAR2(1);
6328: l_clearing_id igs_uc_app_clearing.clearing_app_id%TYPE; -- for holding clearing ID needed while insert
6329:
6330: l_oss_program igs_uc_app_clr_rnd.oss_program_code%TYPE ;
6331: l_oss_program_ver igs_uc_app_clr_rnd.oss_program_version%TYPE ;
6332: l_oss_attend_type igs_uc_app_clr_rnd.oss_attendance_type%TYPE ;