[Home] [Help]
PACKAGE: APPS.ZX_PARTY_MERGE_PKG
Source
1 PACKAGE ZX_PARTY_MERGE_PKG AUTHID CURRENT_USER AS
2 /* $Header: zxcptpms.pls 120.0.12010000.4 2009/10/29 14:24:32 ssohal ship $ */
3
4 PROCEDURE ZX_MERGE (
5 p_entity_name in hz_merge_dictionary.entity_name%type,
6 p_from_id in oks_billing_profiles_b.id%type,
7 x_to_id in out nocopy oks_billing_profiles_b.id%type,
8 p_from_fk_id in hz_merge_parties.from_party_id%type,
9 p_to_fk_id in hz_merge_parties.to_party_id%type,
10 p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
11 p_batch_id in hz_merge_batch.batch_id%type,
12 p_batch_party_id in hz_merge_party_details.batch_party_id%type,
13 x_return_status out nocopy varchar2);
14
15 TYPE reg_attr_rec_type IS RECORD ( REGISTRATION_TYPE_CODE VARCHAR2(30),
16 REGISTRATION_NUMBER VARCHAR2(50),
17 ROUNDING_RULE_CODE VARCHAR2(30),
18 SELF_ASSESS_FLAG VARCHAR2(1),
19 INCLUSIVE_TAX_FLAG VARCHAR2(1),
20 TAX_REGIME_CODE VARCHAR2(30),
21 TAX VARCHAR2(30),
22 REP_REGISTRATION_NUMBER VARCHAR2(50));
23
24 TYPE reg_attr_tbl_type IS TABLE of reg_attr_rec_type index by VARCHAR2(100);
25
26 TYPE reg_xle_rec_type IS RECORD ( REGISTRATION_TYPE_CODE VARCHAR2(30),
27 REGISTRATION_NUMBER VARCHAR2(50),
28 ROUNDING_RULE_CODE VARCHAR2(30),
29 SELF_ASSESS_FLAG VARCHAR2(1),
30 INCLUSIVE_TAX_FLAG VARCHAR2(1),
31 REGISTRATION_STATUS_CODE VARCHAR2(30),
32 BANK_ACCOUNT_NUM VARCHAR2(30),
33 BANK_ID NUMBER,
34 BANK_BRANCH_ID NUMBER);
35
36 TYPE reg_xle_tbl_type IS TABLE of reg_xle_rec_type index by VARCHAR2(100);
37
38 PROCEDURE MERGE_PTP_BULK
39 (request_id IN NUMBER,
40 set_number IN NUMBER,
41 process_mode IN VARCHAR2
42 );
43
44 PROCEDURE MERGE_PTP_SITES (
45 p_entity_name IN VARCHAR2,
46 p_from_id IN NUMBER,
47 p_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 VARCHAR2,
52 p_batch_party_id IN VARCHAR2,
53 x_return_status IN OUT NOCOPY VARCHAR2);
54
55 END ZX_PARTY_MERGE_PKG;