APPS.QP_PRICE_LIST_LINE_UTIL dependencies on QP_LIST_LINES

Line 1729: UPDATE QP_LIST_LINES

1725: NULL;
1726: END;
1727: /* Proration End */
1728:
1729: UPDATE QP_LIST_LINES
1730: SET ACCRUAL_QTY = p_PRICE_LIST_LINE_rec.accrual_qty
1731: , ACCRUAL_UOM_CODE = p_PRICE_LIST_LINE_rec.accrual_uom_code
1732: , ARITHMETIC_OPERATOR = p_PRICE_LIST_LINE_rec.arithmetic_operator
1733: , ATTRIBUTE1 = p_PRICE_LIST_LINE_rec.attribute1

Line 1879: INSERT INTO QP_LIST_LINES

1875: end;
1876:
1877: /* Proration End */
1878:
1879: INSERT INTO QP_LIST_LINES
1880: ( ACCRUAL_QTY
1881: , ACCRUAL_UOM_CODE
1882: , ARITHMETIC_OPERATOR
1883: , ATTRIBUTE1

Line 2101: FROM QP_LIST_LINES

2097: BEGIN
2098:
2099: SELECT LIST_LINE_TYPE_CODE
2100: INTO L_LINE_TYPE_CODE
2101: FROM QP_LIST_LINES
2102: WHERE LIST_LINE_ID = p_list_line_id;
2103:
2104: /* delete all the related modifier lines if the line is a PBH,
2105: else delete all references of this line in qp_rltd_modifiers */

Line 2132: DELETE FROM QP_LIST_LINES

2128: DELETE FROM QP_PRICING_ATTRIBUTES
2129: WHERE LIST_LINE_ID = p_list_line_id; /* done with pricing attributes */
2130:
2131:
2132: DELETE FROM QP_LIST_LINES
2133: WHERE LIST_LINE_ID = p_list_line_id
2134: ;
2135:
2136: EXCEPTION

Line 2252: FROM QP_LIST_LINES

2248: , BREAK_UOM_CODE
2249: , BREAK_UOM_CONTEXT
2250: , BREAK_UOM_ATTRIBUTE
2251: , CONTINUOUS_PRICE_BREAK_FLAG -- Continuous price breaks
2252: FROM QP_LIST_LINES
2253: WHERE LIST_LINE_ID = p_list_line_id;
2254:
2255: /* Peformance changes for 2422019 */
2256: /*

Line 2334: FROM QP_LIST_LINES

2330: , BREAK_UOM_CODE
2331: , BREAK_UOM_CONTEXT
2332: , BREAK_UOM_ATTRIBUTE
2333: , CONTINUOUS_PRICE_BREAK_FLAG -- Continuous price breaks
2334: FROM QP_LIST_LINES
2335: WHERE LIST_HEADER_ID = p_list_header_id;
2336:
2337: BEGIN
2338:

Line 2763: FROM QP_LIST_LINES

2759: , l_PRICE_LIST_LINE_rec.break_uom_code
2760: , l_PRICE_LIST_LINE_rec.break_uom_context
2761: , l_PRICE_LIST_LINE_rec.break_uom_attribute
2762: , l_PRICE_LIST_LINE_rec.continuous_price_break_flag -- Continuous price breaks
2763: FROM QP_LIST_LINES
2764: WHERE LIST_LINE_ID = p_PRICE_LIST_LINE_rec.list_line_id
2765: FOR UPDATE NOWAIT;
2766:
2767: