APPS.AMV_MATCH_PVT dependencies on AMV_C_CHANNELS_B

Line 628: 'From amv_c_channels_b c ';

624: 'c.match_on_keyword_flag, ' ||
625: 'c.match_on_perspective_flag, ' ||
626: 'c.match_on_content_type_flag, ' ||
627: 'c.match_on_item_type_flag ' ||
628: 'From amv_c_channels_b c ';
629: l_where_clause :=
630: 'Where c.application_id = ' || l_application_id || ' ' ||
631: 'And c.match_on_all_criteria_flag = ''' || FND_API.G_TRUE || ''' ' ||
632: 'And c.access_level_type in (''PUBLIC'', ''PROTECT'') ' ||

Line 877: From amv_c_channels_b c

873: c.access_level_type,
874: c.channel_type,
875: c.status,
876: c.expiration_date
877: From amv_c_channels_b c
878: Where c.channel_id = p_channel_id;
879: --
880: BEGIN
881: SAVEPOINT Match_ChannelWithItems_Pvt;

Line 999: 'From jtf_amv_items_b item, amv_c_channels_b chan ';

995: --
996: l_sql_statement :=
997: 'Select ' ||
998: 'item.item_id ' ||
999: 'From jtf_amv_items_b item, amv_c_channels_b chan ';
1000: l_where_clause := 'Where chan.channel_id = :channel_id ' ||
1001: 'And item.application_id = ' || l_application_id || ' ' ||
1002: 'And item.status_code = ''ACTIVE'' ' ||
1003: 'And item.item_type != ''MESSAGE_ITEM'' ' ||

Line 1530: 'From jtf_amv_items_b item, amv_c_channels_b chan ';

1526: END IF;
1527: END IF;
1528: --
1529: l_sql_statement := 'Select 1 ' ||
1530: 'From jtf_amv_items_b item, amv_c_channels_b chan ';
1531: l_where_clause := 'Where item.item_id = :item_id ' ||
1532: 'And chan.channel_id = :channel_id ';
1533: IF (p_match_on_author_flag = FND_API.G_TRUE) THEN
1534: l_where_clause := l_where_clause ||

Line 1679: from amv_c_channels_b

1675: pub_need_approval_flag,
1676: channel_category_id,
1677: AMV_C_CHL_ITEM_MATCH_S.nextval,
1678: sysdate
1679: from amv_c_channels_b
1680: Where channel_id = p_channel_id;
1681: --
1682: CURSOR Get_IdAndDate_csr IS
1683: select

Line 2024: from amv_c_channels_b

2020: pub_need_approval_flag,
2021: channel_category_id,
2022: AMV_C_CHL_ITEM_MATCH_S.nextval,
2023: sysdate
2024: from amv_c_channels_b
2025: Where channel_id = p_channel_id;
2026: --
2027: CURSOR Get_IdAndDate_csr IS
2028: select

Line 2387: From fnd_user u, jtf_rs_resource_extns r, amv_c_channels_b c

2383: CURSOR Get_OwnerIDAndName_csr (p_id IN NUMBER)IS
2384: select
2385: u.user_name,
2386: c.owner_user_id
2387: From fnd_user u, jtf_rs_resource_extns r, amv_c_channels_b c
2388: Where c.channel_id = p_id
2389: And r.resource_id = c.owner_user_id
2390: And r.user_id = u.user_id
2391: ;

Line 2399: from amv_c_channels_b

2395: pub_need_approval_flag,
2396: channel_category_id,
2397: AMV_C_CHL_ITEM_MATCH_S.nextval,
2398: sysdate
2399: from amv_c_channels_b
2400: Where channel_id = p_channel_id;
2401: --
2402: CURSOR Get_IdAndDate_csr IS
2403: select