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_WORKER_JOBS

Line 713: Delete BIX_WORKER_JOBS WHERE OBJECT_NAME = 'BIX_CALL_DETAILS_F';

709: --IF (g_debug_flag = 'Y') THEN
710: --write_log('Number of workers that need to ne instantiated : ' || to_char(l_count));
711: --END IF;
712:
713: Delete BIX_WORKER_JOBS WHERE OBJECT_NAME = 'BIX_CALL_DETAILS_F';
714:
715: --IF (l_count > 0) THEN
716: --l_start_date_range := g_collect_start_date;
717:

Line 732: --INSERT INTO BIX_WORKER_JOBS(OBJECT_NAME,

728: --IF (l_end_date_range > g_collect_end_date) THEN
729: --l_end_date_range := g_collect_end_date;
730: --END IF;
731:
732: --INSERT INTO BIX_WORKER_JOBS(OBJECT_NAME,
733: --START_DATE_RANGE,
734: --END_DATE_RANGE,
735: --WORKER_NUMBER,
736: --STATUS)

Line 862: INSERT INTO BIX_WORKER_JOBS

858:
859: IF SQL%ROWCOUNT > 0
860: THEN
861:
862: INSERT INTO BIX_WORKER_JOBS
863: (
864: OBJECT_NAME,
865: START_DATE_RANGE,
866: END_DATE_RANGE,

Line 5408: /* Get the status of all the jobs in BIX_WORKER_JOBS */

5404: l_count:= 0;
5405:
5406: LOOP
5407:
5408: /* Get the status of all the jobs in BIX_WORKER_JOBS */
5409: --SELECT NVL(sum(decode(status,'UNASSIGNED', 1, 0)),0),
5410: --NVL(sum(decode(status,'FAILED', 1, 0)),0),
5411: --NVL(sum(decode(status,'IN PROCESS', 1, 0)),0),
5412: --NVL(sum(decode(status,'COMPLETED',1 , 0)),0),

Line 5419: --FROM BIX_WORKER_JOBS

5415: --l_failed_cnt,
5416: --l_wip_cnt,
5417: --l_completed_cnt,
5418: --l_total_cnt
5419: --FROM BIX_WORKER_JOBS
5420: --WHERE object_name = 'BIX_CALL_DETAILS_F';
5421:
5422: SELECT NVL(sum(decode(status,'UNASSIGNED', 1, 0)),0),
5423: NVL(sum(decode(status,'FAILED', 1, 0)),0),

Line 5432: FROM BIX_WORKER_JOBS

5428: l_failed_cnt,
5429: l_wip_cnt,
5430: l_completed_cnt,
5431: l_total_cnt
5432: FROM BIX_WORKER_JOBS
5433: WHERE worker_number = p_worker_no
5434: AND object_name = 'BIX_CALL_DETAILS_F';
5435:
5436: --dbms_output.put_line(

Line 5470: --UPDATE BIX_WORKER_JOBS

5466: ELSIF (l_unassigned_cnt > 0) THEN
5467: --dbms_output.put_line('setting to in process for worker ' || p_worker_no);
5468:
5469: /* Pickup any one unassigned job to process */
5470: --UPDATE BIX_WORKER_JOBS
5471: --SET status = 'IN PROCESS',
5472: --worker_number = p_worker_no
5473: --WHERE status = 'UNASSIGNED'
5474: --AND rownum < 2

Line 5477: UPDATE BIX_WORKER_JOBS

5473: --WHERE status = 'UNASSIGNED'
5474: --AND rownum < 2
5475: --AND object_name = 'BIX_CALL_DETAILS_F';
5476:
5477: UPDATE BIX_WORKER_JOBS
5478: SET status = 'IN PROCESS'
5479: WHERE object_name = 'BIX_CALL_DETAILS_F'
5480: AND worker_number = p_worker_no;
5481:

Line 5509: --FROM BIX_WORKER_JOBS

5505: --Collect data for half hour time buckets for the date range of the job
5506: --
5507: --SELECT start_date_range, end_date_range
5508: --INTO l_start_date_range, l_end_date_range
5509: --FROM BIX_WORKER_JOBS
5510: --WHERE worker_number = p_worker_no
5511: --AND status = 'IN PROCESS'
5512: --AND object_name = 'BIX_CALL_DETAILS_F';
5513:

Line 5536: --UPDATE BIX_WORKER_JOBS

5532:
5533: --
5534: -- Update the status of job to 'COMPLETED'
5535: --
5536: --UPDATE BIX_WORKER_JOBS
5537: --SET status = 'COMPLETED'
5538: --WHERE status = 'IN PROCESS'
5539: --AND worker_number = p_worker_no
5540: --AND object_name = 'BIX_CALL_DETAILS_F';

Line 5547: UPDATE BIX_WORKER_JOBS

5543: SET status = 'COMPLETED'
5544: WHERE status = 'IN PROCESS'
5545: AND worker_number = p_worker_no;
5546:
5547: UPDATE BIX_WORKER_JOBS
5548: SET status = 'COMPLETED'
5549: WHERE object_name = 'BIX_CALL_DETAILS_F'
5550: AND status = 'IN PROCESS'
5551: AND worker_number = p_worker_no;

Line 5559: --UPDATE BIX_WORKER_JOBS

5555: EXCEPTION
5556: WHEN OTHERS THEN
5557: retcode := -1;
5558:
5559: --UPDATE BIX_WORKER_JOBS
5560: --SET status = 'FAILED'
5561: --WHERE worker_number = p_worker_no
5562: --AND status = 'IN PROCESS'
5563: --AND object_name = 'BIX_CALL_DETAILS_F';

Line 5565: UPDATE BIX_WORKER_JOBS

5561: --WHERE worker_number = p_worker_no
5562: --AND status = 'IN PROCESS'
5563: --AND object_name = 'BIX_CALL_DETAILS_F';
5564:
5565: UPDATE BIX_WORKER_JOBS
5566: SET status = 'FAILED'
5567: WHERE object_name = 'BIX_CALL_DETAILS_F'
5568: AND status = 'IN PROCESS'
5569: AND worker_number = p_worker_no;

Line 5887: --FROM BIX_WORKER_JOBS

5883: --l_completed_cnt,
5884: --l_wip_cnt,
5885: --l_failed_cnt,
5886: --l_tot_cnt
5887: --FROM BIX_WORKER_JOBS
5888: --WHERE OBJECT_NAME = 'BIX_CALL_DETAILS_F';
5889: SELECT NVL(sum(decode(status,'UNASSIGNED',1,0)),0),
5890: NVL(sum(decode(status,'COMPLETED',1,0)),0),
5891: NVL(sum(decode(status,'IN PROCESS',1,0)),0),

Line 5899: FROM BIX_WORKER_JOBS

5895: l_completed_cnt,
5896: l_wip_cnt,
5897: l_failed_cnt,
5898: l_tot_cnt
5899: FROM BIX_WORKER_JOBS
5900: WHERE object_name = 'BIX_CALL_DETAILS_F';
5901:
5902: --IF (g_debug_flag = 'Y') THEN
5903: --write_log('After worker status select '||