APPS.BIX_SESSION_SUMMARY_PKG dependencies on BIX_WORKER_JOBS

Line 177: Delete BIX_WORKER_JOBS WHERE OBJECT_NAME = 'BIX_AGENT_SESSION_F';

173: g_no_of_jobs := l_count;
174:
175: write_log('Number of workers that need to ne instantiated : ' || to_char(l_count));
176:
177: Delete BIX_WORKER_JOBS WHERE OBJECT_NAME = 'BIX_AGENT_SESSION_F';
178:
179: IF (l_count > 0) THEN
180: l_start_date_range := g_collect_start_date;
181:

Line 196: INSERT INTO BIX_WORKER_JOBS(OBJECT_NAME

192: IF (l_end_date_range > g_collect_end_date) THEN
193: l_end_date_range := g_collect_end_date;
194: END IF;
195:
196: INSERT INTO BIX_WORKER_JOBS(OBJECT_NAME
197: , START_DATE_RANGE
198: , END_DATE_RANGE
199: , WORKER_NUMBER
200: , STATUS)

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

1503: l_count:= 0;
1504:
1505: LOOP
1506:
1507: /* Get the status of all the jobs in BIX_WORKER_JOBS */
1508: SELECT NVL(sum(decode(status,'UNASSIGNED', 1, 0)),0),
1509: NVL(sum(decode(status,'FAILED', 1, 0)),0),
1510: NVL(sum(decode(status,'IN PROCESS', 1, 0)),0),
1511: NVL(sum(decode(status,'COMPLETED',1 , 0)),0),

Line 1518: FROM BIX_WORKER_JOBS

1514: l_failed_cnt,
1515: l_wip_cnt,
1516: l_completed_cnt,
1517: l_total_cnt
1518: FROM BIX_WORKER_JOBS
1519: WHERE object_name = 'BIX_AGENT_SESSION_F';
1520:
1521: write_log('Job status - Unassigned: '||l_unassigned_cnt||
1522: ' In Process: '||l_wip_cnt||

Line 1538: UPDATE BIX_WORKER_JOBS

1534: write_log('All jobs completed, no more job. Terminating');
1535: EXIT;
1536: ELSIF (l_unassigned_cnt > 0) THEN
1537: /* Pickup any one unassigned job to process */
1538: UPDATE BIX_WORKER_JOBS
1539: SET status = 'IN PROCESS',
1540: worker_number = p_worker_no
1541: WHERE status = 'UNASSIGNED'
1542: AND rownum < 2

Line 1565: FROM BIX_WORKER_JOBS

1561:
1562: /* Collect data for half hour time buckets for the date range of the job */
1563: SELECT start_date_range, end_date_range
1564: INTO l_start_date_range, l_end_date_range
1565: FROM BIX_WORKER_JOBS
1566: WHERE worker_number = p_worker_no
1567: AND status = 'IN PROCESS'
1568: AND object_name = 'BIX_AGENT_SESSION_F';
1569:

Line 1577: UPDATE BIX_WORKER_JOBS

1573: collect_day;
1574: write_log('End procedure collect_day');
1575:
1576: /* Update the status of job to 'COMPLETED' */
1577: UPDATE BIX_WORKER_JOBS
1578: SET status = 'COMPLETED'
1579: WHERE status = 'IN PROCESS'
1580: AND worker_number = p_worker_no
1581: AND object_name = 'BIX_AGENT_SESSION_F';

Line 1589: UPDATE BIX_WORKER_JOBS

1585: EXCEPTION
1586: WHEN OTHERS THEN
1587: retcode := -1;
1588:
1589: UPDATE BIX_WORKER_JOBS
1590: SET status = 'FAILED'
1591: WHERE worker_number = p_worker_no
1592: AND status = 'IN PROCESS'
1593: AND object_name = 'BIX_AGENT_SESSION_F';

Line 1768: FROM BIX_WORKER_JOBS

1764: l_completed_cnt,
1765: l_wip_cnt,
1766: l_failed_cnt,
1767: l_tot_cnt
1768: FROM BIX_WORKER_JOBS
1769: WHERE OBJECT_NAME = 'BIX_AGENT_SESSION_F';
1770:
1771: IF (l_failed_cnt > 0) THEN
1772: RAISE G_CHILD_PROCESS_ISSUE;