1 PACKAGE AMS_ImportClient_PVT AUTHID CURRENT_USER AS
2 /*$Header: amsvmics.pls 115.8 2003/05/15 22:34:25 huili ship $*/
3
4 --
5 -- Start of comments.
6 --
7 -- NAME
8 -- AMS_ImportClient_PVT
9 --
10 -- PURPOSE
11 -- The package provides APIs for importing data.
12 --
13 -- Procedures:
14 -- Insert_Import_Data
15 -- Insert_Generic_Data
16 -- Load_Lead_Data_To_Interface
17 --
18 -- NOTES
19 --
20 --
21 -- HISTORY
22 -- 04/10/2001 huili Created
23 -- 04/26/2001 huili Change nested table type using JTF table
24 -- 05/13/2001 huili Added the "Insert_Lead_Data" module
25 --
26 -- End of comments.
27 --
28 --
29 -- Start type definition
30 --
31 --
32 -- Corresponding type def for the PL/SQL data type "JTF_VARCHAR2_TABLE_2000"
33 -- since Rosetta does not support nested tables.
34 --
35 TYPE char_data_set_type_w IS
36 TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
37
38 --
39 -- Corresponding type def for the PL/SQL data type "JTF_NUMBER_TABLE"
40 -- since Rosetta does not support nested tables.
41 --
42 TYPE num_data_set_type_w IS
43 TABLE OF NUMBER INDEX BY BINARY_INTEGER;
44
45 --
46 -- Types for bulk collect data from the "AMS_LEAD_MAPPING_V" into "as_import_interface" table
47 --
48 TYPE varchar2_2000_set_type IS
49 TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
50
51 TYPE varchar2_4000_set_type IS
52 TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
53
54 TYPE varchar2_150_set_type IS
55 TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER;
56
57
58 PROCEDURE Write_Message (
59 x_return_status OUT NOCOPY VARCHAR2,
60 p_log_used_by_id IN VARCHAR2,
61 p_msg_data IN VARCHAR2,
62 p_msg_type IN VARCHAR2
63 );
64
65
66 -- Start of comments
67 -- API Name Mark_Insert_Lead_Errors
68 -- Type Private
69 -- Pre-reqs None.
70 -- Function Mark lead errors to the "ams_imp_source_lines"
71 -- table and insert errors into the
72 -- "ams_list_import_errors" table.
73 -- Parameters
74 -- IN
75 -- p_import_list_header_id NUMBER Required
76 -- OUT x_return_status VARCHAR2
77 -- Version Current version: 1.0
78 -- Previous version: 1.0
79 -- Initial version: 1.0
80 -- End of comments
81 PROCEDURE Mark_Insert_Lead_Errors (
82 p_import_list_header_id IN NUMBER,
83 x_return_status OUT NOCOPY VARCHAR2
84 );
85
86 -- Start of comments
87 -- API Name Load_Lead_Data_To_Interface
88 -- Type Private
89 -- Pre-reqs None.
90 -- Function Load data from the "AMS_LEAD_MAPPING_V" to the "as_import_interface".
91 -- Parameters
92 -- IN
93 -- p_import_list_header_id NUMBER Required
94 -- OUT x_return_status VARCHAR2
95 -- Version Current version: 1.0
96 -- Previous version: 1.0
97 -- Initial version: 1.0
98 -- End of comments
99 PROCEDURE Load_Lead_Data_To_Interface (
100 p_import_list_header_id IN NUMBER,
101 x_return_status OUT NOCOPY VARCHAR2
102 );
103
104
105 -- Start of comments
106 -- API Name Insert_Lead_Data
107 -- Type Private
108 -- Pre-reqs None.
109 -- Function Insert data into the "AMS_IMP_SOURCE_LINES" table.
110 -- Parameters
111 -- IN p_api_version NUMBER Required
112 -- p_init_msg_list VARCHAR2 Optional
113 -- Default := FND_API.G_TRUE
114 -- p_commit VARCHAR2 Optional
115 -- p_import_list_header_id NUMBER Required
116 -- p_data char_data_set_type_w Required
117 -- p_row_count NUMBER Required
118 -- OUT x_return_status VARCHAR2
119 -- x_msg_count NUMBER
120 -- x_msg_data VARCHAR2
121 -- Version Current version: 1.0
122 -- Previous version: 1.0
123 -- Initial version: 1.0
124 -- End of comments
125 PROCEDURE Insert_Lead_Data (
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
128 p_commit IN VARCHAR2 := FND_API.G_TRUE,
129 p_import_list_header_id IN NUMBER,
130 p_data IN char_data_set_type_w,
131 p_error_rows IN num_data_set_type_w,
132 p_row_count IN NUMBER,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2
136 );
137
138
139
140 -- Start of comments
141 -- API Name Insert_List_Data
142 -- Type Private
143 -- Pre-reqs None.
144 -- Function Insert data into the "AMS_IMP_SOURCE_LINES" table.
145 -- Parameters
146 -- IN p_api_version NUMBER Required
147 -- p_init_msg_list VARCHAR2 Optional
148 -- Default := FND_API.G_FALSE
149 -- p_commit VARCHAR2 Optional
150 -- p_import_list_header_id NUMBER Required
151 -- p_data char_data_set_type_w Required
152 -- p_row_count NUMBER Required
153 -- OUT x_return_status VARCHAR2
154 -- x_msg_count NUMBER
155 -- x_msg_data VARCHAR2
156 -- Version Current version: 1.0
157 -- Previous version: 1.0
158 -- Initial version: 1.0
159 -- End of comments
160 PROCEDURE Insert_List_Data (
161 p_api_version IN NUMBER,
162 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
163 p_commit IN VARCHAR2 := FND_API.G_TRUE,
164 p_import_list_header_id IN NUMBER,
165 p_data IN char_data_set_type_w,
166 p_row_count IN NUMBER,
167 p_error_rows IN num_data_set_type_w,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2
171 );
172
173
174 END AMS_ImportClient_PVT;