APPS.OPI_DBI_REP_UOM_STD_CONV_PKG dependencies on OPI_DBI_REP_UOM_STD_CONV_F

Line 548: 1. OPI_DBI_REP_UOM_STD_CONV_F

544:
545: Cleans up tables prior to the initial load run.
546:
547: Truncates:
548: 1. OPI_DBI_REP_UOM_STD_CONV_F
549: 2. OPI_DBI_REP_UOM_CONV_STG
550:
551: Deletes:
552: 1. Rows from OPI_DBI_CONC_PROG_RUN_LOG where row type = REP_UOM.

Line 578: 'OPI_DBI_REP_UOM_STD_CONV_F');

574:
575: l_stmt_id := 10;
576: -- Truncate the fact table
577: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
578: 'OPI_DBI_REP_UOM_STD_CONV_F');
579:
580: l_stmt_id := 20;
581: -- Truncate the staging table
582: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||

Line 644: before querying from OPI_DBI_REP_UOM_STD_CONV_F.

640: No commits done here. Calling function coordinates commit.
641:
642: Using an append hint on the insert since this function is designed
643: to be used after initial loads. Expect to commit after this function
644: before querying from OPI_DBI_REP_UOM_STD_CONV_F.
645:
646: No commits done here. Calling function coordinates commit.
647:
648: Parameters:

Line 673: INTO opi_dbi_rep_uom_std_conv_f (

669: -- Insert all standard rates where from UOM/reporting UOM combination
670: -- is not in in the fact table.
671: -- Standard rates have an item id of 0;
672: INSERT /*+ append */
673: INTO opi_dbi_rep_uom_std_conv_f (
674: from_uom_code,
675: from_uom_class,
676: rep_uom_code,
677: rep_uom_class,

Line 1004: MERGE INTO opi_dbi_rep_uom_std_conv_f base

1000: -- If a combination exists and the rate is different in
1001: -- the fact and the staging table, the fact needs to be updated.
1002: -- If the combination and conversion rate in the fact and
1003: -- and the staging table is the same, the record should not be changed.
1004: MERGE INTO opi_dbi_rep_uom_std_conv_f base
1005: USING
1006: (SELECT
1007: from_uom_code,
1008: from_uom_class,