APPS.IGS_UC_CONFIG_CYCLE dependencies on IGS_UC_DEFAULTS

Line 21: of package igs_uc_defaults_pkg from cur_uc_defaults to

17: (reverse chronological order - newest change first)
18: dsridhar 15-JUL-2003 Tokens added for messages,
19: All messages used on synoyms and objects sdded here.
20: dsridhar 16-JUL-2003 Added cursor cur_uc_defaults_data and changed updation
21: of package igs_uc_defaults_pkg from cur_uc_defaults to
22: cur_uc_defaults_data
23: jbaber 20-JUN-2006 Added new messages for mode CD and CF
24: ***************************************************************/
25:

Line 158: FROM igs_uc_defaults ;

154:
155: -- Get the cycle information from defaults
156: CURSOR cur_cyc_info IS
157: SELECT MAX(current_cycle) current_cycle , MAX(configured_cycle) configured_cycle
158: FROM igs_uc_defaults ;
159:
160: -- Cursor to get the data from IGS_UC_DEFAULTS
161: CURSOR cur_uc_defaults_data IS
162: SELECT iuc.rowid, iuc.*

Line 160: -- Cursor to get the data from IGS_UC_DEFAULTS

156: CURSOR cur_cyc_info IS
157: SELECT MAX(current_cycle) current_cycle , MAX(configured_cycle) configured_cycle
158: FROM igs_uc_defaults ;
159:
160: -- Cursor to get the data from IGS_UC_DEFAULTS
161: CURSOR cur_uc_defaults_data IS
162: SELECT iuc.rowid, iuc.*
163: FROM igs_uc_defaults iuc
164: WHERE system_code <> 'S';

Line 163: FROM igs_uc_defaults iuc

159:
160: -- Cursor to get the data from IGS_UC_DEFAULTS
161: CURSOR cur_uc_defaults_data IS
162: SELECT iuc.rowid, iuc.*
163: FROM igs_uc_defaults iuc
164: WHERE system_code <> 'S';
165:
166: -- Cursor to get the UCAS_INTERFACE for the 'target cycle'
167: CURSOR cur_ucas_interface (cp_ucas_cycle igs_uc_cyc_defaults.ucas_cycle%TYPE,

Line 290: l_configured_cycle igs_uc_defaults.configured_cycle%TYPE;

286: 'IGS_UC_N_CVNCOURSE_2007'
287: );
288:
289: l_cyc_info_rec cur_cyc_info%ROWTYPE;
290: l_configured_cycle igs_uc_defaults.configured_cycle%TYPE;
291: l_current_cycle igs_uc_defaults.current_cycle%TYPE;
292: l_ucas_interface igs_uc_cyc_defaults.ucas_interface%TYPE;
293: l_gttr_interface igs_uc_cyc_defaults.ucas_interface%TYPE;
294: l_nmas_interface igs_uc_cyc_defaults.ucas_interface%TYPE;

Line 291: l_current_cycle igs_uc_defaults.current_cycle%TYPE;

287: );
288:
289: l_cyc_info_rec cur_cyc_info%ROWTYPE;
290: l_configured_cycle igs_uc_defaults.configured_cycle%TYPE;
291: l_current_cycle igs_uc_defaults.current_cycle%TYPE;
292: l_ucas_interface igs_uc_cyc_defaults.ucas_interface%TYPE;
293: l_gttr_interface igs_uc_cyc_defaults.ucas_interface%TYPE;
294: l_nmas_interface igs_uc_cyc_defaults.ucas_interface%TYPE;
295:

Line 1501: igs_uc_defaults_pkg.update_row( x_rowid => rec_cur_defaults.rowid,

1497:
1498: -- Update 'configured cycle' to 'target cycle'
1499: FOR rec_cur_defaults IN cur_uc_defaults_data
1500: LOOP
1501: igs_uc_defaults_pkg.update_row( x_rowid => rec_cur_defaults.rowid,
1502: x_current_inst_code => rec_cur_defaults.current_inst_code,
1503: x_ucas_id_format => rec_cur_defaults.ucas_id_format,
1504: x_test_app_no => rec_cur_defaults.test_app_no,
1505: x_test_choice_no => rec_cur_defaults.test_choice_no,