eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMV_CHANNEL_PVT dependencies on AMV_C_CHANNELS_B

Line 91: from amv_c_channels_b b, amv_c_channels_tl tl

87: x_error_token OUT NOCOPY VARCHAR2
88: ) IS
89: CURSOR Get_ChannelStatusByName is
90: select b.channel_id
91: from amv_c_channels_b b, amv_c_channels_tl tl
92: where tl.channel_name = p_channel_name
93: and tl.language = userenv('lang')
94: -- commented line below for bug no.2950840
95: --and b.channel_category_id = p_category_id

Line 201: from amv_c_channels_b

197: , match_on_keyword_flag
198: , match_on_perspective_flag
199: , match_on_item_type_flag
200: , match_on_content_type_flag
201: from amv_c_channels_b
202: where channel_id = p_channel_id;
203:
204: BEGIN
205:

Line 341: from amv_c_channels_b b

337: b.attribute12,
338: b.attribute13,
339: b.attribute14,
340: b.attribute15
341: from amv_c_channels_b b
342: , amv_c_channels_tl tl
343: where b.channel_id = p_channel_id
344: and tl.language = userenv('lang')
345: and tl.channel_id = b.channel_id;

Line 507: select amv_c_channels_b_s.nextval

503: l_channel_obj AMV_CHANNEL_OBJ_TYPE;
504: l_error_flag varchar2(1);
505:
506: CURSOR ChannelId_Seq IS
507: select amv_c_channels_b_s.nextval
508: from dual;
509: BEGIN
510: -- Standard begin of API savepoint
511: SAVEPOINT Add_Channel_PVT;

Line 2201: from amv_c_channels_b

2197: l_channel_obj AMV_CHANNEL_OBJ_TYPE;
2198:
2199: CURSOR Get_ChnVersion_csr IS
2200: select object_version_number
2201: from amv_c_channels_b
2202: where channel_id = l_channel_id;
2203: --
2204: BEGIN
2205: -- Standard begin of API savepoint

Line 3043: UPDATE amv_c_channels_b

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
3043: UPDATE amv_c_channels_b
3044: set match_on_content_type_flag = FND_API.G_TRUE
3045: where channel_id = l_channel_id;
3046: ELSE
3047: UPDATE amv_c_channels_b

Line 3047: UPDATE amv_c_channels_b

3043: UPDATE amv_c_channels_b
3044: set match_on_content_type_flag = FND_API.G_TRUE
3045: where channel_id = l_channel_id;
3046: ELSE
3047: UPDATE amv_c_channels_b
3048: set match_on_content_type_flag = FND_API.G_FALSE
3049: where channel_id = l_channel_id;
3050: END IF;
3051:

Line 3054: UPDATE amv_c_channels_b

3050: END IF;
3051:
3052: -- set match on all criteria flag
3053: IF Get_MatchOnStatus(l_channel_id) THEN
3054: UPDATE amv_c_channels_b
3055: set match_on_all_criteria_flag = FND_API.G_TRUE
3056: where channel_id = l_channel_id;
3057: ELSE
3058: UPDATE amv_c_channels_b

Line 3058: UPDATE amv_c_channels_b

3054: UPDATE amv_c_channels_b
3055: set match_on_all_criteria_flag = FND_API.G_TRUE
3056: where channel_id = l_channel_id;
3057: ELSE
3058: UPDATE amv_c_channels_b
3059: set match_on_all_criteria_flag = FND_API.G_FALSE
3060: where channel_id = l_channel_id;
3061: END IF;
3062:

Line 3546: UPDATE amv_c_channels_b

3542: WHERE channel_id = l_channel_id;
3543:
3544: -- set match on flag in channel table
3545: IF p_perspective_id_array.count > 0 THEN
3546: UPDATE amv_c_channels_b
3547: set match_on_perspective_flag = FND_API.G_TRUE
3548: where channel_id = l_channel_id;
3549: ELSE
3550: UPDATE amv_c_channels_b

Line 3550: UPDATE amv_c_channels_b

3546: UPDATE amv_c_channels_b
3547: set match_on_perspective_flag = FND_API.G_TRUE
3548: where channel_id = l_channel_id;
3549: ELSE
3550: UPDATE amv_c_channels_b
3551: set match_on_perspective_flag = FND_API.G_FALSE
3552: where channel_id = l_channel_id;
3553: END IF;
3554:

Line 3557: UPDATE amv_c_channels_b

3553: END IF;
3554:
3555: -- set match on all criteria flag
3556: IF Get_MatchOnStatus(l_channel_id) THEN
3557: UPDATE amv_c_channels_b
3558: set match_on_all_criteria_flag = FND_API.G_TRUE
3559: where channel_id = l_channel_id;
3560: ELSE
3561: UPDATE amv_c_channels_b

Line 3561: UPDATE amv_c_channels_b

3557: UPDATE amv_c_channels_b
3558: set match_on_all_criteria_flag = FND_API.G_TRUE
3559: where channel_id = l_channel_id;
3560: ELSE
3561: UPDATE amv_c_channels_b
3562: set match_on_all_criteria_flag = FND_API.G_FALSE
3563: where channel_id = l_channel_id;
3564: END IF;
3565:

Line 4049: UPDATE amv_c_channels_b

4045: WHERE channel_id = l_channel_id;
4046:
4047: -- set match on flag in channel table
4048: IF p_item_type_array.count > 0 THEN
4049: UPDATE amv_c_channels_b
4050: set match_on_item_type_flag = FND_API.G_TRUE
4051: where channel_id = l_channel_id;
4052: ELSE
4053: UPDATE amv_c_channels_b

Line 4053: UPDATE amv_c_channels_b

