50: *
51: * ARGUMENTS
52: * IN:
53: * p_init_msg_list Initialize message stack if it is set to
54: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
55: * p_contact_preference_rec Contact preference record.
56: * IN/OUT:
57: * OUT:
58: * x_contact_preference_id contact preference ID.
56: * IN/OUT:
57: * OUT:
58: * x_contact_preference_id contact preference ID.
59: * x_return_status Return status after the call. The status can
60: * be FND_API.G_RET_STS_SUCCESS (success),
61: * FND_API.G_RET_STS_ERROR (error),
62: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
63: * x_msg_count Number of messages in message stack.
64: * x_msg_data Message text if x_msg_count is 1.
57: * OUT:
58: * x_contact_preference_id contact preference ID.
59: * x_return_status Return status after the call. The status can
60: * be FND_API.G_RET_STS_SUCCESS (success),
61: * FND_API.G_RET_STS_ERROR (error),
62: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
63: * x_msg_count Number of messages in message stack.
64: * x_msg_data Message text if x_msg_count is 1.
65: *
58: * x_contact_preference_id contact preference ID.
59: * x_return_status Return status after the call. The status can
60: * be FND_API.G_RET_STS_SUCCESS (success),
61: * FND_API.G_RET_STS_ERROR (error),
62: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
63: * x_msg_count Number of messages in message stack.
64: * x_msg_data Message text if x_msg_count is 1.
65: *
66: * NOTES
81: * @rep:businessevent oracle.apps.ar.hz.ContactPreference.create
82: * @rep:doccd 120hztig.pdf Contact Preference APIs, Oracle Trading Community Architecture Technical Implementation Guide
83: */
84: PROCEDURE create_contact_preference (
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86: p_contact_preference_rec IN CONTACT_PREFERENCE_REC_TYPE,
87: x_contact_preference_id OUT NOCOPY NUMBER,
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_count OUT NOCOPY NUMBER,
100: *
101: * ARGUMENTS
102: * IN:
103: * p_init_msg_list Initialize message stack if it is set to
104: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
105: * p_contact_preference_rec Contact Preference record.
106: * IN/OUT:
107: * p_object_version_number Used for locking the being updated record.
108: * OUT:
106: * IN/OUT:
107: * p_object_version_number Used for locking the being updated record.
108: * OUT:
109: * x_return_status Return status after the call. The status can
110: * be FND_API.G_RET_STS_SUCCESS (success),
111: * FND_API.G_RET_STS_ERROR (error),
112: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
113: * x_msg_count Number of messages in message stack.
114: * x_msg_data Message text if x_msg_count is 1.
107: * p_object_version_number Used for locking the being updated record.
108: * OUT:
109: * x_return_status Return status after the call. The status can
110: * be FND_API.G_RET_STS_SUCCESS (success),
111: * FND_API.G_RET_STS_ERROR (error),
112: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
113: * x_msg_count Number of messages in message stack.
114: * x_msg_data Message text if x_msg_count is 1.
115: *
108: * OUT:
109: * x_return_status Return status after the call. The status can
110: * be FND_API.G_RET_STS_SUCCESS (success),
111: * FND_API.G_RET_STS_ERROR (error),
112: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
113: * x_msg_count Number of messages in message stack.
114: * x_msg_data Message text if x_msg_count is 1.
115: *
116: * NOTES
130: * @rep:businessevent oracle.apps.ar.hz.ContactPreference.update
131: * @rep:doccd 120hztig.pdf Contact Preference APIs, Oracle Trading Community Architecture Technical Implementation Guide
132: */
133: PROCEDURE update_contact_preference (
134: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
135: p_contact_preference_rec IN CONTACT_PREFERENCE_REC_TYPE,
136: p_object_version_number IN OUT NOCOPY NUMBER,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
149: *
150: * ARGUMENTS
151: * IN:
152: * p_init_msg_list Initialize message stack if it is set to
153: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
154: * p_contact_preference_id Contact preference id.
155: * IN/OUT:
156: * OUT:
157: * x_contact_preference_rec Returned contact preference record.
155: * IN/OUT:
156: * OUT:
157: * x_contact_preference_rec Returned contact preference record.
158: * x_return_status Return status after the call. The status can
159: * be FND_API.G_RET_STS_SUCCESS (success),
160: * FND_API.G_RET_STS_ERROR (error),
161: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
162: * x_msg_count Number of messages in message stack.
163: * x_msg_data Message text if x_msg_count is 1.
156: * OUT:
157: * x_contact_preference_rec Returned contact preference record.
158: * x_return_status Return status after the call. The status can
159: * be FND_API.G_RET_STS_SUCCESS (success),
160: * FND_API.G_RET_STS_ERROR (error),
161: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
162: * x_msg_count Number of messages in message stack.
163: * x_msg_data Message text if x_msg_count is 1.
164: *
157: * x_contact_preference_rec Returned contact preference record.
158: * x_return_status Return status after the call. The status can
159: * be FND_API.G_RET_STS_SUCCESS (success),
160: * FND_API.G_RET_STS_ERROR (error),
161: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
162: * x_msg_count Number of messages in message stack.
163: * x_msg_data Message text if x_msg_count is 1.
164: *
165: * NOTES
170: *
171: */
172:
173: PROCEDURE get_contact_preference_rec (
174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
175: p_contact_preference_id IN NUMBER,
176: x_contact_preference_rec OUT NOCOPY CONTACT_PREFERENCE_REC_TYPE,
177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY NUMBER,