APPS.OKC_QA_PRICE_PVT dependencies on OKC_K_LINES_B

Line 40: FROM OKC_K_LINES_B cle,

36: -- If there is NO top or sub line exists , skip price QA check for KOL.
37: ---
38: CURSOR orig_sys_sourc_csr IS
39: SELECT hdr.orig_system_source_code, cle.ID
40: FROM OKC_K_LINES_B cle,
41: OKC_K_HEADERS_B hdr
42: WHERE hdr.id = p_chr_id
43: AND hdr.id = cle.dnz_chr_id (+)
44: AND ROWNUM < 2;

Line 257: FROM OKC_K_LINES_B cle,

253: -- If there is NO top or sub line exists , skip new QA check for KOL.
254: ---
255: CURSOR orig_sys_sourc_csr IS
256: SELECT hdr.orig_system_source_code, cle.ID
257: FROM OKC_K_LINES_B cle,
258: OKC_K_HEADERS_B hdr
259: WHERE hdr.id = p_chr_id
260: AND hdr.id = cle.dnz_chr_id (+)
261: AND ROWNUM < 2;

Line 291: p_cle_id IN okc_k_lines_b.ID%TYPE,

287: -- Comments: This procedure is to be called only by QA
288:
289: PROCEDURE validate_covered_line_qty
290: (p_chr_id IN okc_k_headers_b.ID%TYPE,
291: p_cle_id IN okc_k_lines_b.ID%TYPE,
292: p_l_id_tbl IN num_tbl_type,
293: p_l_cle_id_tbl IN num_tbl_type,
294: p_l_line_number_tbl IN char_tbl_type,
295: x_return_status OUT NOCOPY VARCHAR2

Line 323: l_parent_cle_id OKC_K_LINES_B.ID%TYPE;

319: l_return_status VARCHAR2(1);
320:
321: l_qty1 NUMBER := OKC_API.G_MISS_NUM;
322: l_qty2 NUMBER := OKC_API.G_MISS_NUM;
323: l_parent_cle_id OKC_K_LINES_B.ID%TYPE;
324: l_line_number OKC_K_LINES_B.LINE_NUMBER%TYPE := '0';
325: l_parent_line_number OKC_K_LINES_B.LINE_NUMBER%TYPE := '0';
326: i PLS_INTEGER := 0;
327: l_top_line_id NUMBER := OKC_API.G_MISS_NUM;

Line 324: l_line_number OKC_K_LINES_B.LINE_NUMBER%TYPE := '0';

320:
321: l_qty1 NUMBER := OKC_API.G_MISS_NUM;
322: l_qty2 NUMBER := OKC_API.G_MISS_NUM;
323: l_parent_cle_id OKC_K_LINES_B.ID%TYPE;
324: l_line_number OKC_K_LINES_B.LINE_NUMBER%TYPE := '0';
325: l_parent_line_number OKC_K_LINES_B.LINE_NUMBER%TYPE := '0';
326: i PLS_INTEGER := 0;
327: l_top_line_id NUMBER := OKC_API.G_MISS_NUM;
328:

Line 325: l_parent_line_number OKC_K_LINES_B.LINE_NUMBER%TYPE := '0';

321: l_qty1 NUMBER := OKC_API.G_MISS_NUM;
322: l_qty2 NUMBER := OKC_API.G_MISS_NUM;
323: l_parent_cle_id OKC_K_LINES_B.ID%TYPE;
324: l_line_number OKC_K_LINES_B.LINE_NUMBER%TYPE := '0';
325: l_parent_line_number OKC_K_LINES_B.LINE_NUMBER%TYPE := '0';
326: i PLS_INTEGER := 0;
327: l_top_line_id NUMBER := OKC_API.G_MISS_NUM;
328:
329: BEGIN

Line 575: FROM okc_k_lines_b

571: END IF;
572:
573: SELECT cle_id, id, line_number, lse_id
574: BULK COLLECT INTO l_cle_id_tbl,l_id_tbl, l_line_number_tbl, l_lse_id_tbl
575: FROM okc_k_lines_b
576: CONNECT BY PRIOR id = cle_id
577: START WITH chr_id = p_chr_id;
578: IF (l_debug = 'Y') THEN
579: okc_debug.Log('1060 : select rowcount'||SQL%ROWCOUNT, 1);