[Home] [Help]
16: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN
17: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_REQ_F';
18: EXECUTE immediate l_stmt;
19:
20: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_REQ_INC';
21: EXECUTE immediate l_stmt;
22:
23: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_REQ_RATES';
24: EXECUTE immediate l_stmt;
75: rpad(rln.line_num,5) line_num,
76: pod.req_distribution_id,
77: rln.requisition_line_id
78: from
79: poa_dbi_req_inc inc,
80: po_requisition_headers_all rhr,
81: po_requisition_lines_all rln,
82: po_req_distributions_all rdn,
83: po_distributions_all pod,
166: END IF;
167:
168: bis_collection_utilities.log('Truncate Currency Conversion table: '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
169: IF (fnd_installation.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN
170: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_REQ_INC';
171: EXECUTE IMMEDIATE l_stmt;
172:
173: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_REQ_RATES';
174: EXECUTE IMMEDIATE l_stmt;
180: d_glob_date := bis_common_parameters.get_global_start_date;
181:
182:
183: IF (g_init) THEN
184: INSERT /*+ append parallel(poa_dbi_req_inc) */ INTO poa_dbi_req_inc
185: (
186: primary_key,
187: line_location_id,
188: batch_id,
257: */
258:
259: commit;
260:
261: /* After collection of poa_dbi_req_inc, run a check for corrupt data.
262: ** If corrupt data is found, print details in request output and
263: ** set the request to complete with warning.
264: */
265:
293: bis_collection_utilities.log('please contact Oracle Support.',0);
294: bis_collection_utilities.log('-------------------------------------------------------------------------------------', 0);
295:
296: for i in 1..corrupt_rec_table.count loop
297: delete from poa_dbi_req_inc where primary_key = corrupt_rec_table(i).requisition_line_id;
298: end loop;
299: commit;
300: l_ret_variable := fnd_concurrent.set_interim_status(
301: status => 'WARNING',
302: message => 'Bad data found in PO tables.'
303: );
304: end if;
305: ELSE -- not initial load
306: INSERT /*+ APPEND */ INTO poa_dbi_req_inc
307: (
308: primary_key,
309: line_location_id,
310: batch_id,
602: COMMIT;
603: dbms_application_info.set_action('stats incremental');
604:
605: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN
606: fnd_stats.gather_table_stats(ownname => l_poa_schema, tabname => 'POA_DBI_REQ_INC') ;
607: END IF;
608:
609: INSERT /*+ APPEND */ INTO poa_dbi_req_rates
610: (
640: txn_cur_code,
641: func_cur_code,
642: rate_date
643: from
644: poa_dbi_req_inc
645: order by func_cur_code, rate_date
646: );
647:
648:
654: tabname => 'POA_DBI_REQ_RATES') ;
655: END IF;
656:
657: bis_collection_utilities.log('Populate base table: '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
658: select max(batch_id), COUNT(1) into l_no_batch, l_count from poa_dbi_req_inc;
659: bis_collection_utilities.log('Identified '|| l_count ||' changed records. Batch size='|| l_batch_size || '. # of Batches=' || l_no_batch
660: || '. Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
661:
662:
964: )
965: )
966: ) base_uom_conv_rate
967: FROM
968: poa_dbi_req_inc inc,
969: poa_dbi_req_rates rat,
970: po_requisition_lines_all rln,
971: po_req_distributions_all rdn,
972: po_headers_all poh,
1419: )
1420: )
1421: ) base_uom_conv_rate
1422: FROM
1423: poa_dbi_req_inc inc,
1424: poa_dbi_req_rates rat,
1425: po_requisition_lines_all rln,
1426: po_req_distributions_all rdn,
1427: po_headers_all poh,