113: * @rep:businessevent oracle.apps.ar.hz.Relationship.create
114: * @rep:doccd 120hztig.pdf Relationship APIs, Oracle Trading Community Architecture Technical Implementation Guide
115: */
116: PROCEDURE create_relationship (
117: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
118: p_relationship_rec IN RELATIONSHIP_REC_TYPE,
119: x_relationship_id OUT NOCOPY NUMBER,
120: x_party_id OUT NOCOPY NUMBER,
121: x_party_number OUT NOCOPY VARCHAR2,
150: * @rep:businessevent oracle.apps.ar.hz.Relationship.create
151: * @rep:doccd 115hztig.pdf Relationship APIs, Oracle Trading Community Architecture Technical Implementation Guide
152: */
153: PROCEDURE create_relationship (
154: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
155: p_relationship_rec IN RELATIONSHIP_REC_TYPE,
156: x_relationship_id OUT NOCOPY NUMBER,
157: x_party_id OUT NOCOPY NUMBER,
158: x_party_number OUT NOCOPY VARCHAR2,
172: *
173: * ARGUMENTS
174: * IN:
175: * p_init_msg_list Initialize message stack if it is set to
176: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
177: * p_relationship_rec Relationship record.
178: * p_contact_party_id Contact party Id.
179: * p_contact_party_usage_code Contact party usage code.
180: * p_create_org_contact Decide if we need to create org contact or not.
183: * x_relationship_id Relationship ID.
184: * x_party_id Relationship party Id.
185: * x_party_number Party number.
186: * x_return_status Return status after the call. The status can
187: * be FND_API.G_RET_STS_SUCCESS (success),
188: * FND_API.G_RET_STS_ERROR (error),
189: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
190: * x_msg_count Number of messages in message stack.
191: * x_msg_data Message text if x_msg_count is 1.
184: * x_party_id Relationship party Id.
185: * x_party_number Party number.
186: * x_return_status Return status after the call. The status can
187: * be FND_API.G_RET_STS_SUCCESS (success),
188: * FND_API.G_RET_STS_ERROR (error),
189: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
190: * x_msg_count Number of messages in message stack.
191: * x_msg_data Message text if x_msg_count is 1.
192: *
185: * x_party_number Party number.
186: * x_return_status Return status after the call. The status can
187: * be FND_API.G_RET_STS_SUCCESS (success),
188: * FND_API.G_RET_STS_ERROR (error),
189: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
190: * x_msg_count Number of messages in message stack.
191: * x_msg_data Message text if x_msg_count is 1.
192: *
193: * NOTES
198: *
199: */
200:
201: PROCEDURE create_relationship_with_usg (
202: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
203: p_relationship_rec IN RELATIONSHIP_REC_TYPE,
204: p_contact_party_id IN NUMBER,
205: p_contact_party_usage_code IN VARCHAR2,
206: p_create_org_contact IN VARCHAR2 DEFAULT NULL,
224: * @rep:businessevent oracle.apps.ar.hz.Relationship.update
225: * @rep:doccd 120hztig.pdf Relationship APIs, Oracle Trading Community Architecture Technical Implementation Guide
226: */
227: PROCEDURE update_relationship (
228: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
229: p_relationship_rec IN RELATIONSHIP_REC_TYPE,
230: p_object_version_number IN OUT NOCOPY NUMBER,
231: p_party_object_version_number IN OUT NOCOPY NUMBER,
232: x_return_status OUT NOCOPY VARCHAR2,
234: x_msg_data OUT NOCOPY VARCHAR2
235: );
236:
237: PROCEDURE get_relationship_rec (
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_relationship_id IN NUMBER,
240: p_directional_flag IN VARCHAR2 := 'F',
241: x_rel_rec OUT NOCOPY RELATIONSHIP_REC_TYPE,
242: x_return_status OUT NOCOPY VARCHAR2,