APPS.IGS_UC_UPD_PENDING_TRANS_PKG dependencies on IGS_UC_DEFAULTS

Line 29: FROM igs_uc_defaults ;

25: jbaber 11-Jul-06 Added modular and part_time fields for UC325 - UCAS 2007 Support
26: -----------------------------------------------------------------------*/
27: CURSOR c_cycle IS
28: SELECT max(current_cycle) current_cycle, max(configured_cycle) configured_cycle
29: FROM igs_uc_defaults ;
30:
31: c_cycle_rec c_cycle%ROWTYPE;
32:
33: CURSOR c_control IS

Line 39: CURSOR c_pending_trans(cp_conf_cycle igs_uc_defaults.configured_cycle%TYPE) IS

35: FROM igs_uc_ucas_control
36: WHERE system_code = 'U'
37: AND ucas_cycle = c_cycle_rec.configured_cycle;
38:
39: CURSOR c_pending_trans(cp_conf_cycle igs_uc_defaults.configured_cycle%TYPE) IS
40: SELECT TRANS.ROWID,
41: TRANS.UC_TRAN_ID,
42: TRANS.TRANSACTION_ID,
43: TRANS.DATETIMESTAMP,

Line 81: CURSOR c_pending_trans_count(cp_conf_cycle igs_uc_defaults.configured_cycle%TYPE) IS

77: AND TRANS.UCAS_CYCLE = DFLTS.UCAS_CYCLE
78: AND DFLTS.UCAS_INTERFACE = 'H'
79: ORDER BY TRANS.CREATION_DATE;
80:
81: CURSOR c_pending_trans_count(cp_conf_cycle igs_uc_defaults.configured_cycle%TYPE) IS
82: SELECT COUNT(*)
83: FROM
84: IGS_UC_TRANSACTIONS TRANS,
85: IGS_UC_CYC_DEFAULTS DFLTS

Line 120: l_entry_year igs_uc_defaults.configured_cycle%TYPE;

116: FROM IGS_UC_APPLICANTS
117: WHERE APP_NO = CP_APPNO;
118:
119: l_soc igs_uc_transactions.SOC%TYPE;
120: l_entry_year igs_uc_defaults.configured_cycle%TYPE;
121: l_pending_cnt NUMBER;
122: l_valid_cnt NUMBER;
123: l_invalid_cnt NUMBER;
124: l_appno igs_uc_u_tranin_2004.appno%TYPE;