APPS.AMV_CHANNEL_PVT dependencies on AMV_C_CONTENT_TYPES

Line 2066: DELETE FROM amv_c_content_types

2062: -- Remove channel from keywords
2063: DELETE FROM amv_c_keywords
2064: WHERE channel_id = l_channel_id;
2065: -- Remove channel from content type
2066: DELETE FROM amv_c_content_types
2067: WHERE channel_id = l_channel_id;
2068: -- Remove channel from perspectives
2069: DELETE FROM amv_c_chl_perspectives
2070: WHERE channel_id = l_channel_id;

Line 2913: select amv_c_content_types_s.nextval

2909: l_update_channel_flag Varchar2(1);
2910: l_chl_content_type_id number;
2911: --
2912: CURSOR C_ChanContentType_Seq IS
2913: select amv_c_content_types_s.nextval
2914: from dual;
2915: BEGIN
2916: -- Standard begin of API savepoint
2917: SAVEPOINT Set_ChannelContent_PVT;

Line 3038: DELETE FROM amv_c_content_types

3034: -- update channels if user has privilege
3035: IF l_update_channel_flag = FND_API.G_TRUE THEN
3036:
3037: -- remove old categories for the channel
3038: DELETE FROM amv_c_content_types
3039: WHERE channel_id = l_channel_id;
3040:
3041: -- set match on flag in channel table
3042: IF p_content_type_id_array.count > 0 THEN

Line 3070: INSERT INTO amv_c_content_types

3066: OPEN C_ChanContentType_Seq;
3067: FETCH C_ChanContentType_Seq into l_chl_content_type_id;
3068: CLOSE C_ChanContentType_Seq;
3069:
3070: INSERT INTO amv_c_content_types
3071: (
3072: channel_content_type_id,
3073: object_version_number,
3074: last_update_date,

Line 3217: from amv_c_content_types

3213: l_content_type_id number;
3214: --
3215: CURSOR Get_Categories IS
3216: select content_type_id
3217: from amv_c_content_types
3218: where channel_id = l_channel_id;
3219: --
3220: BEGIN
3221: -- Standard begin of API savepoint