APPS.OKS_BILL_UTIL_PUB dependencies on OKC_CONTRACT_PUB

Line 1625: l_clev_tbl_in OKC_CONTRACT_PUB.clev_tbl_type;

1621: i NUMBER;
1622: l_api_version NUMBER := 1.0;
1623: l_msg_count NUMBER;
1624: l_msg_data VARCHAR2(2000);
1625: l_clev_tbl_in OKC_CONTRACT_PUB.clev_tbl_type;
1626: l_clev_tbl_out OKC_CONTRACT_PUB.clev_tbl_type;
1627: begin
1628: Open subline_count;
1629: Fetch subline_count into l_count;

Line 1626: l_clev_tbl_out OKC_CONTRACT_PUB.clev_tbl_type;

1622: l_api_version NUMBER := 1.0;
1623: l_msg_count NUMBER;
1624: l_msg_data VARCHAR2(2000);
1625: l_clev_tbl_in OKC_CONTRACT_PUB.clev_tbl_type;
1626: l_clev_tbl_out OKC_CONTRACT_PUB.clev_tbl_type;
1627: begin
1628: Open subline_count;
1629: Fetch subline_count into l_count;
1630: Close subline_count;

Line 1648: OKC_CONTRACT_PUB.update_contract_line(

1644:
1645: l_total_amt := l_total_amt + NVL(l_clev_tbl_in(i).price_negotiated,0);
1646: i := i + 1;
1647: End Loop;
1648: OKC_CONTRACT_PUB.update_contract_line(
1649: p_api_version => l_api_version,
1650: x_return_status => x_status,
1651: x_msg_count => l_msg_count,
1652: x_msg_data => l_msg_data,

Line 1834: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

1830: l_return_status VARCHAR2(1);
1831: l_msg_count NUMBER;
1832: l_msg_data VARCHAR2(2000);
1833: l_msg_index_out NUMBER;
1834: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
1835: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
1836:
1837: cursor total_amount(p_chr_id IN NUMBER) IS
1838: select sum(price_negotiated) sum

Line 1835: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

1831: l_msg_count NUMBER;
1832: l_msg_data VARCHAR2(2000);
1833: l_msg_index_out NUMBER;
1834: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
1835: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
1836:
1837: cursor total_amount(p_chr_id IN NUMBER) IS
1838: select sum(price_negotiated) sum
1839: from okc_k_lines_b

Line 1849: okc_contract_pub.update_contract_header (

1845: For cur_total_amount IN total_amount(g_chr_id)
1846: loop
1847: l_chrv_tbl_in(1).id := g_chr_id;
1848: l_chrv_tbl_in(1).estimated_amount := cur_total_amount.sum;
1849: okc_contract_pub.update_contract_header (
1850: p_api_version => l_api_version,
1851: p_init_msg_list => l_init_msg_list,
1852: x_return_status => l_return_status,
1853: x_msg_count => l_msg_count,