DBA Data[Home] [Help]

APPS.IBU_ALERT_BIN dependencies on AMV_ITEM_PUB

Line 304: item_object AMV_ITEM_PUB.AMV_ITEM_OBJ_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';
304: item_object AMV_ITEM_PUB.AMV_ITEM_OBJ_TYPE;
305: item_file_array AMV_ITEM_PUB.AMV_NUMBER_VARRAY_TYPE;
306: item_persp_array AMV_ITEM_PUB.AMV_NAMEID_VARRAY_TYPE;
307: item_author_array AMV_ITEM_PUB.AMV_CHAR_VARRAY_TYPE;
308: item_keyword_array AMV_ITEM_PUB.AMV_CHAR_VARRAY_TYPE;

Line 305: item_file_array AMV_ITEM_PUB.AMV_NUMBER_VARRAY_TYPE;

301: newln VARCHAR2(2) := fnd_global.newline();
302: no_items_fnd VARCHAR2(1000);
303: DETAIL_URL VARCHAR2(100) := 'ibumis11.jsp';
304: item_object AMV_ITEM_PUB.AMV_ITEM_OBJ_TYPE;
305: item_file_array AMV_ITEM_PUB.AMV_NUMBER_VARRAY_TYPE;
306: item_persp_array AMV_ITEM_PUB.AMV_NAMEID_VARRAY_TYPE;
307: item_author_array AMV_ITEM_PUB.AMV_CHAR_VARRAY_TYPE;
308: item_keyword_array AMV_ITEM_PUB.AMV_CHAR_VARRAY_TYPE;
309:

Line 306: item_persp_array AMV_ITEM_PUB.AMV_NAMEID_VARRAY_TYPE;

302: no_items_fnd VARCHAR2(1000);
303: DETAIL_URL VARCHAR2(100) := 'ibumis11.jsp';
304: item_object AMV_ITEM_PUB.AMV_ITEM_OBJ_TYPE;
305: item_file_array AMV_ITEM_PUB.AMV_NUMBER_VARRAY_TYPE;
306: item_persp_array AMV_ITEM_PUB.AMV_NAMEID_VARRAY_TYPE;
307: item_author_array AMV_ITEM_PUB.AMV_CHAR_VARRAY_TYPE;
308: item_keyword_array AMV_ITEM_PUB.AMV_CHAR_VARRAY_TYPE;
309:
310: l_employee_id fnd_user.employee_id%TYPE;

Line 307: item_author_array AMV_ITEM_PUB.AMV_CHAR_VARRAY_TYPE;

303: DETAIL_URL VARCHAR2(100) := 'ibumis11.jsp';
304: item_object AMV_ITEM_PUB.AMV_ITEM_OBJ_TYPE;
305: item_file_array AMV_ITEM_PUB.AMV_NUMBER_VARRAY_TYPE;
306: item_persp_array AMV_ITEM_PUB.AMV_NAMEID_VARRAY_TYPE;
307: item_author_array AMV_ITEM_PUB.AMV_CHAR_VARRAY_TYPE;
308: item_keyword_array AMV_ITEM_PUB.AMV_CHAR_VARRAY_TYPE;
309:
310: l_employee_id fnd_user.employee_id%TYPE;
311: l_customer_id fnd_user.customer_id%TYPE;

Line 308: item_keyword_array AMV_ITEM_PUB.AMV_CHAR_VARRAY_TYPE;

304: item_object AMV_ITEM_PUB.AMV_ITEM_OBJ_TYPE;
305: item_file_array AMV_ITEM_PUB.AMV_NUMBER_VARRAY_TYPE;
306: item_persp_array AMV_ITEM_PUB.AMV_NAMEID_VARRAY_TYPE;
307: item_author_array AMV_ITEM_PUB.AMV_CHAR_VARRAY_TYPE;
308: item_keyword_array AMV_ITEM_PUB.AMV_CHAR_VARRAY_TYPE;
309:
310: l_employee_id fnd_user.employee_id%TYPE;
311: l_customer_id fnd_user.customer_id%TYPE;
312: l_supplier_id fnd_user.supplier_id%TYPE;

Line 575: AMV_ITEM_PUB.get_item(p_api_version => 1.0,

571: ELSE
572: --dbms_output.put_line('No of items'||items_array.count);
573:
574: for i IN 1 .. items_array.COUNT LOOP
575: AMV_ITEM_PUB.get_item(p_api_version => 1.0,
576: p_init_msg_list => 'T',
577: x_return_status => x_return_status,
578: x_msg_count => x_msg_count,
579: x_msg_data => x_msg_data,