eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMV_ITEM_PUB dependencies on AMV_ITEM_PUB

Line 1: PACKAGE BODY amv_item_pub AS

1: PACKAGE BODY amv_item_pub AS
2: /* $Header: amvpitmb.pls 115.27 2003/03/13 12:27:02 anraman ship $ */
3: --
4: -- NAME
5: -- AMV_ITEM_PUB

Line 5: -- AMV_ITEM_PUB

1: PACKAGE BODY amv_item_pub AS
2: /* $Header: amvpitmb.pls 115.27 2003/03/13 12:27:02 anraman ship $ */
3: --
4: -- NAME
5: -- AMV_ITEM_PUB
6: --
7: -- HISTORY
8: -- 08/30/1999 PWU CREATED
9: -- 12/03/1999 PWU modify to call jtf amv item api

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMV_ITEM_PUB';

7: -- HISTORY
8: -- 08/30/1999 PWU CREATED
9: -- 12/03/1999 PWU modify to call jtf amv item api
10: --
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMV_ITEM_PUB';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amvpitmb.pls';
13: --
14: G_USED_BY_ITEM CONSTANT VARCHAR2(30) := 'ITEM';
15: -- Debug mode

Line 50: l_item_rec JTF_AMV_ITEM_PUB.ITEM_REC_TYPE;

46: --
47: l_admin_flag VARCHAR2(1);
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

Line 219: JTF_AMV_ITEM_PUB.Create_Item

