PACKAGE: APPS.CN_IMP_HIERARCHY_PVT

Source

1 PACKAGE CN_IMP_HIERARCHY_PVT AS
2 -- $Header: cnvimhis.pls 120.1 2005/08/07 23:03:26 vensrini noship $
3 
4 -- * ------------------------------------------------------------------+
5 --   Record Type Definition
6 -- * ------------------------------------------------------------------+
7 
8 TYPE IMP_HIER_REC_TYPE IS RECORD
9   (IMP_HEADER_ID	NUMBER	:= FND_API.G_MISS_NUM,
10    IMP_LINE_ID	        NUMBER	:= FND_API.G_MISS_NUM,
11    IMPORT_TYPE_CODE	VARCHAR2(30)	:= FND_API.G_MISS_CHAR,
12    STATUS_CODE	VARCHAR2(30)	:= FND_API.G_MISS_CHAR,
13    ERROR_CODE	VARCHAR2(30)	:= FND_API.G_MISS_CHAR,
14    RECORD_NUM   NUMBER := FND_API.G_MISS_NUM,
15    HIERARCHY_TYPE VARCHAR2(80)	:= FND_API.G_MISS_CHAR,
16    BASE_TABLE_NAME VARCHAR2(30)	:= FND_API.G_MISS_CHAR,
17    PRIMARY_KEY VARCHAR2(30)	:= FND_API.G_MISS_CHAR,
18    HIERARCHY_VALUE VARCHAR2(30)	:= FND_API.G_MISS_CHAR,
19    HIERARCHY_NAME VARCHAR2(30)	:= FND_API.G_MISS_CHAR,
20    -- set START_DATE END_DATE to VARCHAR on purpose, do not change to DATE type
21    START_DATE     VARCHAR2(30)  := FND_API.G_MISS_CHAR,
22    END_DATE       VARCHAR2(30)	:= FND_API.G_MISS_CHAR,
23    DEFAULT_NODE_FLAG  VARCHAR2(1)	:= FND_API.G_MISS_CHAR,
24    PARENT_NODE_NAME  VARCHAR2(30)	:= FND_API.G_MISS_CHAR,
25    NODE_NAME  VARCHAR2(30)	:= FND_API.G_MISS_CHAR,
26    LEVEL_NUM  VARCHAR2(30)	:= FND_API.G_MISS_CHAR,
27    CREATION_DATE	DATE	:= FND_API.G_MISS_DATE,
28    CREATED_BY	NUMBER	:= FND_API.G_MISS_NUM,
29    LAST_UPDATE_DATE	DATE	:= FND_API.G_MISS_DATE,
30    LAST_UPDATED_BY	NUMBER	:= FND_API.G_MISS_NUM,
31   LAST_UPDATE_LOGIN	NUMBER	:= FND_API.G_MISS_NUM
32   );
33 
34 G_MISS_IMP_HIER_REC IMP_HIER_REC_TYPE;
35 
36 -- Start of comments
37 --    API name        : Hierarchy_Import
38 --    Type            : Private.
39 --    Function        : programtransfer data from staging table into
40 --                      cn_dimension_vl,cn_head_hierarchies,cn_dim_hierarchies
41 --                      cn_hierarchy_nodes, cn_hierarchy_edges
42 --    Pre-reqs        : None.
43 --    Parameters      :
44 --    IN              : p_imp_header_id           IN    NUMBER,
45 --    OUT             : errbuf         OUT VARCHAR2       Required
46 --                      retcode        OUTVARCHAR2     Optional
47 --    Version :         Current version       1.0
48 --
49 --    Notes           : Note text
50 --
51 -- End of comments
52 
53 PROCEDURE Hierarchy_Import
54  ( errbuf                     OUT NOCOPY   VARCHAR2,
55    retcode                    OUT NOCOPY   VARCHAR2,
56    p_imp_header_id           IN    NUMBER,
57    p_org_id		IN	NUMBER
58    );
59 
60 END CN_IMP_HIERARCHY_PVT;