[Home] [Help]
5359: x_msg_count OUT NOCOPY NUMBER,
5360: x_msg_data OUT NOCOPY VARCHAR2,
5361: p_chr_id IN okc_k_headers_v.id%TYPE,
5362: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
5363: p_cle_id IN okl_k_lines_v.id%TYPE,
5364: p_line_number IN okc_k_lines_v.line_number%TYPE,
5365: p_line_type IN okl_lines_interface.line_type%TYPE,
5366: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5367: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5874: x_msg_count OUT NOCOPY NUMBER,
5875: x_msg_data OUT NOCOPY VARCHAR2,
5876: p_chr_id IN okc_k_headers_v.id%TYPE,
5877: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
5878: p_cle_id IN okl_k_lines_v.id%TYPE,
5879: p_line_number IN okc_k_lines_v.line_number%TYPE,
5880: p_line_type IN okl_lines_interface.line_type%TYPE,
5881: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5882: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
23539: CURSOR assoc_csr (p_usage_item_id NUMBER,
23540: p_asset_line_id NUMBER) IS
23541: SELECT 'Y'
23542: FROM okc_k_items_v item,
23543: okl_k_lines_full_v model,
23544: okc_line_styles_v style,
23545: cs_counters cc,
23546: cs_ctr_associations assoc
23547: WHERE model.lse_id = style.id
23952: p_inv_item_id_prev IN okl_lines_interface.inventory_item_id%TYPE,
23953: p_term_quote_id IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_ID%TYPE,
23954: p_term_quote_number IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_NUMBER%TYPE,
23955: x_inv_item_id_prev OUT NOCOPY okl_lines_interface.inventory_item_id%TYPE,
23956: p_cle_id IN okl_k_lines_v.id%TYPE,
23957: x_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE,
23958: x_sub_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE, -- Bug# 3110115
23959: p_new_line_flag IN okl_lines_interface.explicit_new_line_flag%TYPE,
23960: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
23985: x_clev_rec clev_rec_type;
23986:
23987: l_klev_rec klev_rec_type;
23988: l_clev_rec clev_rec_type;
23989: l_capital_amount okl_k_lines.capital_amount%type;
23990:
23991: p_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
23992: x_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
23993:
24006: FROM okl_party_roles_interface
24007: WHERE contract_number_old = p_contract_number
24008: AND line_number = p_line_number;
24009:
24010: CURSOR capital_amount(p_line_id OKL_K_LINES.ID%TYPE)
24011: IS
24012: SELECT nvl(capital_amount , 0)
24013: from okl_k_lines
24014: where id = p_line_id;
24009:
24010: CURSOR capital_amount(p_line_id OKL_K_LINES.ID%TYPE)
24011: IS
24012: SELECT nvl(capital_amount , 0)
24013: from okl_k_lines
24014: where id = p_line_id;
24015:
24016: CURSOR service_item_csr (p_inv_item_id OKX_SYSTEM_ITEMS_V.ID1%TYPE,
24017: p_inv_org_id OKX_SYSTEM_ITEMS_V.ID2%TYPE) IS
24591:
24592: /*begin
24593: select nvl(capital_amount , 0)
24594: into l_capital_amount
24595: from okl_k_lines
24596: where id = x_asset_line_id;
24597: end;*/
24598: l_klev_rec.capital_amount := p_link_asset_amount + l_capital_amount;
24599: