DBA Data[Home] [Help]

APPS.OKL_AM_REMARKET_ASSET_PVT dependencies on INV_ITEM_GRP

Line 55: SUBTYPE item_rec_type IS inv_item_grp.item_rec_type;

51: , x_Return_Status OUT NOCOPY VARCHAR2
52: )
53: IS
54:
55: SUBTYPE item_rec_type IS inv_item_grp.item_rec_type;
56: SUBTYPE error_tbl_type IS inv_item_grp.error_tbl_type;
57:
58: -- sequence for item_number
59: CURSOR l_seqnextval_csr IS

Line 56: SUBTYPE error_tbl_type IS inv_item_grp.error_tbl_type;

52: )
53: IS
54:
55: SUBTYPE item_rec_type IS inv_item_grp.item_rec_type;
56: SUBTYPE error_tbl_type IS inv_item_grp.error_tbl_type;
57:
58: -- sequence for item_number
59: CURSOR l_seqnextval_csr IS
60: SELECT OKL_IMR_SEQ.NEXTVAL

Line 187: 'before INV_Item_GRP.create_item call sts'||x_return_status);

183: l_commit := okl_api.g_FALSE;
184:
185: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
186: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_AM_REMARKET_ASSET_PVT.create_inv_item.',
187: 'before INV_Item_GRP.create_item call sts'||x_return_status);
188: END IF;
189:
190: INV_Item_GRP.create_item
191: (

Line 190: INV_Item_GRP.create_item

186: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_AM_REMARKET_ASSET_PVT.create_inv_item.',
187: 'before INV_Item_GRP.create_item call sts'||x_return_status);
188: END IF;
189:
190: INV_Item_GRP.create_item
191: (
192: p_commit => l_commit
193: , p_validation_level => l_validation_level
194: , p_Item_rec => l_Item_rec

Line 202: 'after INV_Item_GRP.create_item call sts'||x_return_status);

198: );
199:
200: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
201: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_AM_REMARKET_ASSET_PVT.create_inv_item.',
202: 'after INV_Item_GRP.create_item call sts'||x_return_status);
203: END IF;
204:
205: IF ( x_return_status = okl_api.G_RET_STS_SUCCESS ) THEN
206: x_New_Item_Number := x_item_rec.ITEM_NUMBER;

Line 1642: l_Item_rec INV_Item_GRP.Item_rec_type;

1638: p_org_id IN NUMBER,
1639: p_sysdate IN DATE,
1640: x_return_status OUT NOCOPY VARCHAR2)
1641: IS
1642: l_Item_rec INV_Item_GRP.Item_rec_type;
1643: x_Item_rec INV_Item_GRP.Item_rec_type;
1644: l_commit VARCHAR2(1);
1645: l_validation_level NUMBER;
1646: l_return_status VARCHAR2(1);

Line 1643: x_Item_rec INV_Item_GRP.Item_rec_type;

1639: p_sysdate IN DATE,
1640: x_return_status OUT NOCOPY VARCHAR2)
1641: IS
1642: l_Item_rec INV_Item_GRP.Item_rec_type;
1643: x_Item_rec INV_Item_GRP.Item_rec_type;
1644: l_commit VARCHAR2(1);
1645: l_validation_level NUMBER;
1646: l_return_status VARCHAR2(1);
1647: x_Error_tbl INV_Item_GRP.Error_tbl_type;

Line 1647: x_Error_tbl INV_Item_GRP.Error_tbl_type;

1643: x_Item_rec INV_Item_GRP.Item_rec_type;
1644: l_commit VARCHAR2(1);
1645: l_validation_level NUMBER;
1646: l_return_status VARCHAR2(1);
1647: x_Error_tbl INV_Item_GRP.Error_tbl_type;
1648:
1649: l_lock_rows VARCHAR2(20) := fnd_api.g_TRUE;
1650:
1651: BEGIN

Line 1662: INV_Item_GRP.update_item

1658:
1659:
1660: l_commit := OKC_API.g_FALSE;
1661:
1662: INV_Item_GRP.update_item
1663: (
1664: p_commit => l_commit,
1665: p_lock_rows => l_lock_rows
1666: , p_validation_level => l_validation_level