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.CCT_CONCURRENT_PUB dependencies on CCT_IH_PUB

Line 168: ,p10_a8=>CCT_IH_PUB.G_IH_CCT_HANDLER_ID -- IN handler id

164: ,p10_a3=>l_milcs_duration -- IN duration
165: ,p10_a4=>l_end_date_time -- IN end date time
166: ,p10_a5=>c2_rec.milcs_id -- IN milcs id
167: ,p10_a7=>c1_rec.media_item_id -- IN media id
168: ,p10_a8=>CCT_IH_PUB.G_IH_CCT_HANDLER_ID -- IN handler id
169: ,x_return_status=>l_return_status
170: ,x_msg_count=>l_msg_count
171: ,x_msg_data=>l_msg_data );
172:

Line 190: and c.milcs_type_id = CCT_IH_PUB.G_IH_LCS_TYPE_WITH_AGENT;

186:
187: select count(*) into l_unclosed_wa_lc_segs from jtf_ih_media_item_lc_segs c
188: where c.end_date_time is null
189: and c.media_id = c1_rec.media_item_id
190: and c.milcs_type_id = CCT_IH_PUB.G_IH_LCS_TYPE_WITH_AGENT;
191:
192: select count(*) into l_total_wa_lc_segs from jtf_ih_media_item_lc_segs c
193: where c.media_id = c1_rec.media_item_id
194: and c.milcs_type_id = CCT_IH_PUB.G_IH_LCS_TYPE_WITH_AGENT;

Line 194: and c.milcs_type_id = CCT_IH_PUB.G_IH_LCS_TYPE_WITH_AGENT;

190: and c.milcs_type_id = CCT_IH_PUB.G_IH_LCS_TYPE_WITH_AGENT;
191:
192: select count(*) into l_total_wa_lc_segs from jtf_ih_media_item_lc_segs c
193: where c.media_id = c1_rec.media_item_id
194: and c.milcs_type_id = CCT_IH_PUB.G_IH_LCS_TYPE_WITH_AGENT;
195:
196: if ((l_unclosed_wa_lc_segs > 0 ) or (l_total_wa_lc_segs = 0)) then raise no_data_found_ex;
197: end if;
198:

Line 200: where c.media_id = c1_rec.media_item_id and c.milcs_type_id = CCT_IH_PUB.G_IH_LCS_TYPE_WITH_AGENT;

196: if ((l_unclosed_wa_lc_segs > 0 ) or (l_total_wa_lc_segs = 0)) then raise no_data_found_ex;
197: end if;
198:
199: select max(c.end_date_time) into l_end_date_time from jtf_ih_media_item_lc_segs c
200: where c.media_id = c1_rec.media_item_id and c.milcs_type_id = CCT_IH_PUB.G_IH_LCS_TYPE_WITH_AGENT;
201:
202: -- if sql%notfound then raise no_data_found_ex;
203: -- end if;
204: if l_end_date_time is null then raise no_data_found_ex;

Line 208: where c.media_id = c1_rec.media_item_id and c.milcs_type_id = CCT_IH_PUB.G_IH_LCS_TYPE_WITH_AGENT;

204: if l_end_date_time is null then raise no_data_found_ex;
205: end if;
206:
207: select max(c.start_date_time) into l_start_date_time from jtf_ih_media_item_lc_segs c
208: where c.media_id = c1_rec.media_item_id and c.milcs_type_id = CCT_IH_PUB.G_IH_LCS_TYPE_WITH_AGENT;
209:
210: l_in_queue_start_date_time := null;
211:
212: select max(c.start_date_time) into l_in_queue_start_date_time from jtf_ih_media_item_lc_segs c

Line 213: where c.media_id = c1_rec.media_item_id and c.milcs_type_id = CCT_IH_PUB.G_IH_LCS_TYPE_IN_QUEUE;

209:
210: l_in_queue_start_date_time := null;
211:
212: select max(c.start_date_time) into l_in_queue_start_date_time from jtf_ih_media_item_lc_segs c
213: where c.media_id = c1_rec.media_item_id and c.milcs_type_id = CCT_IH_PUB.G_IH_LCS_TYPE_IN_QUEUE;
214:
215: -- if sql%notfound then null;
216: -- end if;
217: if (l_in_queue_start_date_time is not null) and

Line 553: ,p10_a8=>CCT_IH_PUB.G_IH_CCT_HANDLER_ID -- IN handler id

549: ,p10_a3=>l_milcs_duration -- IN duration
550: ,p10_a4=>l_end_date_time -- IN end date time
551: ,p10_a5=>c2_rec.milcs_id -- IN milcs id
552: ,p10_a7=>c1_rec.media_id -- IN media id
553: ,p10_a8=>CCT_IH_PUB.G_IH_CCT_HANDLER_ID -- IN handler id
554: ,x_return_status=>l_return_status
555: ,x_msg_count=>l_msg_count
556: ,x_msg_data=>l_msg_data );
557: