APPS.OKS_QP_PKG dependencies on OKC_PRICE_ADJUSTMENTS

Line 35: FROM okc_price_adjustments

31: END IF;
32:
33: SELECT COUNT (1)
34: INTO l_found
35: FROM okc_price_adjustments
36: WHERE chr_id = p_chr_id;
37:
38: IF l_found > 0
39: THEN

Line 234: FROM okc_price_adjustments

230: p_list_line_id IN NUMBER
231: )
232: IS
233: SELECT *
234: FROM okc_price_adjustments
235: WHERE cle_id = p_cle_id AND
236: list_line_id = p_list_line_id;
237:
238: CURSOR chk_price (

Line 243: FROM okc_price_adjustments

239: p_cle_id IN NUMBER
240: )
241: IS
242: SELECT *
243: FROM okc_price_adjustments
244: WHERE cle_id = p_cle_id;
245:
246: l_api_name CONSTANT VARCHAR2 (30)
247: := 'modifier_handling';

Line 283: FROM okc_price_adjustments

279: cp_topline_id NUMBER
280: )
281: IS
282: SELECT 1
283: FROM okc_price_adjustments
284: WHERE cle_id = cp_topline_id AND
285: list_line_id = p_list_line_id;
286:
287: --- find modifier for header

Line 293: FROM okc_price_adjustments

289: cp_hdr_id NUMBER
290: )
291: IS
292: SELECT 1
293: FROM okc_price_adjustments
294: WHERE chr_id = cp_hdr_id AND
295: cle_id IS NULL AND
296: list_line_id = p_list_line_id;
297:

Line 398: UPDATE okc_price_adjustments

394: INTO price_rec;
395:
396: IF (cur_price%FOUND)
397: THEN
398: UPDATE okc_price_adjustments
399: SET adjusted_amount =
400: p_modifier_details (i).adjustment_amount,
401: arithmetic_operator =
402: p_modifier_details (i).operand_calculation_code,

Line 508: DELETE FROM okc_price_adjustments

504: END IF; --I Check
505:
506: IF (l_flag = FALSE)
507: THEN
508: DELETE FROM okc_price_adjustments
509: WHERE cle_id = p_cle_id AND
510: list_line_id = cur.list_line_id;
511: END IF;
512: END LOOP;

Line 635: FROM okc_price_adjustments

631: modifier_mechanism_type_code,
632: automatic_flag,
633: arithmetic_operator,
634: operand
635: FROM okc_price_adjustments
636: WHERE chr_id = p_chr_id AND
637: cle_id IS NULL AND
638: NVL (automatic_flag, 'N') = 'N';
639:

Line 1039: FROM okc_price_adjustments

1035: modifier_mechanism_type_code,
1036: automatic_flag,
1037: arithmetic_operator,
1038: operand
1039: FROM okc_price_adjustments
1040: WHERE cle_id = p_cle_id AND
1041: NVL (automatic_flag, 'N') = 'N';
1042:
1043: l_req_line_detail_rec2 qp_preq_grp.line_detail_rec_type;