APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_CRAPR_INTS

Line 998: igs_uc_crapr_ints with record status N

994: /******************************************************************
995: Created By : smaddali
996: Date Created By : 11-Jun-03
997: Purpose : loads each record in the hercules view CVREFAPR into the interface table
998: igs_uc_crapr_ints with record status N
999: Known limitations,enhancements,remarks:
1000: Change History
1001: Who When What
1002: ***************************************************************** */

Line 1037: UPDATE igs_uc_crapr_ints SET record_status = 'O' WHERE record_status = 'N' ;

1033: -- if there is a difference in the timestamps then load all records from hercules view
1034: IF ( l_new_max_timestamp > p_old_timestamp OR p_old_timestamp IS NULL ) THEN
1035:
1036: -- Obsolete all records in interface table with status N
1037: UPDATE igs_uc_crapr_ints SET record_status = 'O' WHERE record_status = 'N' ;
1038:
1039: -- create interface records for each record in the hercules view
1040: FOR c_cvapr_rec IN c_cvapr LOOP
1041: -- set x_sync_read to true if the loop is entered even once

Line 1048: INSERT INTO igs_uc_crapr_ints ( dom,

1044: --Validate varchar to number conversion
1045: IF is_valid(c_cvapr_rec.dom,'CVREFAPR','DOM','NUMBER') THEN
1046:
1047: -- copy hercules record into interface table with record status N
1048: INSERT INTO igs_uc_crapr_ints ( dom,
1049: domtext,
1050: leaflag,
1051: record_status,
1052: error_code )