APPS.JTF_AMV_ITEM_PUB dependencies on JTF_AMV_ITEM_AUTHORS

Line 425: Delete from jtf_amv_item_authors

421: END IF;
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;
424: -- Delete the item's authors.
425: Delete from jtf_amv_item_authors
426: where item_id = p_item_id;
427: -- Delete the item's keywords.
428: Delete from jtf_amv_item_keywords
429: where item_id = p_item_id;

Line 1536: From jtf_amv_item_authors

1532: --
1533: CURSOR Check_Itemauthor_csr (p_author in VARCHAR2) IS
1534: Select
1535: item_author_id
1536: From jtf_amv_item_authors
1537: Where author = p_author
1538: And item_id = p_item_id;
1539: --
1540: CURSOR Get_IDandDate_csr is

Line 1541: Select jtf_amv_item_authors_s.nextval, sysdate

1537: Where author = p_author
1538: And item_id = p_item_id;
1539: --
1540: CURSOR Get_IDandDate_csr is
1541: Select jtf_amv_item_authors_s.nextval, sysdate
1542: From Dual;
1543: --
1544: BEGIN
1545: -- Standard call to check for call compatibility.

Line 1591: Insert Into jtf_amv_item_authors

1587: CLOSE Check_Itemauthor_csr;
1588: OPEN Get_IDandDate_csr;
1589: FETCH Get_IDandDate_csr Into l_temp_number, l_date;
1590: CLOSE Get_IDandDate_csr;
1591: Insert Into jtf_amv_item_authors
1592: (
1593: ITEM_AUTHOR_ID,
1594: OBJECT_VERSION_NUMBER,
1595: LAST_UPDATE_DATE,

Line 1708: From jtf_amv_item_authors

1704: --
1705: CURSOR Check_Itemauthor_csr (p_author in VARCHAR2) IS
1706: Select
1707: item_author_id
1708: From jtf_amv_item_authors
1709: Where author = p_author
1710: And item_id = p_item_id;
1711: BEGIN
1712: -- Standard call to check for call compatibility.

Line 1753: Delete from jtf_amv_item_authors

1749: FND_MSG_PUB.Add;
1750: END IF;
1751: ELSE
1752: CLOSE Check_Itemauthor_csr;
1753: Delete from jtf_amv_item_authors
1754: Where item_author_id = l_temp_number;
1755: END IF;
1756: END LOOP;
1757: ELSE

Line 1759: Delete from jtf_amv_item_authors

1755: END IF;
1756: END LOOP;
1757: ELSE
1758: -- If no author specified, delete all the authors of the item.
1759: Delete from jtf_amv_item_authors
1760: Where item_id = p_item_id;
1761: END IF;
1762: --Standard check of commit
1763: IF FND_API.To_Boolean ( p_commit ) THEN

Line 1879: Delete from jtf_amv_item_authors

1875: END IF;
1876: RAISE FND_API.G_EXC_ERROR;
1877: END IF;
1878: -- Delete all the item's original author
1879: Delete from jtf_amv_item_authors
1880: Where item_id = p_item_id;
1881: -- now add the new authors
1882: Add_ItemAuthor
1883: (

Line 1949: from JTF_AMV_ITEM_AUTHORS

1945: l_fetch_count NUMBER := 0;
1946: CURSOR Get_Author_csr is
1947: Select
1948: AUTHOR
1949: from JTF_AMV_ITEM_AUTHORS
1950: Where item_id = p_item_id;
1951: --
1952: BEGIN
1953: -- Standard call to check for call compatibility.