APPS.ASO_BI_LINE_FACT_PVT dependencies on ASO_BI_QUOTE_FACT_JOBS

Line 112: -- Inserts records into ASO_BI_QUOTE_FACT_JOBS as many as the batches

108: COMMIT;
109: END Populate_Quote_Line_ids;
110:
111:
112: -- Inserts records into ASO_BI_QUOTE_FACT_JOBS as many as the batches
113: PROCEDURE Register_Line_jobs
114: AS
115: BEGIN
116:

Line 117: INSERT INTO ASO_BI_QUOTE_FACT_JOBS

113: PROCEDURE Register_Line_jobs
114: AS
115: BEGIN
116:
117: INSERT INTO ASO_BI_QUOTE_FACT_JOBS
118: ( batch_id,
119: worker_number,
120: status
121: )

Line 128: 'ASO_BI_QUOTE_FACT_JOBS');

124: COMMIT;
125:
126: IF (BIS_COLLECTION_UTILITIES.g_debug) THEN
127: BIS_COLLECTION_UTILITIES.Debug('Inserted '||SQL%ROWCOUNT||' jobs into '||
128: 'ASO_BI_QUOTE_FACT_JOBS');
129: END IF;
130:
131: END Register_Line_jobs;
132:

Line 951: FROM ASO_BI_QUOTE_FACT_JOBS;

947: INTO l_unassigned_cnt,
948: l_failed_cnt,
949: l_comp_cnt,
950: l_total_cnt
951: FROM ASO_BI_QUOTE_FACT_JOBS;
952:
953: IF(l_failed_cnt > 0) Then
954: IF (BIS_COLLECTION_UTILITIES.g_debug) THEN
955: BIS_COLLECTION_UTILITIES.Debug('Another worker have errored out.'||

Line 970: UPDATE ASO_BI_QUOTE_FACT_JOBS

966: BIS_COLLECTION_UTILITIES.Debug('All Jobs completed.Terminating.');
967: END IF;
968: EXIT;
969: Elsif(l_unassigned_cnt > 0) Then
970: UPDATE ASO_BI_QUOTE_FACT_JOBS
971: SET status = 'IN_PROCESS',
972: worker_number = p_worker_no
973: WHERE status = 'UNASSIGNED'
974: AND rownum < 2;

Line 983: FROM ASO_BI_QUOTE_FACT_JOBS

979: If (l_count > 0) Then
980: BEGIN
981: SELECT batch_id
982: INTO l_batch_id
983: FROM ASO_BI_QUOTE_FACT_JOBS
984: WHERE worker_number = p_worker_no
985: AND status = 'IN_PROCESS';
986:
987: IF (BIS_COLLECTION_UTILITIES.g_debug) THEN

Line 999: UPDATE ASO_BI_QUOTE_FACT_JOBS

995: BIS_COLLECTION_UTILITIES.Debug('End populate line Staging:'||
996: TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS'));
997: END IF;
998:
999: UPDATE ASO_BI_QUOTE_FACT_JOBS
1000: SET status = 'COMPLETED'
1001: WHERE status = 'IN_PROCESS'
1002: AND worker_number = p_worker_no;
1003:

Line 1008: UPDATE ASO_BI_QUOTE_FACT_JOBS

1004: COMMIT;
1005: EXCEPTION
1006: WHEN OTHERS Then
1007: retcode := -1;
1008: UPDATE ASO_BI_QUOTE_FACT_JOBS
1009: SET status = 'FAILED'
1010: WHERE worker_number = p_worker_no
1011: AND status = 'IN_PROCESS';
1012: COMMIT;

Line 1022: UPDATE ASO_BI_QUOTE_FACT_JOBS

1018: WHEN OTHERS THEN
1019: retcode := -1;
1020: errbuf := FND_MESSAGE.Get;
1021:
1022: UPDATE ASO_BI_QUOTE_FACT_JOBS
1023: SET status = 'FAILED'
1024: WHERE worker_number = p_worker_no
1025: AND status = 'IN_PROCESS';
1026: COMMIT;