[Home] [Help]
PACKAGE: APPS.CZ_IMP_SINGLE
Source
1 PACKAGE CZ_IMP_SINGLE AUTHID CURRENT_USER AS
2 /* $Header: czisngs.pls 120.5 2011/03/29 14:34:49 lamrute ship $ */
3 --------------------------------------
4 RP_ROOT_FOLDER CONSTANT NUMBER:=0;
5 --------------------------------------
6
7 /* Raised when cz_refs.delete_node returns error */
8 CZ_REFS_DELNODE_EXCP EXCEPTION;
9
10 IMP_CHILD_MULTI_COPIES EXCEPTION; --LA 9595142
11 IMP_MODEL_NOT_ENABLED EXCEPTION; --LA 9595142
12
13 FUNCTION ExtractPsNode(inRunId IN NUMBER,
14 inOrgId IN NUMBER,
15 inTopId IN NUMBER,
16 inExplType IN VARCHAR2,
17 inServerId IN NUMBER,
18 inRunExploder IN PLS_INTEGER,
19 inRevDate IN DATE,
20 inDateFormat IN VARCHAR2,
21 inRefreshModelId IN NUMBER,
22 inCopyRootModel IN VARCHAR2,
23 inCopyChildModels IN VARCHAR2,
24 inGenStatistics IN PLS_INTEGER)
25 RETURN NUMBER;
26 ------------------------------------------------------------------------------------------
27 PROCEDURE ImportSingleBill(nOrg_ID IN NUMBER,
28 nTop_ID IN NUMBER,
29 COPY_CHILD_MODELS IN VARCHAR2,
30 REFRESH_MODEL_ID IN NUMBER,
31 COPY_ROOT_MODEL IN VARCHAR2,
32 sExpl_type IN VARCHAR2,
33 dRev_date IN DATE,
34 x_run_id OUT NOCOPY NUMBER); -- sselahi: added x_run_id
35 ------------------------------------------------------------------------------------------
36 FUNCTION isAppsVersion11i(fndLinkName IN VARCHAR2)
37 RETURN BOOLEAN;
38 ------------------------------------------------------------------------------------------
39 FUNCTION importChildModel(inRunId IN NUMBER,
40 inOrgId IN NUMBER,
41 inTopId IN NUMBER,
42 inExplType IN VARCHAR2)
43 RETURN BOOLEAN;
44 ------------------------------------------------------------------------------------------
45 /* Constant Declarations */
46 cnOracleToMerlinOffset CONSTANT NUMBER:=256; /*Conversion Const*/
47 cnProduct CONSTANT NUMBER:=cnOracleToMerlinOffset+2;/*Product Type*/
48 cnComponent CONSTANT NUMBER:=cnOracleToMerlinOffset+3;/*Component Type*/
49 cnFeature CONSTANT NUMBER:=cnOracleToMerlinOffset+5;/*Feature Type*/
50 cnOption CONSTANT NUMBER:=cnOracleToMerlinOffset+6;/*Option Type*/
51 cnModel CONSTANT NUMBER:=1; /*Oracle Model Type*/
52 cnOptionClass CONSTANT NUMBER:=2; /*Oracle Option Class Type*/
53 cnStandard CONSTANT NUMBER:=4; /*Oracle Standard Type*/
54 cnReference CONSTANT NUMBER:=263;
55 bomModel CONSTANT NUMBER:=436; /*BOM Item Model type*/
56 bomOptionClass CONSTANT NUMBER:=437; /*BOM Item OptionClass type*/
57 bomStandard CONSTANT NUMBER:=438; /*BOM Item Standard type*/
58 /* BOM_TREATMENT values */
59 cnNormal CONSTANT NUMBER:=0;
60 cnSkip CONSTANT NUMBER:=1;
61 cnLeaf CONSTANT NUMBER:=2;
62 cnFlatten CONSTANT NUMBER:=3;
63 /* Oracle Yes/No values */
64 OraYes CONSTANT NUMBER:=1;
65 OraNo CONSTANT NUMBER:=2;
66 G_CAPTION_RULE_DESC CONSTANT PLS_INTEGER := 802;
67 G_CAPTION_RULE_NAME CONSTANT PLS_INTEGER := 801;
68 ------------------------------------------------------------------------------------------
69 importUnchangedChildModels NUMBER := 1;
70 ------------------------------------------------------------------------------------------
71 -- this global table stores the item_ids of any models found in a top model during extr_devl_project
72 -- and will be used by extr_intl_text procedure
73 TYPE tModelItemId_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
74 gModelItemId_tbl tModelItemId_tbl;
75
76 FUNCTION get_ItemCatalogTable RETURN SYSTEM.CZ_ITEM_CATALOG_TBL;
77
78 END CZ_IMP_SINGLE;