108: */
109:
110: PROCEDURE Load_Contacts (
111: p_api_version_number IN NUMBER
112: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
113: ,p_mode IN VARCHAR2 := 'EVALUATION'
114: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
115: ,x_return_status OUT NOCOPY VARCHAR2
116: ,x_msg_data OUT NOCOPY VARCHAR2
110: PROCEDURE Load_Contacts (
111: p_api_version_number IN NUMBER
112: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
113: ,p_mode IN VARCHAR2 := 'EVALUATION'
114: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
115: ,x_return_status OUT NOCOPY VARCHAR2
116: ,x_msg_data OUT NOCOPY VARCHAR2
117: ,x_msg_count OUT NOCOPY NUMBER
118: ,p_contact_details_tbl IN CONTACT_DETAILS_TBL_TYPE
146: */
147:
148: PROCEDURE user_create (
149: p_api_version_number IN NUMBER
150: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
151: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
152: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
153: ,p_user_name IN VARCHAR2
154: ,p_password IN OUT NOCOPY VARCHAR2
147:
148: PROCEDURE user_create (
149: p_api_version_number IN NUMBER
150: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
151: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
152: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
153: ,p_user_name IN VARCHAR2
154: ,p_password IN OUT NOCOPY VARCHAR2
155: ,p_user_type_key IN VARCHAR2
148: PROCEDURE user_create (
149: p_api_version_number IN NUMBER
150: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
151: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
152: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
153: ,p_user_name IN VARCHAR2
154: ,p_password IN OUT NOCOPY VARCHAR2
155: ,p_user_type_key IN VARCHAR2
156: ,p_contact_rel_id IN NUMBER
181:
182:
183: PROCEDURE user_update (
184: p_api_version_number IN NUMBER
185: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
186: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
187: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
188: ,p_user_name IN VARCHAR2
189: ,p_user_type_key IN VARCHAR2
182:
183: PROCEDURE user_update (
184: p_api_version_number IN NUMBER
185: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
186: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
187: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
188: ,p_user_name IN VARCHAR2
189: ,p_user_type_key IN VARCHAR2
190: ,p_contact_rel_id IN NUMBER
183: PROCEDURE user_update (
184: p_api_version_number IN NUMBER
185: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
186: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
187: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
188: ,p_user_name IN VARCHAR2
189: ,p_user_type_key IN VARCHAR2
190: ,p_contact_rel_id IN NUMBER
191: ,x_return_status OUT NOCOPY VARCHAR2