[Home] [Help]
PACKAGE: APPS.CN_IMP_HIERARCHY_PVT
Source
1 PACKAGE CN_IMP_HIERARCHY_PVT AUTHID CURRENT_USER 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;