64:
65: --===================================================================
66: TYPE cnt_point_rec_type IS RECORD
67: (
68: contact_point_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
65: --===================================================================
66: TYPE cnt_point_rec_type IS RECORD
67: (
68: contact_point_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
66: TYPE cnt_point_rec_type IS RECORD
67: (
68: contact_point_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
67: (
68: contact_point_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: arc_contact_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: contact_point_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: arc_contact_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: act_contact_used_by_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: arc_contact_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: act_contact_used_by_id NUMBER := FND_API.G_MISS_NUM,
77: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: arc_contact_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: act_contact_used_by_id NUMBER := FND_API.G_MISS_NUM,
77: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: contact_point_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: arc_contact_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: act_contact_used_by_id NUMBER := FND_API.G_MISS_NUM,
77: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: contact_point_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
79: city VARCHAR2(120) := FND_API.G_MISS_CHAR,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: arc_contact_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: act_contact_used_by_id NUMBER := FND_API.G_MISS_NUM,
77: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: contact_point_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
79: city VARCHAR2(120) := FND_API.G_MISS_CHAR,
80: country NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: arc_contact_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: act_contact_used_by_id NUMBER := FND_API.G_MISS_NUM,
77: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: contact_point_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
79: city VARCHAR2(120) := FND_API.G_MISS_CHAR,
80: country NUMBER := FND_API.G_MISS_NUM,
81: zipcode VARCHAR2(120) := FND_API.G_MISS_CHAR,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: arc_contact_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: act_contact_used_by_id NUMBER := FND_API.G_MISS_NUM,
77: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: contact_point_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
79: city VARCHAR2(120) := FND_API.G_MISS_CHAR,
80: country NUMBER := FND_API.G_MISS_NUM,
81: zipcode VARCHAR2(120) := FND_API.G_MISS_CHAR,
82: attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: arc_contact_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: act_contact_used_by_id NUMBER := FND_API.G_MISS_NUM,
77: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: contact_point_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
79: city VARCHAR2(120) := FND_API.G_MISS_CHAR,
80: country NUMBER := FND_API.G_MISS_NUM,
81: zipcode VARCHAR2(120) := FND_API.G_MISS_CHAR,
82: attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: act_contact_used_by_id NUMBER := FND_API.G_MISS_NUM,
77: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: contact_point_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
79: city VARCHAR2(120) := FND_API.G_MISS_CHAR,
80: country NUMBER := FND_API.G_MISS_NUM,
81: zipcode VARCHAR2(120) := FND_API.G_MISS_CHAR,
82: attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: contact_point_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
79: city VARCHAR2(120) := FND_API.G_MISS_CHAR,
80: country NUMBER := FND_API.G_MISS_NUM,
81: zipcode VARCHAR2(120) := FND_API.G_MISS_CHAR,
82: attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: contact_point_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
79: city VARCHAR2(120) := FND_API.G_MISS_CHAR,
80: country NUMBER := FND_API.G_MISS_NUM,
81: zipcode VARCHAR2(120) := FND_API.G_MISS_CHAR,
82: attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: city VARCHAR2(120) := FND_API.G_MISS_CHAR,
80: country NUMBER := FND_API.G_MISS_NUM,
81: zipcode VARCHAR2(120) := FND_API.G_MISS_CHAR,
82: attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: country NUMBER := FND_API.G_MISS_NUM,
81: zipcode VARCHAR2(120) := FND_API.G_MISS_CHAR,
82: attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: zipcode VARCHAR2(120) := FND_API.G_MISS_CHAR,
82: attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: contact_point_value_id NUMBER := FND_API.G_MISS_NUM
91: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: contact_point_value_id NUMBER := FND_API.G_MISS_NUM
99: );
92: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: contact_point_value_id NUMBER := FND_API.G_MISS_NUM
99: );
100:
93: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: contact_point_value_id NUMBER := FND_API.G_MISS_NUM
99: );
100:
101: g_miss_cnt_point_rec cnt_point_rec_type;
94: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: contact_point_value_id NUMBER := FND_API.G_MISS_NUM
99: );
100:
101: g_miss_cnt_point_rec cnt_point_rec_type;
102: TYPE cnt_point_tbl_type IS TABLE OF cnt_point_rec_type INDEX BY BINARY_INTEGER;
114: -- Parameters
115: --
116: -- IN
117: -- p_api_version_number IN NUMBER Required
118: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
119: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
120: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
121: -- p_cnt_point_rec IN cnt_point_rec_type Required
122: --
115: --
116: -- IN
117: -- p_api_version_number IN NUMBER Required
118: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
119: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
120: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
121: -- p_cnt_point_rec IN cnt_point_rec_type Required
122: --
123: -- OUT
116: -- IN
117: -- p_api_version_number IN NUMBER Required
118: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
119: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
120: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
121: -- p_cnt_point_rec IN cnt_point_rec_type Required
122: --
123: -- OUT
124: -- x_return_status OUT VARCHAR2
133: --
134:
135: PROCEDURE Create_Cnt_Point(
136: p_api_version_number IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140:
141: x_return_status OUT NOCOPY VARCHAR2,
134:
135: PROCEDURE Create_Cnt_Point(
136: p_api_version_number IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140:
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
135: PROCEDURE Create_Cnt_Point(
136: p_api_version_number IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140:
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
158: -- Parameters
159: --
160: -- IN
161: -- p_api_version_number IN NUMBER Required
162: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
163: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
164: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
165: -- p_cnt_point_rec IN cnt_point_rec_type Required
166: --
159: --
160: -- IN
161: -- p_api_version_number IN NUMBER Required
162: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
163: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
164: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
165: -- p_cnt_point_rec IN cnt_point_rec_type Required
166: --
167: -- OUT
160: -- IN
161: -- p_api_version_number IN NUMBER Required
162: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
163: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
164: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
165: -- p_cnt_point_rec IN cnt_point_rec_type Required
166: --
167: -- OUT
168: -- x_return_status OUT VARCHAR2
177: --
178:
179: PROCEDURE Update_Cnt_Point(
180: p_api_version_number IN NUMBER,
181: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
182: p_commit IN VARCHAR2 := FND_API.G_FALSE,
183: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
184:
185: x_return_status OUT NOCOPY VARCHAR2,
178:
179: PROCEDURE Update_Cnt_Point(
180: p_api_version_number IN NUMBER,
181: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
182: p_commit IN VARCHAR2 := FND_API.G_FALSE,
183: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
184:
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
179: PROCEDURE Update_Cnt_Point(
180: p_api_version_number IN NUMBER,
181: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
182: p_commit IN VARCHAR2 := FND_API.G_FALSE,
183: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
184:
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2,
202: -- Parameters
203: --
204: -- IN
205: -- p_api_version_number IN NUMBER Required
206: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
207: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
208: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
209: -- p_CONTACT_POINT_ID IN NUMBER
210: -- p_object_version_number IN NUMBER Optional Default = NULL
203: --
204: -- IN
205: -- p_api_version_number IN NUMBER Required
206: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
207: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
208: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
209: -- p_CONTACT_POINT_ID IN NUMBER
210: -- p_object_version_number IN NUMBER Optional Default = NULL
211: --
204: -- IN
205: -- p_api_version_number IN NUMBER Required
206: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
207: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
208: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
209: -- p_CONTACT_POINT_ID IN NUMBER
210: -- p_object_version_number IN NUMBER Optional Default = NULL
211: --
212: -- OUT
222: --
223:
224: PROCEDURE Delete_Cnt_Point(
225: p_api_version_number IN NUMBER,
226: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
227: p_commit IN VARCHAR2 := FND_API.G_FALSE,
228: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
223:
224: PROCEDURE Delete_Cnt_Point(
225: p_api_version_number IN NUMBER,
226: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
227: p_commit IN VARCHAR2 := FND_API.G_FALSE,
228: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
231: x_msg_data OUT NOCOPY VARCHAR2,
224: PROCEDURE Delete_Cnt_Point(
225: p_api_version_number IN NUMBER,
226: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
227: p_commit IN VARCHAR2 := FND_API.G_FALSE,
228: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
231: x_msg_data OUT NOCOPY VARCHAR2,
232: p_contact_point_id IN NUMBER,
245: -- Parameters
246: --
247: -- IN
248: -- p_api_version_number IN NUMBER Required
249: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
250: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
251: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
252: -- p_cnt_point_rec IN cnt_point_rec_type Required
253: --
246: --
247: -- IN
248: -- p_api_version_number IN NUMBER Required
249: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
250: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
251: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
252: -- p_cnt_point_rec IN cnt_point_rec_type Required
253: --
254: -- OUT
247: -- IN
248: -- p_api_version_number IN NUMBER Required
249: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
250: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
251: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
252: -- p_cnt_point_rec IN cnt_point_rec_type Required
253: --
254: -- OUT
255: -- x_return_status OUT VARCHAR2
264: --
265:
266: PROCEDURE Lock_Cnt_Point(
267: p_api_version_number IN NUMBER,
268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
269:
270: x_return_status OUT NOCOPY VARCHAR2,
271: x_msg_count OUT NOCOPY NUMBER,
272: x_msg_data OUT NOCOPY VARCHAR2,
288: -- End of Comments
289:
290: PROCEDURE Validate_cnt_point(
291: p_api_version_number IN NUMBER,
292: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
293: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
294: p_validation_mode IN VARCHAR2,
295: p_cnt_point_rec IN cnt_point_rec_type,
296: x_return_status OUT NOCOPY VARCHAR2,
289:
290: PROCEDURE Validate_cnt_point(
291: p_api_version_number IN NUMBER,
292: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
293: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
294: p_validation_mode IN VARCHAR2,
295: p_cnt_point_rec IN cnt_point_rec_type,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
328:
329: PROCEDURE Validate_cnt_point_rec(
330: p_api_version_number IN NUMBER,
331: p_validation_mode IN VARCHAR2,
332: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
333: x_return_status OUT NOCOPY VARCHAR2,
334: x_msg_count OUT NOCOPY NUMBER,
335: x_msg_data OUT NOCOPY VARCHAR2,
336: p_cnt_point_rec IN cnt_point_rec_type