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 4588: l_clev_tbl_in OKC_CONTRACT_PUB.clev_tbl_type;

4584: i NUMBER;
4585: l_api_version NUMBER := 1.0;
4586: l_msg_count NUMBER;
4587: l_msg_data VARCHAR2(2000);
4588: l_clev_tbl_in OKC_CONTRACT_PUB.clev_tbl_type;
4589: l_clev_tbl_out OKC_CONTRACT_PUB.clev_tbl_type;
4590: BEGIN
4591: OPEN subline_count;
4592: FETCH subline_count INTO l_count;

Line 4589: l_clev_tbl_out OKC_CONTRACT_PUB.clev_tbl_type;

4585: l_api_version NUMBER := 1.0;
4586: l_msg_count NUMBER;
4587: l_msg_data VARCHAR2(2000);
4588: l_clev_tbl_in OKC_CONTRACT_PUB.clev_tbl_type;
4589: l_clev_tbl_out OKC_CONTRACT_PUB.clev_tbl_type;
4590: BEGIN
4591: OPEN subline_count;
4592: FETCH subline_count INTO l_count;
4593: CLOSE subline_count;

Line 4610: OKC_CONTRACT_PUB.update_contract_line(

4606: END IF;
4607: l_total_amt := l_total_amt + NVL(l_clev_tbl_in(i).price_negotiated, 0);
4608: i := i + 1;
4609: END LOOP;
4610: OKC_CONTRACT_PUB.update_contract_line(
4611: p_api_version => l_api_version,
4612: x_return_status => x_status,
4613: x_msg_count => l_msg_count,
4614: x_msg_data => l_msg_data,

Line 5174: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

5170: l_return_status VARCHAR2(1);
5171: l_msg_count NUMBER;
5172: l_msg_data VARCHAR2(2000);
5173: l_msg_index_out NUMBER;
5174: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
5175: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
5176:
5177: CURSOR total_amount(p_chr_id IN NUMBER) IS
5178: SELECT nvl(SUM(price_negotiated), 0) SUM

Line 5175: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

5171: l_msg_count NUMBER;
5172: l_msg_data VARCHAR2(2000);
5173: l_msg_index_out NUMBER;
5174: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
5175: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
5176:
5177: CURSOR total_amount(p_chr_id IN NUMBER) IS
5178: SELECT nvl(SUM(price_negotiated), 0) SUM
5179: FROM okc_k_lines_b

Line 5191: okc_contract_pub.update_contract_header (

5187: FOR cur_total_amount IN total_amount(g_chr_id)
5188: LOOP
5189: l_chrv_tbl_in(1).id := g_chr_id;
5190: l_chrv_tbl_in(1).estimated_amount := cur_total_amount.SUM;
5191: okc_contract_pub.update_contract_header (
5192: p_api_version => l_api_version,
5193: p_init_msg_list => l_init_msg_list,
5194: x_return_status => l_return_status,
5195: x_msg_count => l_msg_count,

Line 6921: l_clev_rec OKC_CONTRACT_PUB.clev_rec_type;

6917: x_return_status OUT NOCOPY VARCHAR2,
6918: x_msg_count OUT NOCOPY NUMBER,
6919: x_msg_data OUT NOCOPY VARCHAR2)
6920: IS
6921: l_clev_rec OKC_CONTRACT_PUB.clev_rec_type;
6922: x_clev_rec OKC_CONTRACT_PUB.clev_rec_type;
6923: l_api_version NUMBER := 1.0;
6924: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
6925: l_return_status VARCHAR2(1);

Line 6922: x_clev_rec OKC_CONTRACT_PUB.clev_rec_type;

6918: x_msg_count OUT NOCOPY NUMBER,
6919: x_msg_data OUT NOCOPY VARCHAR2)
6920: IS
6921: l_clev_rec OKC_CONTRACT_PUB.clev_rec_type;
6922: x_clev_rec OKC_CONTRACT_PUB.clev_rec_type;
6923: l_api_version NUMBER := 1.0;
6924: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
6925: l_return_status VARCHAR2(1);
6926: l_msg_count NUMBER;

Line 6968: OKC_CONTRACT_PUB.Update_Contract_Line

6964:
6965:
6966: l_clev_rec.price_negotiated := l_price_negotiated ;
6967:
6968: OKC_CONTRACT_PUB.Update_Contract_Line
6969: (
6970: p_api_version => l_api_version,
6971: p_init_msg_lISt => l_init_msg_lISt,
6972: x_return_status => x_return_status,

Line 7028: l_clev_rec OKC_CONTRACT_PUB.clev_rec_type;

7024: x_msg_count OUT NOCOPY NUMBER,
7025: x_msg_data OUT NOCOPY VARCHAR2)
7026: IS
7027:
7028: l_clev_rec OKC_CONTRACT_PUB.clev_rec_type;
7029: x_clev_rec OKC_CONTRACT_PUB.clev_rec_type;
7030: l_api_version NUMBER := 1.0;
7031: l_init_msg_lISt VARCHAR2(1) := 'T';
7032:

Line 7029: x_clev_rec OKC_CONTRACT_PUB.clev_rec_type;

7025: x_msg_data OUT NOCOPY VARCHAR2)
7026: IS
7027:
7028: l_clev_rec OKC_CONTRACT_PUB.clev_rec_type;
7029: x_clev_rec OKC_CONTRACT_PUB.clev_rec_type;
7030: l_api_version NUMBER := 1.0;
7031: l_init_msg_lISt VARCHAR2(1) := 'T';
7032:
7033: BEGIN

Line 7042: OKC_CONTRACT_PUB.Update_Contract_Line

7038: l_clev_rec.price_unit := p_clvl_rec.price_unit;
7039: l_clev_rec.price_unit_percent := p_clvl_rec.price_unit_percent;
7040: l_clev_rec.price_negotiated := p_clvl_rec.price_negotiated;
7041:
7042: OKC_CONTRACT_PUB.Update_Contract_Line
7043: (
7044: p_api_version => l_api_version,
7045: p_init_msg_lISt => l_init_msg_lISt,
7046: x_return_status => x_return_status,

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

7050: p_clev_rec => l_clev_rec,
7051: x_clev_rec => x_clev_rec
7052: );
7053:
7054: ----------errorout_ad('OKC_CONTRACT_PUB.Update_Contract_Line status = ' || x_return_status);
7055:
7056: IF NVL(x_return_status, '!') <> OKC_API.G_RET_STS_SUCCESS THEN
7057: RAISE G_ERROR;
7058: END IF;

Line 7073: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

7069: l_return_status VARCHAR2(1);
7070: l_msg_count NUMBER;
7071: l_msg_data VARCHAR2(2000);
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;

Line 7074: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

7070: l_msg_count NUMBER;
7071: l_msg_data VARCHAR2(2000);
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:

Line 7115: okc_contract_pub.update_contract_header (

7111: FOR cur_total_amount IN total_amount
7112: LOOP
7113: l_chrv_tbl_in(1).id := p_header_id;
7114: l_chrv_tbl_in(1).estimated_amount := cur_total_amount.SUM;
7115: okc_contract_pub.update_contract_header (
7116: p_api_version => l_api_version,
7117: p_init_msg_list => l_init_msg_list,
7118: x_return_status => l_return_status,
7119: x_msg_count => l_msg_count,

Line 9428: l_chrv_rec_in okc_contract_pub.chrv_rec_type;

9424: AND date_cancelled IS NULL
9425: AND date_terminated IS NULL
9426: ORDER BY line_number;
9427:
9428: l_chrv_rec_in okc_contract_pub.chrv_rec_type;
9429: l_chrv_rec_out okc_contract_pub.chrv_rec_type;
9430: l_k_det_rec oks_qp_int_pvt.k_details_rec;
9431: l_input_details oks_qp_pkg.input_details;
9432:

Line 9429: l_chrv_rec_out okc_contract_pub.chrv_rec_type;

9425: AND date_terminated IS NULL
9426: ORDER BY line_number;
9427:
9428: l_chrv_rec_in okc_contract_pub.chrv_rec_type;
9429: l_chrv_rec_out okc_contract_pub.chrv_rec_type;
9430: l_k_det_rec oks_qp_int_pvt.k_details_rec;
9431: l_input_details oks_qp_pkg.input_details;
9432:
9433: l_output_details OKS_QP_PKG.PRICE_DETAILS;

Line 9445: l_clev_rec_in okc_contract_pub.clev_rec_type;

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;
9447: l_old_conversion_rate NUMBER;
9448:
9449: l_api_name CONSTANT VARCHAR2(40) := 'REVALUE_CONTRACT';

Line 9446: l_clev_rec_out okc_contract_pub.clev_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;
9447: l_old_conversion_rate NUMBER;
9448:
9449: l_api_name CONSTANT VARCHAR2(40) := 'REVALUE_CONTRACT';
9450: l_mod_name VARCHAR2(256) := lower(G_APP_NAME_OKS) || '.plsql.' ||

Line 9678: okc_contract_pub.update_contract_line(p_api_version => l_api_version,

9674: x_k_det_rec => l_k_det_rec);
9675: l_clev_rec_in.object_version_number := l_k_det_rec.object_version_number;
9676: l_clev_rec_in.price_negotiated :=(l_subline_rec.price_negotiated *l_old_conversion_rate) /Nvl(p_new_conversion_rate, 1);
9677:
9678: okc_contract_pub.update_contract_line(p_api_version => l_api_version,
9679: p_init_msg_list => 'T',
9680: x_return_status => x_return_status,
9681: x_msg_count => l_msg_count,
9682: x_msg_data => l_msg_data,

Line 9749: okc_contract_pub.update_contract_line(p_api_version => l_api_version,

9745: p_type => g_okc_line,
9746: x_k_det_rec => l_k_det_rec);
9747:
9748: l_clev_rec_in.object_version_number := l_k_det_rec.object_version_number;
9749: okc_contract_pub.update_contract_line(p_api_version => l_api_version,
9750: p_init_msg_list => 'T',
9751: x_return_status => x_return_status,
9752: x_msg_count => l_msg_count,
9753: x_msg_data => l_msg_data,

Line 9784: okc_contract_pub.update_contract_header(p_api_version => l_api_version,

9780: p_type => g_okc_hdr,
9781: x_k_det_rec => l_k_det_rec);
9782: l_chrv_rec_in.object_version_number := l_k_det_rec.object_version_number;
9783:
9784: okc_contract_pub.update_contract_header(p_api_version => l_api_version,
9785: p_init_msg_list => 'T',
9786: x_return_status => x_return_status,
9787: x_msg_count => l_msg_count,
9788: x_msg_data => l_msg_data,