APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_CTARIFF_INTS

Line 2429: igs_uc_ctariff_ints with record status N

2425: /******************************************************************
2426: Created By : smaddali
2427: Date Created By : 11-Jun-03
2428: Purpose : loads each record in the hercules view cvreftariff into the interface table
2429: igs_uc_ctariff_ints with record status N
2430: Known limitations,enhancements,remarks:
2431: Change History
2432: Who When What
2433: ***************************************************************** */

Line 2465: UPDATE igs_uc_ctariff_ints SET record_status = 'O' WHERE record_status = 'N' ;

2461: -- if there is a difference in the timestamps then load all records from hercules view
2462: IF ( l_new_max_timestamp > p_old_timestamp OR p_old_timestamp IS NULL ) THEN
2463:
2464: -- Obsolete all records in interface table with status N
2465: UPDATE igs_uc_ctariff_ints SET record_status = 'O' WHERE record_status = 'N' ;
2466:
2467: -- create interface records for each record in the hercules view
2468: FOR c_cvtariff_rec IN c_cvtariff LOOP
2469: -- set x_sync_read to true if the loop is entered even once

Line 2473: INSERT INTO igs_uc_ctariff_ints ( examlevel,

2469: -- set x_sync_read to true if the loop is entered even once
2470: g_sync_reqd := TRUE;
2471:
2472: -- copy hercules record into interface table with record status N
2473: INSERT INTO igs_uc_ctariff_ints ( examlevel,
2474: examgrade,
2475: tariffscore,
2476: record_status,
2477: error_code )