1 PACKAGE CSI_PARTY_MERGE_PKG AS
2 /* $Header: csipymgs.pls 120.0 2005/05/24 17:45:56 appldev noship $ */
3
4 /******************************************************************************
5 Parameters: Applies to all APIs
6
7 IN - All IN parameters are REQUIRED.
8 p_entity_name VARCHAR2 - Name of the entity that is being merged
9 p_from_id NUMBER - Id of the record that is being merged
10 p_from_fk_id NUMBER - Id of the Old Parent
11 p_to_fk_id NUMBER - Id of the New Parent
12 p_parent_entity_name VARCHAR2 - Parent entity name
13 p_batch_id NUMBER - Id of the Batch
14 p_batch_party_id NUMBER - Id of the batch and party record
15 OUT NOCOPY:
16 x_to_id NUMBER - Id of the record under the new parent
17 that its merged to
18 x_return_status VARCHAR2 - Return the status of the procedure
19 ******************************************************************************/
20
21 PROCEDURE CSI_ITEM_INSTANCES_MERGE(
22 p_entity_name IN VARCHAR2,
23 p_from_id IN NUMBER,
24 x_to_id OUT NOCOPY NUMBER,
25 p_from_fk_id IN NUMBER,
26 p_to_fk_id IN NUMBER,
27 p_parent_entity_name IN VARCHAR2,
28 p_batch_id IN NUMBER,
29 p_batch_party_id IN NUMBER,
30 x_return_status OUT NOCOPY VARCHAR2);
31
32 PROCEDURE CSI_I_PARTIES_MERGE(
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 PROCEDURE CSI_SYSTEMS_B_MERGE(
44 p_entity_name IN VARCHAR2,
45 p_from_id IN NUMBER,
46 x_to_id OUT NOCOPY NUMBER,
47 p_from_fk_id IN NUMBER,
48 p_to_fk_id IN NUMBER,
49 p_parent_entity_name IN VARCHAR2,
50 p_batch_id IN NUMBER,
51 p_batch_party_id IN NUMBER,
52 x_return_status OUT NOCOPY VARCHAR2);
53
54 PROCEDURE CSI_T_PARTY_DETAILS_MERGE(
55 p_entity_name IN VARCHAR2,
56 p_from_id IN NUMBER,
57 x_to_id OUT NOCOPY NUMBER,
58 p_from_fk_id IN NUMBER,
59 p_to_fk_id IN NUMBER,
60 p_parent_entity_name IN VARCHAR2,
61 p_batch_id IN NUMBER,
62 p_batch_party_id IN NUMBER,
63 x_return_status OUT NOCOPY VARCHAR2);
64
65 PROCEDURE CSI_T_TXN_SYSTEMS_MERGE(
66 p_entity_name IN VARCHAR2,
67 p_from_id IN NUMBER,
68 x_to_id OUT NOCOPY NUMBER,
69 p_from_fk_id IN NUMBER,
70 p_to_fk_id IN NUMBER,
71 p_parent_entity_name IN VARCHAR2,
72 p_batch_id IN NUMBER,
73 p_batch_party_id IN NUMBER,
74 x_return_status OUT NOCOPY VARCHAR2);
75
76 PROCEDURE CSI_T_TXN_LINE_DETAILS_MERGE(
77 p_entity_name IN VARCHAR2,
78 p_from_id IN NUMBER,
79 x_to_id OUT NOCOPY NUMBER,
80 p_from_fk_id IN NUMBER,
81 p_to_fk_id IN NUMBER,
82 p_parent_entity_name IN VARCHAR2,
83 p_batch_id IN NUMBER,
84 p_batch_party_id IN NUMBER,
85 x_return_status OUT NOCOPY VARCHAR2);
86
87 END CSI_PARTY_MERGE_PKG;