APPS.OKC_CFG_PUB dependencies on OKC_K_LINES_B

Line 114: FROM okc_k_lines_b cleb

110: l_config_rev_nbr NUMBER,
111: l_top_model_line_id NUMBER,
112: l_dnz_chr_id NUMBER) IS
113: SELECT cleb.id
114: FROM okc_k_lines_b cleb
115: WHERE cleb.dnz_chr_id = l_dnz_chr_id
116: AND cleb.id <> l_top_model_line_id
117: AND cleb.config_header_id = l_config_hdr_id
118: AND cleb.config_revision_number = l_config_rev_nbr;

Line 141: FROM okc_k_lines_b cleb,

137: cim.object1_id2 id2,
138: cleb.price_list_id price_list_id,
139: cleb.dnz_chr_id dnz_chr_id,
140: cleb.pricing_date pricing_date -- Added for Bug 2393302
141: FROM okc_k_lines_b cleb,
142: okc_k_items cim
143: WHERE cleb.dnz_chr_id = l_dnz_chr_id
144: AND cleb.config_header_id = l_config_hdr_id
145: AND cleb.config_revision_number = l_config_rev_nbr

Line 161: FROM okc_k_lines_b cleb

157: l_config_hdr_id NUMBER,
158: l_config_rev_nbr NUMBER) IS
159: SELECT cleb.id top_model_id,
160: cleb.config_top_model_line_id top_model_line_id
161: FROM okc_k_lines_b cleb
162: WHERE cleb.dnz_chr_id = l_dnz_chr_id
163: AND cleb.config_header_id = l_config_hdr_id
164: AND cleb.config_revision_number = l_config_rev_nbr
165: AND cleb.config_item_type = 'TOP_MODEL_LINE';

Line 180: FROM okc_k_lines_b cleb

176: SELECT cleb.cle_id,
177: cleb.chr_id,
178: cleb.line_number,
179: cleb.display_sequence
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

Line 199: FROM okc_k_lines_b clev

195: -- -------------------------------------------------------------------------
196: CURSOR cur_pr_list ( l_line_id NUMBER )
197: IS
198: SELECT clev.price_list_id,clev.pricing_date
199: FROM okc_k_lines_b clev
200: WHERE clev.id = l_line_id;
201:
202: /* Commented for Bug 2393302
203: -- -------------------------------------------------------------------------

Line 209: FROM okc_k_lines_b clev

205: -- -------------------------------------------------------------------------
206: CURSOR cur_pr_list ( l_line_id NUMBER )
207: IS
208: SELECT clev.price_list_id
209: FROM okc_k_lines_b clev
210: WHERE clev.id = l_line_id;
211: */
212:
213: -- -------------------------------------------------------------------------

Line 1423: l_valid OKC_K_LINES_B.config_valid_yn%TYPE;

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: -- -----------------------------------------------------
1427: -- Get application Ids to activate config qa check.

Line 1424: l_complete OKC_K_LINES_B.config_complete_yn%TYPE;

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: -- -----------------------------------------------------
1427: -- Get application Ids to activate config qa check.
1428: -- -----------------------------------------------------

Line 1446: FROM okc_k_lines_b clev

1442: -- -----------------------------------------------------
1443: CURSOR get_cfg_count
1444: IS
1445: SELECT count(clev.id)
1446: FROM okc_k_lines_b clev
1447: WHERE clev.dnz_chr_id = p_chr_id
1448: AND clev.config_item_type = 'TOP_MODEL_LINE'
1449: AND ( NVL(clev.config_valid_yn,'Y') = 'N'
1450: OR NVL(clev.config_complete_yn,'Y') = 'N');

Line 1463: FROM okc_k_lines_b clev

1459: IS
1460: SELECT clev.id,
1461: clev.config_valid_yn,
1462: clev.config_complete_yn
1463: FROM okc_k_lines_b clev
1464: WHERE clev.dnz_chr_id = p_chr_id
1465: AND clev.config_item_type = 'TOP_MODEL_LINE'
1466: AND ( NVL(clev.config_valid_yn,'Y') = 'N'
1467: OR NVL(clev.config_complete_yn,'Y') = 'N');

Line 1709: FROM okc_k_lines_b

1705: CURSOR cur_line_details (p_top_model_line_id NUMBER)
1706: IS
1707: SELECT dnz_chr_id,
1708: price_list_id
1709: FROM okc_k_lines_b
1710: WHERE id = p_top_model_line_id;
1711:
1712: CURSOR cur_get_hdr_det (p_chr_id NUMBER)
1713: IS

Line 2185: UPDATE okc_k_lines_b

2181: END IF;
2182: END IF; -- End display all the returned info in debug mode
2183:
2184:
2185: UPDATE okc_k_lines_b
2186: SET config_top_model_line_id = l_top_model_line_id,
2187: config_header_id = x_cfg_hdr_id,
2188: config_revision_number = x_cfg_rev_nbr
2189: WHERE dnz_chr_id = p_dnz_chr_id

Line 2210: UPDATE okc_k_lines_b

2206: END IF;
2207:
2208: IF x_orig_item_id_tbl.COUNT > 0 THEN
2209: FOR i IN x_orig_item_id_tbl.FIRST..x_orig_item_id_tbl.LAST LOOP
2210: UPDATE okc_k_lines_b
2211: SET config_item_id = x_new_item_id_tbl(i)
2212: WHERE
2213: dnz_chr_id = p_dnz_chr_id
2214: AND config_header_id = x_cfg_hdr_id