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