APPS.IGS_UC_CONFIG_CYCLE dependencies on IGS_UC_CYC_DEFAULTS

Line 167: CURSOR cur_ucas_interface (cp_ucas_cycle igs_uc_cyc_defaults.ucas_cycle%TYPE,

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,
168: cp_system_code igs_uc_cyc_defaults.system_code%TYPE) IS
169: SELECT ucas_interface
170: FROM IGS_UC_CYC_DEFAULTS
171: WHERE system_code = cp_system_code

Line 168: cp_system_code igs_uc_cyc_defaults.system_code%TYPE) IS

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,
168: cp_system_code igs_uc_cyc_defaults.system_code%TYPE) IS
169: SELECT ucas_interface
170: FROM IGS_UC_CYC_DEFAULTS
171: WHERE system_code = cp_system_code
172: AND ucas_cycle = cp_ucas_cycle;

Line 170: FROM IGS_UC_CYC_DEFAULTS

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,
168: cp_system_code igs_uc_cyc_defaults.system_code%TYPE) IS
169: SELECT ucas_interface
170: FROM IGS_UC_CYC_DEFAULTS
171: WHERE system_code = cp_system_code
172: AND ucas_cycle = cp_ucas_cycle;
173:
174: -- Cursor to get the SYNONYMS

Line 292: l_ucas_interface igs_uc_cyc_defaults.ucas_interface%TYPE;

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:
296: BEGIN

Line 293: l_gttr_interface igs_uc_cyc_defaults.ucas_interface%TYPE;

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:
296: BEGIN
297:

Line 294: l_nmas_interface igs_uc_cyc_defaults.ucas_interface%TYPE;

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:
296: BEGIN
297:
298: --anwest 18-JAN-2006 Bug# 4950285 R12 Disable OSS Mandate