215: l_item_rec.owner_id := l_item_obj.owner_id;
216: l_item_rec.default_approver_id := l_item_obj.default_approver_id;
217: l_item_rec.item_destination_type := l_item_obj.item_destination_type;
218:
219: JTF_AMV_ITEM_PUB.Create_Item
220: (
221: p_api_version => p_api_version,
222: p_init_msg_list => FND_API.G_FALSE,
223: p_commit => FND_API.G_FALSE,

Line 535: JTF_AMV_ITEM_PUB.Delete_Item

531: x_return_status := FND_API.G_RET_STS_ERROR;
532: END IF;
533: */
534: -- Finally delete the item itself.
535: JTF_AMV_ITEM_PUB.Delete_Item
536: (
537: p_api_version => p_api_version,
538: p_init_msg_list => FND_API.G_FALSE,
539: p_commit => p_commit,

Line 615: l_item_rec JTF_AMV_ITEM_PUB.ITEM_REC_TYPE;

611: l_current_user_status VARCHAR2(80);
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;

Line 757: JTF_AMV_ITEM_PUB.Update_Item

753: l_item_rec.content_type_id := FND_API.G_MISS_NUM;
754: END IF;
755: END IF;
756: END IF;
757: JTF_AMV_ITEM_PUB.Update_Item
758: (
759: p_api_version => p_api_version,
760: p_init_msg_list => FND_API.G_FALSE,
761: p_commit => FND_API.G_FALSE,

Line 1050: l_item_rec JTF_AMV_ITEM_PUB.ITEM_REC_TYPE;

1046: l_current_login_id NUMBER := -1;
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;

Line 1100: JTF_AMV_ITEM_PUB.Get_Item

1096: FND_MSG_PUB.ADD;
1097: END IF;
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;
1100: JTF_AMV_ITEM_PUB.Get_Item
1101: (
1102: p_api_version => p_api_version,
1103: p_init_msg_list => FND_API.G_FALSE,
1104: x_return_status => x_return_status,

Line 1634: l_char_tab JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE;

1630: l_current_login_id NUMBER := -1;
1631: l_current_user_status VARCHAR2(80);
1632: --
1633: l_admin_flag VARCHAR2(1);
1634: l_char_tab JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE;
1635: --
1636: BEGIN
1637: SAVEPOINT Add_ItemKeyword_Pub;
1638: --Initialize message list if p_init_msg_list is TRUE.

Line 1681: l_char_tab := JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE();

1677: RAISE FND_API.G_EXC_ERROR;
1678: END IF;
1679: END IF;
1680: IF (p_keyword_varray IS NOT NULL) THEN
1681: l_char_tab := JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE();
1682: FOR i IN 1..p_keyword_varray.COUNT LOOP
1683: l_char_tab.extend;
1684: l_char_tab(i) := initcap(p_keyword_varray(i));
1685: END LOOP;

Line 1686: JTF_AMV_ITEM_PUB.Add_ItemKeyword

1682: FOR i IN 1..p_keyword_varray.COUNT LOOP
1683: l_char_tab.extend;
1684: l_char_tab(i) := initcap(p_keyword_varray(i));
1685: END LOOP;
1686: JTF_AMV_ITEM_PUB.Add_ItemKeyword
1687: (
1688: p_api_version => p_api_version,
1689: p_init_msg_list => FND_API.G_FALSE,
1690: p_commit => p_commit,

Line 1789: l_char_tab JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE;

1785: l_current_login_id NUMBER := -1;
1786: l_current_user_status VARCHAR2(80);
1787: --
1788: l_admin_flag VARCHAR2(1);
1789: l_char_tab JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE;
1790: BEGIN
1791: -- Standard call to check for call compatibility.
1792: SAVEPOINT Delete_ItemKeyword_Pub;
1793: --Initialize message list if p_init_msg_list is TRUE.

Line 1839: l_char_tab := JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE();

1835: --
1836: IF (p_keyword_varray IS NULL) THEN
1837: l_char_tab := NULL;
1838: ELSE
1839: l_char_tab := JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE();
1840: FOR i IN 1..p_keyword_varray.COUNT LOOP
1841: l_char_tab.extend;
1842: l_char_tab(i) := p_keyword_varray(i);
1843: END LOOP;

Line 1846: JTF_AMV_ITEM_PUB.Delete_ItemKeyword

1842: l_char_tab(i) := p_keyword_varray(i);
1843: END LOOP;
1844: END IF;
1845: -- Now call jtf procedure to do the job.
1846: JTF_AMV_ITEM_PUB.Delete_ItemKeyword
1847: (
1848: p_api_version => p_api_version,
1849: p_init_msg_list => FND_API.G_FALSE,
1850: p_commit => p_commit,

Line 1995: JTF_AMV_ITEM_PUB.Delete_ItemKeyword

1991: RAISE FND_API.G_EXC_ERROR;
1992: END IF;
1993: END IF;
1994: -- Delete all the item's original keyword
1995: JTF_AMV_ITEM_PUB.Delete_ItemKeyword
1996: (
1997: p_api_version => p_api_version,
1998: p_init_msg_list => FND_API.G_FALSE,
1999: p_commit => FND_API.G_FALSE,

Line 2080: l_char_tab JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE;

2076: l_current_user_id NUMBER := -1;
2077: l_current_login_id NUMBER := -1;
2078: l_current_user_status VARCHAR2(80);
2079: --
2080: l_char_tab JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE;
2081: --
2082: BEGIN
2083: --Initialize message list if p_init_msg_list is TRUE.
2084: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 2108: JTF_AMV_ITEM_PUB.Get_ItemKeyword

2104: RAISE FND_API.G_EXC_ERROR;
2105: END IF;
2106: END IF;
2107: -- Now call jtf procedure to do the job.
2108: JTF_AMV_ITEM_PUB.Get_ItemKeyword
2109: (
2110: p_api_version => p_api_version,
2111: p_init_msg_list => FND_API.G_FALSE,
2112: x_return_status => x_return_status,

Line 2177: l_char_tab JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE;

2173: l_current_login_id NUMBER := -1;
2174: l_current_user_status VARCHAR2(80);
2175: --
2176: l_admin_flag VARCHAR2(1);
2177: l_char_tab JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE;
2178: --
2179: BEGIN
2180: -- Standard call to check for call compatibility.
2181: SAVEPOINT Add_ItemAuthor_Pub;

Line 2225: l_char_tab := JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE();

2221: RAISE FND_API.G_EXC_ERROR;
2222: END IF;
2223: END IF;
2224: IF (p_author_varray IS NOT NULL) THEN
2225: l_char_tab := JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE();
2226: FOR i IN 1..p_author_varray.COUNT LOOP
2227: l_char_tab.extend;
2228: l_char_tab(i) := initcap(p_author_varray(i));
2229: END LOOP;

Line 2230: JTF_AMV_ITEM_PUB.Add_ItemAuthor

2226: FOR i IN 1..p_author_varray.COUNT LOOP
2227: l_char_tab.extend;
2228: l_char_tab(i) := initcap(p_author_varray(i));
2229: END LOOP;
2230: JTF_AMV_ITEM_PUB.Add_ItemAuthor
2231: (
2232: p_api_version => p_api_version,
2233: p_init_msg_list => FND_API.G_FALSE,
2234: p_commit => p_commit,

Line 2333: l_char_tab JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE;

2329: l_current_login_id NUMBER := -1;
2330: l_current_user_status VARCHAR2(80);
2331: --
2332: l_admin_flag VARCHAR2(1);
2333: l_char_tab JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE;
2334: BEGIN
2335: -- Standard call to check for call compatibility.
2336: SAVEPOINT Delete_ItemAuthor_Pub;
2337: --Initialize message list if p_init_msg_list is TRUE.

Line 2382: l_char_tab := JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE();

2378: END IF;
2379: IF (p_author_varray IS NULL) THEN
2380: l_char_tab := NULL;
2381: ELSE
2382: l_char_tab := JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE();
2383: FOR i IN 1..p_author_varray.COUNT LOOP
2384: l_char_tab.extend;
2385: l_char_tab(i) := p_author_varray(i);
2386: END LOOP;

Line 2389: JTF_AMV_ITEM_PUB.Delete_ItemAuthor

2385: l_char_tab(i) := p_author_varray(i);
2386: END LOOP;
2387: END IF;
2388: -- Now call jtf procedure to do the job.
2389: JTF_AMV_ITEM_PUB.Delete_ItemAuthor
2390: (
2391: p_api_version => p_api_version,
2392: p_init_msg_list => FND_API.G_FALSE,
2393: p_commit => p_commit,

Line 2548: JTF_AMV_ITEM_PUB.Delete_ItemAuthor

2544: END IF;
2545: RAISE FND_API.G_EXC_ERROR;
2546: END IF;
2547: -- Delete all the item's original authors
2548: JTF_AMV_ITEM_PUB.Delete_ItemAuthor
2549: (
2550: p_api_version => p_api_version,
2551: p_init_msg_list => FND_API.G_FALSE,
2552: p_commit => FND_API.G_FALSE,

Line 2633: l_char_tab JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE;

2629: l_current_user_id NUMBER := -1;
2630: l_current_login_id NUMBER := -1;
2631: l_current_user_status VARCHAR2(80);
2632: --
2633: l_char_tab JTF_AMV_ITEM_PUB.CHAR_TAB_TYPE;
2634: --
2635: BEGIN
2636: --Initialize message list if p_init_msg_list is TRUE.
2637: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 2661: JTF_AMV_ITEM_PUB.Get_ItemAuthor

2657: RAISE FND_API.G_EXC_ERROR;
2658: END IF;
2659: END IF;
2660: -- Now call jtf procedure to do the job.
2661: JTF_AMV_ITEM_PUB.Get_ItemAuthor
2662: (
2663: p_api_version => p_api_version,
2664: p_init_msg_list => FND_API.G_FALSE,
2665: x_return_status => x_return_status,

Line 3970: END amv_item_pub;

3966: p_data => x_msg_data
3967: );
3968: END Get_ChannelsPerItem;
3969: --------------------------------------------------------------------------------
3970: END amv_item_pub;