1 PACKAGE RRS_PARTY_MERGE_PKG as
2 /* $Header: RRSPMRGS.pls 120.0 2005/09/21 08:00 pfarkade noship $ */
3
4 --========================================================================
5 -- PROCEDURE :merge_site_party
6 -- PARAMETERS:
7 -- p_entity_name Name of Entity Being Merged
8 -- p_from_id Primary Key Id of the entity that is being merged
9 -- p_to_id The record under the 'To Parent' that is being merged
10 -- p_from_fk_id Foreign Key id of the Old Parent Record
11 -- p_to_fk_id Foreign Key id of the New Parent Record
12 -- p_parent_entity_name Name of Parent Entity
13 -- p_batch_id Id of the Batch
14 -- p_batch_party_id Id uniquely identifies the batch and party record that is being merged
15 -- x_return_status Returns the staus of call
16 --
17 -- COMMENT : Merge of Real Estate party with another Real Estate or Non-Real Estate party is not allowed.
18 -- When an Legal Entity Party is getting merged update the records in RRS_SITES_B.
19 --========================================================================
20 PROCEDURE MERGE_SITE_PARTY(
21 p_entity_name IN VARCHAR2,
22 p_from_id IN NUMBER,
23 p_to_id IN NUMBER,
24 p_from_fk_id IN NUMBER,
25 p_to_fk_id IN NUMBER,
26 p_parent_entity_name IN VARCHAR2,
27 p_batch_id IN NUMBER,
28 p_batch_party_id IN NUMBER,
29 x_return_status OUT NOCOPY VARCHAR2);
30
31 --========================================================================
32 -- PROCEDURE :merge_le_party
33 -- PARAMETERS:
34 -- p_entity_name Name of Entity Being Merged
35 -- p_from_id Primary Key Id of the entity that is being merged
36 -- p_to_id The record under the 'To Parent' that is being merged
37 -- p_from_fk_id Foreign Key id of the Old Parent Record
38 -- p_to_fk_id Foreign Key id of the New Parent Record
39 -- p_parent_entity_name Name of Parent Entity
40 -- p_batch_id Id of the Batch
41 -- p_batch_party_id Id uniquely identifies the batch and party record that is being merged
42 -- x_return_status Returns the staus of call
43 --
44 -- COMMENT : When an Legal Entity Party is getting merged, update the records in RRS_SITES_B.
45 --==========================================================================
46
47 PROCEDURE MERGE_LE_PARTY(
48 p_entity_name IN VARCHAR2,
49 p_from_id IN NUMBER,
50 p_to_id IN NUMBER,
51 p_from_fk_id IN NUMBER,
52 p_to_fk_id IN NUMBER,
53 p_parent_entity_name IN VARCHAR2,
54 p_batch_id IN NUMBER,
55 p_batch_party_id IN NUMBER,
56 x_return_status OUT NOCOPY VARCHAR2);
57
58 --===========================================================================
59 END RRS_PARTY_MERGE_PKG;