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_SETUP_UTIL_PUB dependencies on OKC_CONTRACT_PUB

Line 881: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

877: l_api_name CONSTANT VARCHAR2(30) := 'Update_Hdr_Amount';
878: l_api_version Number := 1.0;
879:
880: --Contract Header
881: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
882: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
883:
884:
885: Cursor l_line_csr Is Select Sum(Nvl(PRICE_NEGOTIATED,0))

Line 882: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

878: l_api_version Number := 1.0;
879:
880: --Contract Header
881: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
882: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
883:
884:
885: Cursor l_line_csr Is Select Sum(Nvl(PRICE_NEGOTIATED,0))
886: From OKC_K_LINES_B

Line 913: okc_contract_pub.update_contract_header

909:
910: l_chrv_tbl_in(1).id := p_chr_id;
911: l_chrv_tbl_in(1).estimated_amount := l_hdr_amount;
912:
913: okc_contract_pub.update_contract_header
914: (
915: p_api_version => l_api_version,
916: p_init_msg_list => p_init_msg_list,
917: x_return_status => x_return_status,

Line 2350: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

2346: get_cpl_rec get_cpl%rowtype;
2347: l_khrv_tbl oks_khr_pvt.khrv_tbl_type;
2348: x_khrv_tbl oks_khr_pvt.khrv_tbl_type;
2349: l_error_tbl okc_api.error_tbl_type;
2350: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
2351: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
2352: l_clev_rec_in okc_contract_pub.clev_rec_type;
2353: l_clev_rec_out okc_contract_pub.clev_rec_type;
2354: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;

Line 2351: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

2347: l_khrv_tbl oks_khr_pvt.khrv_tbl_type;
2348: x_khrv_tbl oks_khr_pvt.khrv_tbl_type;
2349: l_error_tbl okc_api.error_tbl_type;
2350: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
2351: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
2352: l_clev_rec_in okc_contract_pub.clev_rec_type;
2353: l_clev_rec_out okc_contract_pub.clev_rec_type;
2354: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
2355: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;

Line 2352: l_clev_rec_in okc_contract_pub.clev_rec_type;

2348: x_khrv_tbl oks_khr_pvt.khrv_tbl_type;
2349: l_error_tbl okc_api.error_tbl_type;
2350: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
2351: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
2352: l_clev_rec_in okc_contract_pub.clev_rec_type;
2353: l_clev_rec_out okc_contract_pub.clev_rec_type;
2354: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
2355: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
2356: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;

Line 2353: l_clev_rec_out okc_contract_pub.clev_rec_type;

2349: l_error_tbl okc_api.error_tbl_type;
2350: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
2351: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
2352: l_clev_rec_in okc_contract_pub.clev_rec_type;
2353: l_clev_rec_out okc_contract_pub.clev_rec_type;
2354: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
2355: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
2356: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
2357: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;

Line 2371: okc_contract_pub.update_contract_header

2367: l_chrv_tbl_in(1).ship_to_site_use_id := NULL;
2368: l_chrv_tbl_in(1).cust_po_number := NULL;
2369: l_chrv_tbl_in(1).cust_po_number_req_yn := NULL;
2370:
2371: okc_contract_pub.update_contract_header
2372: (
2373: p_api_version => l_api_version,
2374: p_init_msg_list => l_init_msg_list,
2375: x_return_status => l_return_status,

Line 2443: OKC_CONTRACT_PUB.UPDATE_CONTRACT_LINE (

2439: l_clev_rec_in.cust_acct_id := NULL;
2440: l_clev_rec_in.Bill_to_site_use_id := NULL;
2441: l_clev_rec_in.ship_to_site_use_id := NULL;
2442:
2443: OKC_CONTRACT_PUB.UPDATE_CONTRACT_LINE (
2444: p_api_version => l_api_version,
2445: p_init_msg_list => l_init_msg_list,
2446: x_return_status => l_return_status,
2447: x_msg_count => l_msg_count,

Line 2705: l_okc_hdr_tbl OKC_CONTRACT_PUB.chrv_tbl_type;

2701: l_do_copy boolean;
2702: l_second_call boolean := false;
2703: l_line_num number;
2704: l_update_top_line boolean;
2705: l_okc_hdr_tbl OKC_CONTRACT_PUB.chrv_tbl_type;
2706: x_okc_hdr_tbl OKC_CONTRACT_PUB.chrv_tbl_type;
2707: l_line_id number;
2708: -- Added for price lock project
2709: l_contract_number VARCHAR2(120);

Line 2706: x_okc_hdr_tbl OKC_CONTRACT_PUB.chrv_tbl_type;

2702: l_second_call boolean := false;
2703: l_line_num number;
2704: l_update_top_line boolean;
2705: l_okc_hdr_tbl OKC_CONTRACT_PUB.chrv_tbl_type;
2706: x_okc_hdr_tbl OKC_CONTRACT_PUB.chrv_tbl_type;
2707: l_line_id number;
2708: -- Added for price lock project
2709: l_contract_number VARCHAR2(120);
2710: l_old_price_list_id number;

Line 2903: OKC_CONTRACT_PUB.update_contract_header(

2899: End If;
2900: -- Go into QA hold.
2901: l_okc_hdr_tbl(1).id := p_chr_id;
2902: l_okc_hdr_tbl(1).sts_code := 'QA_HOLD';
2903: OKC_CONTRACT_PUB.update_contract_header(
2904: p_api_version => 1.0,
2905: p_init_msg_list => OKC_API.G_FALSE,
2906: x_return_status => l_return_status,
2907: x_msg_count => l_msg_count,

Line 4256: l_chrv_rec okc_contract_pub.chrv_rec_type;

4252:
4253: l_khrv_rec oks_contract_hdr_pub.khrv_rec_type;
4254: l_klnv_rec oks_contract_line_pub.klnv_rec_type;
4255:
4256: l_chrv_rec okc_contract_pub.chrv_rec_type;
4257: l_Line_Id NUMBER;
4258: --
4259: l_api_version CONSTANT NUMBER := 1.0;
4260: l_init_msg_list CONSTANT VARCHAR2(1):= 'T';

Line 4267: l_gvev_tbl_in okc_contract_pub.gvev_tbl_type;

4263: l_msg_data VARCHAR2(2000):=null;
4264: l_msg_index_out Number;
4265: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Contract';
4266: --
4267: l_gvev_tbl_in okc_contract_pub.gvev_tbl_type;
4268: e_error Exception;
4269: n NUMBER;
4270: m NUMBER;
4271: v_Index NUMBER;

Line 4360: okc_Contract_pub.delete_governance(

4356:
4357: ---------- Delete Governance --------------
4358: IF NOT l_gvev_tbl_In.COUNT=0
4359: THEN
4360: okc_Contract_pub.delete_governance(
4361: p_api_version => l_api_version,
4362: p_init_msg_list => l_init_msg_list,
4363: x_return_status => l_return_status,
4364: x_msg_count => l_msg_count,