140: x_msg_data OUT NOCOPY VARCHAR2) IS
141:
142: l_program_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'create_update_link_assets';
143:
144: l_create_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
145: l_update_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
146: lx_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
147:
148: l_link_asset_tbl link_asset_tbl_type;
141:
142: l_program_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'create_update_link_assets';
143:
144: l_create_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
145: l_update_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
146: lx_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
147:
148: l_link_asset_tbl link_asset_tbl_type;
149:
142: l_program_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'create_update_link_assets';
143:
144: l_create_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
145: l_update_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
146: lx_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
147:
148: l_link_asset_tbl link_asset_tbl_type;
149:
150: k BINARY_INTEGER := 1; -- create table index
354: END LOOP;
355:
356: IF l_create_line_item_tbl.COUNT > 0 THEN
357:
358: okl_contract_line_item_pvt.create_contract_line_item( p_api_version => G_API_VERSION,
359: p_init_msg_list => G_FALSE,
360: x_return_status => lx_return_status,
361: x_msg_count => x_msg_count,
362: x_msg_data => x_msg_data,
372: END IF;
373:
374: IF l_update_line_item_tbl.COUNT > 0 THEN
375:
376: okl_contract_line_item_pvt.update_contract_line_item( p_api_version => G_API_VERSION,
377: p_init_msg_list => G_FALSE,
378: x_return_status => lx_return_status,
379: x_msg_count => x_msg_count,
380: x_msg_data => x_msg_data,