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.BIX_CALL_UPDATE_PKG dependencies on BIX_MEDIAS_FOR_WORKER

Line 145: FROM BIX_MEDIAS_FOR_WORKER WORK

141: SELECT BIX_DM_DNIS_S.NEXTVAL, DNIS, g_sysdate, g_user_id, g_sysdate
142: FROM
143: (
144: SELECT DISTINCT decode(DIRECTION, 'OUTBOUND', 'OUTBOUND', DNIS) DNIS
145: FROM BIX_MEDIAS_FOR_WORKER WORK
146: WHERE NOT EXISTS
147: (SELECT 1
148: FROM BIX_DM_DNIS DNIS
149: WHERE WORK.DNIS = DNIS.DNIS

Line 753: INTO bix_medias_for_worker

749: --Insert the medias to be processed into the worker table
750: --
751:
752: INSERT /* APPEND */
753: INTO bix_medias_for_worker
754: ( MEDIA_ID
755: ,DIRECTION
756: ,START_DATE_TIME
757: ,END_DATE_TIME

Line 814: tabName => 'bix_medias_for_worker',

810:
811: COMMIT;
812:
813: DBMS_STATS.gather_table_stats(ownname => g_bix_schema,
814: tabName => 'bix_medias_for_worker',
815: cascade => TRUE,
816: degree => bis_common_parameters.get_degree_of_parallelism,
817: estimate_percent => 10,
818: granularity => 'GLOBAL');

Line 825: --execute immediate 'analyze index bix.bix_medias_for_worker_n1 compute statistics';

821: --Insert the missing DNIS values
822: --
823: insert_dnis;
824:
825: --execute immediate 'analyze index bix.bix_medias_for_worker_n1 compute statistics';
826:
827: /*
828: SELECT max(ranking)
829: INTO g_no_of_jobs

Line 830: FROM bix_medias_for_worker;

826:
827: /*
828: SELECT max(ranking)
829: INTO g_no_of_jobs
830: FROM bix_medias_for_worker;
831: */
832:
833: --
834: --Set the worker number correctly

Line 847: --UPDATE bix_medias_for_worker

843: FOR x IN 1 .. g_required_workers LOOP
844:
845: --dbms_output.put_line('Inside loop with x = ' || x );
846:
847: --UPDATE bix_medias_for_worker
848: UPDATE bix_medias_for_worker
849: SET worker_number = x,
850: status = 'UNASSIGNED'
851: WHERE worker_number = 1

Line 848: UPDATE bix_medias_for_worker

844:
845: --dbms_output.put_line('Inside loop with x = ' || x );
846:
847: --UPDATE bix_medias_for_worker
848: UPDATE bix_medias_for_worker
849: SET worker_number = x,
850: status = 'UNASSIGNED'
851: WHERE worker_number = 1
852: AND status = 'NO WORKER DEFINED'

Line 887: --from bix_medias_for_worker;

883: COMMIT;
884:
885: --insert into bixtest
886: --select 'worker number is ' || worker_number
887: --from bix_medias_for_worker;
888: --commit;
889:
890: END IF;
891:

Line 1116: bix_medias_for_worker MED,

1112: --LEFT OUTER JOIN
1113: --JTF_IH_MEDIA_ITM_LC_SEG_TYS SEGTYPES
1114: --ON SEGS.MILCS_TYPE_ID = SEGTYPES.MILCS_TYPE_ID
1115: FROM
1116: bix_medias_for_worker MED,
1117: (select *
1118: from jtf_ih_media_item_lc_segs
1119: where milcs_type_id = 1) IVR_SEGS,
1120: (select *

Line 1195: BIX_MEDIAS_FOR_WORKER WORK,

1191: order by int.end_date_time DESC NULLS LAST
1192: ) MAX_AGENT_INT_END
1193: FROM
1194: --JTF_IH_MEDIA_ITEMS MED,
1195: BIX_MEDIAS_FOR_WORKER WORK,
1196: JTF_IH_INTERACTIONS INT LEFT OUTER JOIN JTF_IH_ACTIVITIES ACT
1197: ON INT.interaction_id = ACT.interaction_id
1198: --WHERE MED.last_update_date BETWEEN p_collect_start_date
1199: --AND p_collect_end_date

Line 1241: BIX_MEDIAS_FOR_WORKER WORK,

1237: order by int.end_date_time DESC NULLS LAST
1238: ) MAX_AGENT_INT_END
1239: FROM
1240: --JTF_IH_MEDIA_ITEMS MED,
1241: BIX_MEDIAS_FOR_WORKER WORK,
1242: JTF_IH_INTERACTIONS INT, JTF_IH_ACTIVITIES ACT
1243: --WHERE MED.last_update_date BETWEEN p_collect_start_date
1244: --AND p_collect_end_date
1245: --AND MED.active = 'N'

Line 5482: UPDATE bix_medias_for_worker

5478: SET status = 'IN PROCESS'
5479: WHERE object_name = 'BIX_CALL_DETAILS_F'
5480: AND worker_number = p_worker_no;
5481:
5482: UPDATE bix_medias_for_worker
5483: SET status = 'IN PROCESS'
5484: --worker_number = p_worker_no
5485: WHERE status = 'UNASSIGNED'
5486: AND worker_number = p_worker_no;

Line 5542: UPDATE bix_medias_for_worker

5538: --WHERE status = 'IN PROCESS'
5539: --AND worker_number = p_worker_no
5540: --AND object_name = 'BIX_CALL_DETAILS_F';
5541:
5542: UPDATE bix_medias_for_worker
5543: SET status = 'COMPLETED'
5544: WHERE status = 'IN PROCESS'
5545: AND worker_number = p_worker_no;
5546:

Line 5571: UPDATE bix_medias_for_worker

5567: WHERE object_name = 'BIX_CALL_DETAILS_F'
5568: AND status = 'IN PROCESS'
5569: AND worker_number = p_worker_no;
5570:
5571: UPDATE bix_medias_for_worker
5572: SET status = 'FAILED'
5573: WHERE worker_number = p_worker_no
5574: AND status = 'IN PROCESS';
5575:

Line 5645: truncate_table('bix_medias_for_worker');

5641:
5642: errbuf := null;
5643: retcode := 0;
5644:
5645: truncate_table('bix_medias_for_worker');
5646:
5647: truncate_table('BIX_CALL_DETAILS_STG');
5648: --truncate_table('BIX_CALL_PROCESSED_RECS');
5649:

Line 5945: --At this point bix_medias_for_worker is no longer needed. Truncate this

5941:
5942: END; -- Monitor child process Ends here.
5943:
5944: --
5945: --At this point bix_medias_for_worker is no longer needed. Truncate this
5946: --so that we can save some space.
5947: --
5948: truncate_table('bix_medias_for_worker');
5949:

Line 5948: truncate_table('bix_medias_for_worker');

5944: --
5945: --At this point bix_medias_for_worker is no longer needed. Truncate this
5946: --so that we can save some space.
5947: --
5948: truncate_table('bix_medias_for_worker');
5949:
5950: --ELSE
5951: --
5952: --Collecting only one day - so call insert_half_hour_rows