DBA Data[Home] [Help]

PACKAGE: APPS.QP_PARTY_MERGE_PKG

Source


1 PACKAGE QP_PARTY_MERGE_PKG 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;