APPS.AMV_MYCHANNEL_PVT dependencies on AMV_U_MY_CHANNELS

Line 76: from amv_u_my_channels

72: IS
73: --
74: CURSOR My_Channel IS
75: select my_channel_id
76: from amv_u_my_channels
77: where user_or_group_id = p_user_or_group_id
78: and user_or_group_type = p_user_or_group_type
79: and subscribing_to_id = p_subscribing_to_id
80: and subscribing_to_type = p_subscribing_to_type;

Line 400: select amv_u_my_channels_s.nextval

396: l_order number;
397: l_valid_flag varchar2(1);
398: --
399: CURSOR MyChannelId_Seq IS
400: select amv_u_my_channels_s.nextval
401: from dual;
402:
403: CURSOR MyChannelOrder IS
404: SELECT NVL(MAX(order_number) + 1, 1)

Line 405: FROM amv_u_my_channels

401: from dual;
402:
403: CURSOR MyChannelOrder IS
404: SELECT NVL(MAX(order_number) + 1, 1)
405: FROM amv_u_my_channels
406: WHERE user_or_group_id = p_mychannel_obj.user_or_group_id
407: and user_or_group_type = p_mychannel_obj.user_or_group_type;
408: --
409: BEGIN

Line 501: INSERT INTO amv_u_my_channels (

497: FETCH MyChannelId_Seq INTO l_mychannel_id;
498: CLOSE MyChannelId_Seq;
499:
500: -- Add a record in the mychannel
501: INSERT INTO amv_u_my_channels (
502: my_channel_id,
503: object_version_number,
504: last_update_date,
505: last_updated_by,

Line 685: from amv_u_my_channels

681: select user_or_group_id
682: , user_or_group_type
683: , subscribing_to_id
684: , subscribing_to_type
685: from amv_u_my_channels
686: where my_channel_id = p_mychannel_id;
687: --
688: BEGIN
689: -- Standard begin of API savepoint

Line 779: DELETE FROM amv_u_my_channels

775: l_mychannel_id := p_mychannel_id;
776: END IF;
777:
778: -- Remove subscription
779: DELETE FROM amv_u_my_channels
780: WHERE my_channel_id = l_mychannel_id;
781: --
782:
783: -- Success message

Line 902: from amv_u_my_channels

898: select order_number
899: , status
900: , notify_flag
901: , notification_interval_type
902: from amv_u_my_channels
903: where my_channel_id = l_mychannel_id;
904: --
905: BEGIN
906: -- Standard begin of API savepoint

Line 1027: UPDATE amv_u_my_channels

1023: IF p_mychannel_obj.notification_interval_type = FND_API.G_MISS_CHAR THEN
1024: l_notif_interval_type := p_mychannel_obj.notification_interval_type;
1025: END IF;
1026:
1027: UPDATE amv_u_my_channels
1028: SET order_number = l_order_number
1029: , status = l_status
1030: , notify_flag = l_notify_flag
1031: , notification_interval_type = l_notif_interval_type

Line 1170: from amv_u_my_channels

1166: , order_number
1167: , status
1168: , notify_flag
1169: , notification_interval_type
1170: from amv_u_my_channels
1171: where user_or_group_id = p_user_id
1172: and user_or_group_type = AMV_UTILITY_PVT.G_USER
1173: union
1174: select my_channel_id

Line 1184: from amv_u_my_channels

1180: , order_number
1181: , status
1182: , notify_flag
1183: , notification_interval_type
1184: from amv_u_my_channels
1185: where user_or_group_id in (select group_id
1186: from jtf_rs_group_members
1187: where resource_id = p_user_id and
1188: delete_flag = 'N')

Line 1999: from amv_u_my_channels

1995:
1996: -- NOTE not used now reason bug fix 3260137
1997: CURSOR Get_MyChannels IS
1998: select subscribing_to_id
1999: from amv_u_my_channels
2000: where user_or_group_id in (select group_id
2001: from jtf_rs_group_members
2002: where resource_id = p_user_id)
2003: and user_or_group_type = AMV_UTILITY_PVT.G_GROUP

Line 2007: from amv_u_my_channels

2003: and user_or_group_type = AMV_UTILITY_PVT.G_GROUP
2004: and subscribing_to_type = AMV_UTILITY_PVT.G_CHANNEL
2005: union
2006: select subscribing_to_id
2007: from amv_u_my_channels
2008: where user_or_group_id = p_user_id
2009: and user_or_group_type = AMV_UTILITY_PVT.G_USER
2010: and subscribing_to_type = AMV_UTILITY_PVT.G_CHANNEL;
2011:

Line 2015: from amv_u_my_channels

2011:
2012: -- NOTE currently not used
2013: CURSOR Get_MyCategories IS
2014: select subscribing_to_id
2015: from amv_u_my_channels
2016: where user_or_group_id in (select group_id
2017: from jtf_rs_group_members
2018: where resource_id = p_user_id
2019: and delete_flag <> 'Y')

Line 2024: from amv_u_my_channels

2020: and user_or_group_type = AMV_UTILITY_PVT.G_GROUP
2021: and subscribing_to_type = AMV_UTILITY_PVT.G_CATEGORY
2022: union
2023: select subscribing_to_id
2024: from amv_u_my_channels
2025: where user_or_group_id = p_user_id
2026: and user_or_group_type = AMV_UTILITY_PVT.G_USER
2027: and subscribing_to_type = AMV_UTILITY_PVT.G_CATEGORY;
2028:

Line 2036: from amv_u_my_channels

2032: , cim.channel_id
2033: from amv_c_chl_item_match cim
2034: , jtf_amv_items_vl ib
2035: where cim.channel_id in (select subscribing_to_id
2036: from amv_u_my_channels
2037: where user_or_group_id in (select group_id
2038: from jtf_rs_group_members
2039: where resource_id = p_user_id)
2040: and user_or_group_type = AMV_UTILITY_PVT.G_GROUP

Line 2044: from amv_u_my_channels

2040: and user_or_group_type = AMV_UTILITY_PVT.G_GROUP
2041: and subscribing_to_type = AMV_UTILITY_PVT.G_CHANNEL
2042: union
2043: select subscribing_to_id
2044: from amv_u_my_channels
2045: where user_or_group_id = p_user_id
2046: and user_or_group_type = AMV_UTILITY_PVT.G_USER
2047: and subscribing_to_type = AMV_UTILITY_PVT.G_CHANNEL )
2048: and cim.approval_status_type = AMV_UTILITY_PVT.G_APPROVED

Line 2061: from amv_u_my_channels

2057: select count(cim.item_id)
2058: from amv_c_chl_item_match cim
2059: , jtf_amv_items_vl ib
2060: where cim.channel_id in (select subscribing_to_id
2061: from amv_u_my_channels
2062: where user_or_group_id in (select group_id
2063: from jtf_rs_group_members
2064: where resource_id = p_user_id)
2065: and user_or_group_type = AMV_UTILITY_PVT.G_GROUP

Line 2069: from amv_u_my_channels

2065: and user_or_group_type = AMV_UTILITY_PVT.G_GROUP
2066: and subscribing_to_type = AMV_UTILITY_PVT.G_CHANNEL
2067: union
2068: select subscribing_to_id
2069: from amv_u_my_channels
2070: where user_or_group_id = p_user_id
2071: and user_or_group_type = AMV_UTILITY_PVT.G_USER
2072: and subscribing_to_type = AMV_UTILITY_PVT.G_CHANNEL )
2073: and cim.approval_status_type = AMV_UTILITY_PVT.G_APPROVED