4049: UPDATE amv_c_channels_b
4050: set match_on_item_type_flag = FND_API.G_TRUE
4051: where channel_id = l_channel_id;
4052: ELSE
4053: UPDATE amv_c_channels_b
4054: set match_on_item_type_flag = FND_API.G_FALSE
4055: where channel_id = l_channel_id;
4056: END IF;
4057:

Line 4060: UPDATE amv_c_channels_b

4056: END IF;
4057:
4058: -- set match on all criteria flag
4059: IF Get_MatchOnStatus(l_channel_id) THEN
4060: UPDATE amv_c_channels_b
4061: set match_on_all_criteria_flag = FND_API.G_TRUE
4062: where channel_id = l_channel_id;
4063: ELSE
4064: UPDATE amv_c_channels_b

Line 4064: UPDATE amv_c_channels_b

4060: UPDATE amv_c_channels_b
4061: set match_on_all_criteria_flag = FND_API.G_TRUE
4062: where channel_id = l_channel_id;
4063: ELSE
4064: UPDATE amv_c_channels_b
4065: set match_on_all_criteria_flag = FND_API.G_FALSE
4066: where channel_id = l_channel_id;
4067: END IF;
4068:

Line 4552: UPDATE amv_c_channels_b

4548: WHERE channel_id = l_channel_id;
4549:
4550: -- set match on flag in channel table
4551: IF p_keywords_array.count > 0 THEN
4552: UPDATE amv_c_channels_b
4553: set match_on_keyword_flag = FND_API.G_TRUE
4554: where channel_id = l_channel_id;
4555: ELSE
4556: UPDATE amv_c_channels_b

Line 4556: UPDATE amv_c_channels_b

4552: UPDATE amv_c_channels_b
4553: set match_on_keyword_flag = FND_API.G_TRUE
4554: where channel_id = l_channel_id;
4555: ELSE
4556: UPDATE amv_c_channels_b
4557: set match_on_keyword_flag = FND_API.G_FALSE
4558: where channel_id = l_channel_id;
4559: END IF;
4560:

Line 4563: UPDATE amv_c_channels_b

4559: END IF;
4560:
4561: -- set match on all criteria flag
4562: IF Get_MatchOnStatus(l_channel_id) THEN
4563: UPDATE amv_c_channels_b
4564: set match_on_all_criteria_flag = FND_API.G_TRUE
4565: where channel_id = l_channel_id;
4566: ELSE
4567: UPDATE amv_c_channels_b

Line 4567: UPDATE amv_c_channels_b

4563: UPDATE amv_c_channels_b
4564: set match_on_all_criteria_flag = FND_API.G_TRUE
4565: where channel_id = l_channel_id;
4566: ELSE
4567: UPDATE amv_c_channels_b
4568: set match_on_all_criteria_flag = FND_API.G_FALSE
4569: where channel_id = l_channel_id;
4570: END IF;
4571:

Line 5055: UPDATE amv_c_channels_b

5051: WHERE channel_id = l_channel_id;
5052:
5053: -- set match on flag in channel table
5054: IF p_authors_array.count > 0 THEN
5055: UPDATE amv_c_channels_b
5056: set match_on_author_flag = FND_API.G_TRUE
5057: where channel_id = l_channel_id;
5058: ELSE
5059: UPDATE amv_c_channels_b

Line 5059: UPDATE amv_c_channels_b

5055: UPDATE amv_c_channels_b
5056: set match_on_author_flag = FND_API.G_TRUE
5057: where channel_id = l_channel_id;
5058: ELSE
5059: UPDATE amv_c_channels_b
5060: set match_on_author_flag = FND_API.G_FALSE
5061: where channel_id = l_channel_id;
5062: END IF;
5063:

Line 5066: UPDATE amv_c_channels_b

5062: END IF;
5063:
5064: -- set match on all criteria flag
5065: IF Get_MatchOnStatus(l_channel_id) THEN
5066: UPDATE amv_c_channels_b
5067: set match_on_all_criteria_flag = FND_API.G_TRUE
5068: where channel_id = l_channel_id;
5069: ELSE
5070: UPDATE amv_c_channels_b

Line 5070: UPDATE amv_c_channels_b

5066: UPDATE amv_c_channels_b
5067: set match_on_all_criteria_flag = FND_API.G_TRUE
5068: where channel_id = l_channel_id;
5069: ELSE
5070: UPDATE amv_c_channels_b
5071: set match_on_all_criteria_flag = FND_API.G_FALSE
5072: where channel_id = l_channel_id;
5073: END IF;
5074:

Line 6052: 'FROM amv_c_channels_b b ' ||

6048: ' b.item_match_count, ' ||
6049: ' b.last_match_time, ' ||
6050: ' b.notification_interval_type, ' ||
6051: ' b.last_notification_time ' ||
6052: 'FROM amv_c_channels_b b ' ||
6053: ', amv_c_channels_tl tl ';
6054: --Construct SQL statement for getting totaL count
6055: l_sql_statement2 := 'Select count(*) ' ||
6056: 'FROM amv_c_channels_b b ' ||

Line 6056: 'FROM amv_c_channels_b b ' ||

6052: 'FROM amv_c_channels_b b ' ||
6053: ', amv_c_channels_tl tl ';
6054: --Construct SQL statement for getting totaL count
6055: l_sql_statement2 := 'Select count(*) ' ||
6056: 'FROM amv_c_channels_b b ' ||
6057: ', amv_c_channels_tl tl ';
6058: --Construct the WHERE clause
6059: IF (p_criteria_rec.channel_id <> FND_API.G_MISS_NUM) THEN
6060: l_where_clause := l_where_clause || l_keyword ||