1 PACKAGE FUN_PARTY_MERGE_PUB AUTHID CURRENT_USER as
2 /* $Header: funptymerges.pls 120.0 2005/05/13 01:15:06 akwu noship $ */
3
4 G_PACKAGE_NAME CONSTANT VARCHAR2(50) := 'FUN_PARTY_MERGE_PUB';
5
6 --***************************************************************************--
7
8 --========================================================================
9 -- PROCEDURE : merge_trx_batches Called by HZ Party merge routine
10 -- Should not be called by any other application
11 --
12 -- PARAMETERS: p_entity_name HZ entity name being merged
13 -- p_from_id Input Facility Id to change
14 -- p_to_id Changed Facility Id
15 -- p_from_fk_id Party id before merge
16 -- p_to_fk_id Party id after merge
17 -- p_parent_entity_name
18 -- p_batch_id
19 -- p_batch_party_id
20 -- x_return_status Return status
21 -- COMMENT : This procedure is used to perform for following actions
22 -- When the relationship party merges
23 -- the corresponding initiator_id needs to be merged
24 --========================================================================
25
26 PROCEDURE merge_trx_batches(
27 p_entity_name IN VARCHAR2,
28 p_from_id IN NUMBER,
29 p_to_id IN OUT NOCOPY NUMBER,
30 p_from_fk_id IN NUMBER,
31 p_to_fk_id IN NUMBER,
32 p_parent_entity_name IN VARCHAR2,
33 p_batch_id IN NUMBER,
34 p_batch_party_id IN NUMBER,
35 x_return_status OUT NOCOPY VARCHAR2);
36
37
38 --========================================================================
39 -- PROCEDURE : merge_trx_headers Called by HZ Party merge routine
40 -- Should not be called by any other application
41 --
42 -- COMMENT : This procedure is used to perform for following actions
43 -- When the relationship party merges
44 -- the corresponding initiator_id and recipient_id need to be merged
45 --========================================================================
46
47 PROCEDURE merge_trx_headers(
48 p_entity_name IN VARCHAR2,
49 p_from_id IN NUMBER,
50 p_to_id IN OUT NOCOPY NUMBER,
51 p_from_fk_id IN NUMBER,
52 p_to_fk_id IN NUMBER,
53 p_parent_entity_name IN VARCHAR2,
54 p_batch_id IN NUMBER,
55 p_batch_party_id IN NUMBER,
56 x_return_status OUT NOCOPY VARCHAR2);
57
58
59 --========================================================================
60 -- PROCEDURE : merge_dist_lines Called by HZ Party merge routine
61 -- Should not be called by any other application
62 --
63 -- COMMENT : This procedure is used to perform for following actions
64 -- When the relationship party merges
65 -- the corresponding party_id needs to be merged
66 --========================================================================
67
68 PROCEDURE merge_dist_lines(
69 p_entity_name IN VARCHAR2,
70 p_from_id IN NUMBER,
71 p_to_id IN OUT NOCOPY NUMBER,
72 p_from_fk_id IN NUMBER,
73 p_to_fk_id IN NUMBER,
74 p_parent_entity_name IN VARCHAR2,
75 p_batch_id IN NUMBER,
76 p_batch_party_id IN NUMBER,
77 x_return_status OUT NOCOPY VARCHAR2);
78
79
80 --========================================================================
81 -- PROCEDURE : merge_customer_maps Called by HZ Party merge routine
82 -- Should not be called by any other application
83 --
84 -- COMMENT : This procedure is used to perform for following actions
85 -- When the relationship party merges
86 -- the corresponding party_id needs to be merged
87 --========================================================================
88
89 PROCEDURE merge_customer_maps(
90 p_entity_name IN VARCHAR2,
91 p_from_id IN NUMBER,
92 p_to_id IN OUT NOCOPY NUMBER,
93 p_from_fk_id IN NUMBER,
94 p_to_fk_id IN NUMBER,
95 p_parent_entity_name IN VARCHAR2,
96 p_batch_id IN NUMBER,
97 p_batch_party_id IN NUMBER,
98 x_return_status OUT NOCOPY VARCHAR2);
99
100
101 --========================================================================
102 -- PROCEDURE : merge_supplier_maps Called by HZ Party merge routine
103 -- Should not be called by any other application
104 --
105 -- COMMENT : This procedure is used to perform for following actions
106 -- When the relationship party merges
107 -- the corresponding party_id needs to be merged
108 --========================================================================
109
110 PROCEDURE merge_supplier_maps(
111 p_entity_name IN VARCHAR2,
112 p_from_id IN NUMBER,
113 p_to_id IN OUT NOCOPY NUMBER,
114 p_from_fk_id IN NUMBER,
115 p_to_fk_id IN NUMBER,
116 p_parent_entity_name IN VARCHAR2,
117 p_batch_id IN NUMBER,
118 p_batch_party_id IN NUMBER,
119 x_return_status OUT NOCOPY VARCHAR2);
120
121
122 END FUN_PARTY_MERGE_PUB;