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;