1 PACKAGE POS_MERGE_SUPPLIER_PKG AUTHID CURRENT_USER AS
2 /* $Header: POSMRGSUPS.pls 120.1 2010/11/25 12:27:05 puppulur noship $ */
3
4 PROCEDURE buss_class_merge
5 (
6 p_entity_name IN VARCHAR2,
7 p_from_id IN NUMBER,
8 x_to_id IN OUT NOCOPY NUMBER,
9 p_from_fk_id IN NUMBER,
10 p_to_fk_id IN NUMBER,
11 p_parent_entity_name IN VARCHAR2,
12 p_batch_id IN NUMBER,
13 p_batch_party_id IN NUMBER,
14 x_return_status OUT NOCOPY VARCHAR2
15 );
16
17 PROCEDURE prod_service_merge
18 (
19 p_entity_name IN VARCHAR2,
20 p_from_id IN NUMBER,
21 x_to_id IN OUT NOCOPY NUMBER,
22 p_from_fk_id IN NUMBER,
23 p_to_fk_id IN NUMBER,
24 p_parent_entity_name IN VARCHAR2,
25 p_batch_id IN NUMBER,
26 p_batch_party_id IN NUMBER,
27 x_return_status OUT NOCOPY VARCHAR2
28 );
29
30 PROCEDURE bank_dtls_merge
31 (
32 p_entity_name IN VARCHAR2,
33 p_from_id IN NUMBER,
34 x_to_id IN OUT NOCOPY NUMBER,
35 p_from_fk_id IN NUMBER,
36 p_to_fk_id IN NUMBER,
37 p_parent_entity_name IN VARCHAR2,
38 p_batch_id IN NUMBER,
39 p_batch_party_id IN NUMBER,
40 x_return_status OUT NOCOPY VARCHAR2
41 );
42
43 PROCEDURE enable_party_as_supplier
44 (
45 p_entity_name IN VARCHAR2,
46 p_from_id IN NUMBER,
47 x_to_id IN OUT NOCOPY NUMBER,
48 p_from_fk_id IN NUMBER,
49 p_to_fk_id IN NUMBER,
50 p_parent_entity_name IN VARCHAR2,
51 p_batch_id IN NUMBER,
52 p_batch_party_id IN NUMBER,
53 x_return_status OUT NOCOPY VARCHAR2
54 );
55
56 PROCEDURE party_contact_merge
57 (
58 p_entity_name IN VARCHAR2,
59 p_from_id IN NUMBER,
60 x_to_id IN OUT NOCOPY NUMBER,
61 p_from_fk_id IN NUMBER,
62 p_to_fk_id IN NUMBER,
63 p_parent_entity_name IN VARCHAR2,
64 p_batch_id IN NUMBER,
65 p_batch_party_id IN NUMBER,
66 x_return_status OUT NOCOPY VARCHAR2
67 );
68
69 PROCEDURE supplier_uda_merge
70 (
71 p_entity_name IN VARCHAR2,
72 p_from_id IN NUMBER,
73 x_to_id IN OUT NOCOPY NUMBER,
74 p_from_fk_id IN NUMBER,
75 p_to_fk_id IN NUMBER,
76 p_parent_entity_name IN VARCHAR2,
77 p_batch_id IN NUMBER,
78 p_batch_party_id IN NUMBER,
79 x_return_status OUT NOCOPY VARCHAR2
80 );
81
82 PROCEDURE party_site_uda_merge
83 (
84 p_entity_name IN VARCHAR2,
85 p_from_id IN NUMBER,
86 x_to_id IN OUT NOCOPY NUMBER,
87 p_from_fk_id IN NUMBER,
88 p_to_fk_id IN NUMBER,
89 p_parent_entity_name IN VARCHAR2,
90 p_batch_id IN NUMBER,
91 p_batch_party_id IN NUMBER,
92 x_return_status OUT NOCOPY VARCHAR2
93 );
94
95 PROCEDURE supplier_site_uda_merge
96 (
97 p_from_id IN NUMBER,
98 p_from_fk_id IN NUMBER,
99 p_to_fk_id IN NUMBER,
100 x_return_status OUT NOCOPY VARCHAR2
101 );
102
103 END pos_merge_supplier_pkg;