1 Package IBW_MERGE_PVT AUTHID CURRENT_USER As
2 /* $Header: ibwvmrgs.pls 120.2 2005/12/23 03:48:46 pakrishn noship $ */
3
4
5 /*------------------------------------------------------------------------------------------------------------------------*
6 | PUBLIC PROCEDURES |
7 | MERGE_PAGES -- |
8 | API registered to merge, party_id and party_relationship_id in ibw_page_views
9 | These API's will be called when party_id in the HZ_parties will be merged.
10 *--------------------------------------------------------------------------------------------------------------------------*/
11
12 PROCEDURE MERGE_PAGES(
13 P_entity_name IN VARCHAR2,
14 P_from_id IN NUMBER,
15 X_to_id OUT NOCOPY NUMBER,
16 P_from_fk_id IN NUMBER,
17 P_to_fk_id IN NUMBER,
18 P_parent_entity_name IN VARCHAR2,
19 P_batch_id IN NUMBER,
20 P_batch_party_id IN NUMBER,
21 X_return_status OUT NOCOPY VARCHAR2
22 ) ;
23
24
25 /*------------------------------------------------------------------------------------------------------------------------*
26 | PUBLIC PROCEDURES |
27 | MERGE_SITES -- |
28 | API registered to merge, party_id in ibw_site_visits
29 | These API's will be called when party_id in the HZ_parties will be merged.
30 *--------------------------------------------------------------------------------------------------------------------------*/
31
32
33
34 PROCEDURE MERGE_SITES(
35 P_entity_name IN VARCHAR2,
36 P_from_id IN NUMBER,
37 X_to_id OUT NOCOPY NUMBER,
38 P_from_fk_id IN NUMBER,
39 P_to_fk_id IN NUMBER,
40 P_parent_entity_name IN VARCHAR2,
41 P_batch_id IN NUMBER,
42 P_batch_party_id IN NUMBER,
43 X_return_status OUT NOCOPY VARCHAR2
44 );
45
46
47
48
49
50 END IBW_MERGE_PVT;