DBA Data[Home] [Help]

APPS.AMV_ITEM_PUB dependencies on AMV_PERSPECTIVE_PVT

Line 52: l_persp_id_array AMV_PERSPECTIVE_PVT.AMV_NUMBER_VARRAY_TYPE;

48: l_item_id NUMBER;
49: l_return_status VARCHAR2(1);
50: l_item_rec JTF_AMV_ITEM_PUB.ITEM_REC_TYPE;
51: l_item_obj AMV_ITEM_OBJ_TYPE := p_item_obj;
52: l_persp_id_array AMV_PERSPECTIVE_PVT.AMV_NUMBER_VARRAY_TYPE;
53: --
54: BEGIN
55: -- Standard call to check for call compatibility.
56: SAVEPOINT Create_Item_Pub;

Line 237: l_persp_id_array := AMV_PERSPECTIVE_PVT.AMV_NUMBER_VARRAY_TYPE();

233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234: END IF;
235: -- Add item's perspectives
236: IF (p_persp_array IS NOT NULL) THEN
237: l_persp_id_array := AMV_PERSPECTIVE_PVT.AMV_NUMBER_VARRAY_TYPE();
238: FOR i IN 1..p_persp_array.COUNT LOOP
239: l_persp_id_array.extend;
240: l_persp_id_array(i) := p_persp_array(i).id;
241: END LOOP;

Line 242: amv_perspective_pvt.Add_ItemPersps

238: FOR i IN 1..p_persp_array.COUNT LOOP
239: l_persp_id_array.extend;
240: l_persp_id_array(i) := p_persp_array(i).id;
241: END LOOP;
242: amv_perspective_pvt.Add_ItemPersps
243: (
244: p_api_version => l_api_version,
245: x_return_status => l_return_status,
246: x_msg_count => x_msg_count,

Line 495: amv_perspective_pvt.Delete_ItemPersps

491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493: -- Now do the deleting (real job).
494: -- Delete item's perspectives
495: amv_perspective_pvt.Delete_ItemPersps
496: (
497: p_api_version => p_api_version,
498: x_return_status => l_return_status,
499: x_msg_count => x_msg_count,

Line 616: l_persp_id_array AMV_PERSPECTIVE_PVT.AMV_NUMBER_VARRAY_TYPE;

612: --
613: l_admin_flag VARCHAR2(1);
614: l_return_status VARCHAR2(1);
615: l_item_rec JTF_AMV_ITEM_PUB.ITEM_REC_TYPE;
616: l_persp_id_array AMV_PERSPECTIVE_PVT.AMV_NUMBER_VARRAY_TYPE;
617: l_channel_id_array AMV_NAMEID_VARRAY_TYPE;
618: l_channel_add_id AMV_NUMBER_VARRAY_TYPE;
619: l_channel_remove_id AMV_NUMBER_VARRAY_TYPE;
620: l_flag VARCHAR2(10);

Line 774: l_persp_id_array := AMV_PERSPECTIVE_PVT.AMV_NUMBER_VARRAY_TYPE();

770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771: END IF;
772:
773: IF (p_persp_array IS NOT NULL) THEN
774: l_persp_id_array := AMV_PERSPECTIVE_PVT.AMV_NUMBER_VARRAY_TYPE();
775: FOR i IN 1..p_persp_array.COUNT LOOP
776: l_persp_id_array.extend;
777: l_persp_id_array(i) := p_persp_array(i).id;
778: END LOOP;

Line 779: amv_perspective_pvt.Update_ItemPersps

775: FOR i IN 1..p_persp_array.COUNT LOOP
776: l_persp_id_array.extend;
777: l_persp_id_array(i) := p_persp_array(i).id;
778: END LOOP;
779: amv_perspective_pvt.Update_ItemPersps
780: (
781: p_api_version => p_api_version,
782: x_return_status => l_return_status,
783: x_msg_count => x_msg_count,

Line 1051: l_persp_obj_varray AMV_PERSPECTIVE_PVT.AMV_PERSPECTIVE_OBJ_VARRAY;

1047: l_current_user_status VARCHAR2(80);
1048: --
1049: l_return_status VARCHAR2(1);
1050: l_item_rec JTF_AMV_ITEM_PUB.ITEM_REC_TYPE;
1051: l_persp_obj_varray AMV_PERSPECTIVE_PVT.AMV_PERSPECTIVE_OBJ_VARRAY;
1052: l_persp_varray AMV_NAMEID_VARRAY_TYPE;
1053: l_author_varray AMV_CHAR_VARRAY_TYPE;
1054: l_keyword_varray AMV_CHAR_VARRAY_TYPE;
1055: l_file_id_varray AMV_NUMBER_VARRAY_TYPE;

Line 1119: l_persp_obj_varray := AMV_PERSPECTIVE_PVT.AMV_PERSPECTIVE_OBJ_VARRAY();

1115: -- Get item's perspectives.
1116: --l_persp_id_varray := AMV_NUMBER_VARRAY_TYPE();
1117: --l_persp_name_varray := AMV_CHAR_VARRAY_TYPE();
1118: l_persp_varray := AMV_NAMEID_VARRAY_TYPE();
1119: l_persp_obj_varray := AMV_PERSPECTIVE_PVT.AMV_PERSPECTIVE_OBJ_VARRAY();
1120: AMV_PERSPECTIVE_PVT.Get_ItemPersps
1121: (
1122: p_api_version => p_api_version,
1123: x_return_status => l_return_status,

Line 1120: AMV_PERSPECTIVE_PVT.Get_ItemPersps

1116: --l_persp_id_varray := AMV_NUMBER_VARRAY_TYPE();
1117: --l_persp_name_varray := AMV_CHAR_VARRAY_TYPE();
1118: l_persp_varray := AMV_NAMEID_VARRAY_TYPE();
1119: l_persp_obj_varray := AMV_PERSPECTIVE_PVT.AMV_PERSPECTIVE_OBJ_VARRAY();
1120: AMV_PERSPECTIVE_PVT.Get_ItemPersps
1121: (
1122: p_api_version => p_api_version,
1123: x_return_status => l_return_status,
1124: x_msg_count => x_msg_count,

Line 1307: l_persp_obj_varray AMV_PERSPECTIVE_PVT.AMV_PERSPECTIVE_OBJ_VARRAY;

1303: l_url_string VARCHAR2(2000);
1304: l_item_destination_type VARCHAR2(240);
1305: --
1306: l_return_status VARCHAR2(1);
1307: l_persp_obj_varray AMV_PERSPECTIVE_PVT.AMV_PERSPECTIVE_OBJ_VARRAY;
1308: l_persp_id_list VARCHAR2(2000);
1309: l_persp_name_list VARCHAR2(2000);
1310: l_keyword_varray AMV_CHAR_VARRAY_TYPE;
1311: l_keyword_list VARCHAR2(2000);

Line 1462: AMV_PERSPECTIVE_PVT.Get_ItemPersps

1458: IF (l_start_with <= l_total_count AND
1459: l_fetch_count < p_subset_request_obj.records_requested) THEN
1460: l_fetch_count := l_fetch_count + 1;
1461: -- Get item's perspectives.
1462: AMV_PERSPECTIVE_PVT.Get_ItemPersps
1463: (
1464: p_api_version => p_api_version,
1465: x_return_status => l_return_status,
1466: x_msg_count => x_msg_count,