[Home] [Help]
PACKAGE: APPS.ZX_PARTY_MERGE_PKG
Source
1 PACKAGE ZX_PARTY_MERGE_PKG AS
2 /* $Header: zxcptpms.pls 120.0 2005/06/21 01:27:00 dbetanco noship $ */
3
4
5
6
7 PROCEDURE ZX_MERGE (
8 p_entity_name in hz_merge_dictionary.entity_name%type,
9 p_from_id in oks_billing_profiles_b.id%type,
10 x_to_id in out nocopy oks_billing_profiles_b.id%type,
11 p_from_fk_id in hz_merge_parties.from_party_id%type,
12 p_to_fk_id in hz_merge_parties.to_party_id%type,
13 p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
14 p_batch_id in hz_merge_batch.batch_id%type,
15 p_batch_party_id in hz_merge_party_details.batch_party_id%type,
16 x_return_status out nocopy varchar2);
17
18 TYPE reg_attr_rec_type IS RECORD ( REGISTRATION_TYPE_CODE VARCHAR2(30),
19 REGISTRATION_NUMBER VARCHAR2(50),
20 ROUNDING_RULE_CODE VARCHAR2(30),
21 SELF_ASSESS_FLAG VARCHAR2(1),
22 INCLUSIVE_TAX_FLAG VARCHAR2(1));
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 END; -- Package spec
39