APPS.IGS_UC_START_NEW_CYCLE dependencies on IGS_UC_CYC_DEFAULTS

Line 23: Removed calendar fields from the IGS_UC_CYC_DEFAULTS_PKG procedure calls.

19: dsridhar 16-JUL-2003 Changed cursor cur_uc_defaults, added new cursor, added code to run the process
20: when maximum current cycle and maximum configured cycle are NULL
21: dsridhar 17-JUL-2003 Added code to display message after updating igs_uc_defaults
22: dsridhar 24-JUL-2003 Bug No: 3022067, part of change request for UCAS Application Calendar Mapping.
23: Removed calendar fields from the IGS_UC_CYC_DEFAULTS_PKG procedure calls.
24: jchakrab 20-Sep-2005 Modified for 4616246 - If a record with null current/conf cycle is found in
25: IGS_UC_DEFAULTS and no record exists for the current cycle in IGS_UC_TRANSACTIONS
26: a empty record is inserted into IGS_UC_UCAS_CONTROL to be updated later by user
27: anwest 18-JAN-2006 Bug# 4950285 R12 Disable OSS Mandate

Line 64: -- Cursor to select the Current Cycle details from IGS_UC_CYC_DEFAULTS

60: AND TO_NUMBER(lookup_code) = p_current_cycle + 1
61: AND enabled_flag = 'Y'
62: AND NVL(closed_Ind, 'N') = 'N';
63:
64: -- Cursor to select the Current Cycle details from IGS_UC_CYC_DEFAULTS
65: -- Modified for UC315 - UCAS 2006 Support to exclude SWAS
66: CURSOR cur_uc_cyc_defaults (p_current_cycle igs_uc_defaults.current_cycle%TYPE) IS
67: SELECT ucd.*
68: FROM igs_uc_cyc_defaults ucd

Line 68: FROM igs_uc_cyc_defaults ucd

64: -- Cursor to select the Current Cycle details from IGS_UC_CYC_DEFAULTS
65: -- Modified for UC315 - UCAS 2006 Support to exclude SWAS
66: CURSOR cur_uc_cyc_defaults (p_current_cycle igs_uc_defaults.current_cycle%TYPE) IS
67: SELECT ucd.*
68: FROM igs_uc_cyc_defaults ucd
69: WHERE ucas_cycle = p_current_cycle
70: AND ucd.system_code <> 'S';
71:
72: -- Cursor to check if the record exists in IGS_UC_CYC_DEFAULTS

Line 72: -- Cursor to check if the record exists in IGS_UC_CYC_DEFAULTS

68: FROM igs_uc_cyc_defaults ucd
69: WHERE ucas_cycle = p_current_cycle
70: AND ucd.system_code <> 'S';
71:
72: -- Cursor to check if the record exists in IGS_UC_CYC_DEFAULTS
73: CURSOR cur_check_uc_cyc_defaults (p_system_code igs_uc_cyc_defaults.system_code%TYPE,
74: p_ucas_cycle igs_uc_cyc_defaults.ucas_cycle%TYPE) IS
75: SELECT 'X'
76: FROM igs_uc_cyc_defaults ucd

Line 73: CURSOR cur_check_uc_cyc_defaults (p_system_code igs_uc_cyc_defaults.system_code%TYPE,

69: WHERE ucas_cycle = p_current_cycle
70: AND ucd.system_code <> 'S';
71:
72: -- Cursor to check if the record exists in IGS_UC_CYC_DEFAULTS
73: CURSOR cur_check_uc_cyc_defaults (p_system_code igs_uc_cyc_defaults.system_code%TYPE,
74: p_ucas_cycle igs_uc_cyc_defaults.ucas_cycle%TYPE) IS
75: SELECT 'X'
76: FROM igs_uc_cyc_defaults ucd
77: WHERE system_code = p_system_code

Line 74: p_ucas_cycle igs_uc_cyc_defaults.ucas_cycle%TYPE) IS

70: AND ucd.system_code <> 'S';
71:
72: -- Cursor to check if the record exists in IGS_UC_CYC_DEFAULTS
73: CURSOR cur_check_uc_cyc_defaults (p_system_code igs_uc_cyc_defaults.system_code%TYPE,
74: p_ucas_cycle igs_uc_cyc_defaults.ucas_cycle%TYPE) IS
75: SELECT 'X'
76: FROM igs_uc_cyc_defaults ucd
77: WHERE system_code = p_system_code
78: AND ucas_cycle = p_ucas_cycle;

Line 76: FROM igs_uc_cyc_defaults ucd

72: -- Cursor to check if the record exists in IGS_UC_CYC_DEFAULTS
73: CURSOR cur_check_uc_cyc_defaults (p_system_code igs_uc_cyc_defaults.system_code%TYPE,
74: p_ucas_cycle igs_uc_cyc_defaults.ucas_cycle%TYPE) IS
75: SELECT 'X'
76: FROM igs_uc_cyc_defaults ucd
77: WHERE system_code = p_system_code
78: AND ucas_cycle = p_ucas_cycle;
79:
80: -- Cursor to select current cycle details from IGS_UC_UCAS_CONTROL

Line 285: -- Populate records for new cycle in IGS_UC_CYC_DEFAULTS from previous cycle.

281:
282: -- If next cycle is not null i.e. Current Cycle + 1 is supported
283: IF l_next_cycle IS NOT NULL THEN
284:
285: -- Populate records for new cycle in IGS_UC_CYC_DEFAULTS from previous cycle.
286: FOR rec_uc_cyc_defaults IN cur_uc_cyc_defaults (l_current_cycle)
287: LOOP
288: l_exists := NULL;
289: OPEN cur_check_uc_cyc_defaults(rec_uc_cyc_defaults.system_code, l_next_cycle);

Line 294: igs_uc_cyc_defaults_pkg.insert_row( x_rowid => l_rowid,

290: FETCH cur_check_uc_cyc_defaults INTO l_exists;
291: CLOSE cur_check_uc_cyc_defaults;
292: IF l_exists IS NULL THEN
293: l_rowid := NULL;
294: igs_uc_cyc_defaults_pkg.insert_row( x_rowid => l_rowid,
295: x_SYSTEM_CODE => rec_uc_cyc_defaults.system_code,
296: x_UCAS_CYCLE => l_next_cycle,
297: x_UCAS_INTERFACE => rec_uc_cyc_defaults.ucas_interface,
298: x_MARVIN_SEQ => 0,

Line 306: fnd_message.set_token('TNAME', 'IGS_UC_CYC_DEFAULTS');

302: x_MODE => 'R'
303: );
304:
305: fnd_message.set_name('IGS', 'IGS_UC_REC_INSRT');
306: fnd_message.set_token('TNAME', 'IGS_UC_CYC_DEFAULTS');
307: fnd_message.set_token('SYSTEM_CODE', rec_uc_cyc_defaults.system_code);
308: fnd_file.put_line(fnd_file.log, fnd_message.get);
309: END IF;
310: