777: l_flag varchar2(1);
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;
830: l_flag varchar2(1);
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;
884: l_flag varchar2(1);
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;
937: l_flag varchar2(1);
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;