APPS.OKS_BILL_UTIL_PUB dependencies on OKC_CONTRACT_PUB

Line 1659: l_clev_tbl_in OKC_CONTRACT_PUB.clev_tbl_type;

1655: i NUMBER;
1656: l_api_version NUMBER := 1.0;
1657: l_msg_count NUMBER;
1658: l_msg_data VARCHAR2(2000);
1659: l_clev_tbl_in OKC_CONTRACT_PUB.clev_tbl_type;
1660: l_clev_tbl_out OKC_CONTRACT_PUB.clev_tbl_type;
1661: begin
1662: Open subline_count;
1663: Fetch subline_count into l_count;

Line 1660: l_clev_tbl_out OKC_CONTRACT_PUB.clev_tbl_type;

1656: l_api_version NUMBER := 1.0;
1657: l_msg_count NUMBER;
1658: l_msg_data VARCHAR2(2000);
1659: l_clev_tbl_in OKC_CONTRACT_PUB.clev_tbl_type;
1660: l_clev_tbl_out OKC_CONTRACT_PUB.clev_tbl_type;
1661: begin
1662: Open subline_count;
1663: Fetch subline_count into l_count;
1664: Close subline_count;

Line 1682: OKC_CONTRACT_PUB.update_contract_line(

1678:
1679: l_total_amt := l_total_amt + NVL(l_clev_tbl_in(i).price_negotiated,0);
1680: i := i + 1;
1681: End Loop;
1682: OKC_CONTRACT_PUB.update_contract_line(
1683: p_api_version => l_api_version,
1684: x_return_status => x_status,
1685: x_msg_count => l_msg_count,
1686: x_msg_data => l_msg_data,

Line 1868: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

1864: l_return_status VARCHAR2(1);
1865: l_msg_count NUMBER;
1866: l_msg_data VARCHAR2(2000);
1867: l_msg_index_out NUMBER;
1868: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
1869: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
1870:
1871: cursor total_amount(p_chr_id IN NUMBER) IS
1872: select sum(price_negotiated) sum

Line 1869: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

1865: l_msg_count NUMBER;
1866: l_msg_data VARCHAR2(2000);
1867: l_msg_index_out NUMBER;
1868: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
1869: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
1870:
1871: cursor total_amount(p_chr_id IN NUMBER) IS
1872: select sum(price_negotiated) sum
1873: from okc_k_lines_b

Line 1883: okc_contract_pub.update_contract_header (

1879: For cur_total_amount IN total_amount(g_chr_id)
1880: loop
1881: l_chrv_tbl_in(1).id := g_chr_id;
1882: l_chrv_tbl_in(1).estimated_amount := cur_total_amount.sum;
1883: okc_contract_pub.update_contract_header (
1884: p_api_version => l_api_version,
1885: p_init_msg_list => l_init_msg_list,
1886: x_return_status => l_return_status,
1887: x_msg_count => l_msg_count,