[Home] [Help]
PACKAGE: APPS.FTE_TL_LOADER
Source
1 PACKAGE FTE_TL_LOADER AUTHID CURRENT_USER AS
2 /* $Header: FTETLLRS.pls 120.0 2005/06/28 02:17:39 pkaliyam noship $ */
3
4 --Global package variables
5 g_unit_uom VARCHAR2(10);
6 g_debug_set BOOLEAN := TRUE;
7 g_debug_on BOOLEAN := TRUE;
8
9 G_CONST_PRECEDENCE_LOW CONSTANT NUMBER := 180;
10 G_CONST_PRECEDENCE_MID CONSTANT NUMBER := 200;
11 G_CONST_PRECEDENCE_HIGH CONSTANT NUMBER := 220;
12
13
14
15 TYPE Number_Tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
16 TYPE Varchar100_Tab IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
17 TYPE Varchar2000_Tab IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
18
19
20 --Caches for Rate Chart Information
21 Chart_Names Varchar100_Tab;
22 Chart_Carriers Varchar100_Tab;
23 Chart_Service_Levels Varchar100_Tab;
24 Chart_LineNums Number_Tab;
25 Chart_Process_Ids Number_Tab;
26 Chart_Types Varchar100_Tab;
27 Chart_Min_Charges Varchar2000_Tab;
28 Chart_Start_Dates Varchar100_Tab;
29 Chart_End_Dates Varchar100_Tab;
30 Chart_Ids Number_Tab;
31 Chart_Currencies Varchar100_Tab;
32 Link_Chartnames Varchar100_Tab;
33 Link_Modifiernames Varchar100_Tab;
34
35 Fac_Modifier_Names Varchar100_Tab;
36 Fac_Modifier_Bases Varchar100_Tab;
37 Fac_Modifier_Uoms Varchar100_Tab;
38
39 g_chart_name VARCHAR2(60);
40 g_carrier_name VARCHAR2(60);
41 g_service_level VARCHAR2(30);
42 g_carrier_id NUMBER;
43 g_carrier_unit_basis VARCHAR2(30);
44 g_carrier_unit_basis_uom VARCHAR2(3);
45 g_carrier_distance_uom VARCHAR2(3);
46 g_carrier_time_uom VARCHAR2(3);
47 g_carrier_currency VARCHAR2(3);
48
49 g_wknd_layovr_uom VARCHAR2(10);
50 g_layovr_charges STRINGARRAY := STRINGARRAY();
51 g_layovr_breaks STRINGARRAY := STRINGARRAY();
52
53 PROCEDURE PROCESS_TL_BASE_RATES( p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
54 p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
55 p_line_number IN NUMBER,
56 p_doValidate IN BOOLEAN DEFAULT TRUE,
57 x_status OUT NOCOPY NUMBER,
58 x_error_msg OUT NOCOPY VARCHAR2);
59
60 PROCEDURE PROCESS_TL_SURCHARGES(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
61 p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
62 p_line_number IN NUMBER,
63 p_doValidate IN BOOLEAN DEFAULT TRUE,
64 x_error_msg OUT NOCOPY VARCHAR2,
65 x_status OUT NOCOPY NUMBER);
66
67 PROCEDURE PROCESS_FACILITY_CHARGES(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
68 p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
69 p_line_number IN NUMBER,
70 x_error_msg OUT NOCOPY VARCHAR2,
71 x_status OUT NOCOPY NUMBER);
72
73 PROCEDURE SUBMIT_TL_CHART (x_status OUT NOCOPY NUMBER,
74 x_error_msg OUT NOCOPY VARCHAR2);
75
76 PROCEDURE PROCESS_DATA(p_type IN VARCHAR2,
77 p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
78 p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
79 p_line_number IN NUMBER,
80 x_status OUT NOCOPY NUMBER,
81 x_error_msg OUT NOCOPY VARCHAR2);
82
83 PROCEDURE RESET_ALL;
84 END FTE_TL_LOADER;