[Home] [Help]
21:
22: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_RATES';
23: EXECUTE IMMEDIATE l_stmt;
24:
25: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_PO_RATES';
26: EXECUTE IMMEDIATE l_stmt;
27:
28: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_DETAILS';
29: EXECUTE IMMEDIATE l_stmt;
149: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_INC';
150: EXECUTE IMMEDIATE l_stmt;
151: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_RATES';
152: EXECUTE IMMEDIATE l_stmt;
153: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_PO_RATES';
154: EXECUTE IMMEDIATE l_stmt;
155: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_DETAILS';
156: EXECUTE IMMEDIATE l_stmt;
157:
489:
490: COMMIT;
491:
492: if(g_init) then
493: insert /*+ APPEND PARALLEL*/ into poa_dbi_neg_po_rates
494: (
495: txn_cur_code,
496: func_cur_code,
497: rate_date,
582: order by func_cur_code,
583: rate_date );
584:
585: else --not initial load
586: insert /*+ APPEND */ into poa_dbi_neg_po_rates
587: (
588: txn_cur_code,
589: func_cur_code,
590: rate_date,
676: rate_date );
677:
678: end if;
679: COMMIT;
680: -- Gather statistics for poa_dbi_neg_po_rates
681: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema, TABNAME => 'POA_DBI_NEG_PO_RATES') ;
682:
683: --- Create a Negotiations Table that stores all relevant data pertaining to negotiations ---
684: if(g_init) then
677:
678: end if;
679: COMMIT;
680: -- Gather statistics for poa_dbi_neg_po_rates
681: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema, TABNAME => 'POA_DBI_NEG_PO_RATES') ;
682:
683: --- Create a Negotiations Table that stores all relevant data pertaining to negotiations ---
684: if(g_init) then
685: insert /*+ APPEND */ into poa_dbi_neg_details
740: pon_bid_item_prices ponbip,
741: pon_bid_headers ponbh,
742: pon_auction_item_prices_all ponip,
743: pon_auction_headers_all ponh,
744: poa_dbi_neg_po_rates neg_rates,
745: financials_system_params_all pfsp,
746: gl_sets_of_books pgl,
747: mtl_system_items pitem,
748: mtl_units_of_measure uom,
817: pon_bid_item_prices ponbip,
818: pon_bid_headers ponbh,
819: pon_auction_item_prices_all ponip,
820: pon_auction_headers_all ponh,
821: poa_dbi_neg_po_rates neg_rates,
822: financials_system_params_all pfsp,
823: gl_sets_of_books pgl,
824: mtl_system_items pitem,
825: mtl_units_of_measure uom,
896: pon_bid_item_prices ponbip,
897: pon_bid_headers ponbh,
898: pon_auction_item_prices_all ponip,
899: pon_auction_headers_all ponh,
900: poa_dbi_neg_po_rates neg_rates,
901: financials_system_params_all pfsp,
902: gl_sets_of_books pgl,
903: mtl_system_items pitem,
904: mtl_units_of_measure uom,
986: pon_bid_item_prices ponbip,
987: pon_bid_headers ponbh,
988: pon_auction_item_prices_all ponip,
989: pon_auction_headers_all ponh,
990: poa_dbi_neg_po_rates neg_rates,
991: financials_system_params_all pfsp,
992: gl_sets_of_books pgl,
993: mtl_system_items pitem,
994: mtl_units_of_measure uom,
1063: pon_bid_item_prices ponbip,
1064: pon_bid_headers ponbh,
1065: pon_auction_item_prices_all ponip,
1066: pon_auction_headers_all ponh,
1067: poa_dbi_neg_po_rates neg_rates,
1068: financials_system_params_all pfsp,
1069: gl_sets_of_books pgl,
1070: mtl_system_items pitem,
1071: mtl_units_of_measure uom,
1142: pon_bid_item_prices ponbip,
1143: pon_bid_headers ponbh,
1144: pon_auction_item_prices_all ponip,
1145: pon_auction_headers_all ponh,
1146: poa_dbi_neg_po_rates neg_rates,
1147: financials_system_params_all pfsp,
1148: gl_sets_of_books pgl,
1149: mtl_system_items pitem,
1150: mtl_units_of_measure uom,