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_MV_DATA_UPLD dependencies on IGS_UC_CYC_DEFAULTS

Line 53: | calendar fields in igs_uc_cyc_defaults_pkg. |

49: | UCFD203-Multiple cycles build, bug 2669208 |
50: | smaddali 30-Jun-03 Modified for Bug#2669208 , UCFD203 -multiple cycles |
51: | dsridhar 25-Jul-03 Bug No: 3022067, part of change request for UCAS |
52: | Application Calendar Mapping. Removed references to |
53: | calendar fields in igs_uc_cyc_defaults_pkg. |
54: | ayedubat 30-Jul-03 Changed the procedure,transfer_to_starw to replace |
55: | the column names substchoice1, substchoice2, |
56: | substchoice3, substchoice4, substchoice5, |
57: | substchoice6 and substchoice7 with choice1lost, |

Line 195: || to get the marvin seq no from igs_uc_cyc_defaults, since

191: || Known limitations, enhancements or remarks :
192: || Change History :
193: || Who When What
194: || smaddali 30-jun-03 modified for ucfd203 - multiple cycles build ,bug#2669208
195: || to get the marvin seq no from igs_uc_cyc_defaults, since
196: || igs_uc_adm_systems is obsolete
197: || dsridhar 25-JUL-2003 Bug No: 3022067, part of change request for UCAS Application Calendar Mapping.
198: || Removed references to calendar fields in igs_uc_cyc_defaults_pkg.
199: || (reverse chronological order - newest change first)

Line 198: || Removed references to calendar fields in igs_uc_cyc_defaults_pkg.

194: || smaddali 30-jun-03 modified for ucfd203 - multiple cycles build ,bug#2669208
195: || to get the marvin seq no from igs_uc_cyc_defaults, since
196: || igs_uc_adm_systems is obsolete
197: || dsridhar 25-JUL-2003 Bug No: 3022067, part of change request for UCAS Application Calendar Mapping.
198: || Removed references to calendar fields in igs_uc_cyc_defaults_pkg.
199: || (reverse chronological order - newest change first)
200: */
201:
202: -- To identify the system to which the file sequence number transaction has come.

Line 212: CURSOR c_cyc_defaults(cp_syscode igs_uc_cyc_defaults.system_code%TYPE) IS

208: WHERE marvin_id = p_marvin_id - 1;
209:
210: -- Cursor to get the existing sequence number for the coresponding system
211: -- smaddali modified cursor for bug #2669208 , ucfd203 build, igs_uc_adm_systems is now merged with igs_uc_defaults
212: CURSOR c_cyc_defaults(cp_syscode igs_uc_cyc_defaults.system_code%TYPE) IS
213: SELECT a.rowid , a.* , b.name
214: FROM igs_uc_cyc_defaults a , igs_uc_defaults b
215: WHERE a.system_code = b.system_code
216: AND a.system_code = cp_syscode

Line 214: FROM igs_uc_cyc_defaults a , igs_uc_defaults b

210: -- Cursor to get the existing sequence number for the coresponding system
211: -- smaddali modified cursor for bug #2669208 , ucfd203 build, igs_uc_adm_systems is now merged with igs_uc_defaults
212: CURSOR c_cyc_defaults(cp_syscode igs_uc_cyc_defaults.system_code%TYPE) IS
213: SELECT a.rowid , a.* , b.name
214: FROM igs_uc_cyc_defaults a , igs_uc_defaults b
215: WHERE a.system_code = b.system_code
216: AND a.system_code = cp_syscode
217: AND a.ucas_cycle = g_c_cycles.configured_cycle ;
218:

