1 Package OKC_PARTY_MERGE_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKCPPMGS.pls 120.0 2005/05/25 18:43:56 appldev noship $ */
3
4 -- Notes :
5 --
6 -- *******************************************************
7 -- Start of Comments
8 -- *******************************************************
9 -- API Name: OKC_CPL_MERGE_PARTY
10 -- Purpose : Merges parties in OKC_K_PARTY_ROLES table
11 -- Type : Private
12 -- Pre-Req : None.
13 -- Parameters:
14 -- IN - All IN parameters are REQUIRED.
15 -- p_entity_name VARCHAR2 - Name of the entity that is being merged
16 -- p_from_id NUMBER - Id of the record that is being merged
17 -- p_from_fk_id NUMBER - Id of the Old Parent
18 -- p_to_fk_id NUMBER - Id of the New Parent
19 -- p_parent_entity_name VARCHAR2 - Parent entity name
20 -- p_batch_id NUMBER - Id of the Batch
21 -- p_batch_party_id NUMBER - Id of the batch and party record
22 -- OUT:
23 -- x_to_id NUMBER - Id of the record under the new parent
24 -- that its merged to
25 -- x_return_status VARCHAR2 - Return the status of the procedure
26 --
27 -- Version : Current version 1.0
28 --
29 -- End of Comments
30 --
31
32 PROCEDURE OKC_CPL_MERGE_PARTY(
33 p_entity_name IN VARCHAR2,
34 p_from_id IN NUMBER,
35 x_to_id OUT NOCOPY NUMBER,
36 p_from_fk_id IN NUMBER,
37 p_to_fk_id IN NUMBER,
38 p_parent_entity_name IN VARCHAR2,
39 p_batch_id IN NUMBER,
40 p_batch_party_id IN NUMBER,
41 x_return_status OUT NOCOPY VARCHAR2);
42 --
43 -- *******************************************************
44 -- Start of Comments
45 -- *******************************************************
46 -- API Name: OKC_RUL_MERGE_PARTY_ID1
47 -- Purpose : Merges parties in OKC_RULES (For OBJECT1_ID1 column associated with JTOT_OBJECT1_CODE) table
48 -- Type : Private
49 -- Pre-Req : None.
50 -- Parameters:
51 -- IN - All IN parameters are REQUIRED.
52 -- p_entity_name VARCHAR2 - Name of the entity that is being merged
53 -- p_from_id NUMBER - Id of the record that is being merged
54 -- p_from_fk_id NUMBER - Id of the Old Parent
55 -- p_to_fk_id NUMBER - Id of the New Parent
56 -- p_parent_entity_name VARCHAR2 - Parent entity name
57 -- p_batch_id NUMBER - Id of the Batch
58 -- p_batch_party_id NUMBER - Id of the batch and party record
59 -- p_request_id NUMBER - Id of the Request
60 -- OUT:
61 -- x_to_id NUMBER - Id of the record under the new parent
62 -- that its merged to
63 -- x_return_status VARCHAR2 - Return the status of the procedure
64 --
65 -- Version : Current version 1.0
66 --
67 -- End of Comments
68 --
69
70 PROCEDURE OKC_RUL_MERGE_PARTY_ID1(
71 p_entity_name IN VARCHAR2,
72 p_from_id IN NUMBER,
73 x_to_id OUT NOCOPY NUMBER,
74 p_from_fk_id IN NUMBER,
75 p_to_fk_id IN NUMBER,
76 p_parent_entity_name IN VARCHAR2,
77 p_batch_id IN NUMBER,
78 p_batch_party_id IN NUMBER,
79 x_return_status OUT NOCOPY VARCHAR2);
80 --
81 -- *******************************************************
82 -- Start of Comments
83 -- *******************************************************
84 -- API Name: OKC_RUL_MERGE_PARTY_ID2
85 -- Purpose : Merges parties in OKC_RULES (For OBJECT2_ID1 column associated with JTOT_OBJECT2_CODE) table
86 -- Type : Private
87 -- Pre-Req : None.
88 -- Parameters:
89 -- IN - All IN parameters are REQUIRED.
90 -- p_entity_name VARCHAR2 - Name of the entity that is being merged
91 -- p_from_id NUMBER - Id of the record that is being merged
92 -- p_from_fk_id NUMBER - Id of the Old Parent
93 -- p_to_fk_id NUMBER - Id of the New Parent
94 -- p_parent_entity_name VARCHAR2 - Parent entity name
95 -- p_batch_id NUMBER - Id of the Batch
96 -- p_batch_party_id NUMBER - Id of the batch and party record
97 -- p_request_id NUMBER - Id of the Request
98 -- OUT:
99 -- x_to_id NUMBER - Id of the record under the new parent
100 -- that its merged to
101 -- x_return_status VARCHAR2 - Return the status of the procedure
102 --
103 -- Version : Current version 1.0
104 --
105 -- End of Comments
106 --
107 PROCEDURE OKC_RUL_MERGE_PARTY_ID2(
108 p_entity_name IN VARCHAR2,
109 p_from_id IN NUMBER,
110 x_to_id OUT NOCOPY NUMBER,
111 p_from_fk_id IN NUMBER,
112 p_to_fk_id IN NUMBER,
113 p_parent_entity_name IN VARCHAR2,
114 p_batch_id IN NUMBER,
115 p_batch_party_id IN NUMBER,
116 x_return_status OUT NOCOPY VARCHAR2);
117 --
118 -- *******************************************************
119 -- Start of Comments
120 -- *******************************************************
121 -- API Name: OKC_RUL_MERGE_PARTY_ID3
122 -- Purpose : Merges parties in OKC_RULES (For OBJECT2_ID1 column associated with JTOT_OBJECT2_CODE) table
123 -- Type : Private
124 -- Pre-Req : None.
125 -- Parameters:
126 -- IN - All IN parameters are REQUIRED.
127 -- p_entity_name VARCHAR2 - Name of the entity that is being merged
128 -- p_from_id NUMBER - Id of the record that is being merged
129 -- p_from_fk_id NUMBER - Id of the Old Parent
130 -- p_to_fk_id NUMBER - Id of the New Parent
131 -- p_parent_entity_name VARCHAR2 - Parent entity name
132 -- p_batch_id NUMBER - Id of the Batch
133 -- p_batch_party_id NUMBER - Id of the batch and party record
134 -- p_request_id NUMBER - Id of the Request
135 -- OUT:
136 -- x_to_id NUMBER - Id of the record under the new parent
137 -- that its merged to
138 -- x_return_status VARCHAR2 - Return the status of the procedure
139 --
140 -- Version : Current version 1.0
141 --
142 -- End of Comments
143 --
144
145 PROCEDURE OKC_RUL_MERGE_PARTY_ID3(
146 p_entity_name IN VARCHAR2,
147 p_from_id IN NUMBER,
148 x_to_id OUT NOCOPY NUMBER,
149 p_from_fk_id IN NUMBER,
150 p_to_fk_id IN NUMBER,
151 p_parent_entity_name IN VARCHAR2,
152 p_batch_id IN NUMBER,
153 p_batch_party_id IN NUMBER,
154 x_return_status OUT NOCOPY VARCHAR2);
155 --
156 -- *******************************************************
157 -- Start of Comments
158 -- *******************************************************
159 -- API Name: OKC_CIM_MERGE_PARTY
160 -- Purpose : Merges parties in OKC_K_ITEMS table
161 -- Type : Private
162 -- Pre-Req : None.
163 -- Parameters:
164 -- IN - All IN parameters are REQUIRED.
165 -- p_entity_name VARCHAR2 - Name of the entity that is being merged
166 -- p_from_id NUMBER - Id of the record that is being merged
167 -- p_from_fk_id NUMBER - Id of the Old Parent
168 -- p_to_fk_id NUMBER - Id of the New Parent
169 -- p_parent_entity_name VARCHAR2 - Parent entity name
170 -- p_batch_id NUMBER - Id of the Batch
171 -- p_batch_party_id NUMBER - Id of the batch and party record
172 -- OUT:
173 -- x_to_id NUMBER - Id of the record under the new parent
174 -- that its merged to
175 -- x_return_status VARCHAR2 - Return the status of the procedure
176 --
177 -- Version : Current version 1.0
178 --
179 -- End of Comments
180 --
181
182 PROCEDURE OKC_CIM_MERGE_PARTY(
183 p_entity_name IN VARCHAR2,
184 p_from_id IN NUMBER,
185 x_to_id OUT NOCOPY NUMBER,
186 p_from_fk_id IN NUMBER,
187 p_to_fk_id IN NUMBER,
188 p_parent_entity_name IN VARCHAR2,
189 p_batch_id IN NUMBER,
190 p_batch_party_id IN NUMBER,
191 x_return_status OUT NOCOPY VARCHAR2);
192 --
193 --
194 -- *******************************************************
195 -- Start of Comments
196 -- *******************************************************
197 -- API Name: OKC_CTC_MERGE_PARTY
198 -- Purpose : Merges parties in OKC_CONTACTS table
199 -- Type : Private
200 -- Pre-Req : None.
201 -- Parameters:
202 -- IN - All IN parameters are REQUIRED.
203 -- p_entity_name VARCHAR2 - Name of the entity that is being merged
204 -- p_from_id NUMBER - Id of the record that is being merged
205 -- p_from_fk_id NUMBER - Id of the Old Parent
206 -- p_to_fk_id NUMBER - Id of the New Parent
207 -- p_parent_entity_name VARCHAR2 - Parent entity name
208 -- p_batch_id NUMBER - Id of the Batch
209 -- p_batch_party_id NUMBER - Id of the batch and party record
210 -- OUT:
211 -- x_to_id NUMBER - Id of the record under the new parent
212 -- that its merged to
213 -- x_return_status VARCHAR2 - Return the status of the procedure
214 --
215 -- Version : Current version 1.0
216 --
217 -- End of Comments
218 --
219
220 PROCEDURE OKC_CTC_MERGE_PARTY(
221 p_entity_name IN VARCHAR2,
222 p_from_id IN NUMBER,
223 x_to_id OUT NOCOPY NUMBER,
224 p_from_fk_id IN NUMBER,
225 p_to_fk_id IN NUMBER,
226 p_parent_entity_name IN VARCHAR2,
227 p_batch_id IN NUMBER,
228 p_batch_party_id IN NUMBER,
229 x_return_status OUT NOCOPY VARCHAR2);
230 --
231 END; -- Package Specification OKC_PARTY_MERGE_PUB