[Home] [Help]
PACKAGE: APPS.HZ_CUST_ACCOUNT_MERGE_V2PVT
Source
1 PACKAGE hz_cust_account_merge_v2pvt AUTHID CURRENT_USER AS
2 /*$Header: ARHACTMS.pls 120.1 2005/06/16 21:08:21 jhuang noship $ */
3
4
5 --------------PARTY------------------------------------------------------
6
7 g_miss_content_source_type VARCHAR2(30) := 'USER_ENTERED';
8 g_miss_party_rec hz_party_v2pub.party_rec_type;
9
10 procedure get_party_rec (
11 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
12 p_party_id IN NUMBER,
13 x_party_rec OUT NOCOPY hz_party_v2pub.party_rec_type,
14 x_return_status OUT NOCOPY VARCHAR2,
15 x_msg_count OUT NOCOPY NUMBER,
16 x_msg_data OUT NOCOPY VARCHAR2
17 );
18
19 --------------relationship------------------------------------------------
20
21 g_miss_rel_rec hz_relationship_v2pub.relationship_rec_type;
22
23 PROCEDURE create_relationship (
24 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
25 p_relationship_rec IN hz_relationship_v2pub.relationship_rec_type,
26 p_direction_code IN VARCHAR2,
27 x_relationship_id OUT NOCOPY NUMBER,
28 x_party_id OUT NOCOPY NUMBER,
29 x_party_number OUT NOCOPY VARCHAR2,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2
33 );
34
35
36 PROCEDURE get_relationship_rec (
37 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
38 p_relationship_id IN NUMBER,
39 p_directional_flag IN VARCHAR2 := 'F',
40 x_rel_rec OUT NOCOPY hz_relationship_v2pub.relationship_rec_type,
41 x_direction_code OUT NOCOPY VARCHAR2,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2
45 );
46
47 --------------------PARTY_CONTACT--------------------------------------------
48 PROCEDURE create_org_contact (
49 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
50 p_org_contact_rec IN hz_party_contact_v2pub.org_contact_rec_type,
51 p_direction_code IN VARCHAR2,
52 x_org_contact_id OUT NOCOPY NUMBER,
53 x_party_rel_id OUT NOCOPY NUMBER,
54 x_party_id OUT NOCOPY NUMBER,
55 x_party_number OUT NOCOPY VARCHAR2,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2);
59
60
61
62 PROCEDURE get_org_contact_rec (
63 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
64 p_org_contact_id IN NUMBER,
65 x_org_contact_rec OUT NOCOPY hz_party_contact_v2pub.org_contact_rec_type,
66 x_direction_code OUT NOCOPY VARCHAR2,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2
70 );
71
72 --------------------PARTY_SITE-----------------------------------------------
73 PROCEDURE create_party_site (
74 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
75 p_party_site_rec IN hz_party_site_v2pub.party_site_rec_type,
76 p_actual_cont_source IN VARCHAR2,
77 x_party_site_id OUT NOCOPY NUMBER,
78 x_party_site_number OUT NOCOPY VARCHAR2,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2
82 );
83
84 PROCEDURE get_party_site_rec (
85 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
86 p_party_site_id IN NUMBER,
87 x_party_site_rec OUT NOCOPY hz_party_site_v2pub.party_site_rec_type,
88 x_actual_cont_source OUT NOCOPY VARCHAR2,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2
92 );
93
94 ------------------account_site-----------------------------------------------
95
96 PROCEDURE create_cust_acct_site (
97 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
98 p_cust_acct_site_rec IN hz_cust_account_site_v2pub.cust_acct_site_rec_type,
99 p_org_id IN NUMBER DEFAULT null,
100 x_cust_acct_site_id OUT NOCOPY NUMBER,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2
104 );
105
106 PROCEDURE create_cust_site_use (
107 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
108 p_cust_site_use_rec IN hz_cust_account_site_v2pub.cust_site_use_rec_type,
109 p_customer_profile_rec IN hz_customer_profile_v2pub.customer_profile_rec_type,
110 p_create_profile IN VARCHAR2 := fnd_api.g_true,
111 p_create_profile_amt IN VARCHAR2 := fnd_api.g_true,
112 p_org_id IN NUMBER DEFAULT null,
113 x_site_use_id OUT NOCOPY NUMBER,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2
117 );
118 ----------------CUST_PROFILE-------------------------------------------------
119 PROCEDURE create_customer_profile (
120 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
121 p_customer_profile_rec IN hz_customer_profile_v2pub.customer_profile_rec_type,
122 p_create_profile_amt IN VARCHAR2 := fnd_api.g_true,
123 x_cust_account_profile_id OUT NOCOPY NUMBER,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2
127 );
128
129
130 PROCEDURE create_cust_profile_amt (
131 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
132 p_check_foreign_key IN VARCHAR2 := fnd_api.g_true,
133 p_cust_profile_amt_rec IN hz_customer_profile_v2pub.cust_profile_amt_rec_type,
134 x_cust_acct_profile_amt_id OUT NOCOPY NUMBER,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2
138 );
139
140 ------------------------CONTACT_POINTS------------------------
141
142 g_miss_edi_rec hz_contact_point_v2pub.edi_rec_type;
143 g_miss_eft_rec hz_contact_point_v2pub.eft_rec_type;
144 g_miss_email_rec hz_contact_point_v2pub.email_rec_type;
145 g_miss_phone_rec hz_contact_point_v2pub.phone_rec_type;
146 g_miss_telex_rec hz_contact_point_v2pub.telex_rec_type;
147 g_miss_web_rec hz_contact_point_v2pub.web_rec_type;
148
149 PROCEDURE create_contact_point (
150 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
151 p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
152 p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := g_miss_edi_rec,
153 p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
154 p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,
155 p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,
156 p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := g_miss_telex_rec,
157 p_web_rec IN hz_contact_point_v2pub.web_rec_type := g_miss_web_rec,
158 x_contact_point_id OUT NOCOPY NUMBER,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2
162 );
163
164 PROCEDURE get_contact_point_rec (
165 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
166 p_contact_point_id IN NUMBER,
167 x_contact_point_rec OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
168 x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
169 x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
170 x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
171 x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
172 x_telex_rec OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
173 x_web_rec OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2
177 );
178
179 ----- Party Site Uses --------------------
180
181 PROCEDURE create_party_site_use (
182 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
183 p_party_site_use_rec IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE,
184 x_party_site_use_id OUT NOCOPY NUMBER,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2
188 );
189
190 PROCEDURE get_party_site_use_rec (
191 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192 p_party_site_use_id IN NUMBER,
193 x_party_site_use_rec OUT NOCOPY HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2
197 );
198
199 END hz_cust_account_merge_v2pvt;