APPS.AMV_STOCK_PVT dependencies on AMV_NEWS

Line 1668: -- p_news_rec IN AMV_NEWS_OBJ_TYPE Required

1664: -- p_validation_level IN NUMBER Optional
1665: -- Default = FND_API.G_VALID_LEVEL_FULL
1666: -- p_vendor_id IN NUMBER Required
1667: -- vendor id.
1668: -- p_news_rec IN AMV_NEWS_OBJ_TYPE Required
1669: -- array of news objects.
1670: -- OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2
1671: -- x_msg_count OUT NOCOPY NUMBER
1672: -- x_msg_data OUT NOCOPY VARCHAR2

Line 1689: p_news_rec IN AMV_NEWS_OBJ_TYPE

1685: x_return_status OUT NOCOPY VARCHAR2,
1686: x_msg_count OUT NOCOPY NUMBER,
1687: x_msg_data OUT NOCOPY VARCHAR2,
1688: p_vendor_id IN NUMBER,
1689: p_news_rec IN AMV_NEWS_OBJ_TYPE
1690: )
1691: IS
1692: l_api_name CONSTANT VARCHAR2(30) := 'Insert_VendorNews';
1693: l_api_version CONSTANT NUMBER := 1.0;

Line 1715: select amv_news_s.nextval

1711: where vendor_id = p_vendor_id
1712: and vendor_key = l_key_id;
1713:
1714: CURSOR NewsId_seq IS
1715: select amv_news_s.nextval
1716: from dual;
1717: --
1718: BEGIN
1719: -- Standard begin of API savepoint

Line 1754: INSERT INTO amv_news (

1750: OPEN NewsId_seq;
1751: FETCH NewsId_seq INTO l_news_id;
1752: CLOSE NewsId_seq;
1753:
1754: INSERT INTO amv_news (
1755: news_id,
1756: object_version_number,
1757: last_update_date,
1758: last_updated_by,

Line 1869: -- x_news_array OUT AMV_NEWS_VARRAY_TYPE

1865: -- vendor id.
1866: -- OUT : x_return_status OUT VARCHAR2
1867: -- x_msg_count OUT NUMBER
1868: -- x_msg_data OUT VARCHAR2
1869: -- x_news_array OUT AMV_NEWS_VARRAY_TYPE
1870: -- array of news objects.
1871: -- Version : Current version 1.0
1872: -- Previous version 1.0
1873: -- Initial version 1.0

Line 1887: x_news_array OUT NOCOPY AMV_NEWS_VARRAY_TYPE

1883: x_return_status OUT NOCOPY VARCHAR2,
1884: x_msg_count OUT NOCOPY NUMBER,
1885: x_msg_data OUT NOCOPY VARCHAR2,
1886: p_stock_id IN NUMBER,
1887: x_news_array OUT NOCOPY AMV_NEWS_VARRAY_TYPE
1888: )
1889: IS
1890: l_api_name CONSTANT VARCHAR2(30) := 'Get_CompanyNews';
1891: l_api_version CONSTANT NUMBER := 1.0;

Line 1914: from amv_news n

1910: , n.news_url
1911: , n.news_title
1912: , n.provider
1913: , n.date_time
1914: from amv_news n
1915: , amv_vendor_keys v
1916: where v.stock_id = p_stock_id
1917: and v.vendor_key_id = n.vendor_key_id
1918: order by n.date_time desc;