DBA Data[Home] [Help]

APPS.OKS_AUTH_UTIL_PVT dependencies on OKS_CONTRACT_HDR_PUB

Line 4858: l_khrv_tbl OKS_CONTRACT_HDR_PUB.khrv_tbl_type;

4854: , x_total OUT NOCOPY NUMBER)
4855:
4856: IS
4857:
4858: l_khrv_tbl OKS_CONTRACT_HDR_PUB.khrv_tbl_type;
4859: lx_khrv_tbl OKS_CONTRACT_HDR_PUB.khrv_tbl_type;
4860:
4861: l_klnv_tbl OKS_CONTRACT_LINE_PUB.klnv_tbl_type;
4862: lx_klnv_tbl OKS_CONTRACT_LINE_PUB.klnv_tbl_type;

Line 4859: lx_khrv_tbl OKS_CONTRACT_HDR_PUB.khrv_tbl_type;

4855:
4856: IS
4857:
4858: l_khrv_tbl OKS_CONTRACT_HDR_PUB.khrv_tbl_type;
4859: lx_khrv_tbl OKS_CONTRACT_HDR_PUB.khrv_tbl_type;
4860:
4861: l_klnv_tbl OKS_CONTRACT_LINE_PUB.klnv_tbl_type;
4862: lx_klnv_tbl OKS_CONTRACT_LINE_PUB.klnv_tbl_type;
4863:

Line 4994: OKS_CONTRACT_HDR_PUB.update_header(p_api_version => p_api_version,

4990: --BUG#4066428 hkamdar 01/21/05 added object_version_number
4991: l_khrv_tbl(1).object_version_number := l_hdr_object_ver_num;
4992:
4993:
4994: OKS_CONTRACT_HDR_PUB.update_header(p_api_version => p_api_version,
4995: p_init_msg_list => p_init_msg_list,
4996: x_return_status => l_return_status,
4997: x_msg_count => l_msg_count,
4998: x_msg_data => l_msg_data,

Line 7076: l_khrv_tbl_type_in oks_contract_hdr_pub.khrv_tbl_type;

7072: l_msg_index_out NUMBER;
7073: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
7074: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
7075: -- Header Level Tax Amount --
7076: l_khrv_tbl_type_in oks_contract_hdr_pub.khrv_tbl_type;
7077: l_khrv_tbl_type_out oks_contract_hdr_pub.khrv_tbl_type;
7078:
7079: -- Header Level Tax Amount --
7080: CURSOR total_amount IS

Line 7077: l_khrv_tbl_type_out oks_contract_hdr_pub.khrv_tbl_type;

7073: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
7074: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
7075: -- Header Level Tax Amount --
7076: l_khrv_tbl_type_in oks_contract_hdr_pub.khrv_tbl_type;
7077: l_khrv_tbl_type_out oks_contract_hdr_pub.khrv_tbl_type;
7078:
7079: -- Header Level Tax Amount --
7080: CURSOR total_amount IS
7081: SELECT nvl(SUM(price_negotiated), 0) SUM

Line 7146: oks_contract_hdr_pub.update_header(

7142: l_khrv_tbl_type_in(1).chr_id := p_header_id;
7143: l_khrv_tbl_type_in(1).object_version_number := l_get_hdr_details.object_version_number;
7144: l_khrv_tbl_type_in(1).tax_amount := l_total_tax.amount;
7145:
7146: oks_contract_hdr_pub.update_header(
7147: p_api_version => l_api_version,
7148: p_init_msg_list => l_init_msg_list,
7149: x_return_status => l_return_status,
7150: x_msg_count => l_msg_count,

Line 9441: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;

9437: l_msg_data Varchar2(2000);
9438: l_active_request BOOLEAN := FALSE;
9439:
9440: l_api_version CONSTANT NUMBER := 1.0;
9441: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;
9442: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
9443: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
9444: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
9445: l_clev_rec_in okc_contract_pub.clev_rec_type;

Line 9442: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;

9438: l_active_request BOOLEAN := FALSE;
9439:
9440: l_api_version CONSTANT NUMBER := 1.0;
9441: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;
9442: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
9443: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
9444: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;
9445: l_clev_rec_in okc_contract_pub.clev_rec_type;
9446: l_clev_rec_out okc_contract_pub.clev_rec_type;