1 package ZX_FC_MIGRATE_PKG as
2 /* $Header: zxfcmigrates.pls 120.15.12010000.1 2008/07/28 13:32:03 appldev ship $ */
3
4 PROCEDURE MTL_SYSTEM_ITEMS;
5 PROCEDURE FC_ENTITIES;
6 PROCEDURE COUNTRY_DEFAULT;
7 PROCEDURE ZX_FC_MIGRATE;
8 PROCEDURE ZX_MIGRATE_AP;
9 PROCEDURE ZX_MIGRATE_AR;
10
11 PROCEDURE FC_TYPE_INSERT(
12 p_classification_type_code IN ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE,
13 p_classification_type_name IN ZX_FC_TYPES_TL.CLASSIFICATION_TYPE_NAME%TYPE,
14 p_owner_id_num IN ZX_FC_TYPES_B.OWNER_ID_NUM%TYPE);
15
16 PROCEDURE FC_PARTY_TYPE_INSERT(
17 p_classification_type_code IN ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE,
18 p_classification_type_name IN ZX_FC_TYPES_TL.CLASSIFICATION_TYPE_NAME%TYPE,
19 p_tca_class IN VARCHAR2);
20
21 PROCEDURE FIRST_LEVEL_FC_CODE_INSERT(
22 p_classification_type_code IN ZX_FC_CODES_B.CLASSIFICATION_TYPE_CODE%TYPE,
23 p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
24 p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
25 p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
26 x_fc_id OUT NOCOPY ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE);
27
28
29 PROCEDURE CREATE_MTL_CATEGORIES (l_lookup_type IN VARCHAR2,
30 l_category_name IN VARCHAR2,
31 l_category_status OUT NOCOPY VARCHAR2,
32 l_category_set OUT NOCOPY mtl_category_sets_b.Category_set_ID%TYPE,
33 l_structure_id OUT NOCOPY mtl_category_sets_b.structure_id%TYPE);
34
35 FUNCTION Is_Country_Installed(
36 p_application_id IN fnd_module_installations.APPLICATION_ID%TYPE,
37 p_module_short_name IN fnd_module_installations.MODULE_SHORT_NAME%TYPE
38 ) RETURN BOOLEAN;
39
40 PROCEDURE Create_Category_Sets;
41
42 PROCEDURE OKL_MIGRATION;
43
44 PROCEDURE Create_Category_Set(p_structure_code IN VARCHAR2,
45 p_structure_desc IN VARCHAR2,
46 p_category_set_name IN VARCHAR2,
47 p_category_set_desc IN VARCHAR2 );
48
49 -- Bug # 5106298. Called from country defaults UI.
50 -- Used to create the FC Types for fresh install.
51 PROCEDURE CREATE_SEEDED_FC_TYPES(p_country_code IN VARCHAR2,
52 x_category_set OUT NOCOPY NUMBER,
53 x_category_set_name OUT NOCOPY VARCHAR2,
54 x_return_status OUT NOCOPY VARCHAR2
55 );
56
57 -- Bug# 5106298. This procedure is called from zxcfctbc.lct file
58 PROCEDURE FC_CODE_GDF_INSERT(
59 p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
60 p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
61 p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
62 p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,
63 p_tax_event_class_code IN ZX_EVENT_CLASSES_VL.TAX_EVENT_CLASS_CODE%TYPE,
64 p_record_type_code IN ZX_FC_CODES_B.RECORD_TYPE_CODE%TYPE
65 );
66
67
68 /*THIS PROECEDURE IS USED TO INSERT VALUES BASED UPON THE LOOKUP TYPE */
69 PROCEDURE FC_CODE_FROM_FND_LOOKUP(
70 p_classification_type_code IN ZX_FC_CODES_B.CLASSIFICATION_TYPE_CODE%TYPE,
71 p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,
72 p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
73 p_parent_fc_id IN ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE,
74 p_ancestor_code IN ZX_FC_CODES_DENORM_B.ANCESTOR_CODE%TYPE,
75 p_ancestor_name IN ZX_FC_CODES_DENORM_B.ANCESTOR_NAME%TYPE,
76 p_classification_code_level IN ZX_FC_CODES_DENORM_B.CLASSIFICATION_CODE_LEVEL%TYPE
77 );
78
79 END ZX_FC_MIGRATE_PKG;