1 package OKE_PARTY_MERGE_PKG AUTHID CURRENT_USER as
2 /* $Header: OKEVPMGS.pls 115.4 2002/11/21 20:48:19 syho ship $ */
3
4
5
6 --
7 -- Procedure: pool_party_merge
8 --
9 -- Description: This routine takes care of the party merge for OKE_POOL_PARTIES table
10 --
11
12 PROCEDURE pool_party_merge(p_merge_name IN VARCHAR2 ,
13 p_from_id IN NUMBER ,
14 p_to_id OUT NOCOPY NUMBER ,
15 p_from_fk_id IN NUMBER ,
16 p_to_fk_id IN NUMBER ,
17 p_parent_entity_name IN VARCHAR2 ,
18 p_batch_id IN NUMBER ,
19 p_batch_party_id IN NUMBER ,
20 x_return_status OUT NOCOPY VARCHAR2
21 );
22
23
24 --
25 -- Procedure: funding_party_merge
26 --
27 -- Description: This routine takes care of the party merge for OKE_K_FUNDING_SOURCES table
28 --
29
30 PROCEDURE funding_party_merge(p_merge_name IN VARCHAR2 ,
31 p_from_id IN NUMBER ,
32 p_to_id OUT NOCOPY NUMBER ,
33 p_from_fk_id IN NUMBER ,
34 p_to_fk_id IN NUMBER ,
35 p_parent_entity_name IN VARCHAR2 ,
36 p_batch_id IN NUMBER ,
37 p_batch_party_id IN NUMBER ,
38 x_return_status OUT NOCOPY VARCHAR2
39 );
40
41
42 --
43 -- Procedure: funding_party_h_merge
44 --
45 -- Description: This routine takes care of the party merge for OKE_K_FUNDING_SOURCES_H table
46 --
47
48 PROCEDURE funding_party_h_merge(p_merge_name IN VARCHAR2 ,
49 p_from_id IN NUMBER ,
50 p_to_id OUT NOCOPY 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
60 end OKE_PARTY_MERGE_PKG;