1 PACKAGE OKC_REP_PARTY_MERGE_GRP AUTHID CURRENT_USER AS
2 /* $Header: OKCGREPMERGES.pls 120.0 2005/05/25 19:09:47 appldev noship $ */
3
4 ------------------------------------------------------------------------------------
5 -- Global Constants
6 ------------------------------------------------------------------------------------
7 G_PACKAGE_NAME CONSTANT VARCHAR2(1) := 'OKC_REP_PARTY_MERGE_GRP';
8
9
10 G_PARTNER_ROLE CONSTANT VARCHAR2(1) := 'PARTNER_ORG';
11 G_CUSTOMER_ROLE CONSTANT VARCHAR2(1) := 'CUSTOMER_ORG';
12 G_SUPPLIER_ROLE CONSTANT VARCHAR2(1) := 'SUPPLIER_ORG';
13
14 G_OKC_REP_DOCUMENT_CLASS CONSTANT VARCHAR2(30) := 'REPOSITORY';
15
16
17 G_HZ_PARTY_ENTITY CONSTANT VARCHAR2(30) := 'HZ_PARTIES';
18 G_HZ_PARTY_SITES_ENTITY CONSTANT VARCHAR2(30) := 'HZ_PARTY_SITES';
19 G_OKC_REP_PARTY_ENTITY CONSTANT VARCHAR2(30) := 'OKC_REP_CONTRACT_PARTIES';
20
21
22 ---------------------------------------------------------------------------
23 -- START: Procedures and Functions
24 ---------------------------------------------------------------------------
25
26 -- Start of comments
27 --API name : party_merge
28 --Type : Group.
29 --Procedure : Merge Parties from HZ_PARTIES table that are referenced from
30 -- OKC_REP_CONTRACT_PARTIES table.
31 --Pre-reqs : None.
32 --Parameters :
33 --IN : p_entity_name IN HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE
34 -- : p_entity_name is the registered entity for which
35 -- : this routine is being called. It should have the value
36 -- : OKC_REP_CONTRACT_PARTIES.
37 -- :
38 -- : p_from_id IN ROWID
39 -- : PK of the entity that is being merged.
40 -- :
41 -- : x_to_id OUT ROWID
42 --
43 -- : p_from_fk_id IN NUMBER
44 -- : Old PK of the entity being merged.
45 -- :
46 -- : p_to_fk_id IN NUMBER
47 -- : New PK of the entity being merged.
48 -- :
49 -- : p_parent_entity_name IN HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE
50 -- : Entity name of the parent which is being merged.
51 -- : This should have the value HZ_PARTIES.
52 -- :
53 -- : p_batch_id IN NUMBER
54 -- : ID of the batch.
55 -- :
56 -- : p_batch_party_id IN NUMBER
57 -- : ID that uniquely identifies the batch and
58 -- : party record that is being merged.
59 -- End of comments
60
61 PROCEDURE party_merge(p_entity_name IN HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE,
62 p_from_id IN ROWID,
63 x_to_id IN OUT NOCOPY ROWID,
64 p_from_fk_id IN NUMBER,
65 p_to_fk_id IN NUMBER,
66 p_parent_entity_name IN HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE,
67 p_batch_id IN NUMBER,
68 p_batch_party_id IN NUMBER);
69
70 ---------------------------------------------------------------------------
71 -- START: Procedures and Functions
72 ---------------------------------------------------------------------------
73
74 -- Start of comments
75 --API name : party_site_merge
76 --Type : Group.
77 --Procedure : Merge Parties from HZ_PARTY_SITES table that are referenced from
78 -- OKC_REP_CONTRACT_PARTIES.location_id table.
79 --Pre-reqs : None.
80 --Parameters :
81 --IN : p_entity_name IN HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE
82 -- : p_entity_name is the registered entity for which
83 -- : this routine is being called. It should have the value
84 -- : OKC_REP_CONTRACT_PARTIES.
85 -- :
86 -- : p_from_id IN ROWID
87 -- : PK of the entity that is being merged.
88 -- :
89 -- : x_to_id OUT ROWID
90 --
91 -- : p_from_fk_id IN NUMBER
92 -- : Old PK of the entity being merged.
93 -- :
94 -- : p_to_fk_id IN NUMBER
95 -- : New PK of the entity being merged.
96 -- :
97 -- : p_parent_entity_name IN HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE
98 -- : Entity name of the parent which is being merged.
99 -- : This should have the value HZ_PARTIES.
100 -- :
101 -- : p_batch_id IN NUMBER
102 -- : ID of the batch.
103 -- :
104 -- : p_batch_party_id IN NUMBER
105 -- : ID that uniquely identifies the batch and
106 -- : party record that is being merged.
107 -- End of comments
108
109 PROCEDURE party_site_merge(p_entity_name IN HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE,
110 p_from_id IN ROWID,
111 x_to_id IN OUT NOCOPY ROWID,
112 p_from_fk_id IN NUMBER,
113 p_to_fk_id IN NUMBER,
114 p_parent_entity_name IN HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE,
115 p_batch_id IN NUMBER,
116 p_batch_party_id IN NUMBER);
117
118 ---------------------------------------------------------------------------
119 -- START: Procedures and Functions
120 ---------------------------------------------------------------------------
121
122 -- Start of comments
123 --API name : party_merge
124 --Type : Group.
125 --Procedure : Merge Parties from PO_VENDORS table that are referenced from
126 -- OKC_REP_CONTRACT_PARTIES table.
127 --Pre-reqs : None.
128 --Parameters :
129 --IN : p_entity_name IN VARCHAR2
130 -- : p_entity_name is the registered entity for which
131 -- : this routine is being called. It should have the value
132 -- : OKC_REP_CONTRACT_PARTIES.
133 -- :
134 -- : p_from_id IN ROWID
135 -- : PK of the entity that is being merged.
136 -- :
137 -- : x_to_id OUT ROWID
138 --
139 -- : p_from_fk_id IN NUMBER
140 -- : Old PK of the entity being merged.
141 -- :
142 -- : p_to_fk_id IN NUMBER
143 -- : New PK of the entity being merged.
144 -- :
145 -- : p_parent_entity_name IN VARCHAR2
146 -- : Entity name of the parent which is being merged.
147 -- : This should have the value PO_VENDORS.
148 -- :
149 -- : p_batch_id IN NUMBER
150 -- : ID of the batch.
151 -- :
152 -- : p_batch_party_id IN NUMBER
153 -- : ID that uniquely identifies the batch and
154 -- : party record that is being merged.
155 -- End of comments
156
157 PROCEDURE vendor_merge(p_entity_name IN VARCHAR2,
158 p_from_id IN ROWID,
159 x_to_id IN OUT NOCOPY ROWID,
160 p_from_fk_id IN NUMBER,
161 p_to_fk_id IN NUMBER,
162 p_parent_entity_name IN VARCHAR2,
163 p_batch_id IN NUMBER,
164 p_batch_party_id IN NUMBER);
165
166 -- Start of comments
167 --API name : party_site_merge
168 --Type : Group.
169 --Procedure : Merge Parties from HZ_PARTY_SITES table that are referenced from
170 -- OKC_REP_CONTRACT_PARTIES.location_id table.
171 --Pre-reqs : None.
172 --Parameters :
173 --IN : p_entity_name IN VARCHAR2
174 -- : p_entity_name is the registered entity for which
175 -- : this routine is being called. It should have the value
176 -- : OKC_REP_CONTRACT_PARTIES.
177 -- :
178 -- : p_from_id IN ROWID
179 -- : PK of the entity that is being merged.
180 -- :
181 -- : x_to_id OUT ROWID
182 --
183 -- : p_from_fk_id IN NUMBER
184 -- : Old PK of the entity being merged.
185 -- :
186 -- : p_to_fk_id IN NUMBER
187 -- : New PK of the entity being merged.
188 -- :
189 -- : p_parent_entity_name IN VARCHAR2
190 -- : Entity name of the parent which is being merged.
191 -- : This should have the value PO_VENDORS.
192 -- :
193 -- : p_batch_id IN NUMBER
194 -- : ID of the batch.
195 -- :
196 -- : p_batch_party_id IN NUMBER
197 -- : ID that uniquely identifies the batch and
198 -- : party record that is being merged.
199 -- End of comments
200
201 PROCEDURE vendor_site_merge(p_entity_name IN VARCHAR2,
202 p_from_id IN ROWID,
203 x_to_id IN OUT NOCOPY ROWID,
204 p_from_fk_id IN NUMBER,
205 p_to_fk_id IN NUMBER,
206 p_parent_entity_name IN VARCHAR2,
207 p_batch_id IN NUMBER,
208 p_batch_party_id IN NUMBER);
209
210
211 END OKC_REP_PARTY_MERGE_GRP;