APPS.OKC_CFG_PUB dependencies on OKC_K_HEADERS_B

Line 184: -- To get pricing date from OKC_K_HEADERS_B -- Added for Bug 2393302

180: FROM okc_k_lines_b cleb
181: WHERE cleb.id = l_line_id;
182:
183: -- -------------------------------------------------------------------------
184: -- To get pricing date from OKC_K_HEADERS_B -- Added for Bug 2393302
185: -- -------------------------------------------------------------------------
186: CURSOR cur_hdr_pr_date ( l_dnz_chr_id NUMBER )
187: IS
188: SELECT chrv.pricing_date

Line 189: FROM okc_k_headers_b chrv

185: -- -------------------------------------------------------------------------
186: CURSOR cur_hdr_pr_date ( l_dnz_chr_id NUMBER )
187: IS
188: SELECT chrv.pricing_date
189: FROM okc_k_headers_b chrv
190: WHERE chrv.id = l_dnz_chr_id;
191:
192: -- -------------------------------------------------------------------------
193: -- To get price list id. Required to default value for config lines.

Line 1421: l_app_id OKC_K_HEADERS_B.application_id%TYPE;

1417: l_msg_token VARCHAR2(300);
1418: l_line_index VARCHAR2(200);
1419: l_return_status VARCHAR2(1);
1420:
1421: l_app_id OKC_K_HEADERS_B.application_id%TYPE;
1422: l_buy_or_sell OKC_K_HEADERS_B.buy_or_sell%TYPE;
1423: l_valid OKC_K_LINES_B.config_valid_yn%TYPE;
1424: l_complete OKC_K_LINES_B.config_complete_yn%TYPE;
1425:

Line 1422: l_buy_or_sell OKC_K_HEADERS_B.buy_or_sell%TYPE;

1418: l_line_index VARCHAR2(200);
1419: l_return_status VARCHAR2(1);
1420:
1421: l_app_id OKC_K_HEADERS_B.application_id%TYPE;
1422: l_buy_or_sell OKC_K_HEADERS_B.buy_or_sell%TYPE;
1423: l_valid OKC_K_LINES_B.config_valid_yn%TYPE;
1424: l_complete OKC_K_LINES_B.config_complete_yn%TYPE;
1425:
1426: -- -----------------------------------------------------

Line 1433: FROM okc_k_headers_b

1429: CURSOR get_k_app_id
1430: IS
1431: SELECT application_id,
1432: buy_or_sell
1433: FROM okc_k_headers_b
1434: WHERE id = p_chr_id;
1435:
1436: -- -----------------------------------------------------
1437: -- Get configured models count from the contract.