APPS.OKS_CHANGE_STATUS_PVT dependencies on OKS_K_HEADERS_B

Line 251: l_wf_item_key oks_k_headers_b.wf_item_key%type;

247: l_cle_id number := NULL;
248: l_chr_id number;
249: l_init_msg_list varchar2(1) := 'N';
250: l_wf_attr_details wf_attr_details;
251: l_wf_item_key oks_k_headers_b.wf_item_key%type;
252: l_valid_flag varchar2(1) := 'Y';
253:
254: CURSOR csr_k_item_key(p_contract_id in number) IS
255: SELECT wf_item_key

Line 256: FROM oks_k_headers_b

252: l_valid_flag varchar2(1) := 'Y';
253:
254: CURSOR csr_k_item_key(p_contract_id in number) IS
255: SELECT wf_item_key
256: FROM oks_k_headers_b
257: WHERE chr_id = p_contract_id;
258:
259: begin
260: p_count := p_chrv_tbl.count;

Line 2412: Update OKS_K_headers_b

2408: Open get_hdr_tax_amt_csr;
2409: Fetch get_hdr_tax_amt_csr Into l_hdr_tax_amt;
2410: Close get_hdr_tax_amt_csr;
2411:
2412: Update OKS_K_headers_b
2413: set tax_amount = l_hdr_tax_amt
2414: Where chr_id = p_id;
2415:
2416: ---