APPS.OKS_CHANGE_STATUS_PVT dependencies on OKS_K_HEADERS_B

Line 220: l_wf_item_key oks_k_headers_b.wf_item_key%type;

216: l_cle_id number := NULL;
217: l_chr_id number;
218: l_init_msg_list varchar2(1) := 'N';
219: l_wf_attr_details wf_attr_details;
220: l_wf_item_key oks_k_headers_b.wf_item_key%type;
221: l_valid_flag varchar2(1) := 'Y';
222:
223: CURSOR csr_k_item_key(p_contract_id in number) IS
224: SELECT wf_item_key

Line 225: FROM oks_k_headers_b

221: l_valid_flag varchar2(1) := 'Y';
222:
223: CURSOR csr_k_item_key(p_contract_id in number) IS
224: SELECT wf_item_key
225: FROM oks_k_headers_b
226: WHERE chr_id = p_contract_id;
227:
228: begin
229: p_count := p_chrv_tbl.count;

Line 2246: Update OKS_K_headers_b

2242: Open get_hdr_tax_amt_csr;
2243: Fetch get_hdr_tax_amt_csr Into l_hdr_tax_amt;
2244: Close get_hdr_tax_amt_csr;
2245:
2246: Update OKS_K_headers_b
2247: set tax_amount = l_hdr_tax_amt
2248: Where chr_id = p_id;
2249:
2250: ---