eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_AUTH_UTIL_PVT dependencies on OKC_CONTRACT_PUB

Line 4048: l_clev_tbl_in OKC_CONTRACT_PUB.clev_tbl_type;

4044: i NUMBER;
4045: l_api_version NUMBER := 1.0;
4046: l_msg_count NUMBER;
4047: l_msg_data VARCHAR2(2000);
4048: l_clev_tbl_in OKC_CONTRACT_PUB.clev_tbl_type;
4049: l_clev_tbl_out OKC_CONTRACT_PUB.clev_tbl_type;
4050: BEGIN
4051: OPEN subline_count;
4052: FETCH subline_count INTO l_count;

Line 4049: l_clev_tbl_out OKC_CONTRACT_PUB.clev_tbl_type;

4045: l_api_version NUMBER := 1.0;
4046: l_msg_count NUMBER;
4047: l_msg_data VARCHAR2(2000);
4048: l_clev_tbl_in OKC_CONTRACT_PUB.clev_tbl_type;
4049: l_clev_tbl_out OKC_CONTRACT_PUB.clev_tbl_type;
4050: BEGIN
4051: OPEN subline_count;
4052: FETCH subline_count INTO l_count;
4053: CLOSE subline_count;

Line 4070: OKC_CONTRACT_PUB.update_contract_line(

4066: END IF;
4067: l_total_amt := l_total_amt + NVL(l_clev_tbl_in(i).price_negotiated, 0);
4068: i := i + 1;
4069: END LOOP;
4070: OKC_CONTRACT_PUB.update_contract_line(
4071: p_api_version => l_api_version,
4072: x_return_status => x_status,
4073: x_msg_count => l_msg_count,
4074: x_msg_data => l_msg_data,

Line 4633: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

4629: l_return_status VARCHAR2(1);
4630: l_msg_count NUMBER;
4631: l_msg_data VARCHAR2(2000);
4632: l_msg_index_out NUMBER;
4633: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
4634: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
4635:
4636: CURSOR total_amount(p_chr_id IN NUMBER) IS
4637: SELECT nvl(SUM(price_negotiated), 0) SUM

Line 4634: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

4630: l_msg_count NUMBER;
4631: l_msg_data VARCHAR2(2000);
4632: l_msg_index_out NUMBER;
4633: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
4634: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
4635:
4636: CURSOR total_amount(p_chr_id IN NUMBER) IS
4637: SELECT nvl(SUM(price_negotiated), 0) SUM
4638: FROM okc_k_lines_b

Line 4650: okc_contract_pub.update_contract_header (

4646: FOR cur_total_amount IN total_amount(g_chr_id)
4647: LOOP
4648: l_chrv_tbl_in(1).id := g_chr_id;
4649: l_chrv_tbl_in(1).estimated_amount := cur_total_amount.SUM;
4650: okc_contract_pub.update_contract_header (
4651: p_api_version => l_api_version,
4652: p_init_msg_list => l_init_msg_list,
4653: x_return_status => l_return_status,
4654: x_msg_count => l_msg_count,

Line 6301: l_clev_rec OKC_CONTRACT_PUB.clev_rec_type;

6297: x_return_status OUT NOCOPY VARCHAR2,
6298: x_msg_count OUT NOCOPY NUMBER,
6299: x_msg_data OUT NOCOPY VARCHAR2)
6300: IS
6301: l_clev_rec OKC_CONTRACT_PUB.clev_rec_type;
6302: x_clev_rec OKC_CONTRACT_PUB.clev_rec_type;
6303: l_api_version NUMBER := 1.0;
6304: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
6305: l_return_status VARCHAR2(1);

Line 6302: x_clev_rec OKC_CONTRACT_PUB.clev_rec_type;

6298: x_msg_count OUT NOCOPY NUMBER,
6299: x_msg_data OUT NOCOPY VARCHAR2)
6300: IS
6301: l_clev_rec OKC_CONTRACT_PUB.clev_rec_type;
6302: x_clev_rec OKC_CONTRACT_PUB.clev_rec_type;
6303: l_api_version NUMBER := 1.0;
6304: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
6305: l_return_status VARCHAR2(1);
6306: l_msg_count NUMBER;

Line 6348: OKC_CONTRACT_PUB.Update_Contract_Line

6344:
6345:
6346: l_clev_rec.price_negotiated := l_price_negotiated ;
6347:
6348: OKC_CONTRACT_PUB.Update_Contract_Line
6349: (
6350: p_api_version => l_api_version,
6351: p_init_msg_lISt => l_init_msg_lISt,
6352: x_return_status => x_return_status,

Line 6408: l_clev_rec OKC_CONTRACT_PUB.clev_rec_type;

6404: x_msg_count OUT NOCOPY NUMBER,
6405: x_msg_data OUT NOCOPY VARCHAR2)
6406: IS
6407:
6408: l_clev_rec OKC_CONTRACT_PUB.clev_rec_type;
6409: x_clev_rec OKC_CONTRACT_PUB.clev_rec_type;
6410: l_api_version NUMBER := 1.0;
6411: l_init_msg_lISt VARCHAR2(1) := 'T';
6412:

Line 6409: x_clev_rec OKC_CONTRACT_PUB.clev_rec_type;

6405: x_msg_data OUT NOCOPY VARCHAR2)
6406: IS
6407:
6408: l_clev_rec OKC_CONTRACT_PUB.clev_rec_type;
6409: x_clev_rec OKC_CONTRACT_PUB.clev_rec_type;
6410: l_api_version NUMBER := 1.0;
6411: l_init_msg_lISt VARCHAR2(1) := 'T';
6412:
6413: BEGIN

Line 6422: OKC_CONTRACT_PUB.Update_Contract_Line

6418: l_clev_rec.price_unit := p_clvl_rec.price_unit;
6419: l_clev_rec.price_unit_percent := p_clvl_rec.price_unit_percent;
6420: l_clev_rec.price_negotiated := p_clvl_rec.price_negotiated;
6421:
6422: OKC_CONTRACT_PUB.Update_Contract_Line
6423: (
6424: p_api_version => l_api_version,
6425: p_init_msg_lISt => l_init_msg_lISt,
6426: x_return_status => x_return_status,

Line 6434: ----------errorout_ad('OKC_CONTRACT_PUB.Update_Contract_Line status = ' || x_return_status);

6430: p_clev_rec => l_clev_rec,
6431: x_clev_rec => x_clev_rec
6432: );
6433:
6434: ----------errorout_ad('OKC_CONTRACT_PUB.Update_Contract_Line status = ' || x_return_status);
6435:
6436: IF NVL(x_return_status, '!') <> OKC_API.G_RET_STS_SUCCESS THEN
6437: RAISE G_ERROR;
6438: END IF;

Line 6453: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

6449: l_return_status VARCHAR2(1);
6450: l_msg_count NUMBER;
6451: l_msg_data VARCHAR2(2000);
6452: l_msg_index_out NUMBER;
6453: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
6454: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
6455: -- Header Level Tax Amount --
6456: l_khrv_tbl_type_in oks_contract_hdr_pub.khrv_tbl_type;
6457: l_khrv_tbl_type_out oks_contract_hdr_pub.khrv_tbl_type;

Line 6454: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

6450: l_msg_count NUMBER;
6451: l_msg_data VARCHAR2(2000);
6452: l_msg_index_out NUMBER;
6453: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
6454: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
6455: -- Header Level Tax Amount --
6456: l_khrv_tbl_type_in oks_contract_hdr_pub.khrv_tbl_type;
6457: l_khrv_tbl_type_out oks_contract_hdr_pub.khrv_tbl_type;
6458:

Line 6495: okc_contract_pub.update_contract_header (

6491: FOR cur_total_amount IN total_amount
6492: LOOP
6493: l_chrv_tbl_in(1).id := p_header_id;
6494: l_chrv_tbl_in(1).estimated_amount := cur_total_amount.SUM;
6495: okc_contract_pub.update_contract_header (
6496: p_api_version => l_api_version,
6497: p_init_msg_list => l_init_msg_list,
6498: x_return_status => l_return_status,
6499: x_msg_count => l_msg_count,