7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AK_REGION2_PVT';
8:
9: -- PL/SQL table for holding records that need to be processed
10: -- the second time in UPLOAD
11: G_REGION_REDO_TBL AK_REGION_PUB.Region_Tbl_Type;
12: G_ITEM_REDO_TBL AK_REGION_PUB.Item_Tbl_Type;
13: G_LOV_RELATION_REDO_TBL AK_REGION_PUB.Lov_Relation_Tbl_Type;
14: --G_GRAPH_REDO_TBL AK_REGION_PUB.Graph_Tbl_Type;
15: --G_GRAPH_COLUMN_REDO_TBL AK_REGION_PUB.Graph_Column_Tbl_Type;
8:
9: -- PL/SQL table for holding records that need to be processed
10: -- the second time in UPLOAD
11: G_REGION_REDO_TBL AK_REGION_PUB.Region_Tbl_Type;
12: G_ITEM_REDO_TBL AK_REGION_PUB.Item_Tbl_Type;
13: G_LOV_RELATION_REDO_TBL AK_REGION_PUB.Lov_Relation_Tbl_Type;
14: --G_GRAPH_REDO_TBL AK_REGION_PUB.Graph_Tbl_Type;
15: --G_GRAPH_COLUMN_REDO_TBL AK_REGION_PUB.Graph_Column_Tbl_Type;
16: --
9: -- PL/SQL table for holding records that need to be processed
10: -- the second time in UPLOAD
11: G_REGION_REDO_TBL AK_REGION_PUB.Region_Tbl_Type;
12: G_ITEM_REDO_TBL AK_REGION_PUB.Item_Tbl_Type;
13: G_LOV_RELATION_REDO_TBL AK_REGION_PUB.Lov_Relation_Tbl_Type;
14: --G_GRAPH_REDO_TBL AK_REGION_PUB.Graph_Tbl_Type;
15: --G_GRAPH_COLUMN_REDO_TBL AK_REGION_PUB.Graph_Column_Tbl_Type;
16: --
17: -- Pointer to redo tables
10: -- the second time in UPLOAD
11: G_REGION_REDO_TBL AK_REGION_PUB.Region_Tbl_Type;
12: G_ITEM_REDO_TBL AK_REGION_PUB.Item_Tbl_Type;
13: G_LOV_RELATION_REDO_TBL AK_REGION_PUB.Lov_Relation_Tbl_Type;
14: --G_GRAPH_REDO_TBL AK_REGION_PUB.Graph_Tbl_Type;
15: --G_GRAPH_COLUMN_REDO_TBL AK_REGION_PUB.Graph_Column_Tbl_Type;
16: --
17: -- Pointer to redo tables
18: G_REGION_REDO_INDEX NUMBER := 0;
11: G_REGION_REDO_TBL AK_REGION_PUB.Region_Tbl_Type;
12: G_ITEM_REDO_TBL AK_REGION_PUB.Item_Tbl_Type;
13: G_LOV_RELATION_REDO_TBL AK_REGION_PUB.Lov_Relation_Tbl_Type;
14: --G_GRAPH_REDO_TBL AK_REGION_PUB.Graph_Tbl_Type;
15: --G_GRAPH_COLUMN_REDO_TBL AK_REGION_PUB.Graph_Column_Tbl_Type;
16: --
17: -- Pointer to redo tables
18: G_REGION_REDO_INDEX NUMBER := 0;
19: G_ITEM_REDO_INDEX NUMBER := 0;