APPS.OKC_QA_PRICE_PVT dependencies on OKC_K_HEADERS_B

Line 19: l_application_id okc_k_headers_b.application_id%TYPE;

15: l_control_rec OKC_PRICE_PUB.PRICE_CONTROL_REC_TYPE;
16: l_msg_count NUMBER;
17: l_msg_data VARCHAR2(240);
18: l_return_status VARCHAR2(3);
19: l_application_id okc_k_headers_b.application_id%TYPE;
20: l_estimated_price okc_k_headers_b.estimated_amount%TYPE;
21: l_chr_net_price NUMBER;
22: l_buy_or_sell VARCHAR2(1);
23: l_orig_system_source_code VARCHAR2(30);

Line 20: l_estimated_price okc_k_headers_b.estimated_amount%TYPE;

16: l_msg_count NUMBER;
17: l_msg_data VARCHAR2(240);
18: l_return_status VARCHAR2(3);
19: l_application_id okc_k_headers_b.application_id%TYPE;
20: l_estimated_price okc_k_headers_b.estimated_amount%TYPE;
21: l_chr_net_price NUMBER;
22: l_buy_or_sell VARCHAR2(1);
23: l_orig_system_source_code VARCHAR2(30);
24: l_price_qa_check_yn VARCHAR2(1):= 'N' ;

Line 31: from okc_k_headers_b

27: select application_id,
28: estimated_amount,
29: buy_or_sell,
30: orig_system_source_code
31: from okc_k_headers_b
32: where id = p_chr_id;
33:
34: -- execute price QA check for KOL (hdr.orig_system_source_code = 'KSSA_HDR)If there is
35: -- at least one one line(top or sub line).

Line 41: OKC_K_HEADERS_B hdr

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;
45: rec_orig_sys_sourc_csr orig_sys_sourc_csr%ROWTYPE ;

Line 230: p_chr_id IN okc_k_headers_b.ID%TYPE,

226: End Check_Price;
227: --
228:
229: PROCEDURE check_covered_line_qty (
230: p_chr_id IN okc_k_headers_b.ID%TYPE,
231: x_return_status OUT NOCOPY VARCHAR2) IS
232:
233:
234:

Line 239: l_application_id okc_k_headers_b.application_id%TYPE;

235: l_cle_price_tbl OKC_PRICE_PVT.CLE_PRICE_TBL_TYPE;
236: l_msg_count NUMBER;
237: l_msg_data VARCHAR2(240);
238: l_return_status VARCHAR2(3);
239: l_application_id okc_k_headers_b.application_id%TYPE;
240: l_buy_or_sell VARCHAR2(1);
241: l_orig_system_source_code VARCHAR2(30);
242: l_new_qa_check_yn VARCHAR2(1):= 'N' ;
243: --

Line 248: from okc_k_headers_b

244: cursor k_csr is
245: select application_id,
246: buy_or_sell,
247: orig_system_source_code
248: from okc_k_headers_b
249: where id = p_chr_id;
250:
251: -- execute new QA check for KOL (hdr.orig_system_source_code = 'KSSA_HDR)If there is
252: -- at least one one line(top or sub line).

Line 258: OKC_K_HEADERS_B hdr

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;
262: rec_orig_sys_sourc_csr orig_sys_sourc_csr%ROWTYPE ;

Line 290: (p_chr_id IN okc_k_headers_b.ID%TYPE,

286: --
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,