1 PACKAGE JTF_TERR_MERGE_PUB AUTHID CURRENT_USER AS
2 /* $Header: jtfptrms.pls 120.3 2006/02/12 17:47:07 jradhakr noship $ */
3 -- ---------------------------------------------------
4 -- Start of Comments
5 -- ---------------------------------------------------
6 -- PACKAGE NAME: JTF_TERR_MERGE_PUB
7 -- ---------------------------------------------------
8 -- PURPOSE
9 -- Joint task force core territory manager public api's.
10 -- This package is a public API for party and
11 -- party site merge
12 --
13 -- Procedures:
14 -- (see below for specification)
15 --
16 -- NOTES
17 -- This package is publicly available for use
18 --
19 -- HISTORY
20 -- 03/05/01 JDOCHERT Created
21 --
22 -- End of Comments
23 --
24
25 PROCEDURE party_merge(
26 p_entity_name IN VARCHAR2,
27 p_from_id IN NUMBER,
28 x_to_id OUT NOCOPY NUMBER,
29 p_from_fk_id IN NUMBER,
30 p_to_fk_id IN NUMBER,
31 p_parent_entity_name IN VARCHAR2,
32 p_batch_id IN NUMBER,
33 p_batch_party_id IN NUMBER,
34 x_return_status OUT NOCOPY VARCHAR2);
35
36 PROCEDURE party_site_merge(
37 p_entity_name IN VARCHAR2,
38 p_from_id IN NUMBER,
39 x_to_id OUT NOCOPY NUMBER,
40 p_from_fk_id IN NUMBER,
41 p_to_fk_id IN NUMBER,
42 p_parent_entity_name IN VARCHAR2,
43 p_batch_id IN NUMBER,
44 p_batch_party_id IN NUMBER,
45 x_return_status OUT NOCOPY VARCHAR2);
46
47
48 END JTF_TERR_MERGE_PUB;