APPS.IEM_TAG_KEY_PVT dependencies on IEM_TAG_KEY_PVT

Line 1: PACKAGE BODY IEM_TAG_KEY_PVT AS

1: PACKAGE BODY IEM_TAG_KEY_PVT AS
2: /* $Header: iemvtagb.pls 120.0 2005/06/02 14:17:25 appldev noship $ */
3:
4: --
5: --

Line 18: G_PKG_NAME CONSTANT varchar2(30) :='IEM_TAG_KEY_PVT ';

14: -- Liang Xia 12/04/2004 changed to iem_mstemail_accounts for 115.11 schema compliance
15: -- --------- ------ ------------------------------------------
16:
17: -- Enter procedure, function bodies as shown below
18: G_PKG_NAME CONSTANT varchar2(30) :='IEM_TAG_KEY_PVT ';
19: G_created_updated_by NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
20: G_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID') ) ;
21:
22: PROCEDURE delete_item_batch

Line 799: l_in_tab := IEM_TAG_KEY_PVT.varChar_to_table(p_in_key_id);

795: -- Initialize API return status to SUCCESS
796: x_return_status := FND_API.G_RET_STS_SUCCESS;
797:
798: --API Body
799: l_in_tab := IEM_TAG_KEY_PVT.varChar_to_table(p_in_key_id);
800: l_out_tab := IEM_TAG_KEY_PVT.varChar_to_table(p_out_key_id);
801:
802: --delete association based on OUT list
803: for i in 1..l_out_tab.count() loop

Line 800: l_out_tab := IEM_TAG_KEY_PVT.varChar_to_table(p_out_key_id);

796: x_return_status := FND_API.G_RET_STS_SUCCESS;
797:
798: --API Body
799: l_in_tab := IEM_TAG_KEY_PVT.varChar_to_table(p_in_key_id);
800: l_out_tab := IEM_TAG_KEY_PVT.varChar_to_table(p_out_key_id);
801:
802: --delete association based on OUT list
803: for i in 1..l_out_tab.count() loop
804: delete from iem_account_tag_keys a where a.email_account_id=p_account_id and a.tag_key_id =

Line 1080: END IEM_TAG_KEY_PVT; -- Package Body IEM_TAG_KEY_PVT

1076:
1077: END update_item_tag_key;
1078:
1079:
1080: END IEM_TAG_KEY_PVT; -- Package Body IEM_TAG_KEY_PVT