APPS.OE_PRICE_BREAK_UTIL dependencies on OE_PRICE_BREAK_LINES

Line 785: UPDATE OE_PRICE_BREAK_LINES

781: )
782: IS
783: BEGIN
784:
785: UPDATE OE_PRICE_BREAK_LINES
786: SET AMOUNT = p_Price_Break_rec.amount
787: , ATTRIBUTE1 = p_Price_Break_rec.attribute1
788: , ATTRIBUTE10 = p_Price_Break_rec.attribute10
789: , ATTRIBUTE11 = p_Price_Break_rec.attribute11

Line 851: INSERT INTO OE_PRICE_BREAK_LINES

847: )
848: IS
849: BEGIN
850:
851: INSERT INTO OE_PRICE_BREAK_LINES
852: ( AMOUNT
853: , ATTRIBUTE1
854: , ATTRIBUTE10
855: , ATTRIBUTE11

Line 953: DELETE FROM OE_PRICE_BREAK_LINES

949: )
950: IS
951: BEGIN
952:
953: DELETE FROM OE_PRICE_BREAK_LINES
954: WHERE DISCOUNT_LINE_ID = p_discount_line_id
955: AND METHOD_TYPE_CODE = p_method_type_code
956: AND PRICE_BREAK_LINES_HIGH_RANGE = p_price_break_high
957: AND PRICE_BREAK_LINES_LOW_RANGE = p_price_break_low

Line 1050: FROM OE_PRICE_BREAK_LINES

1046: , PROGRAM_UPDATE_DATE
1047: , REQUEST_ID
1048: , START_DATE_ACTIVE
1049: , UNIT_CODE
1050: FROM OE_PRICE_BREAK_LINES
1051: WHERE ( DISCOUNT_LINE_ID = p_discount_line_id
1052: AND METHOD_TYPE_CODE = p_method_type_code
1053: AND PRICE_BREAK_LINES_HIGH_RANGE = p_price_break_high
1054: AND PRICE_BREAK_LINES_LOW_RANGE = p_price_break_low

Line 1273: FROM OE_PRICE_BREAK_LINES

1269: , l_Price_Break_rec.program_update_date
1270: , l_Price_Break_rec.request_id
1271: , l_Price_Break_rec.start_date_active
1272: , l_Price_Break_rec.unit_code
1273: FROM OE_PRICE_BREAK_LINES
1274: WHERE DISCOUNT_LINE_ID = p_Price_Break_rec.discount_line_id
1275: AND METHOD_TYPE_CODE = p_Price_Break_rec.method_type_code
1276: AND PRICE_BREAK_LINES_HIGH_RANGE = p_Price_Break_rec.price_break_high
1277: AND PRICE_BREAK_LINES_LOW_RANGE = p_Price_Break_rec.price_break_low