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_LOAD_HERCULES_DATA dependencies on IGS_UC_CRPREPO_INTS

Line 3959: igs_uc_crprepo_ints with record status N

3955: /******************************************************************
3956: Created By : smaddali
3957: Date Created By : 11-Jun-03
3958: Purpose : loads each record in the hercules view cvrefpre2000pocc into the interface table
3959: igs_uc_crprepo_ints with record status N
3960: Known limitations,enhancements,remarks:
3961: Change History
3962: Who When What
3963: ***************************************************************** */

Line 3986: UPDATE igs_uc_crprepo_ints SET record_status = 'O' WHERE record_status = 'N' ;

3982: -- log message that this view is being loaded
3983: log_start('CVREFPRE2000POCC ON ' ) ;
3984:
3985: -- Obsolete records in interface table with status N
3986: UPDATE igs_uc_crprepo_ints SET record_status = 'O' WHERE record_status = 'N' ;
3987:
3988: -- create interface records for each record in the hercules view
3989: FOR c_cvprepocc_rec IN c_cvprepocc LOOP
3990: -- set x_sync_read to true if the loop is entered even once

Line 3994: INSERT INTO igs_uc_crprepo_ints( pocc,

3990: -- set x_sync_read to true if the loop is entered even once
3991: g_sync_reqd := TRUE;
3992:
3993: -- copy hercules record into interface table with record status N
3994: INSERT INTO igs_uc_crprepo_ints( pocc,
3995: socialclass,
3996: occupationtext,
3997: alternativetext,
3998: alternateclass1,