1 PACKAGE QP_PARTY_MERGE_PKG AUTHID CURRENT_USER AS
2 /* $Header: QPXPMRGS.pls 120.1 2005/06/13 02:39:17 appldev $ */
3
4 --GLOBAL Constant holding the package name
5
6 G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_PARTY_MERGE_PKG';
7
8 /***********************************************************************
9 Procedure to Merge those qualifier_attr_value's in QP_QUALIFIERS which
10 reference Party_Id or Party_Site_Id. To be called by TCA when Parties
11 or Party Sites are merged.
12 ***********************************************************************/
13
14 Procedure Merge_Qualifiers(p_entity_name IN VARCHAR2,
15 p_from_id IN NUMBER,
16 p_to_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
17 p_from_fk_id IN NUMBER,
18 p_to_fk_id IN NUMBER,
19 p_parent_entity_name IN VARCHAR2,
20 p_batch_id IN NUMBER,
21 p_batch_party_id IN NUMBER,
22 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
23
24
25 END QP_PARTY_MERGE_PKG;