1 PACKAGE FTE_BULK_DTT_PKG AUTHID CURRENT_USER AS
2 /* $Header: FTEDISUS.pls 115.6 2004/01/27 00:39:51 ablundel noship $ */
3
4
5 g_user_debug NUMBER := 0;
6
7 TYPE fte_location_distance_rec IS RECORD(ORIGIN_ID NUMBER,
8 DESTINATION_ID NUMBER,
9 IDENTIFIER_TYPE VARCHAR2(30),
10 DISTANCE NUMBER,
11 DISTANCE_UOM VARCHAR2(3),
12 TRANSIT_TIME NUMBER,
13 TRANSIT_TIME_UOM VARCHAR2(3),
14 CREATION_DATE DATE,
15 CREATED_BY NUMBER,
16 LAST_UPDATE_DATE DATE,
17 LAST_UPDATED_BY NUMBER,
18 LAST_UPDATE_LOGIN NUMBER,
19 PROGRAM_APPLICATION_ID NUMBER,
20 PROGRAM_ID NUMBER,
21 PROGRAM_UPDATE_DATE DATE,
22 REQUEST_ID NUMBER);
23 TYPE fte_location_distance_tab IS TABLE OF fte_location_distance_rec INDEX BY BINARY_INTEGER;
24
25
26 TYPE fte_distu_tmp_num_table IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
27 TYPE fte_distu_tmp_flag_table IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
28 TYPE fte_distu_tmp_uom_table IS TABLE OF VARCHAR2(3) INDEX BY BINARY_INTEGER;
29 TYPE fte_distu_tmp_char4_table IS TABLE OF VARCHAR2(4) INDEX BY BINARY_INTEGER;
30 TYPE fte_distu_tmp_char10_table IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
31 TYPE fte_distu_tmp_code_table IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
32 TYPE fte_distu_tmp_char60_table IS TABLE OF VARCHAR2(60) INDEX BY BINARY_INTEGER;
33 TYPE fte_distu_tmp_desc_table IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
34 TYPE fte_distu_tmp_msg_table IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
35 TYPE fte_distu_tmp_date_table IS TABLE OF DATE INDEX BY BINARY_INTEGER;
36
37
38
39 PROCEDURE BULK_LOAD_DTT(p_load_id IN NUMBER,
40 p_src_filename IN VARCHAR2,
41 p_resp_id IN NUMBER,
42 p_resp_appl_id IN NUMBER,
43 p_user_id IN NUMBER,
44 p_user_debug IN NUMBER,
45 x_request_id OUT NOCOPY NUMBER,
46 x_error_msg_text OUT NOCOPY VARCHAR2);
47
48
49 PROCEDURE LOAD_DTT_FILE(p_errbuf OUT NOCOPY VARCHAR2,
50 p_retcode OUT NOCOPY VARCHAR2,
51 p_load_id IN NUMBER,
52 p_src_filename IN VARCHAR2,
53 p_src_filedir IN VARCHAR2,
54 p_user_debug IN NUMBER);
55
56
57 PROCEDURE READ_DTT_FILE(p_source_file_directory IN VARCHAR2,
58 p_source_file_name IN VARCHAR2,
59 p_load_id IN VARCHAR2,
60 x_return_message OUT NOCOPY VARCHAR2,
61 x_return_status OUT NOCOPY NUMBER);
62
63
64 FUNCTION FIRST_TIME RETURN BOOLEAN;
65
66
67 END FTE_BULK_DTT_PKG;