APPS.POA_SUPPERF_POPULATE_PKG dependencies on POA_BIS_SUPPLIER_PERFORMANCE

Line 7: * insert into poa_bis_supplier_performance. The data is only extracted if

3:
4: /* populate_fact_table
5: * -------------------
6: * Main procedure to extract neccessary facts from po base tables and
7: * insert into poa_bis_supplier_performance. The data is only extracted if
8: * the last_update_date of po_line_locations_all is between the date
9: * parameters.
10: * Delete the corresponding record in the fact table before inserting
11: * the updated one.

Line 352: DELETE FROM poa_bis_supplier_performance

348: x_progress VARCHAR2(3);
349: BEGIN
350: x_progress := '001';
351:
352: DELETE FROM poa_bis_supplier_performance
353: WHERE po_shipment_id = p_line_location_id;
354:
355: EXCEPTION
356: WHEN OTHERS THEN

Line 416: INSERT INTO poa_bis_supplier_performance (

412: x_progress VARCHAR2(3);
413: BEGIN
414: x_progress := '001';
415:
416: INSERT INTO poa_bis_supplier_performance (
417: PO_SHIPMENT_ID ,
418: SHIP_TO_LOCATION_ID ,
419: SHIP_TO_ORGANIZATION_ID ,
420: ORG_ID ,