APPS.QP_FORMULA_LINES_UTIL dependencies on QP_PRICE_FORMULA_LINES

Line 823: UPDATE QP_PRICE_FORMULA_LINES

819: IS
820: BEGIN
821:
822: oe_debug_pub.add('Entering proc Update_Row in FormulaLines Util Pkg');
823: UPDATE QP_PRICE_FORMULA_LINES
824: SET ATTRIBUTE1 = p_FORMULA_LINES_rec.attribute1
825: , ATTRIBUTE10 = p_FORMULA_LINES_rec.attribute10
826: , ATTRIBUTE11 = p_FORMULA_LINES_rec.attribute11
827: , ATTRIBUTE12 = p_FORMULA_LINES_rec.attribute12

Line 898: INSERT INTO QP_PRICE_FORMULA_LINES

894: IS
895: BEGIN
896:
897: oe_debug_pub.add('Entering proc Insert_Row in FormulaLines Util Pkg');
898: INSERT INTO QP_PRICE_FORMULA_LINES
899: ( ATTRIBUTE1
900: , ATTRIBUTE10
901: , ATTRIBUTE11
902: , ATTRIBUTE12

Line 1008: DELETE FROM QP_PRICE_FORMULA_LINES

1004: IS
1005: BEGIN
1006:
1007: oe_debug_pub.add('Entering proc Delete_Row in FormulaLines Util Pkg');
1008: DELETE FROM QP_PRICE_FORMULA_LINES
1009: WHERE PRICE_FORMULA_LINE_ID = p_price_formula_line_id
1010: ;
1011:
1012: oe_debug_pub.add('Leaving proc Delete_Row in FormulaLines Util Pkg');

Line 1094: FROM QP_PRICE_FORMULA_LINES

1090: , PRICING_ATTRIBUTE_CONTEXT
1091: , START_DATE_ACTIVE
1092: , STEP_NUMBER
1093: , REQD_FLAG
1094: FROM QP_PRICE_FORMULA_LINES
1095: WHERE ( PRICE_FORMULA_LINE_ID = p_price_formula_line_id
1096: )
1097: OR ( PRICE_FORMULA_ID = p_price_formula_id
1098: );

Line 1286: FROM QP_PRICE_FORMULA_LINES

1282: , l_FORMULA_LINES_rec.pricing_attribute_context
1283: , l_FORMULA_LINES_rec.start_date_active
1284: , l_FORMULA_LINES_rec.step_number
1285: , l_FORMULA_LINES_rec.reqd_flag
1286: FROM QP_PRICE_FORMULA_LINES
1287: WHERE PRICE_FORMULA_LINE_ID = p_FORMULA_LINES_rec.price_formula_line_id
1288: FOR UPDATE NOWAIT;
1289:
1290: -- Row locked. Compare IN attributes to DB attributes.