APPS.QP_FORMULA_UTIL dependencies on QP_PRICE_FORMULAS_B

Line 691: UPDATE QP_PRICE_FORMULAS_B

687: IS
688: BEGIN
689:
690: oe_debug_pub.add('Entering proc Update_Row in Formula Util Pkg');
691: UPDATE QP_PRICE_FORMULAS_B
692: SET ATTRIBUTE1 = p_FORMULA_rec.attribute1
693: , ATTRIBUTE10 = p_FORMULA_rec.attribute10
694: , ATTRIBUTE11 = p_FORMULA_rec.attribute11
695: , ATTRIBUTE12 = p_FORMULA_rec.attribute12

Line 756: INSERT INTO QP_PRICE_FORMULAS_B

752: IS
753: BEGIN
754:
755: oe_debug_pub.add('Entering proc Insert_Row in Formula Util Pkg');
756: INSERT INTO QP_PRICE_FORMULAS_B
757: ( ATTRIBUTE1
758: , ATTRIBUTE10
759: , ATTRIBUTE11
760: , ATTRIBUTE12

Line 869: DELETE FROM QP_PRICE_FORMULAS_B

865: oe_debug_pub.add('Entering proc Delete_Row in Formula Util Pkg');
866: DELETE FROM QP_PRICE_FORMULAS_TL
867: WHERE PRICE_FORMULA_ID = p_price_formula_id;
868:
869: DELETE FROM QP_PRICE_FORMULAS_B
870: WHERE PRICE_FORMULA_ID = p_price_formula_id;
871: oe_debug_pub.add('Leaving proc Delete_Row in Formula Util Pkg');
872:
873: EXCEPTION

Line 949: FROM QP_PRICE_FORMULAS_B

945: , l_FORMULA_rec.last_update_date
946: , l_FORMULA_rec.last_update_login
947: , l_FORMULA_rec.price_formula_id
948: , l_FORMULA_rec.start_date_active
949: FROM QP_PRICE_FORMULAS_B
950: WHERE PRICE_FORMULA_ID = p_price_formula_id
951: ;
952:
953: SELECT DESCRIPTION

Line 1043: FROM QP_PRICE_FORMULAS_B

1039: , l_FORMULA_rec.last_update_date
1040: , l_FORMULA_rec.last_update_login
1041: , l_FORMULA_rec.price_formula_id
1042: , l_FORMULA_rec.start_date_active
1043: FROM QP_PRICE_FORMULAS_B
1044: WHERE PRICE_FORMULA_ID = p_FORMULA_rec.price_formula_id
1045: FOR UPDATE NOWAIT;
1046:
1047: -- Row locked. Compare IN attributes to DB attributes.