DBA Data[Home] [Help]

APPS.OKS_SETUP_UTIL_PUB dependencies on OKC_CONTRACT_PUB

Line 887: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

883: l_api_name CONSTANT VARCHAR2(30) := 'Update_Hdr_Amount';
884: l_api_version Number := 1.0;
885:
886: --Contract Header
887: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
888: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
889:
890:
891: Cursor l_line_csr Is Select Sum(Nvl(PRICE_NEGOTIATED,0))

Line 888: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

884: l_api_version Number := 1.0;
885:
886: --Contract Header
887: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
888: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
889:
890:
891: Cursor l_line_csr Is Select Sum(Nvl(PRICE_NEGOTIATED,0))
892: From OKC_K_LINES_B

Line 919: okc_contract_pub.update_contract_header

915:
916: l_chrv_tbl_in(1).id := p_chr_id;
917: l_chrv_tbl_in(1).estimated_amount := l_hdr_amount;
918:
919: okc_contract_pub.update_contract_header
920: (
921: p_api_version => l_api_version,
922: p_init_msg_list => p_init_msg_list,
923: x_return_status => x_return_status,

Line 2359: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

2355: get_cpl_rec get_cpl%rowtype;
2356: l_khrv_tbl oks_khr_pvt.khrv_tbl_type;
2357: x_khrv_tbl oks_khr_pvt.khrv_tbl_type;
2358: l_error_tbl okc_api.error_tbl_type;
2359: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
2360: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
2361: l_clev_rec_in okc_contract_pub.clev_rec_type;
2362: l_clev_rec_out okc_contract_pub.clev_rec_type;
2363: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;

Line 2360: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

2356: l_khrv_tbl oks_khr_pvt.khrv_tbl_type;
2357: x_khrv_tbl oks_khr_pvt.khrv_tbl_type;
2358: l_error_tbl okc_api.error_tbl_type;
2359: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
2360: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
2361: l_clev_rec_in okc_contract_pub.clev_rec_type;
2362: l_clev_rec_out okc_contract_pub.clev_rec_type;
2363: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
2364: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;

Line 2361: l_clev_rec_in okc_contract_pub.clev_rec_type;

2357: x_khrv_tbl oks_khr_pvt.khrv_tbl_type;
2358: l_error_tbl okc_api.error_tbl_type;
2359: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
2360: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
2361: l_clev_rec_in okc_contract_pub.clev_rec_type;
2362: l_clev_rec_out okc_contract_pub.clev_rec_type;
2363: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
2364: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
2365: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;

Line 2362: l_clev_rec_out okc_contract_pub.clev_rec_type;

2358: l_error_tbl okc_api.error_tbl_type;
2359: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
2360: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
2361: l_clev_rec_in okc_contract_pub.clev_rec_type;
2362: l_clev_rec_out okc_contract_pub.clev_rec_type;
2363: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
2364: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
2365: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;
2366: l_kln_rec_out oks_contract_line_pub.klnv_rec_type;

Line 2380: okc_contract_pub.update_contract_header

2376: l_chrv_tbl_in(1).ship_to_site_use_id := NULL;
2377: l_chrv_tbl_in(1).cust_po_number := NULL;
2378: l_chrv_tbl_in(1).cust_po_number_req_yn := NULL;
2379:
2380: okc_contract_pub.update_contract_header
2381: (
2382: p_api_version => l_api_version,
2383: p_init_msg_list => l_init_msg_list,
2384: x_return_status => l_return_status,

Line 2452: OKC_CONTRACT_PUB.UPDATE_CONTRACT_LINE (

2448: l_clev_rec_in.cust_acct_id := NULL;
2449: l_clev_rec_in.Bill_to_site_use_id := NULL;
2450: l_clev_rec_in.ship_to_site_use_id := NULL;
2451:
2452: OKC_CONTRACT_PUB.UPDATE_CONTRACT_LINE (
2453: p_api_version => l_api_version,
2454: p_init_msg_list => l_init_msg_list,
2455: x_return_status => l_return_status,
2456: x_msg_count => l_msg_count,

Line 2714: l_okc_hdr_tbl OKC_CONTRACT_PUB.chrv_tbl_type;

2710: l_do_copy boolean;
2711: l_second_call boolean := false;
2712: l_line_num number;
2713: l_update_top_line boolean;
2714: l_okc_hdr_tbl OKC_CONTRACT_PUB.chrv_tbl_type;
2715: x_okc_hdr_tbl OKC_CONTRACT_PUB.chrv_tbl_type;
2716: l_line_id number;
2717: -- Added for price lock project
2718: l_contract_number VARCHAR2(120);

Line 2715: x_okc_hdr_tbl OKC_CONTRACT_PUB.chrv_tbl_type;

2711: l_second_call boolean := false;
2712: l_line_num number;
2713: l_update_top_line boolean;
2714: l_okc_hdr_tbl OKC_CONTRACT_PUB.chrv_tbl_type;
2715: x_okc_hdr_tbl OKC_CONTRACT_PUB.chrv_tbl_type;
2716: l_line_id number;
2717: -- Added for price lock project
2718: l_contract_number VARCHAR2(120);
2719: l_old_price_list_id number;

Line 2912: OKC_CONTRACT_PUB.update_contract_header(

2908: End If;
2909: -- Go into QA hold.
2910: l_okc_hdr_tbl(1).id := p_chr_id;
2911: l_okc_hdr_tbl(1).sts_code := 'QA_HOLD';
2912: OKC_CONTRACT_PUB.update_contract_header(
2913: p_api_version => 1.0,
2914: p_init_msg_list => OKC_API.G_FALSE,
2915: x_return_status => l_return_status,
2916: x_msg_count => l_msg_count,

Line 4265: l_chrv_rec okc_contract_pub.chrv_rec_type;

4261:
4262: l_khrv_rec oks_contract_hdr_pub.khrv_rec_type;
4263: l_klnv_rec oks_contract_line_pub.klnv_rec_type;
4264:
4265: l_chrv_rec okc_contract_pub.chrv_rec_type;
4266: l_Line_Id NUMBER;
4267: --
4268: l_api_version CONSTANT NUMBER := 1.0;
4269: l_init_msg_list CONSTANT VARCHAR2(1):= 'T';

Line 4276: l_gvev_tbl_in okc_contract_pub.gvev_tbl_type;

4272: l_msg_data VARCHAR2(2000):=null;
4273: l_msg_index_out Number;
4274: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Contract';
4275: --
4276: l_gvev_tbl_in okc_contract_pub.gvev_tbl_type;
4277: e_error Exception;
4278: n NUMBER;
4279: m NUMBER;
4280: v_Index NUMBER;

Line 4369: okc_Contract_pub.delete_governance(

4365:
4366: ---------- Delete Governance --------------
4367: IF NOT l_gvev_tbl_In.COUNT=0
4368: THEN
4369: okc_Contract_pub.delete_governance(
4370: p_api_version => l_api_version,
4371: p_init_msg_list => l_init_msg_list,
4372: x_return_status => l_return_status,
4373: x_msg_count => l_msg_count,