DBA Data[Home] [Help]

APPS.OPI_DBI_INV_VALUE_INCR_PKG dependencies on OPI_DBI_INV_VALUE_UTL_PKG

Line 40: -- ---> OPI_DBI_INV_VALUE_UTL_PKG.Get_Conversion_Rate

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

Line 1509: IF (OPI_DBI_INV_VALUE_UTL_PKG.Get_Conversion_Rate(errbuf, retcode) = -1) THEN

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;