1 PACKAGE HZ_PARTY_CONTACT_V2PUB AUTHID CURRENT_USER AS
2 /*$Header: ARH2PCSS.pls 120.9 2006/08/17 10:12:43 idali noship $ */
3 /*#
4 * This package includes the create and update procedures for contacts and contact roles.
5 * @rep:scope public
6 * @rep:product HZ
7 * @rep:displayname Party Contact
8 * @rep:category BUSINESS_ENTITY HZ_CONTACT
9 * @rep:lifecycle active
10 * @rep:doccd 120hztig.pdf Party Contact APIs, Oracle Trading Community Architecture Technical Implementation Guide
11 */
12
13 TYPE org_contact_rec_type IS RECORD(
14 org_contact_id NUMBER,
15 comments VARCHAR2(240),
16 contact_number VARCHAR2(30),
17 department_code VARCHAR2(30),
18 department VARCHAR2(60),
19 title VARCHAR2(30),
20 job_title VARCHAR2(100),
21 decision_maker_flag VARCHAR2(1),
22 job_title_code VARCHAR2(30),
23 reference_use_flag VARCHAR2(1),
24 rank VARCHAR2(30),
25 party_site_id NUMBER,
26 orig_system_reference VARCHAR2(240),
27 orig_system VARCHAR2(30),
28 attribute_category VARCHAR2(30),
29 attribute1 VARCHAR2(150),
30 attribute2 VARCHAR2(150),
31 attribute3 VARCHAR2(150),
32 attribute4 VARCHAR2(150),
33 attribute5 VARCHAR2(150),
34 attribute6 VARCHAR2(150),
35 attribute7 VARCHAR2(150),
36 attribute8 VARCHAR2(150),
37 attribute9 VARCHAR2(150),
38 attribute10 VARCHAR2(150),
39 attribute11 VARCHAR2(150),
40 attribute12 VARCHAR2(150),
41 attribute13 VARCHAR2(150),
42 attribute14 VARCHAR2(150),
43 attribute15 VARCHAR2(150),
44 attribute16 VARCHAR2(150),
45 attribute17 VARCHAR2(150),
46 attribute18 VARCHAR2(150),
47 attribute19 VARCHAR2(150),
48 attribute20 VARCHAR2(150),
49 attribute21 VARCHAR2(150),
50 attribute22 VARCHAR2(150),
51 attribute23 VARCHAR2(150),
52 attribute24 VARCHAR2(150),
53 created_by_module VARCHAR2(150),
54 application_id NUMBER,
55 party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type:= HZ_RELATIONSHIP_V2PUB.G_MISS_REL_REC
56 );
57
58
59 TYPE org_contact_role_rec_type IS RECORD(
60 org_contact_role_id NUMBER,
61 role_type VARCHAR2(30),
62 primary_flag VARCHAR2(1),
63 org_contact_id NUMBER,
64 orig_system_reference VARCHAR2(240),
65 orig_system VARCHAR2(30),
66 role_level VARCHAR2(30),
67 primary_contact_per_role_type VARCHAR2(1),
68 status VARCHAR2(1),
69 created_by_module VARCHAR2(150),
70 application_id NUMBER
71 );
72
73 -------------------------------------------------------------------------
74 /*#
75 * Use this routine to create a contact person for an organization or person. This API
76 * creates a record in the HZ_ORG_CONTACTS table. It also creates a relationship record in
77 * the HZ_RELATIONSHIPS table using the contact person as the subject, the organization or
78 * person as the object, and the relationship type and code passed by the caller. At the
79 * same time, the API creates a reverse relationship record. Depending on the relationship
80 * type set up for the relationship being used for the organization contact, the API creates a
81 * denormalized party record.
82 * @rep:scope public
83 * @rep:lifecycle active
84 * @rep:displayname Create Organization Contact
85 * @rep:businessevent oracle.apps.ar.hz.OrgContact.create
86 * @rep:doccd 120hztig.pdf Party Contact APIs, Oracle Trading Community Architecture Technical Implementation Guide
87 */
88 PROCEDURE create_org_contact (
89 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
90 p_org_contact_rec IN ORG_CONTACT_REC_TYPE,
91 x_org_contact_id OUT NOCOPY NUMBER,
92 x_party_rel_id OUT NOCOPY NUMBER,
93 x_party_id OUT NOCOPY NUMBER,
94 x_party_number OUT NOCOPY VARCHAR2,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2
98 );
99
100 /*#
101 * Use this routine to update a contact person. This API updates the contact record in the
102 * HZ_ORG_CONTACTS table. Optionally, you can call this API to update the relevant
103 * relationship record in the HZ_RELATIONSHIPS table and the underlying party record in the
104 * HZ_PARTIES table. To perform these updates you must pass the corresponding id and object
105 * version number.
106 * @rep:scope public
107 * @rep:lifecycle active
108 * @rep:displayname Update Organization Contact
109 * @rep:businessevent oracle.apps.ar.hz.OrgContact.update
110 * @rep:doccd 120hztig.pdf Party Contact APIs, Oracle Trading Community Architecture Technical Implementation Guide
111 */
112 PROCEDURE update_org_contact (
113 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
114 p_org_contact_rec IN ORG_CONTACT_REC_TYPE,
115 p_cont_object_version_number IN OUT NOCOPY NUMBER,
116 p_rel_object_version_number IN OUT NOCOPY NUMBER,
117 p_party_object_version_number IN OUT NOCOPY NUMBER,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2
121 );
122
123 /*#
124 * Use this routine to create a contact role for a contact person. This API
125 * creates a record in the HZ_ORG_CONTACT_ROLES table. You can create multiple
126 * role records for an organization contact. For an organization contact, you can
127 * identify one of the organization contact role records as Primary. There can be
128 * one role record per role type. For an organization or person, among all its
129 * organization contacts, you can mark one role record per role type as primary.
130 * @rep:scope public
131 * @rep:lifecycle active
132 * @rep:displayname Create Organization Contact Role
133 * @rep:businessevent oracle.apps.ar.hz.OrgContactRole.create
134 * @rep:doccd 120hztig.pdf Party Contact APIs, Oracle Trading Community Architecture Technical Implementation Guide
135 */
136 PROCEDURE create_org_contact_role (
137 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
138 p_org_contact_role_rec IN ORG_CONTACT_ROLE_REC_TYPE,
139 x_org_contact_role_id OUT NOCOPY NUMBER,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2
143 );
144
145 /*#
146 * Use this routine to update a contact role record. The API updates records in the
147 * HZ_ORG_CONTACT_ROLES table.
148 * @rep:scope public
149 * @rep:lifecycle active
150 * @rep:displayname Update Organization Contact Role
151 * @rep:businessevent oracle.apps.ar.hz.OrgContactRole.update
152 * @rep:doccd 120hztig.pdf Party Contact APIs, Oracle Trading Community Architecture Technical Implementation Guide
153 */
154 PROCEDURE update_org_contact_role (
155 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
156 p_org_contact_role_rec IN ORG_CONTACT_ROLE_REC_TYPE,
157 p_object_version_number IN OUT NOCOPY NUMBER,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2
161 );
162
163
164 PROCEDURE get_org_contact_rec (
165 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
166 p_org_contact_id IN NUMBER,
167 x_org_contact_rec OUT NOCOPY ORG_CONTACT_REC_TYPE,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2
171 );
172
173 PROCEDURE get_org_contact_role_rec (
174 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
175 p_org_contact_role_id IN NUMBER,
176 x_org_contact_role_rec OUT NOCOPY ORG_CONTACT_ROLE_REC_TYPE,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2
180 );
181
182 END HZ_PARTY_CONTACT_V2PUB;
[Home] [Help]