Line 240: igs_uc_cyc_defaults_pkg.update_row (

236: fnd_message.set_token('SEQ', p_curr_seq_num);
237: fnd_file.put_line(fnd_file.log, fnd_message.get());
238:
239: --Update the Marvin file seq number in the setup table.
240: igs_uc_cyc_defaults_pkg.update_row (
241: x_rowid => cyc_defaults_rec.rowid,
242: x_system_code => cyc_defaults_rec.system_code,
243: x_ucas_cycle => cyc_defaults_rec.ucas_cycle,
244: x_ucas_interface => cyc_defaults_rec.ucas_interface,

Line 290: CURSOR c_cyc_defaults(cp_syscode igs_uc_cyc_defaults.system_code%TYPE) IS

286: WHERE marvin_id = cp_marvin_id - 1;
287:
288: -- Cursor to get the existing sequence number for the coresponding system
289: -- smaddali modified cursor for bug #2669208 , ucfd203 build, igs_uc_adm_systems is now merged with igs_uc_defaults
290: CURSOR c_cyc_defaults(cp_syscode igs_uc_cyc_defaults.system_code%TYPE) IS
291: SELECT a.rowid , a.* , b.name
292: FROM igs_uc_cyc_defaults a , igs_uc_defaults b
293: WHERE a.system_code = b.system_code
294: AND a.system_code = cp_syscode

Line 292: FROM igs_uc_cyc_defaults a , igs_uc_defaults b

288: -- Cursor to get the existing sequence number for the coresponding system
289: -- smaddali modified cursor for bug #2669208 , ucfd203 build, igs_uc_adm_systems is now merged with igs_uc_defaults
290: CURSOR c_cyc_defaults(cp_syscode igs_uc_cyc_defaults.system_code%TYPE) IS
291: SELECT a.rowid , a.* , b.name
292: FROM igs_uc_cyc_defaults a , igs_uc_defaults b
293: WHERE a.system_code = b.system_code
294: AND a.system_code = cp_syscode
295: AND a.ucas_cycle = g_c_cycles.configured_cycle ;
296:

Line 2365: || a. Data file contains valid supported file formats specified in the igs_uc_cyc_defaults

2361: /*
2362: || Created By : brajendr
2363: || Created On :
2364: || Purpose : Function returns TRUE if the
2365: || a. Data file contains valid supported file formats specified in the igs_uc_cyc_defaults
2366: || b. Profile interface value is set to Marvin
2367: || c. Data file contains valid data sections with number of Headers and Trailers are equal
2368: || Else this function returns FALSE.
2369: || Known limitations, enhancements or remarks :

Line 2373: || replaced profile for interface type by igs_uc_cyc_defaults

2369: || Known limitations, enhancements or remarks :
2370: || Change History :
2371: || Who When What
2372: || smaddali 30-jun-03 Modified for ucfd203- multiple cycles build , bug#2669208
2373: || replaced profile for interface type by igs_uc_cyc_defaults
2374: || (reverse chronological order - newest change first)
2375: */
2376:
2377: -- Check for the count of the number of the Headers and trailers

Line 2394: CURSOR c_interface(cp_sys_code igs_uc_cyc_defaults.system_code%TYPE) IS

2390:
2391: ln_count NUMBER := 0 ;
2392:
2393: -- smaddali added cursor for bug#2669208 , ucfd203 build
2394: CURSOR c_interface(cp_sys_code igs_uc_cyc_defaults.system_code%TYPE) IS
2395: SELECT ucas_interface
2396: FROM igs_uc_cyc_defaults
2397: WHERE system_code = cp_sys_code
2398: AND ucas_cycle = g_c_cycles.configured_cycle ;

Line 2396: FROM igs_uc_cyc_defaults

2392:
2393: -- smaddali added cursor for bug#2669208 , ucfd203 build
2394: CURSOR c_interface(cp_sys_code igs_uc_cyc_defaults.system_code%TYPE) IS
2395: SELECT ucas_interface
2396: FROM igs_uc_cyc_defaults
2397: WHERE system_code = cp_sys_code
2398: AND ucas_cycle = g_c_cycles.configured_cycle ;
2399: c_interface_rec c_interface%ROWTYPE ;
2400: