1 package ZX_PTP_MIGRATE_PKG AUTHID CURRENT_USER AS
2 /* $Header: zxptpmigs.pls 120.5 2006/02/24 02:31:16 dbetanco ship $ */
3
4
5 ----The PL/SQL TABLES AND THE CORRESPONDING DECLARATIONS ARE PART OF BUG FIX 3722296
6
7 TYPE org_reg_num_tab IS TABLE OF HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%TYPE
8 INDEX BY BINARY_INTEGER;
9 TYPE loc_reg_num_tab IS TABLE OF HR_LOCATIONS_ALL.GLOBAL_ATTRIBUTE1%TYPE
10 INDEX BY BINARY_INTEGER;
11 TYPE ar_sys_reg_num_tab IS TABLE OF AR_SYSTEM_PARAMETERS_ALL.TAX_REGISTRATION_NUMBER%TYPE
12 INDEX BY BINARY_INTEGER;
13 TYPE fin_sys_reg_num_tab IS TABLE OF FINANCIALS_SYSTEM_PARAMS_ALL.VAT_REGISTRATION_NUM%TYPE
14 INDEX BY BINARY_INTEGER;
15 TYPE register_num_tab IS TABLE OF VARCHAR2(160)
16 INDEX BY BINARY_INTEGER;
17 TYPE party_tax_profile_tab IS TABLE OF ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE
18 INDEX BY BINARY_INTEGER;
19 TYPE hr_org_rep_info_tab IS TABLE OF VARCHAR2(160)
20 INDEX BY BINARY_INTEGER;
21 TYPE ar_tax_reg_num_info_tab IS TABLE OF VARCHAR2(70)
22 INDEX BY BINARY_INTEGER;
23 TYPE fin_vat_reg_num_tab IS TABLE OF VARCHAR2(30)
24 INDEX BY BINARY_INTEGER;
25 TYPE hr_org_reg_num_tab IS TABLE OF VARCHAR2(160)
26 INDEX BY BINARY_INTEGER;
27
28 PROCEDURE FIRST_PARTY_EXTRACT(p_org_id in Number default null);
29
30 PROCEDURE LEGAL_ESTABLISHMENT(p_org_id in Number) ;
31
32 PROCEDURE SUPPLIER_EXTRACT(p_party_id in NUMBER, p_org_id in Number);
33
34 PROCEDURE SUPPLIER_SITE_EXTRACT(p_party_id in NUMBER, p_org_id in Number) ;
35
36 PROCEDURE OU_EXTRACT(p_party_id in NUMBER) ;
37
38 PROCEDURE SUPPLIER_TYPE_EXTRACT;
39
40 PROCEDURE SUPPLIER_ASSOC_EXTRACT;
41
42 PROCEDURE Party_Assoc_Extract
43 (p_party_source IN VARCHAR2,
44 p_party_tax_profile_id IN NUMBER,
45 p_fiscal_class_type_code IN VARCHAR2,
46 p_fiscal_classification_code IN VARCHAR2 ,
47 p_dml_type IN VARCHAR2);
48
49 PROCEDURE ZX_PTP_MAIN;
50
51 PROCEDURE SUPPLIER_TYPE_MIGRATION;
52
53 PROCEDURE REG_REP_DRIVER_PROC
54 (p_party_type_code zx_party_tax_profile.party_type_code%type) ;
55
56 PROCEDURE REG_REP_DRIVER_PROC_OU
57 (p_party_type_code zx_party_tax_profile.party_type_code%type) ;
58
59
60 END ZX_PTP_MIGRATE_PKG;