APPS.FTE_BULK_DTT_PKG dependencies on FTE_LOCATION_MILEAGES

Line 11: -- records in FTE_LOCATION_MILEAGES table --

7: -- TYPE: PACKAGE BODY --
8: -- --
9: -- DESCRIPTION: Read a file containing DTT data from the directory specified --
10: -- in FTE_BULKLOAD_PKG.GET_DIRNAME and create location/mileage --
11: -- records in FTE_LOCATION_MILEAGES table --
12: -- --
13: -- PROCEDURE BULK_LOAD_DTT called from BulkLoadDataCO.java to --
14: -- start the loading process. submits a request to a concurrent --
15: -- program to execute the loading process --

Line 441: -- the values into the FTE_LOCATION_MILEAGES table --

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: -- ------------------ --
445: -- --

Line 637: FTE_LOCATION_MILEAGES tt

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:
641:

Line 1960: -- -- fte_location_mileages table using the new funky MErGe stuff.....

1956: --
1957: --
1958: -- --
1959: -- -- All the records are in the temp table now we have to insert/update them into the
1960: -- -- fte_location_mileages table using the new funky MErGe stuff.....
1961: -- --
1962: -- MERGE INTO fte_location_mileages flm
1963: -- USING (SELECT origin_id,
1964: -- destination_id,

Line 1962: -- MERGE INTO fte_location_mileages flm

1958: -- --
1959: -- -- All the records are in the temp table now we have to insert/update them into the
1960: -- -- fte_location_mileages table using the new funky MErGe stuff.....
1961: -- --
1962: -- MERGE INTO fte_location_mileages flm
1963: -- USING (SELECT origin_id,
1964: -- destination_id,
1965: -- identifier_type,
1966: -- distance,

Line 2300: UPDATE FTE_LOCATION_MILEAGES

2296: --
2297: -- Update records exist, doing a bulk update
2298: --
2299: FORALL m in l_u_origin_id_tab.FIRST..l_u_origin_id_tab.LAST
2300: UPDATE FTE_LOCATION_MILEAGES
2301: SET identifier_type = l_u_identifier_type_tab(m),
2302: distance = l_u_distance_tab(m),
2303: distance_uom = l_u_distance_uom_tab(m),
2304: transit_time = l_u_transit_time_tab(m),

Line 2333: insert into FTE_LOCATION_MILEAGES(origin_id,

2329: --
2330: -- Insert records exist, doing a bulk insert
2331: --
2332: FORALL i in l_i_origin_id_tab.FIRST..l_i_origin_id_tab.LAST
2333: insert into FTE_LOCATION_MILEAGES(origin_id,
2334: destination_id,
2335: identifier_type,
2336: distance,
2337: distance_uom,