2: /* $Header: cnvtmaps.pls 120.4 2005/09/03 02:53:44 apink noship $ */
3:
4: TYPE table_map_rec_type IS RECORD
5: (
6: TABLE_MAP_ID NUMBER := cn_api.G_MISS_NUM,
7: MAPPING_TYPE VARCHAR2(4) := cn_api.G_MISS_CHAR,
8: SOURCE_TABLE_ID NUMBER := cn_api.G_MISS_NUM,
9: DESTINATION_TABLE_ID NUMBER := cn_api.G_MISS_NUM,
10: MODULE_ID NUMBER := cn_api.G_MISS_NUM,
3:
4: TYPE table_map_rec_type IS RECORD
5: (
6: TABLE_MAP_ID NUMBER := cn_api.G_MISS_NUM,
7: MAPPING_TYPE VARCHAR2(4) := cn_api.G_MISS_CHAR,
8: SOURCE_TABLE_ID NUMBER := cn_api.G_MISS_NUM,
9: DESTINATION_TABLE_ID NUMBER := cn_api.G_MISS_NUM,
10: MODULE_ID NUMBER := cn_api.G_MISS_NUM,
11: LAST_UPDATE_DATE DATE := cn_api.G_MISS_DATE,
4: TYPE table_map_rec_type IS RECORD
5: (
6: TABLE_MAP_ID NUMBER := cn_api.G_MISS_NUM,
7: MAPPING_TYPE VARCHAR2(4) := cn_api.G_MISS_CHAR,
8: SOURCE_TABLE_ID NUMBER := cn_api.G_MISS_NUM,
9: DESTINATION_TABLE_ID NUMBER := cn_api.G_MISS_NUM,
10: MODULE_ID NUMBER := cn_api.G_MISS_NUM,
11: LAST_UPDATE_DATE DATE := cn_api.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := cn_api.G_MISS_NUM,
5: (
6: TABLE_MAP_ID NUMBER := cn_api.G_MISS_NUM,
7: MAPPING_TYPE VARCHAR2(4) := cn_api.G_MISS_CHAR,
8: SOURCE_TABLE_ID NUMBER := cn_api.G_MISS_NUM,
9: DESTINATION_TABLE_ID NUMBER := cn_api.G_MISS_NUM,
10: MODULE_ID NUMBER := cn_api.G_MISS_NUM,
11: LAST_UPDATE_DATE DATE := cn_api.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := cn_api.G_MISS_NUM,
13: CREATION_DATE DATE := cn_api.G_MISS_DATE,
6: TABLE_MAP_ID NUMBER := cn_api.G_MISS_NUM,
7: MAPPING_TYPE VARCHAR2(4) := cn_api.G_MISS_CHAR,
8: SOURCE_TABLE_ID NUMBER := cn_api.G_MISS_NUM,
9: DESTINATION_TABLE_ID NUMBER := cn_api.G_MISS_NUM,
10: MODULE_ID NUMBER := cn_api.G_MISS_NUM,
11: LAST_UPDATE_DATE DATE := cn_api.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := cn_api.G_MISS_NUM,
13: CREATION_DATE DATE := cn_api.G_MISS_DATE,
14: CREATED_BY NUMBER := cn_api.G_MISS_NUM,
7: MAPPING_TYPE VARCHAR2(4) := cn_api.G_MISS_CHAR,
8: SOURCE_TABLE_ID NUMBER := cn_api.G_MISS_NUM,
9: DESTINATION_TABLE_ID NUMBER := cn_api.G_MISS_NUM,
10: MODULE_ID NUMBER := cn_api.G_MISS_NUM,
11: LAST_UPDATE_DATE DATE := cn_api.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := cn_api.G_MISS_NUM,
13: CREATION_DATE DATE := cn_api.G_MISS_DATE,
14: CREATED_BY NUMBER := cn_api.G_MISS_NUM,
15: LAST_UPDATE_LOGIN NUMBER := cn_api.G_MISS_NUM,
8: SOURCE_TABLE_ID NUMBER := cn_api.G_MISS_NUM,
9: DESTINATION_TABLE_ID NUMBER := cn_api.G_MISS_NUM,
10: MODULE_ID NUMBER := cn_api.G_MISS_NUM,
11: LAST_UPDATE_DATE DATE := cn_api.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := cn_api.G_MISS_NUM,
13: CREATION_DATE DATE := cn_api.G_MISS_DATE,
14: CREATED_BY NUMBER := cn_api.G_MISS_NUM,
15: LAST_UPDATE_LOGIN NUMBER := cn_api.G_MISS_NUM,
16: ORG_ID NUMBER := cn_api.G_MISS_NUM,
9: DESTINATION_TABLE_ID NUMBER := cn_api.G_MISS_NUM,
10: MODULE_ID NUMBER := cn_api.G_MISS_NUM,
11: LAST_UPDATE_DATE DATE := cn_api.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := cn_api.G_MISS_NUM,
13: CREATION_DATE DATE := cn_api.G_MISS_DATE,
14: CREATED_BY NUMBER := cn_api.G_MISS_NUM,
15: LAST_UPDATE_LOGIN NUMBER := cn_api.G_MISS_NUM,
16: ORG_ID NUMBER := cn_api.G_MISS_NUM,
17: SOURCE_TBL_PKCOL_ID NUMBER := cn_api.G_MISS_NUM,
10: MODULE_ID NUMBER := cn_api.G_MISS_NUM,
11: LAST_UPDATE_DATE DATE := cn_api.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := cn_api.G_MISS_NUM,
13: CREATION_DATE DATE := cn_api.G_MISS_DATE,
14: CREATED_BY NUMBER := cn_api.G_MISS_NUM,
15: LAST_UPDATE_LOGIN NUMBER := cn_api.G_MISS_NUM,
16: ORG_ID NUMBER := cn_api.G_MISS_NUM,
17: SOURCE_TBL_PKCOL_ID NUMBER := cn_api.G_MISS_NUM,
18: DELETE_FLAG VARCHAR2(1) := cn_api.G_MISS_CHAR,
11: LAST_UPDATE_DATE DATE := cn_api.G_MISS_DATE,
12: LAST_UPDATED_BY NUMBER := cn_api.G_MISS_NUM,
13: CREATION_DATE DATE := cn_api.G_MISS_DATE,
14: CREATED_BY NUMBER := cn_api.G_MISS_NUM,
15: LAST_UPDATE_LOGIN NUMBER := cn_api.G_MISS_NUM,
16: ORG_ID NUMBER := cn_api.G_MISS_NUM,
17: SOURCE_TBL_PKCOL_ID NUMBER := cn_api.G_MISS_NUM,
18: DELETE_FLAG VARCHAR2(1) := cn_api.G_MISS_CHAR,
19: SOURCE_HDR_TBL_PKCOL_ID NUMBER := cn_api.G_MISS_NUM,
12: LAST_UPDATED_BY NUMBER := cn_api.G_MISS_NUM,
13: CREATION_DATE DATE := cn_api.G_MISS_DATE,
14: CREATED_BY NUMBER := cn_api.G_MISS_NUM,
15: LAST_UPDATE_LOGIN NUMBER := cn_api.G_MISS_NUM,
16: ORG_ID NUMBER := cn_api.G_MISS_NUM,
17: SOURCE_TBL_PKCOL_ID NUMBER := cn_api.G_MISS_NUM,
18: DELETE_FLAG VARCHAR2(1) := cn_api.G_MISS_CHAR,
19: SOURCE_HDR_TBL_PKCOL_ID NUMBER := cn_api.G_MISS_NUM,
20: SOURCE_TBL_HDR_FKCOL_ID NUMBER := cn_api.G_MISS_NUM,
13: CREATION_DATE DATE := cn_api.G_MISS_DATE,
14: CREATED_BY NUMBER := cn_api.G_MISS_NUM,
15: LAST_UPDATE_LOGIN NUMBER := cn_api.G_MISS_NUM,
16: ORG_ID NUMBER := cn_api.G_MISS_NUM,
17: SOURCE_TBL_PKCOL_ID NUMBER := cn_api.G_MISS_NUM,
18: DELETE_FLAG VARCHAR2(1) := cn_api.G_MISS_CHAR,
19: SOURCE_HDR_TBL_PKCOL_ID NUMBER := cn_api.G_MISS_NUM,
20: SOURCE_TBL_HDR_FKCOL_ID NUMBER := cn_api.G_MISS_NUM,
21: NOTIFY_WHERE VARCHAR2(1900) := cn_api.G_MISS_CHAR,
14: CREATED_BY NUMBER := cn_api.G_MISS_NUM,
15: LAST_UPDATE_LOGIN NUMBER := cn_api.G_MISS_NUM,
16: ORG_ID NUMBER := cn_api.G_MISS_NUM,
17: SOURCE_TBL_PKCOL_ID NUMBER := cn_api.G_MISS_NUM,
18: DELETE_FLAG VARCHAR2(1) := cn_api.G_MISS_CHAR,
19: SOURCE_HDR_TBL_PKCOL_ID NUMBER := cn_api.G_MISS_NUM,
20: SOURCE_TBL_HDR_FKCOL_ID NUMBER := cn_api.G_MISS_NUM,
21: NOTIFY_WHERE VARCHAR2(1900) := cn_api.G_MISS_CHAR,
22: COLLECT_WHERE VARCHAR2(1900) := cn_api.G_MISS_CHAR
15: LAST_UPDATE_LOGIN NUMBER := cn_api.G_MISS_NUM,
16: ORG_ID NUMBER := cn_api.G_MISS_NUM,
17: SOURCE_TBL_PKCOL_ID NUMBER := cn_api.G_MISS_NUM,
18: DELETE_FLAG VARCHAR2(1) := cn_api.G_MISS_CHAR,
19: SOURCE_HDR_TBL_PKCOL_ID NUMBER := cn_api.G_MISS_NUM,
20: SOURCE_TBL_HDR_FKCOL_ID NUMBER := cn_api.G_MISS_NUM,
21: NOTIFY_WHERE VARCHAR2(1900) := cn_api.G_MISS_CHAR,
22: COLLECT_WHERE VARCHAR2(1900) := cn_api.G_MISS_CHAR
23: );
16: ORG_ID NUMBER := cn_api.G_MISS_NUM,
17: SOURCE_TBL_PKCOL_ID NUMBER := cn_api.G_MISS_NUM,
18: DELETE_FLAG VARCHAR2(1) := cn_api.G_MISS_CHAR,
19: SOURCE_HDR_TBL_PKCOL_ID NUMBER := cn_api.G_MISS_NUM,
20: SOURCE_TBL_HDR_FKCOL_ID NUMBER := cn_api.G_MISS_NUM,
21: NOTIFY_WHERE VARCHAR2(1900) := cn_api.G_MISS_CHAR,
22: COLLECT_WHERE VARCHAR2(1900) := cn_api.G_MISS_CHAR
23: );
24:
17: SOURCE_TBL_PKCOL_ID NUMBER := cn_api.G_MISS_NUM,
18: DELETE_FLAG VARCHAR2(1) := cn_api.G_MISS_CHAR,
19: SOURCE_HDR_TBL_PKCOL_ID NUMBER := cn_api.G_MISS_NUM,
20: SOURCE_TBL_HDR_FKCOL_ID NUMBER := cn_api.G_MISS_NUM,
21: NOTIFY_WHERE VARCHAR2(1900) := cn_api.G_MISS_CHAR,
22: COLLECT_WHERE VARCHAR2(1900) := cn_api.G_MISS_CHAR
23: );
24:
25:
18: DELETE_FLAG VARCHAR2(1) := cn_api.G_MISS_CHAR,
19: SOURCE_HDR_TBL_PKCOL_ID NUMBER := cn_api.G_MISS_NUM,
20: SOURCE_TBL_HDR_FKCOL_ID NUMBER := cn_api.G_MISS_NUM,
21: NOTIFY_WHERE VARCHAR2(1900) := cn_api.G_MISS_CHAR,
22: COLLECT_WHERE VARCHAR2(1900) := cn_api.G_MISS_CHAR
23: );
24:
25:
26: