[Home] [Help]
PACKAGE: APPS.ECE_EXTRACT_UTILS_PUB
Source
1 PACKAGE ece_extract_utils_pub AS
2 -- $Header: ECPEXTUS.pls 120.2 2005/09/29 11:38:58 arsriniv ship $
3 g_maxcolwidth NUMBER := 400; -- ****** IMPORTANT ********
4 g_transaction_date VARCHAR2(35) := 'TRANSACTION_DATE';
5 g_pkg_name CONSTANT VARCHAR2(30) := 'ece_extract_utils_pub';
6 g_file_name CONSTANT VARCHAR2(12) := 'ECPEXTUB.pls';
7
8 TYPE source_rec_type IS RECORD(
9 data_loc_id NUMBER,
10 table_name VARCHAR2(50),
11 column_name VARCHAR2(50),
12 base_table_name VARCHAR2(50),
13 base_column_name VARCHAR2(50),
14 xref_category_id NUMBER,
15 xref_key1_source_column VARCHAR2(50),
16 xref_key2_source_column VARCHAR2(50),
17 xref_key3_source_column VARCHAR2(50),
18 xref_key4_source_column VARCHAR2(50),
19 xref_key5_source_column VARCHAR2(50),
20 data_type VARCHAR2(50),
21 data_length NUMBER,
22 int_val VARCHAR2(400),
23 ext_val1 VARCHAR2(80),
24 ext_val2 VARCHAR2(80),
25 ext_val3 VARCHAR2(80),
26 ext_val4 VARCHAR2(80),
27 ext_val5 VARCHAR2(80));
28
29 TYPE Source_tbl_type IS TABLE OF Source_rec_type
30 INDEX BY BINARY_INTEGER;
31
32 PROCEDURE select_clause(
33 cTransaction_Type IN VARCHAR2,
34 cCommunication_Method IN VARCHAR2,
35 cInterface_Table IN VARCHAR2,
36 p_source_tbl IN ece_flatfile_pvt.interface_tbl_type,
37 cSelect_string OUT NOCOPY VARCHAR2,
38 cFrom_string OUT NOCOPY VARCHAR2,
39 cWhere_string OUT NOCOPY VARCHAR2);
40
41 PROCEDURE insert_into_interface_tbl(
42 iRun_id IN NUMBER,
43 cTransaction_Type IN VARCHAR2,
44 cCommunication_Method IN VARCHAR2,
45 cInterface_Table IN VARCHAR2,
46 p_source_tbl IN ece_flatfile_pvt.Interface_tbl_type,
47 p_foreign_key IN NUMBER);
48
49 PROCEDURE insert_into_prod_interface(
50 p_Interface_Table IN VARCHAR2,
51 p_Insert_cur IN OUT NOCOPY INTEGER,
52 p_apps_tbl IN ece_flatfile_pvt.Interface_tbl_type);
53
54 /*Bug 1854866
55 Assigned default values to the parameters
56 p_init_msg_list,p_simulate,p_commit,p_validation_level
57 of the procedure insert_prod_interface_pvt
58 since the default values are assigned to these parameters
59 in the package body
60 */
61
62 PROCEDURE insert_into_prod_interface_pvt(
63 p_api_version_number IN NUMBER,
64 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
65 p_simulate IN VARCHAR2 := fnd_api.g_false,
66 p_commit IN VARCHAR2 := fnd_api.g_false,
67 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2,
71 p_interface_table IN VARCHAR2,
72 p_insert_cur IN OUT NOCOPY INTEGER,
73 p_apps_tbl IN ece_flatfile_pvt.Interface_tbl_type);
74
75 PROCEDURE find_pos(
76 p_source_tbl IN ece_flatfile_pvt.Interface_tbl_type,
77 p_in_text IN VARCHAR2,
78 p_Pos IN OUT NOCOPY NUMBER);
79
80 FUNCTION pos_of(
81 pInterface_tbl IN ece_flatfile_pvt.Interface_tbl_type,
82 cCol_name IN VARCHAR2)
83 RETURN NUMBER;
84
85 -- 2823215
86 PROCEDURE ext_get_value(
87 l_plsql_tbl IN ece_flatfile_pvt.Interface_tbl_type,
88 p_in_text IN VARCHAR2,
89 p_Position IN OUT NOCOPY NUMBER,
90 o_value OUT NOCOPY varchar2);
91
92 PROCEDURE ext_insert_value(
93 l_plsql_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
94 p_position IN number,
95 p_value IN varchar2);
96
97 END ece_extract_utils_pub;
98