APPS.AMV_UTILITY_PVT2 dependencies on AMV_UTILITY_PVT2

Line 1: PACKAGE BODY amv_utility_pvt2 AS

1: PACKAGE BODY amv_utility_pvt2 AS
2: /* $Header: amvvutcb.pls 115.3 2000/02/02 17:25:02 pkm ship $ */
3: --
4: -- NAME
5: -- AMV_UTILITY_PVT2

Line 5: -- AMV_UTILITY_PVT2

1: PACKAGE BODY amv_utility_pvt2 AS
2: /* $Header: amvvutcb.pls 115.3 2000/02/02 17:25:02 pkm ship $ */
3: --
4: -- NAME
5: -- AMV_UTILITY_PVT2
6: --
7: -- HISTORY
8: -- 08/30/1999 SLKRISHN CREATED
9: --

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

7: -- HISTORY
8: -- 08/30/1999 SLKRISHN CREATED
9: --
10: --
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMV_UTILITY_PVT2';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amvvutlb.pls';
13: --
14: G_VALID_LEVEL_LOGIN CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
15: --

Line 165: where access_to_table_code = AMV_UTILITY_PVT2.G_CHANNEL

161:
162: CURSOR DelChanAccs_csr IS
163: select can_delete_flag
164: from amv_u_access
165: where access_to_table_code = AMV_UTILITY_PVT2.G_CHANNEL
166: and access_to_table_record_id = p_channel_id
167: and user_or_group_id = p_user_or_group_id
168: and user_or_group_type = p_user_or_group_type;
169: --

Line 218: where access_to_table_code = AMV_UTILITY_PVT2.G_CHANNEL

214:
215: CURSOR UpdChanAccs_csr IS
216: select can_update_flag
217: from amv_u_access
218: where access_to_table_code = AMV_UTILITY_PVT2.G_CHANNEL
219: and access_to_table_record_id = p_channel_id
220: and user_or_group_id = p_user_or_group_id
221: and user_or_group_type = p_user_or_group_type;
222: --

Line 272: where access_to_table_code = AMV_UTILITY_PVT2.G_CATEGORY

268:
269: CURSOR DelCatAccs_csr IS
270: select can_delete_flag
271: from amv_u_access
272: where access_to_table_code = AMV_UTILITY_PVT2.G_CATEGORY
273: and access_to_table_record_id = p_category_id
274: and user_or_group_id = p_user_or_group_id
275: and user_or_group_type = p_user_or_group_type;
276: --

Line 325: where access_to_table_code = AMV_UTILITY_PVT2.G_CATEGORY

321:
322: CURSOR UpdCatAccs_csr IS
323: select can_update_flag
324: from amv_u_access
325: where access_to_table_code = AMV_UTILITY_PVT2.G_CATEGORY
326: and access_to_table_record_id = p_category_id
327: and user_or_group_id = p_user_or_group_id
328: and user_or_group_type = p_user_or_group_type;
329: --

Line 350: END amv_utility_pvt2;

346: --
347: --------------------------------------------------------------------------------
348: --------------------------------------------------------------------------------
349:
350: END amv_utility_pvt2;