APPS.JTF_AMV_ITEM_PUB dependencies on JTF_AMV_ITEM_KEYWORDS

Line 428: Delete from jtf_amv_item_keywords

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;
430: -- Remove item's files.
431: Delete from jtf_amv_attachments
432: where attachment_used_by_id = p_item_id

Line 1022: From jtf_amv_item_keywords

1018: --
1019: CURSOR Check_Itemkeyword_csr (p_kword in VARCHAR2) IS
1020: Select
1021: item_keyword_id
1022: From jtf_amv_item_keywords
1023: Where keyword = p_kword
1024: And item_id = p_item_id;
1025: --
1026: CURSOR Get_IDandDate_csr is

Line 1027: Select jtf_amv_item_keywords_s.nextval, sysdate

1023: Where keyword = p_kword
1024: And item_id = p_item_id;
1025: --
1026: CURSOR Get_IDandDate_csr is
1027: Select jtf_amv_item_keywords_s.nextval, sysdate
1028: From Dual;
1029: --
1030: BEGIN
1031: -- Standard call to check for call compatibility.

Line 1077: Insert Into jtf_amv_item_keywords

1073: CLOSE Check_Itemkeyword_csr;
1074: OPEN Get_IDandDate_csr;
1075: FETCH Get_IDandDate_csr Into l_temp_number, l_date;
1076: CLOSE Get_IDandDate_csr;
1077: Insert Into jtf_amv_item_keywords
1078: (
1079: ITEM_KEYWORD_ID,
1080: OBJECT_VERSION_NUMBER,
1081: LAST_UPDATE_DATE,

Line 1196: From jtf_amv_item_keywords

1192: --
1193: CURSOR Check_Itemkeyword_csr (p_kword in VARCHAR2) IS
1194: Select
1195: item_keyword_id
1196: From jtf_amv_item_keywords
1197: Where keyword = p_kword
1198: And item_id = p_item_id;
1199: BEGIN
1200: -- Standard call to check for call compatibility.

Line 1241: Delete from jtf_amv_item_keywords

1237: FND_MSG_PUB.Add;
1238: END IF;
1239: ELSE
1240: CLOSE Check_Itemkeyword_csr;
1241: Delete from jtf_amv_item_keywords
1242: Where item_keyword_id = l_temp_number;
1243: END IF;
1244: END LOOP;
1245: ELSE

Line 1247: Delete from jtf_amv_item_keywords

1243: END IF;
1244: END LOOP;
1245: ELSE
1246: -- If no keyword specified, delete all the keywords of the item.
1247: Delete from jtf_amv_item_keywords
1248: Where item_id = p_item_id;
1249: END IF;
1250: --Standard check of commit
1251: IF FND_API.To_Boolean ( p_commit ) THEN

Line 1367: Delete from jtf_amv_item_keywords

1363: END IF;
1364: RAISE FND_API.G_EXC_ERROR;
1365: END IF;
1366: -- Delete all the item's original keyword
1367: Delete from jtf_amv_item_keywords
1368: Where item_id = p_item_id;
1369: -- now add the new keywords
1370: Add_ItemKeyword
1371: (

Line 1442: from JTF_AMV_ITEM_KEYWORDS

1438: l_fetch_count NUMBER := 0;
1439: CURSOR Get_Keyword_csr is
1440: Select
1441: KEYWORD
1442: from JTF_AMV_ITEM_KEYWORDS
1443: Where item_id = p_item_id;
1444: --
1445: BEGIN
1446: -- Standard call to check for call compatibility.