APPS.CN_IMP_HIERARCHY_PVT dependencies on FND_API

Line 9: (IMP_HEADER_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 10: IMP_LINE_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 11: IMPORT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 12: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 13: ERROR_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 14: RECORD_NUM 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,

Line 15: HIERARCHY_TYPE VARCHAR2(80) := FND_API.G_MISS_CHAR,

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,

Line 16: BASE_TABLE_NAME 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

Line 17: PRIMARY_KEY 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,

Line 18: HIERARCHY_VALUE 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,

Line 19: HIERARCHY_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 21: START_DATE 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,

Line 22: END_DATE 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,

Line 23: DEFAULT_NODE_FLAG VARCHAR2(1) := 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,

Line 24: PARENT_NODE_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,

Line 25: NODE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 26: LEVEL_NUM 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,

Line 27: CREATION_DATE DATE := FND_API.G_MISS_DATE,

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

Line 28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

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: );

Line 29: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

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:

Line 30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

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;

Line 31: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM

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: