65: location integer;
66: msg_data VARCHAR2(1000);
67: batch_size NUMBER := 3;
68:
69: request_obj AMV_MYCHANNEL_PVT.AMV_REQUEST_OBJ_TYPE;
70: return_obj AMV_MYCHANNEL_PVT.AMV_RETURN_OBJ_TYPE;
71: items_array AMV_MYCHANNEL_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE;
72: resource_id NUMBER;
73: newln VARCHAR2(2) := fnd_global.newline();
66: msg_data VARCHAR2(1000);
67: batch_size NUMBER := 3;
68:
69: request_obj AMV_MYCHANNEL_PVT.AMV_REQUEST_OBJ_TYPE;
70: return_obj AMV_MYCHANNEL_PVT.AMV_RETURN_OBJ_TYPE;
71: items_array AMV_MYCHANNEL_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE;
72: resource_id NUMBER;
73: newln VARCHAR2(2) := fnd_global.newline();
74: no_items_fnd VARCHAR2(1000);
67: batch_size NUMBER := 3;
68:
69: request_obj AMV_MYCHANNEL_PVT.AMV_REQUEST_OBJ_TYPE;
70: return_obj AMV_MYCHANNEL_PVT.AMV_RETURN_OBJ_TYPE;
71: items_array AMV_MYCHANNEL_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE;
72: resource_id NUMBER;
73: newln VARCHAR2(2) := fnd_global.newline();
74: no_items_fnd VARCHAR2(1000);
75:
293: l_msg_index NUMBER;
294: l_more_msg_data BOOLEAN := FALSE;
295:
296: batch_size NUMBER := 5;
297: request_obj AMV_MYCHANNEL_PVT.AMV_REQUEST_OBJ_TYPE;
298: return_obj AMV_MYCHANNEL_PVT.AMV_RETURN_OBJ_TYPE;
299: items_array AMV_MYCHANNEL_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE;
300: resource_id NUMBER;
301: newln VARCHAR2(2) := fnd_global.newline();
294: l_more_msg_data BOOLEAN := FALSE;
295:
296: batch_size NUMBER := 5;
297: request_obj AMV_MYCHANNEL_PVT.AMV_REQUEST_OBJ_TYPE;
298: return_obj AMV_MYCHANNEL_PVT.AMV_RETURN_OBJ_TYPE;
299: items_array AMV_MYCHANNEL_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE;
300: resource_id NUMBER;
301: newln VARCHAR2(2) := fnd_global.newline();
302: no_items_fnd VARCHAR2(1000);
295:
296: batch_size NUMBER := 5;
297: request_obj AMV_MYCHANNEL_PVT.AMV_REQUEST_OBJ_TYPE;
298: return_obj AMV_MYCHANNEL_PVT.AMV_RETURN_OBJ_TYPE;
299: items_array AMV_MYCHANNEL_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE;
300: resource_id NUMBER;
301: newln VARCHAR2(2) := fnd_global.newline();
302: no_items_fnd VARCHAR2(1000);
303: DETAIL_URL VARCHAR2(100) := 'ibumis11.jsp';