APPS.CCT_CONCURRENT_PUB dependencies on CCT_MEDIA_ITEMS

Line 129: from cct_media_items a, jtf_ih_media_items b

125: -- dbms_output.put_line('Worker Program Started 2');
126:
127: declare cursor c1 is
128: select a.media_item_id, a.last_update_date, a.status, a.classification, a.attribute1, a.attribute2, b.start_date_time
129: from cct_media_items a, jtf_ih_media_items b
130: where a.media_type <> 1 and a.media_item_id = b.media_id and b.active = 'Y';
131:
132: begin
133: -- fnd_file.put_line(fnd_file.log,'Cursor declared');

Line 257: delete from cct_media_items where media_item_id = c1_rec.media_item_id;

253:
254: -- fnd_file.put_line(fnd_file.log,'Closed mi');
255: -- dbms_output.put_line('Closed mi');
256:
257: delete from cct_media_items where media_item_id = c1_rec.media_item_id;
258:
259: -- fnd_file.put_line(fnd_file.log,'deleted mi');
260: -- dbms_output.put_line('deleted mi');
261: exception

Line 478: (select media_item_id from cct_media_items where media_type <> 1 and status NOT IN (1,2))

474: l_timeout_in_minutes := 60*p_timeout_in_hrs;
475:
476: declare cursor c1 is
477: select media_id, start_date_time from jtf_ih_media_items where active = 'Y' and media_id in
478: (select media_item_id from cct_media_items where media_type <> 1 and status NOT IN (1,2))
479: and start_date_time <= (sysdate - (l_timeout_in_minutes/1440));
480:
481: begin
482: -- fnd_file.put_line(fnd_file.log,'Cursor declared');

Line 525: select classification, attribute1, attribute2 into l_classification, l_attribute1, l_attribute2 from cct_media_items where media_item_id = c1_rec.media_id;

521:
522: -- dbms_output.put_line('Before classify');
523: l_classification := 'unClassified';
524:
525: select classification, attribute1, attribute2 into l_classification, l_attribute1, l_attribute2 from cct_media_items where media_item_id = c1_rec.media_id;
526:
527:
528: -- dbms_output.put_line('After classify');
529:

Line 588: delete from cct_media_items where media_item_id = c1_rec.media_id;

584: ,x_msg_data=>l_msg_data );
585:
586: -- fnd_file.put_line(fnd_file.log,'Closed mi');
587: -- dbms_output.put_line('Closed mi');
588: delete from cct_media_items where media_item_id = c1_rec.media_id;
589: -- fnd_file.put_line(fnd_file.log,'deleted mi');
590: -- dbms_output.put_line('deleted mi');
591:
592: exception

Line 602: -- force delete remainder media items that are in cct_media_items but are inactive in jtf_ih_media_items.

598: end;
599: end;
600: end loop;
601:
602: -- force delete remainder media items that are in cct_media_items but are inactive in jtf_ih_media_items.
603:
604: delete from CCT_MEDIA_ITEMS where
605: media_type <> 1 and status NOT IN (1,2) and creation_date <= (sysdate - (l_timeout_in_minutes/1440)) ;
606:

Line 604: delete from CCT_MEDIA_ITEMS where

600: end loop;
601:
602: -- force delete remainder media items that are in cct_media_items but are inactive in jtf_ih_media_items.
603:
604: delete from CCT_MEDIA_ITEMS where
605: media_type <> 1 and status NOT IN (1,2) and creation_date <= (sysdate - (l_timeout_in_minutes/1440)) ;
606:
607: end;
608: