307: o_err_msg OUT NOCOPY VARCHAR2
308: );
309:
310: TYPE t_item_id_tbl IS TABLE OF MTL_SYSTEM_ITEMS.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
311: TYPE t_cost_layer_id_tbl IS TABLE OF CST_PAC_ITEM_COSTS.cost_layer_id%TYPE INDEX BY BINARY_INTEGER;
312: TYPE t_qty_layer_id_tbl IS TABLE OF CST_PAC_QUANTITY_LAYERS.quantity_layer_id%TYPE INDEX BY BINARY_INTEGER;
313: TYPE t_cost_element_id_tbl IS TABLE OF CST_COST_ELEMENTS.cost_element_id%TYPE INDEX BY BINARY_INTEGER;
314: TYPE t_level_type_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.level_type%TYPE INDEX BY BINARY_INTEGER;
315: TYPE t_txn_category_tbl IS TABLE OF CST_PAC_PERIOD_BALANCES.txn_category%TYPE INDEX BY BINARY_INTEGER;
318: TYPE t_buy_balance_tbl IS TABLE OF CST_PAC_ITEM_COST_DETAILS.buy_balance%TYPE INDEX BY BINARY_INTEGER;
319:
320: TYPE t_item_index_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
321:
322: TYPE t_item_quantity_tbl IS TABLE OF CST_PAC_ITEM_COSTS.total_layer_quantity%TYPE INDEX BY BINARY_INTEGER;
323: TYPE t_make_quantity_tbl IS TABLE OF CST_PAC_ITEM_COSTS.make_quantity%TYPE INDEX BY BINARY_INTEGER;
324: TYPE t_buy_quantity_tbl IS TABLE OF CST_PAC_ITEM_COSTS.buy_quantity%TYPE INDEX BY BINARY_INTEGER;
325: TYPE t_issue_quantity_tbl IS TABLE OF CST_PAC_ITEM_COSTS.issue_quantity%TYPE INDEX BY BINARY_INTEGER;
326:
319:
320: TYPE t_item_index_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
321:
322: TYPE t_item_quantity_tbl IS TABLE OF CST_PAC_ITEM_COSTS.total_layer_quantity%TYPE INDEX BY BINARY_INTEGER;
323: TYPE t_make_quantity_tbl IS TABLE OF CST_PAC_ITEM_COSTS.make_quantity%TYPE INDEX BY BINARY_INTEGER;
324: TYPE t_buy_quantity_tbl IS TABLE OF CST_PAC_ITEM_COSTS.buy_quantity%TYPE INDEX BY BINARY_INTEGER;
325: TYPE t_issue_quantity_tbl IS TABLE OF CST_PAC_ITEM_COSTS.issue_quantity%TYPE INDEX BY BINARY_INTEGER;
326:
327: l_item_id_tbl t_item_id_tbl;
320: TYPE t_item_index_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
321:
322: TYPE t_item_quantity_tbl IS TABLE OF CST_PAC_ITEM_COSTS.total_layer_quantity%TYPE INDEX BY BINARY_INTEGER;
323: TYPE t_make_quantity_tbl IS TABLE OF CST_PAC_ITEM_COSTS.make_quantity%TYPE INDEX BY BINARY_INTEGER;
324: TYPE t_buy_quantity_tbl IS TABLE OF CST_PAC_ITEM_COSTS.buy_quantity%TYPE INDEX BY BINARY_INTEGER;
325: TYPE t_issue_quantity_tbl IS TABLE OF CST_PAC_ITEM_COSTS.issue_quantity%TYPE INDEX BY BINARY_INTEGER;
326:
327: l_item_id_tbl t_item_id_tbl;
328: l_cost_layer_id_tbl t_cost_layer_id_tbl;
321:
322: TYPE t_item_quantity_tbl IS TABLE OF CST_PAC_ITEM_COSTS.total_layer_quantity%TYPE INDEX BY BINARY_INTEGER;
323: TYPE t_make_quantity_tbl IS TABLE OF CST_PAC_ITEM_COSTS.make_quantity%TYPE INDEX BY BINARY_INTEGER;
324: TYPE t_buy_quantity_tbl IS TABLE OF CST_PAC_ITEM_COSTS.buy_quantity%TYPE INDEX BY BINARY_INTEGER;
325: TYPE t_issue_quantity_tbl IS TABLE OF CST_PAC_ITEM_COSTS.issue_quantity%TYPE INDEX BY BINARY_INTEGER;
326:
327: l_item_id_tbl t_item_id_tbl;
328: l_cost_layer_id_tbl t_cost_layer_id_tbl;
329: l_qty_layer_id_tbl t_qty_layer_id_tbl;