7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AK_CUSTOM2_PVT';
8:
9: -- PL/SQL table for holding records that need to be processed
10: -- the second time in UPLOAD
11: G_CUSTOM_REDO_TBL AK_CUSTOM_PUB.Custom_Tbl_Type;
12: G_CUST_REGION_REDO_TBL AK_CUSTOM_PUB.Cust_Region_Tbl_Type;
13: G_CUST_REG_ITEM_REDO_TBL AK_CUSTOM_PUB.Cust_Reg_Item_Tbl_Type;
14: G_CRITERIA_REDO_TBL AK_CUSTOM_PUB.Criteria_Tbl_Type;
15: --
8:
9: -- PL/SQL table for holding records that need to be processed
10: -- the second time in UPLOAD
11: G_CUSTOM_REDO_TBL AK_CUSTOM_PUB.Custom_Tbl_Type;
12: G_CUST_REGION_REDO_TBL AK_CUSTOM_PUB.Cust_Region_Tbl_Type;
13: G_CUST_REG_ITEM_REDO_TBL AK_CUSTOM_PUB.Cust_Reg_Item_Tbl_Type;
14: G_CRITERIA_REDO_TBL AK_CUSTOM_PUB.Criteria_Tbl_Type;
15: --
16: -- Pointer to redo tables
9: -- PL/SQL table for holding records that need to be processed
10: -- the second time in UPLOAD
11: G_CUSTOM_REDO_TBL AK_CUSTOM_PUB.Custom_Tbl_Type;
12: G_CUST_REGION_REDO_TBL AK_CUSTOM_PUB.Cust_Region_Tbl_Type;
13: G_CUST_REG_ITEM_REDO_TBL AK_CUSTOM_PUB.Cust_Reg_Item_Tbl_Type;
14: G_CRITERIA_REDO_TBL AK_CUSTOM_PUB.Criteria_Tbl_Type;
15: --
16: -- Pointer to redo tables
17: G_CUSTOM_REDO_INDEX NUMBER := 0;
10: -- the second time in UPLOAD
11: G_CUSTOM_REDO_TBL AK_CUSTOM_PUB.Custom_Tbl_Type;
12: G_CUST_REGION_REDO_TBL AK_CUSTOM_PUB.Cust_Region_Tbl_Type;
13: G_CUST_REG_ITEM_REDO_TBL AK_CUSTOM_PUB.Cust_Reg_Item_Tbl_Type;
14: G_CRITERIA_REDO_TBL AK_CUSTOM_PUB.Criteria_Tbl_Type;
15: --
16: -- Pointer to redo tables
17: G_CUSTOM_REDO_INDEX NUMBER := 0;
18: G_CUST_REGION_REDO_INDEX NUMBER := 0;