[Home] [Help]
436: -- --
437: -- DESCRIPTION: Reads the DTT data file. Gets the relevant origin and --
438: -- destination ids from fte_mile_download_lines and --
439: -- stores the information in a global temp table: --
440: -- FTE_DISTANCE_LOADER_TMP and then inserts or updates --
441: -- the values into the FTE_LOCATION_MILEAGES table --
442: -- --
443: -- CHANGE CONTROL LOG --
444: -- ------------------ --
632: last_update_login,
633: program_application_id,
634: program_id,
635: program_update_date,
636: request_id FROM FTE_DISTANCE_LOADER_TMP) fdlt,
637: FTE_LOCATION_MILEAGES tt
638: where fdlt.origin_id = tt.origin_id(+)
639: and fdlt.destination_id = tt.destination_id(+);
640:
1514: l_location_request_id(l_load_ctr) := p_load_id;
1515:
1516: IF (l_load_ctr = 250) THEN
1517: IF l_debug_on THEN
1518: WSH_DEBUG_SV.logmsg(l_module_name,'we are going to insert 250 at a time into the global temp table insert into fte_distance_loader_tmp');
1519: END IF;
1520: --
1521: FND_FILE.PUT_LINE(FND_FILE.log, 'Inserting 250 records into temp table');
1522: --
1523: -- we are going to insert 250 at a time into the global
1524: -- temp table
1525: --
1526: FORALL i in l_location_origin_id.FIRST..l_location_origin_id.LAST
1527: insert into fte_distance_loader_tmp(ORIGIN_ID,
1528: DESTINATION_ID,
1529: IDENTIFIER_TYPE,
1530: DISTANCE,
1531: DISTANCE_UOM,
1871:
1872: FND_FILE.PUT_LINE(FND_FILE.log, 'Inserting remainder of records into temp table');
1873:
1874: FORALL i in l_location_origin_id.FIRST..l_location_origin_id.LAST
1875: insert into fte_distance_loader_tmp(ORIGIN_ID,
1876: DESTINATION_ID,
1877: IDENTIFIER_TYPE,
1878: DISTANCE,
1879: DISTANCE_UOM,
1974: -- last_update_login,
1975: -- program_application_id,
1976: -- program_id,
1977: -- program_update_date,
1978: -- request_id FROM FTE_DISTANCE_LOADER_TMP) fdlt
1979: -- ON (flm.origin_id = fdlt.origin_id AND
1980: -- flm.destination_id = fdlt.destination_id)
1981: -- WHEN MATCHED THEN UPDATE SET flm.identifier_type = fdlt.identifier_type,
1982: -- flm.distance = fdlt.distance,