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_TRANSACTIONS

Line 2511: in IGS_UC_TRANSACTIONS with choice_no = 99 then those records are also updated. Bug#3239860

2507: Who When What
2508: arvsrini 05-MAR-04 Added code to check before inserting records to IGS_UC_APP_CHOICES whether there exists record with
2509: same institution code and system code but having choice number as 99.If there exists no records, then insert is performed
2510: If it exists, the record is updated using choice number as IGS_UC_ISTARC_INTS.CHOICENO. Also if there exists records
2511: in IGS_UC_TRANSACTIONS with choice_no = 99 then those records are also updated. Bug#3239860
2512: jchakrab 23-AUG-04 Modified for Bug# 3837871 - Update system_code of existing app_choice records in
2513: IGS_UC_APP_CHOICES with current cycle's system_code in IGS_UC_APLICANTS
2514: jbaber 15-Sep-05 Entryyear defaults if NULL for all systems
2515: anwest 29-May-06 Bug #5190520 UCTD320 - UCAS 2006 CLEARING ISSUES

Line 2581: CURSOR uc_transaction_9_cur(p_app_no igs_uc_transactions.app_no%TYPE) IS

2577: FROM igs_uc_defaults
2578: WHERE system_code = p_sys_code;
2579:
2580: -- 29-MAY-2006 anwest Bug #5190520 UCTD320 - UCAS 2006 CLEARING ISSUES
2581: CURSOR uc_transaction_9_cur(p_app_no igs_uc_transactions.app_no%TYPE) IS
2582: SELECT trans.rowid,
2583: trans.*
2584: FROM igs_uc_transactions trans
2585: WHERE trans.app_no = p_app_no

Line 2584: FROM igs_uc_transactions trans

2580: -- 29-MAY-2006 anwest Bug #5190520 UCTD320 - UCAS 2006 CLEARING ISSUES
2581: CURSOR uc_transaction_9_cur(p_app_no igs_uc_transactions.app_no%TYPE) IS
2582: SELECT trans.rowid,
2583: trans.*
2584: FROM igs_uc_transactions trans
2585: WHERE trans.app_no = p_app_no
2586: AND trans.choice_no = 9;
2587:
2588:

Line 2916: --in IGS_UC_TRANSACTIONS with choice_no = 99 then those records are also updated. Bug#3239860

2912:
2913: END IF;
2914:
2915: --the record is to be updated using choice number as IGS_UC_ISTARC_INTS.CHOICENO. Also if there exists records
2916: --in IGS_UC_TRANSACTIONS with choice_no = 99 then those records are also updated. Bug#3239860
2917:
2918:
2919: BEGIN
2920:

Line 2924: igs_uc_transactions_pkg.update_row

2920:
2921: -- 29-MAY-2006 anwest Bug #5190520 UCTD320 - UCAS 2006 CLEARING ISSUES
2922: FOR uc_transaction_rec IN uc_transaction_9_cur(new_ivstarc_rec.appno)
2923: LOOP
2924: igs_uc_transactions_pkg.update_row
2925: (
2926: x_rowid => uc_transaction_rec.rowid,
2927: x_uc_tran_id => uc_transaction_rec.uc_tran_id,
2928: x_transaction_id => uc_transaction_rec.transaction_id,

Line 3252: in IGS_UC_TRANSACTIONS with choice_no = 99 then those records are also updated.Bug#3239860

3248: Who When What
3249: arvsrini 08-MAR-04 Added code to check before inserting records to IGS_UC_APP_CHOICES whether there exists record with
3250: same institution code and system code but having choice number as 99.If there exists no records, then insert is performed
3251: If it exists, the record is updated using choice number as IGS_UC_ISTARC_INTS.ROUNDNO. Also if there exists records
3252: in IGS_UC_TRANSACTIONS with choice_no = 99 then those records are also updated.Bug#3239860
3253: ******************************************************************/
3254:
3255: CURSOR new_ivstarg_cur IS
3256: SELECT ivstk.rowid,

Line 3314: CURSOR uc_transaction_cur(p_app_no igs_uc_transactions.app_no%TYPE) IS

3310: SELECT current_inst_code
3311: FROM igs_uc_defaults
3312: WHERE system_code = p_sys_code;
3313:
3314: CURSOR uc_transaction_cur(p_app_no igs_uc_transactions.app_no%TYPE) IS
3315: SELECT trans.rowid,
3316: trans.*
3317: FROM igs_uc_transactions trans
3318: WHERE trans.app_no = p_app_no

Line 3317: FROM igs_uc_transactions trans

3313:
3314: CURSOR uc_transaction_cur(p_app_no igs_uc_transactions.app_no%TYPE) IS
3315: SELECT trans.rowid,
3316: trans.*
3317: FROM igs_uc_transactions trans
3318: WHERE trans.app_no = p_app_no
3319: AND trans.choice_no = 99;
3320:
3321:

Line 3728: --in IGS_UC_TRANSACTIONS with choice_no = 99 then those records are also updated.Bug#3239860

3724: END IF;
3725:
3726:
3727: --If it exists, the record is updated using choice number as IGS_UC_ISTARC_INTS.ROUNDNO. Also if there exists records
3728: --in IGS_UC_TRANSACTIONS with choice_no = 99 then those records are also updated.Bug#3239860
3729:
3730:
3731: BEGIN
3732:

Line 3735: igs_uc_transactions_pkg.update_row

3731: BEGIN
3732:
3733: FOR uc_transaction_rec IN uc_transaction_cur(new_ivstarg_rec.appno)
3734: LOOP
3735: igs_uc_transactions_pkg.update_row
3736: (
3737: x_rowid => uc_transaction_rec.rowid,
3738: x_uc_tran_id => uc_transaction_rec.uc_tran_id,
3739: x_transaction_id => uc_transaction_rec.transaction_id,