[Home] [Help]
PACKAGE: APPS.CZ_BOM_SYNCH
Source
1 PACKAGE CZ_BOM_SYNCH AUTHID CURRENT_USER AS
2 /* $Header: czbomsys.pls 120.5 2006/08/09 15:43:17 asiaston ship $ */
3 ---------------------------------------------------------------------------------------
4 THIS_PACKAGE_NAME CONSTANT VARCHAR2(25) := 'CZ_BOM_SYNCH';
5 THIS_FILE_NAME CONSTANT VARCHAR2(25) := 'czbomsyb.pls';
6 THIS_HEADER_TAG CONSTANT VARCHAR2(25) := '%$Header%';
7 THIS_DATE_FORMAT CONSTANT VARCHAR2(25) := 'YYYY/MM/DD/HH24:MI:SS';
8 ---------------------------------------------------------------------------------------
9 ORACLE_YES CONSTANT PLS_INTEGER := 1;
10 ORACLE_NO CONSTANT PLS_INTEGER := 2;
11 CONCURRENT_SUCCESS CONSTANT PLS_INTEGER := 0;
12 CONCURRENT_ERROR CONSTANT PLS_INTEGER := 2;
13 ORACLE_BOM_MODEL CONSTANT PLS_INTEGER := 1;
14 ORACLE_BOM_OPTIONCLASS CONSTANT PLS_INTEGER := 2;
15 ORACLE_BOM_STANDARD CONSTANT PLS_INTEGER := 4;
16 DEFAULT_COMMIT_BLOCK_SIZE CONSTANT PLS_INTEGER := 500;
17 LOCAL_SERVER_SEED_ID CONSTANT PLS_INTEGER := 0;
18 DEFAULT_DAYSTILLEPOCHEND CONSTANT PLS_INTEGER := 20000;
19 ---------------------------------------------------------------------------------------
20 STRING_HASH_BASE_VALUE CONSTANT NUMBER := 1000;
21 STRING_HASH_SIZE CONSTANT NUMBER := 1048576; -- 2 ** 20
22 STRING_CONCAT_CHARACTER CONSTANT VARCHAR2(1) := '-';
23 ---------------------------------------------------------------------------------------
24 EpochBeginDate CONSTANT DATE := CZ_UTILS.EPOCH_BEGIN_;
25 EpochEndDate CONSTANT DATE := CZ_UTILS.EPOCH_END_;
26 ---------------------------------------------------------------------------------------
27 PS_NODE_TYPE_REFERENCE CONSTANT PLS_INTEGER := 263;
28 PS_NODE_TYPE_BOM_MODEL CONSTANT PLS_INTEGER := 436;
29 PS_NODE_TYPE_BOM_OPTIONCLASS CONSTANT PLS_INTEGER := 437;
30 PS_NODE_TYPE_BOM_STANDARD CONSTANT PLS_INTEGER := 438;
31 ---------------------------------------------------------------------------------------
32 EXECUTION_MODE_REPORT CONSTANT PLS_INTEGER := 0;
33 EXECUTION_MODE_VERIFY CONSTANT PLS_INTEGER := 1;
34 EXECUTION_MODE_SYNC CONSTANT PLS_INTEGER := 2;
35 ---------------------------------------------------------------------------------------
36 URGENCY_ERROR CONSTANT PLS_INTEGER := 0;
37 URGENCY_WARNING CONSTANT PLS_INTEGER := 1;
38 URGENCY_MESSAGE CONSTANT PLS_INTEGER := 2;
39 URGENCY_DEBUG CONSTANT PLS_INTEGER := 3;
40 ---------------------------------------------------------------------------------------
41 LOG_LEVEL_WARNINGS CONSTANT PLS_INTEGER := 0;
42 LOG_LEVEL_MESSAGES CONSTANT PLS_INTEGER := 1;
43 LOG_LEVEL_DEBUG CONSTANT PLS_INTEGER := 2;
44 ---------------------------------------------------------------------------------------
45 ERROR_FLAG_SUCCESS CONSTANT VARCHAR2(1) := '0';
46 ERROR_FLAG_ERROR CONSTANT VARCHAR2(1) := '1';
47 ---------------------------------------------------------------------------------------
48 FLAG_NOT_DELETED CONSTANT VARCHAR2(1) := '0';
49 FLAG_BOM_OPTIONAL CONSTANT VARCHAR2(1) := '0';
50 FLAG_BOM_REQUIRED CONSTANT VARCHAR2(1) := '1';
51 ---------------------------------------------------------------------------------------
52 ORIGINAL_SEPARATOR CONSTANT VARCHAR2(1) := ':';
53 NAME_PATH_SEPARATOR CONSTANT VARCHAR2(2) := '=>';
54 ---------------------------------------------------------------------------------------
55 PUBLICATION_STATUS_PROCESSING CONSTANT VARCHAR2(3) := 'PRC';
56 PUBLICATION_STATUS_OK CONSTANT VARCHAR2(3) := 'OK';
57 PUBLICATION_TARGET_FLAG CONSTANT VARCHAR2(1) := 'T';
58 REPOSITORY_TYPE_PROJECT CONSTANT VARCHAR2(3) := 'PRJ';
59 FND_LANGUAGES_BASE CONSTANT VARCHAR2(1) := 'B';
60 FND_LANGUAGES_INSTALLED CONSTANT VARCHAR2(1) := 'I';
61 ---------------------------------------------------------------------------------------
62 DBSETTINGS_SECTION_NAME CONSTANT VARCHAR2(25) := 'BOMSYNCH';
63 COMMIT_BLOCK_SETTING_ID CONSTANT VARCHAR2(25) := 'COMMITBLOCKSIZE';
64 VERIFY_PROPERTIES_SETTING_ID CONSTANT VARCHAR2(25) := 'VERIFYITEMPROPERTIES';
65 DAYSTILLEPOCHEND_SETTING_ID CONSTANT VARCHAR2(25) := 'DAYSTILLEPOCHEND';
66 ---------------------------------------------------------------------------------------
67 CZ_SYNC_UNEXPECTED_STRUCTURE EXCEPTION;
68 CZ_SYNC_UNABLE_TO_REPORT EXCEPTION;
69 CZ_SYNC_GENERAL_EXCEPTION EXCEPTION;
70 CZ_SYNC_NO_DATABASE_LINK EXCEPTION;
71 CZ_SYNC_INCORRECT_MODEL EXCEPTION;
72 CZ_SYNC_NO_ORGANIZATION_ID EXCEPTION;
73 CZ_SYNC_NORMAL_EXCEPTION EXCEPTION;
74 ---------------------------------------------------------------------------------------
75 PROCEDURE synchronize_all_models_cp(errbuf OUT NOCOPY VARCHAR2,
76 retcode OUT NOCOPY NUMBER,
77 p_target_name IN VARCHAR2);
78 ---------------------------------------------------------------------------------------
79 PROCEDURE report_model_cp(errbuf OUT NOCOPY VARCHAR2,
80 retcode OUT NOCOPY NUMBER,
81 p_target_name IN VARCHAR2,
82 p_model_id IN NUMBER);
83 ---------------------------------------------------------------------------------------
84 PROCEDURE report_all_models_cp(errbuf OUT NOCOPY VARCHAR2,
85 retcode OUT NOCOPY NUMBER,
86 p_target_name IN VARCHAR2);
87 ---------------------------------------------------------------------------------------
88 PROCEDURE verify_model(p_model_id IN NUMBER,
89 p_target_name IN VARCHAR2,
90 p_error_flag IN OUT NOCOPY VARCHAR2,
91 p_run_id IN OUT NOCOPY NUMBER);
92 ---------------------------------------------------------------------------------------
93 PROCEDURE build_structure_map(p_model_id IN NUMBER,
94 p_target_name IN VARCHAR2,
95 p_execution_mode IN NUMBER,
96 p_log_level IN NUMBER,
97 p_error_flag IN OUT NOCOPY VARCHAR2,
98 p_run_id IN OUT NOCOPY NUMBER);
99 ---------------------------------------------------------------------------------------
100 FUNCTION psnode_origSysRef(p_orig_sys_ref IN VARCHAR2)
101 RETURN VARCHAR2;
102 ---------------------------------------------------------------------------------------
103 FUNCTION psnode_compSeqPath(p_component_seq_path IN VARCHAR2)
104 RETURN VARCHAR2;
105 ---------------------------------------------------------------------------------------
106 FUNCTION psnode_compSeqId(p_component_id IN NUMBER)
107 RETURN NUMBER;
108 ---------------------------------------------------------------------------------------
109 FUNCTION itemMaster_origSysRef(p_orig_sys_ref IN VARCHAR2)
110 RETURN VARCHAR2;
111 ---------------------------------------------------------------------------------------
112 FUNCTION itemType_origSysRef(p_orig_sys_ref IN VARCHAR2)
113 RETURN VARCHAR2;
114 ---------------------------------------------------------------------------------------
115 FUNCTION devlProject_origSysRef(p_orig_sys_ref IN VARCHAR2)
116 RETURN VARCHAR2;
117 ---------------------------------------------------------------------------------------
118 FUNCTION locText_origSysRef(p_orig_sys_ref IN VARCHAR2)
119 RETURN VARCHAR2;
120 ---------------------------------------------------------------------------------------
121 FUNCTION projectBill_orgId(p_organization_id IN NUMBER)
122 RETURN NUMBER;
123 ---------------------------------------------------------------------------------------
124 FUNCTION projectBill_topItemId(p_top_item_id IN NUMBER)
125 RETURN NUMBER;
126 ---------------------------------------------------------------------------------------
127 FUNCTION projectBill_compItemId(p_component_item_id IN NUMBER)
128 RETURN NUMBER;
129 ---------------------------------------------------------------------------------------
130 FUNCTION projectBill_sourceServer(p_server_id IN NUMBER)
131 RETURN NUMBER;
132 ---------------------------------------------------------------------------------------
133 FUNCTION modelPublication_productKey(p_product_key IN VARCHAR2)
134 RETURN VARCHAR2;
135 ---------------------------------------------------------------------------------------
136 FUNCTION modelPublication_topItemId(p_top_item_id IN NUMBER)
137 RETURN NUMBER;
138 ---------------------------------------------------------------------------------------
139 FUNCTION modelPublication_orgId(p_organization_id IN NUMBER)
140 RETURN NUMBER;
141 ---------------------------------------------------------------------------------------
142 FUNCTION devlProject_invId(p_inventory_item_id IN NUMBER)
143 RETURN NUMBER;
144 ------------------------------------------------------------------------------
145 FUNCTION devlProject_orgId(p_organization_id IN NUMBER)
146 RETURN NUMBER;
147 --------------------------------------------------------------------------------
148 FUNCTION devlProject_productKey(p_product_key IN VARCHAR2)
149 RETURN VARCHAR2;
150 ------------------------------------------------------------------------
151
152 FUNCTION ITEMPROPVALUES_ORIGSYSREF(p_orig_sys_ref IN VARCHAR2)
153 RETURN VARCHAR2;
154 ------------------------------------------------------------------------
155
156 FUNCTION ITEMTYPEPROP_ORIGSYSREF(p_orig_sys_ref IN VARCHAR2)
157 RETURN VARCHAR2;
158
159
160 END;