196: batch_size NUMBER := 5;
197: channel_title VARCHAR2(500);
198: items_title VARCHAR2(500);
199:
200: item_request_obj AMV_CHANNEL_PVT.AMV_REQUEST_OBJ_TYPE;
201: item_return_obj AMV_CHANNEL_PVT.AMV_RETURN_OBJ_TYPE;
202: items_array AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE;
203:
204: cats_array AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE;
197: channel_title VARCHAR2(500);
198: items_title VARCHAR2(500);
199:
200: item_request_obj AMV_CHANNEL_PVT.AMV_REQUEST_OBJ_TYPE;
201: item_return_obj AMV_CHANNEL_PVT.AMV_RETURN_OBJ_TYPE;
202: items_array AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE;
203:
204: cats_array AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE;
205: channels_array AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE;
198: items_title VARCHAR2(500);
199:
200: item_request_obj AMV_CHANNEL_PVT.AMV_REQUEST_OBJ_TYPE;
201: item_return_obj AMV_CHANNEL_PVT.AMV_RETURN_OBJ_TYPE;
202: items_array AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE;
203:
204: cats_array AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE;
205: channels_array AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE;
206:
505: urlformat_channel_name VARCHAR2(500):='';
506: channel_name VARCHAR2 (500);
507: items_title VARCHAR2(500);
508:
509: item_request_obj AMV_CHANNEL_PVT.AMV_REQUEST_OBJ_TYPE;
510: item_return_obj AMV_CHANNEL_PVT.AMV_RETURN_OBJ_TYPE;
511: items_array AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE;
512:
513: cats_array AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE;
506: channel_name VARCHAR2 (500);
507: items_title VARCHAR2(500);
508:
509: item_request_obj AMV_CHANNEL_PVT.AMV_REQUEST_OBJ_TYPE;
510: item_return_obj AMV_CHANNEL_PVT.AMV_RETURN_OBJ_TYPE;
511: items_array AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE;
512:
513: cats_array AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE;
514: channels_array AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE;
507: items_title VARCHAR2(500);
508:
509: item_request_obj AMV_CHANNEL_PVT.AMV_REQUEST_OBJ_TYPE;
510: item_return_obj AMV_CHANNEL_PVT.AMV_RETURN_OBJ_TYPE;
511: items_array AMV_CHANNEL_PVT.AMV_NUMBER_VARRAY_TYPE;
512:
513: cats_array AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE;
514: channels_array AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE;
515: