API CST_Inventory_PUB.Calculate_InventoryValue

Hi guys

We were able to execute the API CST_Inventory_PUB.Calculate_InventoryValue successfully, however couldn't retrive any rows from following tables

    cst_inv_qty_temp

    cst_inv_cost_temp

Which we believe, are populated for the session once the API is executed. We obtained the API call from "Inventory Value Report - by Subinventory" concurrent program, which provides rollback dated inventory values...

The sample API script is as following

SET SERVEROUTPUT ON;

Declare

L_FCN_CURRENCY VARCHAR2(15);

L_REPORT_NAME VARCHAR2(80);

sql_stmt_num varchar2(5);

l_exp_sub NUMBER;

l_msg_count NUMBER;

l_msg_data VARCHAR2(8000);

l_return_status VARCHAR2(1);