APPS.AMV_UTILITY_PVT dependencies on AMV_UTILITY_PVT

Line 1: PACKAGE BODY amv_utility_pvt AS

1: PACKAGE BODY amv_utility_pvt AS
2: /* $Header: amvvutlb.pls 120.1 2005/06/21 16:54:22 appldev ship $ */
3: --
4: -- NAME
5: -- AMV_UTILITY_PVT

Line 5: -- AMV_UTILITY_PVT

1: PACKAGE BODY amv_utility_pvt AS
2: /* $Header: amvvutlb.pls 120.1 2005/06/21 16:54:22 appldev ship $ */
3: --
4: -- NAME
5: -- AMV_UTILITY_PVT
6: --
7: -- HISTORY
8: -- 06/01/1999 PWU CREATED
9: --

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30):='AMV_UTILITY_PVT';

6: --
7: -- HISTORY
8: -- 06/01/1999 PWU CREATED
9: --
10: G_PKG_NAME CONSTANT VARCHAR2(30):='AMV_UTILITY_PVT';
11: G_FILE_NAME CONSTANT VARCHAR2(12):='amvvutlb.pls';
12:
13: -- Debug mode
14: --g_debug boolean := FALSE;

Line 782: where access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL

778:
779: CURSOR DelChanAccs_csr IS
780: select can_delete_flag
781: from amv_u_access
782: where access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
783: and access_to_table_record_id = p_channel_id
784: and user_or_group_id = p_user_or_group_id
785: and user_or_group_type = p_user_or_group_type;
786: --

Line 835: where access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL

831:
832: CURSOR UpdChanAccs_csr IS
833: select can_update_flag
834: from amv_u_access
835: where access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
836: and access_to_table_record_id = p_channel_id
837: and user_or_group_id = p_user_or_group_id
838: and user_or_group_type = p_user_or_group_type;
839: --

Line 889: where access_to_table_code = AMV_UTILITY_PVT.G_CATEGORY

885:
886: CURSOR DelCatAccs_csr IS
887: select can_delete_flag
888: from amv_u_access
889: where access_to_table_code = AMV_UTILITY_PVT.G_CATEGORY
890: and access_to_table_record_id = p_category_id
891: and user_or_group_id = p_user_or_group_id
892: and user_or_group_type = p_user_or_group_type;
893: --

Line 942: where access_to_table_code = AMV_UTILITY_PVT.G_CATEGORY

938:
939: CURSOR UpdCatAccs_csr IS
940: select can_update_flag
941: from amv_u_access
942: where access_to_table_code = AMV_UTILITY_PVT.G_CATEGORY
943: and access_to_table_record_id = p_category_id
944: and user_or_group_id = p_user_or_group_id
945: and user_or_group_type = p_user_or_group_type;
946: --

Line 965: END amv_utility_pvt;

961: --
962: END Get_UpdateCategoryStatus;
963: --
964: --------------------------------------------------------------------------------
965: END amv_utility_pvt;