APPS.OKS_AUTH_UTIL_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 8660: FROM okc_k_headers_all_b a, okc_k_lines_b b,

8656: nvl(a.estimated_amount, 0) hdr_amt,
8657: SUM(nvl(b.price_negotiated,0)) sum_tl_line_amt,
8658: nvl(c.tax_amount,0) hdr_tax_amt,
8659: SUM(nvl(d.tax_amount,0)) sum_tl_line_amt_tax
8660: FROM okc_k_headers_all_b a, okc_k_lines_b b,
8661: oks_k_headers_b c, oks_k_lines_b d
8662: WHERE a.id = cp_chr_id
8663: AND b.dnz_chr_id = a.id AND b.cle_id IS NULL
8664: AND d.dnz_chr_id = c.chr_id AND d.cle_id=b.id

Line 8676: FROM okc_k_headers_all_b a,

8672: nvl(a.estimated_amount, 0) hdr_amt,
8673: 0 sum_tl_line_amt,
8674: nvl(c.tax_amount,0) hdr_tax_amt,
8675: 0 sum_tl_line_amt_tax
8676: FROM okc_k_headers_all_b a,
8677: oks_k_headers_b c
8678: WHERE a.id = cp_chr_id
8679: AND c.chr_id = a.id
8680: AND NOT EXISTS (SELECT 1 from okc_k_lines_b b

Line 8688: FROM okc_k_headers_all_b WHERE id = cp_chr_id

8684: AND b.lse_id IN (1,12,14,19,46));
8685:
8686: CURSOR c_lock_hdr(cp_chr_id IN NUMBER) IS
8687: SELECT estimated_amount
8688: FROM okc_k_headers_all_b WHERE id = cp_chr_id
8689: FOR UPDATE OF estimated_amount NOWAIT;
8690:
8691: -- select all the toplines which has cancelled amount not equal to those of sublines
8692: CURSOR c_k_toplines_cancelled (cp_chr_id IN NUMBER) IS

Line 8708: FROM okc_k_headers_all_b a, okc_k_lines_b b

8704: CURSOR c_k_hdr_cancelled(cp_chr_id IN NUMBER) IS
8705: SELECT
8706: nvl(a.cancelled_amount, 0) hdr_cancelled_amt,
8707: SUM(nvl(b.cancelled_amount,0)) sum_tl_line_cancelled_amt
8708: FROM okc_k_headers_all_b a, okc_k_lines_b b
8709: WHERE a.id = cp_chr_id
8710: AND b.dnz_chr_id = a.id AND b.cle_id IS NULL
8711: AND b.lse_id IN (1,12,14,19,46)
8712: GROUP BY a.cancelled_amount;

Line 8922: UPDATE okc_k_headers_all_b

8918: FETCH c_lock_hdr INTO l_dummy;
8919: CLOSE c_lock_hdr;
8920:
8921: IF (l_hdr_amt <> l_tl_amt) THEN
8922: UPDATE okc_k_headers_all_b
8923: SET estimated_amount = l_tl_amt
8924: WHERE id = p_chr_id;
8925: END IF;
8926:

Line 8979: UPDATE okc_k_headers_all_b

8975: FETCH c_lock_hdr INTO l_dummy;
8976: CLOSE c_lock_hdr;
8977:
8978: IF (l_hdr_amt <> l_tl_amt) THEN
8979: UPDATE okc_k_headers_all_b
8980: SET estimated_amount = l_tl_amt
8981: WHERE id = p_chr_id;
8982: END IF;
8983:

Line 9109: update okc_k_headers_all_b

9105: OPEN c_lock_hdr(p_chr_id);
9106: FETCH c_lock_hdr INTO l_dummy;
9107: CLOSE c_lock_hdr;
9108:
9109: update okc_k_headers_all_b
9110: set cancelled_amount = l_topline_cancelled
9111: where id=p_chr_id;
9112:
9113: EXCEPTION

Line 9520: FROM okc_k_headers_all_b

9516: l_api_name CONSTANT VARCHAR2(30) := 'GET_K_DETAILS';
9517:
9518: CURSOR l_okc_chr_csr(p_id NUMBER) IS
9519: SELECT ID, object_version_number
9520: FROM okc_k_headers_all_b
9521: WHERE ID = p_id;
9522:
9523: CURSOR l_okc_cle_csr(p_id NUMBER) IS
9524: SELECT ID, object_version_number FROM okc_k_lines_b WHERE ID = p_id;

Line 9613: FROM okc_k_headers_all_b

9609: x_return_status := OKC_API.G_RET_STS_SUCCESS;
9610: /*
9611: SELECT Nvl(conversion_rate, 1)
9612: INTO l_old_conversion_rate
9613: FROM okc_k_headers_all_b
9614: WHERE id = p_chr_id;*/
9615:
9616: l_old_conversion_rate:= Nvl(p_old_conversion_rate,1);
9617: