APPS.OKL_SERVICE_INTEGRATION_PVT dependencies on OKL_CONTRACT_LINE_ITEM_PVT

Line 3438: l_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;

3434: l_asset_number VARCHAR2(35);
3435: i NUMBER;
3436: j NUMBER;
3437:
3438: l_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3439: x_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3440:
3441: BEGIN
3442: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 3439: x_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;

3435: i NUMBER;
3436: j NUMBER;
3437:
3438: l_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3439: x_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3440:
3441: BEGIN
3442: IF (G_DEBUG_ENABLED = 'Y') THEN
3443: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

Line 3620: l_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;

3616: FROM okl_la_cov_asset_uv
3617: WHERE serv_top_line_id = p_okl_service_id
3618: AND serial_number_control_code <> 1; -- serial item
3619:
3620: l_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3621: x_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3622: i NUMBER := 0;
3623: l_asset_number okl_la_cov_asset_uv.name%TYPE;
3624: l_id1 okl_la_cov_asset_uv.id1%TYPE;

Line 3621: x_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;

3617: WHERE serv_top_line_id = p_okl_service_id
3618: AND serial_number_control_code <> 1; -- serial item
3619:
3620: l_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3621: x_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3622: i NUMBER := 0;
3623: l_asset_number okl_la_cov_asset_uv.name%TYPE;
3624: l_id1 okl_la_cov_asset_uv.id1%TYPE;
3625: l_id2 okl_la_cov_asset_uv.id2%TYPE;