APPS.FTE_LTL_LOADER dependencies on FTE_BULKLOAD_FILE

Line 2531: -- Analyze the data in FTE_BULKLOAD_FILE:

2527: --
2528: -- PROCEDURE: LOAD_RATE_CHARTS
2529: --
2530: -- PURPOSE
2531: -- Analyze the data in FTE_BULKLOAD_FILE:
2532: -- a. Identify the destinations sharing the same rate chart and group
2533: -- them in the same zone. Put this information in FTE_INTERFACE_ZONES.
2534: -- b. Create a rate chart for each zone. Put this chart information
2535: -- into the QP_INTERFACE tables and later into the QP tables.

Line 2635: -- Analyze the data in FTE_BULKLOAD_FILE:

2631: -- PROCEDURE: BUILD_ZONES_AND_CHARTS
2632: --
2633: -- PURPOSE
2634: --
2635: -- Analyze the data in FTE_BULKLOAD_FILE:
2636: -- a. Identify the destinations sharing the same rate chart and group
2637: -- them in the same zone. Put this information in FTE_INTERFACE_ZONES.
2638: -- b. Create a rate chart for each zone. Put this chart information
2639: -- into the QP_INTERFACE tables and later into the QP tables.

Line 2715: fte_bulkload_file

2711: SELECT DISTINCT
2712: origin_low,
2713: origin_high
2714: FROM
2715: fte_bulkload_file
2716: WHERE
2717: load_id = p_load_id;
2718:
2719: --+

Line 2735: fte_bulkload_file

2731: dest_high,
2732: class,
2733: lpad(min_charge1,6,'0')
2734: FROM
2735: fte_bulkload_file
2736: WHERE
2737: load_id = p_load_id AND
2738: origin_low = p_origin_low
2739: ORDER BY dest_low, dest_high, TO_NUMBER(class) desc;

Line 3799: -- Create the lanes, zones and rate charts from the data in FTE_BULKLOAD_FILE.

3795: --
3796: -- PROCEDURE: LOAD_TEMP_TABLES
3797: --
3798: -- Purpose
3799: -- Create the lanes, zones and rate charts from the data in FTE_BULKLOAD_FILE.
3800: --
3801: -- It calls 4 sub procedures.
3802: -- i. BUILD_ZONES_AND_CHARTS
3803: -- ii. MANAGE_ZONES

Line 4073: -- Insert the read data into FTE_BULKLOAD_FILE.

4069: --
4070: -- PROCEDURE: INSERT_LTL_DATA
4071: --
4072: -- PURPOSE:
4073: -- Insert the read data into FTE_BULKLOAD_FILE.
4074: --
4075: -- PARAMETERS:
4076: -- IN
4077: -- p_load_id, the load id for the current job.

Line 4098: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Inserting ' || FL_ORIGIN_LOW.COUNT || ' rows into fte_bulkload_file.');

4094: FTE_UTIL_PKG.Enter_Debug(l_module_name);
4095: x_status := -1;
4096:
4097: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN
4098: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Inserting ' || FL_ORIGIN_LOW.COUNT || ' rows into fte_bulkload_file.');
4099: END IF;
4100:
4101: FORALL i in 1..FL_ORIGIN_LOW.COUNT
4102: INSERT INTO FTE_BULKLOAD_FILE ( LOAD_ID,

Line 4102: INSERT INTO FTE_BULKLOAD_FILE ( LOAD_ID,

4098: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Inserting ' || FL_ORIGIN_LOW.COUNT || ' rows into fte_bulkload_file.');
4099: END IF;
4100:
4101: FORALL i in 1..FL_ORIGIN_LOW.COUNT
4102: INSERT INTO FTE_BULKLOAD_FILE ( LOAD_ID,
4103: ORIGIN_LOW,
4104: ORIGIN_HIGH,
4105: DEST_LOW,
4106: DEST_HIGH,

Line 4356: -- contents in FTE_BULKLOAD_FILE.

4352: -- PROCEDURE: READ_LTL_FILE_FROM_TABLE
4353: --
4354: -- PURPOSE
4355: -- Read the LTL data file from the table FTE_BULKLOAD_DATA and insert the
4356: -- contents in FTE_BULKLOAD_FILE.
4357: --
4358: -- PARAMETERS
4359: -- IN
4360: -- 1. p_file_name: The filename of the data file.

Line 4487: -- Read the LTL data file and insert the contents in FTE_BULKLOAD_FILE.

4483: --
4484: -- PROCEDURE: READ_LTL_FILE_FROM_DIR
4485: --
4486: -- Purpose:
4487: -- Read the LTL data file and insert the contents in FTE_BULKLOAD_FILE.
4488: --
4489: -- IN Parameters
4490: -- 1. p_file_name: The filename of the data file.
4491: -- 2. p_load_id: The load id of the bulkload job.