36: -- ---->> GET_ONHAND_ACTIVITY
37: -- ---->> GET_INTRANSIT_ACTIVITY
38: -- ---->> GET_WIP_ACTIVITY
39: --
40: -- ---> OPI_DBI_INV_VALUE_UTL_PKG.Get_Conversion_Rate
41: -- ---> MERGE_INTO_SUMMARY
42: -- ---> CLEAN_STAGING_TABLE
43: --
44: -- --> OPI_DBI_INV_CPCS_PKG.RUN_PERIOD_CLOSE_ADJUSTMENT
1505: END IF;
1506:
1507: -- this api prints the report in case there are conversion rates missing.
1508: -- it returns -1 in case there are missing conversion rates as well.
1509: IF (OPI_DBI_INV_VALUE_UTL_PKG.Get_Conversion_Rate(errbuf, retcode) = -1) THEN
1510: OPI_DBI_BOUNDS_PKG.write (g_pkg_name, l_proc_name,l_stmt_num,'Missing currency rate.');
1511: RAISE OPI_DBI_EXCEPTION;
1512: END IF;
1513: COMMIT;