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_LOAD_PKG dependencies on BIX_WORKER_JOBS

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

718: --IF (g_debug_flag = 'Y') THEN
719: --write_log('Number of workers that need to ne instantiated : ' || to_char(l_count));
720: --END IF;
721:
722: Delete BIX_WORKER_JOBS WHERE OBJECT_NAME = 'BIX_CALL_DETAILS_F';
723:
724: --IF (l_count > 0) THEN
725: --l_start_date_range := g_collect_start_date;
726:

Line 741: --INSERT INTO BIX_WORKER_JOBS(OBJECT_NAME,

737: --IF (l_end_date_range > g_collect_end_date) THEN
738: --l_end_date_range := g_collect_end_date;
739: --END IF;
740:
741: --INSERT INTO BIX_WORKER_JOBS(OBJECT_NAME,
742: --START_DATE_RANGE,
743: --END_DATE_RANGE,
744: --WORKER_NUMBER,
745: --STATUS)

Line 869: INSERT INTO BIX_WORKER_JOBS

865:
866: IF SQL%ROWCOUNT > 0
867: THEN
868:
869: INSERT INTO BIX_WORKER_JOBS
870: (
871: OBJECT_NAME,
872: START_DATE_RANGE,
873: END_DATE_RANGE,

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

5434: l_count:= 0;
5435:
5436: LOOP
5437:
5438: /* Get the status of all the jobs in BIX_WORKER_JOBS */
5439: --SELECT NVL(sum(decode(status,'UNASSIGNED', 1, 0)),0),
5440: --NVL(sum(decode(status,'FAILED', 1, 0)),0),
5441: --NVL(sum(decode(status,'IN PROCESS', 1, 0)),0),
5442: --NVL(sum(decode(status,'COMPLETED',1 , 0)),0),

Line 5449: --FROM BIX_WORKER_JOBS

5445: --l_failed_cnt,
5446: --l_wip_cnt,
5447: --l_completed_cnt,
5448: --l_total_cnt
5449: --FROM BIX_WORKER_JOBS
5450: --WHERE object_name = 'BIX_CALL_DETAILS_F';
5451:
5452: SELECT NVL(sum(decode(status,'UNASSIGNED', 1, 0)),0),
5453: NVL(sum(decode(status,'FAILED', 1, 0)),0),

Line 5462: FROM BIX_WORKER_JOBS

5458: l_failed_cnt,
5459: l_wip_cnt,
5460: l_completed_cnt,
5461: l_total_cnt
5462: FROM BIX_WORKER_JOBS
5463: WHERE worker_number = p_worker_no
5464: AND object_name = 'BIX_CALL_DETAILS_F';
5465:
5466: --dbms_output.put_line(

Line 5500: --UPDATE BIX_WORKER_JOBS

5496: ELSIF (l_unassigned_cnt > 0) THEN
5497: --dbms_output.put_line('setting to in process for worker ' || p_worker_no);
5498:
5499: /* Pickup any one unassigned job to process */
5500: --UPDATE BIX_WORKER_JOBS
5501: --SET status = 'IN PROCESS',
5502: --worker_number = p_worker_no
5503: --WHERE status = 'UNASSIGNED'
5504: --AND rownum < 2

Line 5507: UPDATE BIX_WORKER_JOBS

5503: --WHERE status = 'UNASSIGNED'
5504: --AND rownum < 2
5505: --AND object_name = 'BIX_CALL_DETAILS_F';
5506:
5507: UPDATE BIX_WORKER_JOBS
5508: SET status = 'IN PROCESS'
5509: WHERE object_name = 'BIX_CALL_DETAILS_F'
5510: AND worker_number = p_worker_no;
5511:

Line 5539: --FROM BIX_WORKER_JOBS

5535: --Collect data for half hour time buckets for the date range of the job
5536: --
5537: --SELECT start_date_range, end_date_range
5538: --INTO l_start_date_range, l_end_date_range
5539: --FROM BIX_WORKER_JOBS
5540: --WHERE worker_number = p_worker_no
5541: --AND status = 'IN PROCESS'
5542: --AND object_name = 'BIX_CALL_DETAILS_F';
5543:

Line 5566: --UPDATE BIX_WORKER_JOBS

5562:
5563: --
5564: -- Update the status of job to 'COMPLETED'
5565: --
5566: --UPDATE BIX_WORKER_JOBS
5567: --SET status = 'COMPLETED'
5568: --WHERE status = 'IN PROCESS'
5569: --AND worker_number = p_worker_no
5570: --AND object_name = 'BIX_CALL_DETAILS_F';

Line 5577: UPDATE BIX_WORKER_JOBS

5573: SET status = 'COMPLETED'
5574: WHERE status = 'IN PROCESS'
5575: AND worker_number = p_worker_no;
5576:
5577: UPDATE BIX_WORKER_JOBS
5578: SET status = 'COMPLETED'
5579: WHERE object_name = 'BIX_CALL_DETAILS_F'
5580: AND status = 'IN PROCESS'
5581: AND worker_number = p_worker_no;

Line 5589: --UPDATE BIX_WORKER_JOBS

5585: EXCEPTION
5586: WHEN OTHERS THEN
5587: retcode := -1;
5588:
5589: --UPDATE BIX_WORKER_JOBS
5590: --SET status = 'FAILED'
5591: --WHERE worker_number = p_worker_no
5592: --AND status = 'IN PROCESS'
5593: --AND object_name = 'BIX_CALL_DETAILS_F';

Line 5595: UPDATE BIX_WORKER_JOBS

5591: --WHERE worker_number = p_worker_no
5592: --AND status = 'IN PROCESS'
5593: --AND object_name = 'BIX_CALL_DETAILS_F';
5594:
5595: UPDATE BIX_WORKER_JOBS
5596: SET status = 'FAILED'
5597: WHERE object_name = 'BIX_CALL_DETAILS_F'
5598: AND status = 'IN PROCESS'
5599: AND worker_number = p_worker_no;

Line 5896: --FROM BIX_WORKER_JOBS

5892: --l_completed_cnt,
5893: --l_wip_cnt,
5894: --l_failed_cnt,
5895: --l_tot_cnt
5896: --FROM BIX_WORKER_JOBS
5897: --WHERE OBJECT_NAME = 'BIX_CALL_DETAILS_F';
5898: SELECT NVL(sum(decode(status,'UNASSIGNED',1,0)),0),
5899: NVL(sum(decode(status,'COMPLETED',1,0)),0),
5900: NVL(sum(decode(status,'IN PROCESS',1,0)),0),

Line 5908: FROM BIX_WORKER_JOBS

5904: l_completed_cnt,
5905: l_wip_cnt,
5906: l_failed_cnt,
5907: l_tot_cnt
5908: FROM BIX_WORKER_JOBS
5909: WHERE object_name = 'BIX_CALL_DETAILS_F';
5910:
5911: --IF (g_debug_flag = 'Y') THEN
5912: --write_log('After worker status select '||