APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_K_LINES

Line 5531: p_cle_id IN okl_k_lines_v.id%TYPE,

5527: x_msg_count OUT NOCOPY NUMBER,
5528: x_msg_data OUT NOCOPY VARCHAR2,
5529: p_chr_id IN okc_k_headers_v.id%TYPE,
5530: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
5531: p_cle_id IN okl_k_lines_v.id%TYPE,
5532: p_line_number IN okc_k_lines_v.line_number%TYPE,
5533: p_line_type IN okl_lines_interface.line_type%TYPE,
5534: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5535: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,

Line 6046: p_cle_id IN okl_k_lines_v.id%TYPE,

6042: x_msg_count OUT NOCOPY NUMBER,
6043: x_msg_data OUT NOCOPY VARCHAR2,
6044: p_chr_id IN okc_k_headers_v.id%TYPE,
6045: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
6046: p_cle_id IN okl_k_lines_v.id%TYPE,
6047: p_line_number IN okc_k_lines_v.line_number%TYPE,
6048: p_line_type IN okl_lines_interface.line_type%TYPE,
6049: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
6050: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,

Line 23732: okl_k_lines_full_v model,

23728: CURSOR assoc_csr (p_usage_item_id NUMBER,
23729: p_asset_line_id NUMBER) IS
23730: SELECT 'Y'
23731: FROM okc_k_items_v item,
23732: okl_k_lines_full_v model,
23733: okc_line_styles_v style,
23734: cs_counters cc,
23735: cs_ctr_associations assoc
23736: WHERE model.lse_id = style.id

Line 24145: p_cle_id IN okl_k_lines_v.id%TYPE,

24141: p_inv_item_id_prev IN okl_lines_interface.inventory_item_id%TYPE,
24142: p_term_quote_id IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_ID%TYPE,
24143: p_term_quote_number IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_NUMBER%TYPE,
24144: x_inv_item_id_prev OUT NOCOPY okl_lines_interface.inventory_item_id%TYPE,
24145: p_cle_id IN okl_k_lines_v.id%TYPE,
24146: x_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE,
24147: x_sub_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE, -- Bug# 3110115
24148: p_new_line_flag IN okl_lines_interface.explicit_new_line_flag%TYPE,
24149: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,

Line 24196: l_capital_amount okl_k_lines.capital_amount%type;

24192: x_clev_rec clev_rec_type;
24193:
24194: l_klev_rec klev_rec_type;
24195: l_clev_rec clev_rec_type;
24196: l_capital_amount okl_k_lines.capital_amount%type;
24197:
24198: p_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
24199: x_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
24200:

Line 24217: CURSOR capital_amount(p_line_id OKL_K_LINES.ID%TYPE)

24213: FROM okl_party_roles_interface
24214: WHERE contract_number_old = p_contract_number
24215: AND line_number = p_line_number;
24216:
24217: CURSOR capital_amount(p_line_id OKL_K_LINES.ID%TYPE)
24218: IS
24219: SELECT nvl(capital_amount , 0)
24220: from okl_k_lines
24221: where id = p_line_id;

Line 24220: from okl_k_lines

24216:
24217: CURSOR capital_amount(p_line_id OKL_K_LINES.ID%TYPE)
24218: IS
24219: SELECT nvl(capital_amount , 0)
24220: from okl_k_lines
24221: where id = p_line_id;
24222:
24223: CURSOR service_item_csr (p_inv_item_id OKX_SYSTEM_ITEMS_V.ID1%TYPE,
24224: p_inv_org_id OKX_SYSTEM_ITEMS_V.ID2%TYPE) IS

Line 24837: from okl_k_lines

24833:
24834: /*begin
24835: select nvl(capital_amount , 0)
24836: into l_capital_amount
24837: from okl_k_lines
24838: where id = x_asset_line_id;
24839: end;*/
24840: l_klev_rec.capital_amount := p_link_asset_amount + l_capital_amount;
24841: