1 PACKAGE CS_CH_PARTY_MERGE_PKG AS
2 /* $Header: cschmpgs.pls 120.0 2006/02/09 16:39:24 spusegao noship $ */
3 -- Start of Comments
4 -- Package name : CS_CH_PARTY_MERGE_PKG
5 --
6 -- Purpose : Merges duplicate party_site_id's in Charges tables. The
7 -- Charges tables that need to be considered for
8 -- Party Merge are:
9 -- CS_ESTIMATE_DETAILS and CS_CHG_SUB_RESTRICTIONS.
10
11 -- History
12 -- MM-DD-YYYY NAME MODIFICATIONS
13 -- 11-20-2000 aseethep Created.
14 -- 11-08-2002 mviswana Added NOCOPY Functionality to file
15 -- 05/04/2003 mviswana Added new TCA Party Merge functionality
16 -- for 11.5.9 TCA columns in Charges
17 -- 08/12/2003 cnemalik For 11.5.10, added the new procedure
18 -- CS_CHG_ALL_SETUP_PARTY for the
19 -- Auto Submission Restriction Table.
20 --
21 -- End of Comments
22
23
24 -- *******************************************************
25 -- Start of Comments
26 -- *******************************************************
27 -- API Name: CS_CHG_ALL_MERGE_PARTY
28 -- Purpose : Performs bill_to_party_id/ship_to_party_id
29 -- bill_to_contact_id/ship_to_contact_id merge
30 -- in CS_ESTIMATE_DETAILS table.
31 -- Type : Private
32 -- Pre-Req : None.
33 -- Parameters:
34 -- IN - All IN parameters are REQUIRED.
35 -- p_entity_name VARCHAR2 - Name of the entity that is being merged
36 -- p_from_id NUMBER - Id of the record that is being merged
37 -- p_from_fk_id NUMBER - Id of the Old Parent
38 -- p_to_fk_id NUMBER - Id of the New Parent
39 -- p_parent_entity_name VARCHAR2 - Parent entity name
40 -- p_batch_id NUMBER - Id of the Batch
41 -- p_batch_party_id NUMBER - Id of the batch and party record
42 -- OUT:
43 -- x_to_id NUMBER - Id of the record under the new parent
44 -- that its merged to
45 -- x_return_status VARCHAR2 - Return the status of the procedure
46 --
47 -- Version : Current version 1.0
48 --
49 -- End of Comments
50 --
51
52
53 PROCEDURE CS_CHG_ALL_MERGE_PARTY (
54 p_entity_name IN VARCHAR2,
55 p_from_id IN NUMBER,
56 x_to_id OUT NOCOPY NUMBER,
57 p_from_fk_id IN NUMBER,
58 p_to_fk_id IN NUMBER,
59 p_parent_entity_name IN VARCHAR2,
60 p_batch_id IN NUMBER,
61 p_batch_party_id IN NUMBER,
62 x_return_status OUT NOCOPY VARCHAR2);
63
64
65 -- *******************************************************
66 -- Start of Comments
67 -- *******************************************************
68 -- API Name: CS_CHG_ALL_MERGE_SITE_ID
69 -- Purpose : Performs invoice_to_site_id/ship_to_site_id merge
70 -- in CS_ESTIMATE_DETAILS table.
71 -- Type : Private
72 -- Pre-Req : None.
73 -- Parameters:
74 -- IN - All IN parameters are REQUIRED.
75 -- p_entity_name VARCHAR2 - Name of the entity that is being merged
76 -- p_from_id NUMBER - Id of the record that is being merged
77 -- p_from_fk_id NUMBER - Id of the Old Parent
78 -- p_to_fk_id NUMBER - Id of the New Parent
79 -- p_parent_entity_name VARCHAR2 - Parent entity name
80 -- p_batch_id NUMBER - Id of the Batch
81 -- p_batch_party_id NUMBER - Id of the batch and party record
82 -- OUT:
83 -- x_to_id NUMBER - Id of the record under the new parent
84 -- that its merged to
85 -- x_return_status VARCHAR2 - Return the status of the procedure
86 --
87 -- Version : Current version 1.0
88 --
89 -- End of Comments
90 --
91 PROCEDURE CS_CHG_ALL_MERGE_SITE_ID(
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 -- Start of Comments
104 -- *******************************************************
105 -- API Name: CS_CHG_ALL_SETUP_PARTY
106 -- Purpose : Performs value_object_id merge
107 -- in CS_CHG_SUB_RESTRICTIONS table.
108 -- Type : Private
109 -- Pre-Req : None.
110 -- Parameters:
111 -- IN - All IN parameters are REQUIRED.
112 -- p_entity_name VARCHAR2 - Name of the entity that is being merged
113 -- p_from_id NUMBER - Id of the record that is being merged
114 -- p_from_fk_id NUMBER - Id of the Old Parent
115 -- p_to_fk_id NUMBER - Id of the New Parent
116 -- p_parent_entity_name VARCHAR2 - Parent entity name
117 -- p_batch_id NUMBER - Id of the Batch
118 -- p_batch_party_id NUMBER - Id of the batch and party record
119 -- OUT:
120 -- x_to_id NUMBER - Id of the record under the new parent
121 -- that its merged to
122 -- x_return_status VARCHAR2 - Return the status of the procedure
123 --
124 --
125 -- End of Comments
126
127 PROCEDURE CS_CHG_ALL_SETUP_PARTY(
128 p_entity_name IN VARCHAR2,
129 p_from_id IN NUMBER,
130 x_to_id OUT NOCOPY NUMBER,
131 p_from_fk_id IN NUMBER,
132 p_to_fk_id IN NUMBER,
133 p_parent_entity_name IN VARCHAR2,
134 p_batch_id IN NUMBER,
135 p_batch_party_id IN NUMBER,
136 x_return_status OUT NOCOPY VARCHAR2);
137
138
139 END CS_CH_PARTY_MERGE_PKG;
140
141