APPS.OKS_AUTH_UTIL_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 7978: FROM okc_k_headers_all_b a, okc_k_lines_b b,

7974: nvl(a.estimated_amount, 0) hdr_amt,
7975: SUM(nvl(b.price_negotiated,0)) sum_tl_line_amt,
7976: nvl(c.tax_amount,0) hdr_tax_amt,
7977: SUM(nvl(d.tax_amount,0)) sum_tl_line_amt_tax
7978: FROM okc_k_headers_all_b a, okc_k_lines_b b,
7979: oks_k_headers_b c, oks_k_lines_b d
7980: WHERE a.id = cp_chr_id
7981: AND b.dnz_chr_id = a.id AND b.cle_id IS NULL
7982: AND d.dnz_chr_id = c.chr_id AND d.cle_id=b.id

Line 7989: FROM okc_k_headers_all_b WHERE id = cp_chr_id

7985: GROUP BY a.contract_number, a.contract_number_modifier, a.estimated_amount,c.tax_amount;
7986:
7987: CURSOR c_lock_hdr(cp_chr_id IN NUMBER) IS
7988: SELECT estimated_amount
7989: FROM okc_k_headers_all_b WHERE id = cp_chr_id
7990: FOR UPDATE OF estimated_amount NOWAIT;
7991:
7992: -- select all the toplines which has cancelled amount not equal to those of sublines
7993: CURSOR c_k_toplines_cancelled (cp_chr_id IN NUMBER) IS

Line 8009: FROM okc_k_headers_all_b a, okc_k_lines_b b

8005: CURSOR c_k_hdr_cancelled(cp_chr_id IN NUMBER) IS
8006: SELECT
8007: nvl(a.cancelled_amount, 0) hdr_cancelled_amt,
8008: SUM(nvl(b.cancelled_amount,0)) sum_tl_line_cancelled_amt
8009: FROM okc_k_headers_all_b a, okc_k_lines_b b
8010: WHERE a.id = cp_chr_id
8011: AND b.dnz_chr_id = a.id AND b.cle_id IS NULL
8012: AND b.lse_id IN (1,12,14,19,46)
8013: GROUP BY a.cancelled_amount;

Line 8140: UPDATE okc_k_headers_all_b

8136: FETCH c_lock_hdr INTO l_dummy;
8137: CLOSE c_lock_hdr;
8138:
8139: IF (l_hdr_amt <> l_tl_amt) THEN
8140: UPDATE okc_k_headers_all_b
8141: SET estimated_amount = l_tl_amt
8142: WHERE id = p_chr_id;
8143: END IF;
8144:

Line 8269: update okc_k_headers_all_b

8265: OPEN c_lock_hdr(p_chr_id);
8266: FETCH c_lock_hdr INTO l_dummy;
8267: CLOSE c_lock_hdr;
8268:
8269: update okc_k_headers_all_b
8270: set cancelled_amount = l_topline_cancelled
8271: where id=p_chr_id;
8272:
8273: EXCEPTION