APPS.INV_TURNS dependencies on INV_TURNS

Line 1: PACKAGE BODY INV_TURNS as

1: PACKAGE BODY INV_TURNS as
2: /* $Header: INVTRNIB.pls 120.2 2006/06/09 09:34:26 srayadur noship $ */
3:
4:
5: PROCEDURE get_1st_onhand (p_organization_id IN NUMBER,

Line 493: INV_TURNS.get_mbi_onhand(mta.organization_id,mta.inventory_item_id,p_last_period_id)

489: -- index hint is added
490:
491: SELECT /*+ leading(mmt) index(mmt mtl_material_transactions_n5) */ MTA.inventory_item_id,
492: SUM(NVL(MTA.base_transaction_value,0)) +
493: INV_TURNS.get_mbi_onhand(mta.organization_id,mta.inventory_item_id,p_last_period_id)
494: BULK COLLECT INTO l_item_id,l_item_onhand
495: FROM MTL_TRANSACTION_ACCOUNTS MTA, MTL_MATERIAL_TRANSACTIONS MMT
496: WHERE (MTA.accounting_line_type = 1
497: OR MTA.accounting_line_type =

Line 1048: inv_turns.closed_tb (closed_periods_rec.organization_id,

1044: FOR closed_periods_rec IN closed_periods
1045: LOOP
1046: IF(closed_periods_rec.primary_cost_method IN (2,5,6))
1047: THEN
1048: inv_turns.closed_tb (closed_periods_rec.organization_id,
1049: closed_periods_rec.acct_period_id,
1050: l_return_status);
1051: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1061: inv_turns.closed_sc (closed_periods_rec.organization_id,

1057: FROM mtl_bis_inv_by_period
1058: WHERE organization_id = closed_periods_rec.organization_id
1059: AND acct_period_id < closed_periods_rec.acct_period_id ;
1060:
1061: inv_turns.closed_sc (closed_periods_rec.organization_id,
1062: closed_periods_rec.acct_period_id,
1063: l_last_period_id,
1064: l_return_status);
1065: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1504: END INV_TURNS;

1500: end;
1501: return l_onhand_qty;
1502: end GET_MBI_ONHAND;
1503: -- End changes 2856158
1504: END INV_TURNS;