APPS.OPI_DBI_INV_VALUE_INCR_PKG dependencies on OPI_DBI_INV_VALUE_F

Line 1225: l_debug_msg := 'Inserting data into OPI_DBI_INV_VALUE_F';

1221: END IF;
1222:
1223: l_stmt_num := 10;
1224: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
1225: l_debug_msg := 'Inserting data into OPI_DBI_INV_VALUE_F';
1226: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
1227: END IF;
1228:
1229: MERGE INTO OPI_DBI_INV_VALUE_F base

Line 1229: MERGE INTO OPI_DBI_INV_VALUE_F base

1225: l_debug_msg := 'Inserting data into OPI_DBI_INV_VALUE_F';
1226: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
1227: END IF;
1228:
1229: MERGE INTO OPI_DBI_INV_VALUE_F base
1230: USING
1231: (SELECT /*+ index (rate OPI_DBI_CONVERSION_RATES_N2) */
1232: NULL operating_unit,
1233: s.organization_id,

Line 1423: l_debug_msg := 'Inserted into staging table OPI_DBI_INV_VALUE_F - ' || SQL%ROWCOUNT || ' rows. ';

1419: );
1420:
1421: commit;
1422:
1423: l_debug_msg := 'Inserted into staging table OPI_DBI_INV_VALUE_F - ' || SQL%ROWCOUNT || ' rows. ';
1424: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num,l_debug_msg);
1425:
1426:
1427: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then

Line 1573: if (bis_collection_utilities.setup(p_object_name => 'OPI_DBI_INV_VALUE_F') = false) then

1569: l_debug_msg := 'Start of Incremental Load for Inventory ';
1570: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
1571:
1572: l_stmt_num := 5;
1573: if (bis_collection_utilities.setup(p_object_name => 'OPI_DBI_INV_VALUE_F') = false) then
1574: raise_application_error(-20000,errbuf);
1575: end if;
1576:
1577: l_stmt_num :=10;