1 PACKAGE CSP_MERGE_PKG AUTHID CURRENT_USER AS
2 /*$Header: cspvmrgs.pls 115.5 2003/05/22 18:46:18 jjalla noship $*/
3 --Start of comments
4 --
5 -- API name : CSP_MERGE_PKG
6 -- Type : Private
7 -- Purpose : Merges duplicate parties in Spares tables. The
8 -- Spares tables that need to be considered for
9 -- Party Merge are:
10 -- CSP_MOVEORDER_HEADERS
11 -- CSP_PACKLIST_HEADERS
12 -- CSP_RS_CUST_RELATIONS
13 --
14 -- Modification History
15 -- Person Date Comments
16 -- --------- ----------- ------------------------------------------
17 -- iouyang 23-JUL-2001 New
18 --
19
20 -- *******************************************************
21 -- Start of Comments
22 -- *******************************************************
23 -- API Name: MO_MERGE_PARTY_SITE
24 -- Purpose : Performs party_site_id merge
25 -- in CSP_MOVEORDER_HEADERS table.
26 -- Type : private
27 -- Pre-Req : None.
28 -- Parameters:
29 -- IN - All IN parameters are REQUIRED.
30 -- p_entity_name VARCHAR2 - Name of the entity that is being merged
31 -- p_from_id NUMBER - Id of the record that is being merged
32 -- p_from_fk_id NUMBER - Id of the Old Parent
33 -- p_to_fk_id NUMBER - Id of the New Parent
34 -- p_parent_entity_name VARCHAR2 - Parent entity name
35 -- p_batch_id NUMBER - Id of the Batch
36 -- p_batch_party_id NUMBER - Id of the batch and party record
37 -- OUT:
38 -- x_to_id NUMBER - Id of the record under the new parent
39 -- that its merged to
40 -- x_return_status VARCHAR2 - Return the status of the procedure
41 --
42 -- Version : Current version 1.0
43 --
44 -- End of Comments
45 --
46 PROCEDURE mo_merge_party_site(
47 p_entity_name IN VARCHAR2,
48 p_from_id IN NUMBER,
49 x_to_id OUT NOCOPY NUMBER,
50 p_from_fk_id IN NUMBER,
51 p_to_fk_id IN NUMBER,
52 p_parent_entity_name IN VARCHAR2,
53 p_batch_id IN NUMBER,
54 p_batch_party_id IN NUMBER,
55 x_return_status OUT NOCOPY VARCHAR2);
56
57
58 -- *******************************************************
59 -- Start of Comments
60 -- *******************************************************
61 -- API Name: PL_MERGE_PARTY_SITE
62 -- Purpose : Performs party_site_id merge
63 -- in CSP_PACKLIST_HEADERS table.
64 -- Type : private
65 -- Pre-Req : None.
66 -- Parameters:
67 -- IN - All IN parameters are REQUIRED.
68 -- p_entity_name VARCHAR2 - Name of the entity that is being merged
69 -- p_from_id NUMBER - Id of the record that is being merged
70 -- p_from_fk_id NUMBER - Id of the Old Parent
71 -- p_to_fk_id NUMBER - Id of the New Parent
72 -- p_parent_entity_name VARCHAR2 - Parent entity name
73 -- p_batch_id NUMBER - Id of the Batch
74 -- p_batch_party_id NUMBER - Id of the batch and party record
75 -- OUT:
76 -- x_to_id NUMBER - Id of the record under the new parent
77 -- that its merged to
78 -- x_return_status VARCHAR2 - Return the status of the procedure
79 --
80 -- Version : Current version 1.0
81 --
82 -- End of Comments
83 --
84
85 PROCEDURE pl_merge_party_site(
86 p_entity_name IN VARCHAR2,
87 p_from_id IN NUMBER,
88 x_to_id OUT NOCOPY NUMBER,
89 p_from_fk_id IN NUMBER,
90 p_to_fk_id IN NUMBER,
91 p_parent_entity_name IN VARCHAR2,
92 p_batch_id IN NUMBER,
93 p_batch_party_id IN NUMBER,
94 x_return_status OUT NOCOPY VARCHAR2);
95
96 -- *******************************************************
97 -- Start of Comments
98 -- *******************************************************
99 -- API Name: MERGE_CUST_ACCOUNT
100 -- Purpose : Performs customer_id merge
101 -- in CSP_RS_CUST_RELATIONS table.
102 -- Type : private
103 -- Pre-Req : None.
104 -- Parameters:
105 -- IN - All IN parameters are REQUIRED.
106 -- req_id NUMBER - request id
107 -- set_number NUMBER - set_number
108 -- process_mode NUMBER - process_mode
109 --
110 -- Version : Current version 1.0
111 --
112 -- End of Comments
113 --
114
115 PROCEDURE merge_cust_account (
116 req_id Number,
117 set_num Number,
118 process_mode Varchar2);
119 END; -- Package spec