APPS.BIX_CALL_LOAD_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 762: INTO bix_medias_for_worker

758: --Insert the medias to be processed into the worker table
759: --
760:
761: INSERT /* APPEND */
762: INTO bix_medias_for_worker
763: ( MEDIA_ID
764: ,DIRECTION
765: ,START_DATE_TIME
766: ,END_DATE_TIME

Line 828: --tabName => 'bix_medias_for_worker',

824: --
825: insert_dnis;
826:
827: --DBMS_STATS.gather_table_stats(ownname => g_bix_schema,
828: --tabName => 'bix_medias_for_worker',
829: --cascade => TRUE,
830: --degree => bis_common_parameters.get_degree_of_parallelism,
831: --estimate_percent => 10,
832: --granularity => 'GLOBAL');

Line 837: FROM bix_medias_for_worker;

833:
834: /*
835: SELECT max(ranking)
836: INTO g_no_of_jobs
837: FROM bix_medias_for_worker;
838: */
839:
840: --
841: --Set the worker number correctly

Line 854: --UPDATE bix_medias_for_worker

850: FOR x IN 1 .. g_required_workers LOOP
851:
852: --dbms_output.put_line('Inside loop with x = ' || x );
853:
854: --UPDATE bix_medias_for_worker
855: UPDATE /*+ FULL(work) */ bix_medias_for_worker work
856: SET worker_number = x,
857: status = 'UNASSIGNED'
858: WHERE worker_number = 1

Line 855: UPDATE /*+ FULL(work) */ bix_medias_for_worker work

851:
852: --dbms_output.put_line('Inside loop with x = ' || x );
853:
854: --UPDATE bix_medias_for_worker
855: UPDATE /*+ FULL(work) */ bix_medias_for_worker work
856: SET worker_number = x,
857: status = 'UNASSIGNED'
858: WHERE worker_number = 1
859: AND status = 'NO WORKER DEFINED'

Line 894: --from bix_medias_for_worker;

890: COMMIT;
891:
892: --insert into bixtest
893: --select 'worker number is ' || worker_number
894: --from bix_medias_for_worker;
895: --commit;
896:
897: END IF;
898:

Line 1124: bix_medias_for_worker MED,

1120: --LEFT OUTER JOIN
1121: --JTF_IH_MEDIA_ITM_LC_SEG_TYS SEGTYPES
1122: --ON SEGS.MILCS_TYPE_ID = SEGTYPES.MILCS_TYPE_ID
1123: FROM
1124: bix_medias_for_worker MED,
1125: (select *
1126: from jtf_ih_media_item_lc_segs
1127: where milcs_type_id = 1) IVR_SEGS,
1128: (select *

Line 1171: bix_medias_for_worker WORK,

1167: int.resource_id
1168: order by int.end_date_time DESC NULLS LAST
1169: ) MAX_AGENT_INT_END
1170: FROM
1171: bix_medias_for_worker WORK,
1172: JTF_IH_INTERACTIONS INT LEFT OUTER JOIN JTF_IH_ACTIVITIES ACT
1173: ON INT.interaction_id = ACT.interaction_id
1174: WHERE WORK.MEDIA_ID = nvl(act.media_id,int.productive_time_amount)
1175: AND work.status = 'IN PROCESS'

Line 5512: UPDATE bix_medias_for_worker

5508: SET status = 'IN PROCESS'
5509: WHERE object_name = 'BIX_CALL_DETAILS_F'
5510: AND worker_number = p_worker_no;
5511:
5512: UPDATE bix_medias_for_worker
5513: SET status = 'IN PROCESS'
5514: --worker_number = p_worker_no
5515: WHERE status = 'UNASSIGNED'
5516: AND worker_number = p_worker_no;

Line 5572: UPDATE bix_medias_for_worker

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

Line 5601: UPDATE bix_medias_for_worker

5597: WHERE object_name = 'BIX_CALL_DETAILS_F'
5598: AND status = 'IN PROCESS'
5599: AND worker_number = p_worker_no;
5600:
5601: UPDATE bix_medias_for_worker
5602: SET status = 'FAILED'
5603: WHERE worker_number = p_worker_no
5604: AND status = 'IN PROCESS';
5605:

Line 5677: truncate_table('bix_medias_for_worker');

5673: retcode := 0;
5674:
5675: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIX_CALL_DETAILS_F');
5676:
5677: truncate_table('bix_medias_for_worker');
5678: truncate_table('BIX_CALL_DETAILS_STG');
5679: truncate_table('BIX_CALL_DETAILS_F');
5680:
5681:

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

5950:
5951: END; -- Monitor child process Ends here.
5952:
5953: --
5954: --At this point bix_medias_for_worker is no longer needed. Truncate this
5955: --so that we can save some space.
5956: --
5957: truncate_table('bix_medias_for_worker');
5958:

Line 5957: truncate_table('bix_medias_for_worker');

5953: --
5954: --At this point bix_medias_for_worker is no longer needed. Truncate this
5955: --so that we can save some space.
5956: --
5957: truncate_table('bix_medias_for_worker');
5958:
5959: --ELSE
5960: --
5961: --Collecting only one day - so call insert_half_hour_rows