APPS.IEM_UTILS_PUB dependencies on JTF_IH_MEDIA_ITEM_LC_SEGS

Line 134: from jtf_ih_media_item_lc_segs

130: l_read_count:=0;
131: l_agent_id:=v1.resource_id;
132: FOR v2 in c_new LOOP
133: select max(start_date_time) into l_time
134: from jtf_ih_media_item_lc_segs
135: where media_id=v2.ih_media_item_id;
136: IF l_time <= (sysdate-p_duration/24) THEN
137: l_new_count:=l_new_count+1;
138: END IF;

Line 143: from jtf_ih_media_item_lc_segs

139: END LOOP;
140:
141: FOR v3 in c_read LOOP
142: select max(start_date_time) into l_time
143: from jtf_ih_media_item_lc_segs
144: where media_id=v3.ih_media_item_id;
145: IF l_time <= (sysdate-p_duration/24) THEN
146: l_read_count:=l_read_count+1;
147: END IF;

Line 160: from jtf_ih_media_item_lc_segs

156: l_new_count:=0;
157: l_read_count:=0;
158: FOR v2 in c_new LOOP
159: select max(start_date_time) into l_time
160: from jtf_ih_media_item_lc_segs
161: where media_id=v2.ih_media_item_id;
162: IF l_time <= (sysdate-p_duration/24) THEN
163: l_new_count:=l_new_count+1;
164: END IF;

Line 169: from jtf_ih_media_item_lc_segs

165: END LOOP;
166:
167: FOR v3 in c_read LOOP
168: select max(start_date_time) into l_time
169: from jtf_ih_media_item_lc_segs
170: where media_id=v3.ih_media_item_id;
171: IF l_time <= (sysdate-p_duration/24) THEN
172: l_read_count:=l_read_count+1;
173: END IF;

Line 259: (select media_id from jtf_ih_media_item_lc_segs

255: into l_new_count_1
256: FROM iem_rt_proc_emails a
257: WHERE resource_id=v1.resource_id
258: and a.ih_media_item_id in
259: (select media_id from jtf_ih_media_item_lc_segs
260: WHERE milcs_type_id in (select * from TABLE(cast(i_tbl as jtf_number_table)))
261: AND resource_id=v1.resource_id and (sysdate-start_date_time)*24>=p_duration);
262: IF l_new_count_1>0 THEN
263: x_email_count(l_counter).resource_id:=v1.resource_id;

Line 274: (select distinct media_id from jtf_ih_media_item_lc_segs

270: into l_new_count_1
271: FROM iem_rt_proc_emails
272: WHERE resource_id=p_resource_id
273: and ih_media_item_id in
274: (select distinct media_id from jtf_ih_media_item_lc_segs
275: where milcs_type_id in (select * from TABLE(cast(i_tbl as jtf_number_table)))
276: and resource_id=p_resource_id and (sysdate-start_date_time)*24>=p_duration);
277: x_email_count(l_counter).resource_id:=p_resource_id;
278: x_email_count(l_counter).count:=l_new_count_1;