APPS.ASO_BI_QUOTE_FACT_PVT dependencies on ASO_BI_QUOTE_FACT_JOBS

Line 117: Insert Into ASO_BI_QUOTE_FACT_JOBS(batch_id,worker_number,status)

113:
114: Procedure Register_jobs
115: As
116: Begin
117: Insert Into ASO_BI_QUOTE_FACT_JOBS(batch_id,worker_number,status)
118: SELECT DISTINCT batch_id,0,'UNASSIGNED'
119: FROM ASO_BI_QUOTE_IDS ;
120: COMMIT;
121:

Line 123: BIS_COLLECTION_UTILITIES.Debug('Inserted '||SQL%ROWCOUNT||' jobs into '||'ASO_BI_QUOTE_FACT_JOBS');

119: FROM ASO_BI_QUOTE_IDS ;
120: COMMIT;
121:
122: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
123: BIS_COLLECTION_UTILITIES.Debug('Inserted '||SQL%ROWCOUNT||' jobs into '||'ASO_BI_QUOTE_FACT_JOBS');
124: END IF;
125:
126: End Register_jobs;
127:

Line 538: FROM ASO_BI_QUOTE_FACT_JOBS;

534: INTO l_unassigned_cnt,
535: l_failed_cnt,
536: l_comp_cnt,
537: l_total_cnt
538: FROM ASO_BI_QUOTE_FACT_JOBS;
539:
540: IF(l_failed_cnt > 0) Then
541: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
542: BIS_COLLECTION_UTILITIES.Debug('Another worker have errored out.Stop Processing.');

Line 556: UPDATE ASO_BI_QUOTE_FACT_JOBS

552: BIS_COLLECTION_UTILITIES.Debug('All Jobs completed.Terminating.');
553: END IF;
554: EXIT;
555: Elsif(l_unassigned_cnt > 0) Then
556: UPDATE ASO_BI_QUOTE_FACT_JOBS
557: SET status = 'IN_PROCESS',
558: worker_number = p_worker_no
559: WHERE status = 'UNASSIGNED'
560: AND rownum < 2;

Line 569: FROM ASO_BI_QUOTE_FACT_JOBS

565: If (l_count > 0) Then
566: BEGIN
567: SELECT batch_id
568: INTO l_batch_id
569: FROM ASO_BI_QUOTE_FACT_JOBS
570: WHERE worker_number = p_worker_no
571: AND status = 'IN_PROCESS';
572:
573: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

Line 583: UPDATE ASO_BI_QUOTE_FACT_JOBS

579: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
580: BIS_COLLECTION_UTILITIES.Debug('End populate Staging:'||TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS'));
581: END IF;
582:
583: UPDATE ASO_BI_QUOTE_FACT_JOBS
584: SET status = 'COMPLETED'
585: WHERE status = 'IN_PROCESS'
586: AND worker_number = p_worker_no;
587:

Line 592: UPDATE ASO_BI_QUOTE_FACT_JOBS

588: COMMIT;
589: EXCEPTION
590: WHEN OTHERS Then
591: retcode := -1;
592: UPDATE ASO_BI_QUOTE_FACT_JOBS
593: SET status = 'FAILED'
594: WHERE worker_number = p_worker_no
595: AND status = 'IN_PROCESS';
596: COMMIT;

Line 606: UPDATE ASO_BI_QUOTE_FACT_JOBS

602: WHEN OTHERS THEN
603: retcode := -1;
604: errbuf := FND_MESSAGE.Get;
605:
606: UPDATE ASO_BI_QUOTE_FACT_JOBS
607: SET status = 'FAILED'
608: WHERE worker_number = p_worker_no
609: AND status = 'IN_PROCESS';
610: COMMIT;