APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_CRSUBJ_INTS

Line 4182: igs_uc_crsubj_ints with record status N

4178: /******************************************************************
4179: Created By : smaddali
4180: Date Created By : 11-Jun-03
4181: Purpose : loads each record in the hercules view cvrefsubj into the interface table
4182: igs_uc_crsubj_ints with record status N
4183: Known limitations,enhancements,remarks:
4184: Change History
4185: Who When What
4186: jbaber 15-Sep-05 Replace subjtext value with '*' if NULL for bug 4589994

Line 4208: UPDATE igs_uc_crsubj_ints SET record_status = 'O' WHERE record_status = 'N' ;

4204: -- log message that this view is being loaded
4205: log_start( 'CVREFSUBJ ON ') ;
4206:
4207: -- Obsolete records in interface table with status N
4208: UPDATE igs_uc_crsubj_ints SET record_status = 'O' WHERE record_status = 'N' ;
4209:
4210: -- create interface records for each record in the hercules view
4211: FOR c_cvsubj_rec IN c_cvsubj LOOP
4212: -- set x_sync_read to true if the loop is entered even once

Line 4216: INSERT INTO igs_uc_crsubj_ints( subjcode,

4212: -- set x_sync_read to true if the loop is entered even once
4213: g_sync_reqd := TRUE;
4214:
4215: -- copy hercules record into interface table with record status N
4216: INSERT INTO igs_uc_crsubj_ints( subjcode,
4217: subjtext,
4218: subjabbrev,
4219: ebl_subj,
4220: record_status,