DBA Data[Home] [Help]

PACKAGE: APPS.JTF_RS_PARTY_MERGE_PUB

Source


1 PACKAGE JTF_RS_PARTY_MERGE_PUB AUTHID CURRENT_USER AS
2 /* $Header: jtfrsbms.pls 120.0 2005/05/11 08:19:21 appldev ship $ */
3 /*#
4  * Party Merge API for Resource manager
5  * This API contains the procedures to Party merge, Party site merge and Party contact merge in Resource manager.
6  * @rep:scope internal
7  * @rep:product JTF
8  * @rep:displayname Party Merge API for Resource manager
9  * @rep:category BUSINESS_ENTITY JTF_RS_RESOURCE
10  * @rep:businessevent oracle.apps.jtf.jres.resource.merge
11 */
12 
13 /************************************************************
14 
15 This is the part and party site merge package for jtf resources
16 
17  *****************************************************************************/
18 
19 /*#
20  * Resource Party Merge API
21  * This procedure allows to merge two party resources or partner resources.
22  * @param p_entity_name Entity Name
23  * @param p_from_id From Resource Identifier
24  * @param p_from_fk_id From Party Identifier
25  * @param p_to_fk_id To Party Identifier
26  * @param p_parent_entity_name Parent Entity Name
27  * @param p_batch_id Batch Identifier
28  * @param p_batch_party_id Batch Party Identifier
29  * @param x_return_status Output parameter for return status
30  * @param x_to_id Out parameter for To Resource Identifier
31  * @rep:scope internal
32  * @rep:lifecycle active
33  * @rep:displayname Resource Party Merge API
34  * @rep:businessevent oracle.apps.jtf.jres.resource.merge
35 */
36 PROCEDURE resource_party_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  * Resource Party Site Merge API
49  * This procedure allows to merge two party Sites in Resource Manager.
50  * @param p_entity_name Entity Name
51  * @param p_from_id From Resource Identifier
52  * @param p_from_fk_id From Party Identifier
53  * @param p_to_fk_id To Party Identifier
54  * @param p_parent_entity_name Parent Entity Name
55  * @param p_batch_id Batch Identifier
56  * @param p_batch_party_id Batch Party Identifier
57  * @param x_to_id Out parameter for To Resource Identifier
58  * @param x_return_status Output parameter for return status
59  * @rep:scope internal
60  * @rep:lifecycle active
61  * @rep:displayname Resource Party Site Merge API
62  * @rep:businessevent oracle.apps.jtf.jres.resource.merge
63 */
64 PROCEDURE resource_party_site_merge(
65                            p_entity_name                IN   VARCHAR2,
66                            p_from_id                    IN   NUMBER,
67                            x_to_id                      OUT NOCOPY NUMBER,
68               		   p_from_fk_id                 IN   NUMBER,
69                            p_to_fk_id                   IN   NUMBER,
70                            p_parent_entity_name         IN   VARCHAR2,
71 			   p_batch_id                   IN   NUMBER,
72 			   p_batch_party_id             IN   NUMBER,
73 			   x_return_status              OUT NOCOPY VARCHAR2);
74 
75 /*#
76  * Resource Party Contact Merge API
77  * This procedure allows to merge two party Contacts in Resource Manager.
78  * @param p_entity_name Entity Name
79  * @param p_from_id From Resource Identifier
80  * @param p_from_fk_id From Party Identifier
81  * @param p_to_fk_id To Party Identifier
82  * @param p_parent_entity_name Parent Entity Name
83  * @param p_batch_id Batch Identifier
84  * @param p_batch_party_id Batch Party Identifier
85  * @param x_to_id Out parameter for To Resource Identifier
86  * @param x_return_status Output parameter for return status
87  * @rep:scope internal
88  * @rep:lifecycle active
89  * @rep:displayname Resource Party Contact Merge API
90 */
91 PROCEDURE resource_party_cont_merge(
92                            p_entity_name                IN   VARCHAR2,
93                            p_from_id                    IN   NUMBER,
94                            x_to_id                      OUT NOCOPY NUMBER,
95               		   p_from_fk_id                 IN   NUMBER,
96                            p_to_fk_id                   IN   NUMBER,
97                            p_parent_entity_name         IN   VARCHAR2,
98 			   p_batch_id                   IN   NUMBER,
99 			   p_batch_party_id             IN   NUMBER,
100 			   x_return_status              OUT NOCOPY VARCHAR2);
101 
102 /*#
103  * Resource Support Site Merge API
104  * This procedure allows to merge two support sites in Resource Manager.
105  * @param p_entity_name Entity Name
106  * @param p_from_id From Resource Identifier
107  * @param p_from_fk_id From Party Site Identifier
108  * @param p_to_fk_id To Party Site Identifier
109  * @param p_parent_entity_name Parent Entity Name
110  * @param p_batch_id Batch Identifier
111  * @param p_batch_party_id Batch Party Identifier
112  * @param x_to_id Out parameter for To Resource Identifier
113  * @param x_return_status Output parameter for return status
114  * @rep:scope internal
115  * @rep:lifecycle active
116  * @rep:displayname Resource Support Site Merge API
117 */
118 PROCEDURE resource_support_site_merge(
119                            p_entity_name                IN   VARCHAR2,
120                            p_from_id                    IN   NUMBER,
121                            x_to_id                      OUT NOCOPY NUMBER,
122                            p_from_fk_id                 IN   NUMBER,
123                            p_to_fk_id                   IN   NUMBER,
124                            p_parent_entity_name         IN   VARCHAR2,
125                            p_batch_id                   IN   NUMBER,
126                            p_batch_party_id             IN   NUMBER,
127                            x_return_status              OUT NOCOPY VARCHAR2);
128 
129 end;