[Home] [Help]
PACKAGE: APPS.AMS_CONTACT_POINT_PVT
Source
1 PACKAGE AMS_CONTACT_POINT_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvcpts.pls 115.4 2002/11/22 08:55:19 jieli ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_CONTACT_POINT_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 --===================================================================
19 -- Start of Comments
20 -- -------------------------------------------------------
21 -- Record name
22 -- contact_point_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 --
26 -- Required
27 --
28 -- Defaults
29 --
30 -- Note: This is automatic generated record definition, it includes all columns
31 -- defined in the table, developer must manually add or delete some of the attributes.
32 --
33 -- End of Comments
34
35 --===================================================================
36 G_MISS_CONTENT_SOURCE_TYPE CONSTANT VARCHAR2(30) := 'USER_ENTERED';
37
38 TYPE contact_point_rec_type IS RECORD (
39 contact_point_id NUMBER,
40 contact_point_type VARCHAR2(30),
41 status VARCHAR2(30),
42 owner_table_name VARCHAR2(30),
43 owner_table_id NUMBER,
44 primary_flag VARCHAR2(1),
45 orig_system_reference VARCHAR2(240),
46 content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
47 attribute_category VARCHAR2(30),
48 attribute1 VARCHAR2(150),
49 attribute2 VARCHAR2(150),
50 attribute3 VARCHAR2(150),
51 attribute4 VARCHAR2(150),
52 attribute5 VARCHAR2(150),
53 attribute6 VARCHAR2(150),
54 attribute7 VARCHAR2(150),
55 attribute8 VARCHAR2(150),
56 attribute9 VARCHAR2(150),
57 attribute10 VARCHAR2(150),
58 attribute11 VARCHAR2(150),
59 attribute12 VARCHAR2(150),
60 attribute13 VARCHAR2(150),
61 attribute14 VARCHAR2(150),
62 attribute15 VARCHAR2(150),
63 attribute16 VARCHAR2(150),
64 attribute17 VARCHAR2(150),
65 attribute18 VARCHAR2(150),
66 attribute19 VARCHAR2(150),
67 attribute20 VARCHAR2(150),
68 contact_point_purpose VARCHAR2(30),
69 primary_by_purpose VARCHAR2(30),
70 created_by_module VARCHAR2(150),
71 application_id NUMBER,
72 actual_content_source VARCHAR2(30)
73 );
74
75 TYPE edi_rec_type IS RECORD (
76 edi_transaction_handling VARCHAR2(25),
77 edi_id_number VARCHAR2(30),
78 edi_payment_method VARCHAR2(30),
79 edi_payment_format VARCHAR2(30),
80 edi_remittance_method VARCHAR2(30),
81 edi_remittance_instruction VARCHAR2(30),
82 edi_tp_header_id NUMBER,
83 edi_ece_tp_location_code VARCHAR2(40)
84 );
85
86 g_miss_edi_rec edi_rec_type;
87
88 TYPE eft_rec_type IS RECORD (
89 eft_transmission_program_id NUMBER,
90 eft_printing_program_id NUMBER,
91 eft_user_number VARCHAR2(30),
92 eft_swift_code VARCHAR2(30)
93 );
94
95 G_MISS_EFT_REC eft_rec_type;
96
97 TYPE email_rec_type IS RECORD (
98 email_format VARCHAR2(30),
99 email_address VARCHAR2(2000)
100 );
101
102 g_miss_email_rec email_rec_type;
103
104 TYPE phone_rec_type IS RECORD (
105 phone_calling_calendar VARCHAR2(30),
106 last_contact_dt_time DATE,
107 timezone_id NUMBER,
108 phone_area_code VARCHAR2(10),
109 phone_country_code VARCHAR2(10),
110 phone_number VARCHAR2(40),
111 phone_extension VARCHAR2(20),
112 phone_line_type VARCHAR2(30),
113 raw_phone_number VARCHAR2(60)
114 );
115
116 g_miss_phone_rec phone_rec_type;
117
118 TYPE telex_rec_type IS RECORD (
119 telex_number VARCHAR2(50)
120 );
121
122 g_miss_telex_rec telex_rec_type;
123
124 TYPE web_rec_type IS RECORD (
125 web_type VARCHAR2(60),
126 url VARCHAR2(2000)
127 );
128
129 g_miss_web_rec web_rec_type;
130
131
132 -- ==============================================================================
133 -- Start of Comments
134 -- ==============================================================================
135 -- API Name
136 -- create_contact_POINT
137 -- Type
138 -- Private
139 -- Pre-Req
140 --
141 -- Parameters
142 --
143 -- IN
144 -- p_api_version_number IN NUMBER Required
145 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
146 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
147 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
148 -- p_ams_contact_pref_rec IN ams_contact_pref_rec_type Required
149 --
150 -- OUT
151 -- x_return_status OUT VARCHAR2
152 -- x_msg_count OUT NUMBER
153 -- x_msg_data OUT VARCHAR2
154 -- Version : Current version 1.0
155 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
156 -- and basic operation, developer must manually add parameters and business logic as necessary.
157 --
158 -- End of Comments
159 -- ==============================================================================
160 --
161
162
163 PROCEDURE create_contact_POINT(
164 p_api_version_number IN NUMBER,
165 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
166 p_commit IN VARCHAR2 := FND_API.G_FALSE,
167 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171
172 p_ams_contact_point_rec IN contact_POINT_rec_type ,
173 p_ams_edi_rec IN edi_rec_type := g_miss_edi_rec,
174 p_ams_email_rec IN email_rec_type := g_miss_email_rec,
175 p_ams_phone_rec IN phone_rec_type := g_miss_phone_rec,
176 p_ams_telex_rec IN telex_rec_type := g_miss_telex_rec,
177 p_ams_web_rec IN web_rec_type := g_miss_web_rec,
178
179 x_contact_POINT_id OUT NOCOPY NUMBER
180
181 );
182
183 -- ==============================================================================
184 -- Start of Comments
185 -- ==============================================================================
186 -- API Name
187 -- update_contact_POINT
188 -- Type
189 -- Private
190 -- Pre-Req
191 --
192 -- Parameters
193 --
194 -- IN
195 -- p_api_version_number IN NUMBER Required
196 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
197 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
198 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
199 -- p_ams_contact_point_rec IN contact_point_rec_type Required
200 --
201 -- OUT
202 -- x_return_status OUT VARCHAR2
203 -- x_msg_count OUT NUMBER
204 -- x_msg_data OUT VARCHAR2
205 -- Version : Current version 1.0
206 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
207 -- and basic operation, developer must manually add parameters and business logic as necessary.
208 --
209 -- End of Comments
210 -- ==============================================================================
211 --
212
213
214 PROCEDURE update_contact_POINT(
215 p_api_version_number IN NUMBER,
216 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217 p_commit IN VARCHAR2 := FND_API.G_FALSE,
218 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219 x_return_status OUT NOCOPY VARCHAR2,
220 x_msg_count OUT NOCOPY NUMBER,
221 x_msg_data OUT NOCOPY VARCHAR2,
222
223 p_ams_contact_point_rec IN contact_POINT_rec_type ,
224 p_ams_edi_rec IN edi_rec_type := g_miss_edi_rec,
225 p_ams_email_rec IN email_rec_type := g_miss_email_rec,
226 p_ams_phone_rec IN phone_rec_type := g_miss_phone_rec,
227 p_ams_telex_rec IN telex_rec_type := g_miss_telex_rec,
228 p_ams_web_rec IN web_rec_type := g_miss_web_rec,
229
230 px_object_version_number IN OUT NOCOPY NUMBER
231 );
232
233
234 END AMS_CONTACT_POINT_PVT;