441: FROM okc_k_lines_b
442: WHERE ID = p_line_id;
443:
444: l_line_rec l_line_csr%ROWTYPE;
445: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
446: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
447: l_k_det_rec k_details_rec;
448: -- l_rule_rec OKC_RUL_PVT.rulv_rec_type;
449: l_billed_date DATE;
442: WHERE ID = p_line_id;
443:
444: l_line_rec l_line_csr%ROWTYPE;
445: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
446: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
447: l_k_det_rec k_details_rec;
448: -- l_rule_rec OKC_RUL_PVT.rulv_rec_type;
449: l_billed_date DATE;
450: BEGIN
506: l_kln_rec_in.ID := l_k_det_rec.ID;
507: l_kln_rec_in.status_text := g_billed_line;
508: l_kln_rec_in.object_version_number :=
509: l_k_det_rec.object_version_number;
510: oks_contract_line_pub.update_line
511: (p_api_version => l_api_version,
512: p_init_msg_list => l_init_msg_list,
513: x_return_status => x_return_status,
514: x_msg_count => x_msg_count,
533: l_kln_rec_in.ID := l_k_det_rec.ID;
534: l_kln_rec_in.status_text := g_billed_line;
535: l_kln_rec_in.object_version_number :=
536: l_k_det_rec.object_version_number;
537: oks_contract_line_pub.update_line
538: (p_api_version => l_api_version,
539: p_init_msg_list => l_init_msg_list,
540: x_return_status => x_return_status,
541: x_msg_count => x_msg_count,
1757: l_rail_rec oks_tax_util_pvt.ra_rec_type;
1758: l_k_det_rec k_details_rec;
1759: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;
1760: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
1761: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
1762: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
1763: l_clev_rec_in okc_contract_pub.clev_rec_type;
1764: l_clev_rec_out okc_contract_pub.clev_rec_type;
1765: l_scev_rec_in oks_subscr_elems_pub.scev_rec_type;
1758: l_k_det_rec k_details_rec;
1759: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;
1760: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
1761: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
1762: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
1763: l_clev_rec_in okc_contract_pub.clev_rec_type;
1764: l_clev_rec_out okc_contract_pub.clev_rec_type;
1765: l_scev_rec_in oks_subscr_elems_pub.scev_rec_type;
1766: l_scev_rec_out oks_subscr_elems_pub.scev_rec_type;
2349: x_k_det_rec => l_k_det_rec
2350: );
2351: l_kln_rec_in.ID := l_k_det_rec.ID;
2352: l_kln_rec_in.object_version_number := l_k_det_rec.object_version_number;
2353: oks_contract_line_pub.update_line (p_api_version => l_api_version,
2354: p_init_msg_list => l_init_msg_list,
2355: x_return_status => x_return_status,
2356: x_msg_count => x_msg_count,
2357: x_msg_data => x_msg_data,
2715: l_rail_rec oks_tax_util_pvt.ra_rec_type;
2716: l_k_det_rec k_details_rec;
2717: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;
2718: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
2719: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
2720: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
2721: l_clev_rec_in okc_contract_pub.clev_rec_type;
2722: l_clev_rec_out okc_contract_pub.clev_rec_type;
2723: l_prod_qty NUMBER;
2716: l_k_det_rec k_details_rec;
2717: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;
2718: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
2719: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
2720: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
2721: l_clev_rec_in okc_contract_pub.clev_rec_type;
2722: l_clev_rec_out okc_contract_pub.clev_rec_type;
2723: l_prod_qty NUMBER;
2724: l_serv_qty NUMBER;
3198: x_k_det_rec => l_k_det_rec
3199: );
3200: l_kln_rec_in.ID := l_k_det_rec.ID;
3201: l_kln_rec_in.object_version_number := l_k_det_rec.object_version_number;
3202: oks_contract_line_pub.update_line (p_api_version => l_api_version,
3203: p_init_msg_list => l_init_msg_list,
3204: x_return_status => x_return_status,
3205: x_msg_count => x_msg_count,
3206: x_msg_data => x_msg_data,
3391: l_rail_rec oks_tax_util_pvt.ra_rec_type;
3392: l_k_det_rec k_details_rec;
3393: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;
3394: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
3395: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
3396: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
3397: l_clev_rec_in okc_contract_pub.clev_rec_type;
3398: l_clev_rec_out okc_contract_pub.clev_rec_type;
3399: l_subs_item BOOLEAN := FALSE;
3392: l_k_det_rec k_details_rec;
3393: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;
3394: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
3395: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
3396: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
3397: l_clev_rec_in okc_contract_pub.clev_rec_type;
3398: l_clev_rec_out okc_contract_pub.clev_rec_type;
3399: l_subs_item BOOLEAN := FALSE;
3400: l_clvl_name VARCHAR2 (240);
3623: );
3624: l_kln_rec_in.ID := l_k_det_rec.ID;
3625: l_kln_rec_in.object_version_number :=
3626: l_k_det_rec.object_version_number;
3627: oks_contract_line_pub.update_line
3628: (p_api_version => l_api_version,
3629: p_init_msg_list => l_init_msg_list,
3630: x_return_status => x_return_status,
3631: x_msg_count => x_msg_count,
4356: l_rail_rec oks_tax_util_pvt.ra_rec_type;
4357: l_k_det_rec k_details_rec;
4358: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;
4359: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
4360: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
4361: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
4362: l_clev_rec_in okc_contract_pub.clev_rec_type;
4363: l_clev_rec_out okc_contract_pub.clev_rec_type;
4364: l_subs_item boolean := false;
4357: l_k_det_rec k_details_rec;
4358: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;
4359: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
4360: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
4361: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
4362: l_clev_rec_in okc_contract_pub.clev_rec_type;
4363: l_clev_rec_out okc_contract_pub.clev_rec_type;
4364: l_subs_item boolean := false;
4365: l_clvl_name varchar2 (240);
5780: );
5781: l_kln_rec_in.id := l_k_det_rec.id;
5782: l_kln_rec_in.object_version_number :=
5783: l_k_det_rec.object_version_number;
5784: oks_contract_line_pub.update_line
5785: (p_api_version => l_api_version,
5786: p_init_msg_list => l_init_msg_list,
5787: x_return_status => x_return_status,
5788: x_msg_count => x_msg_count,