APPS.QP_FORMULA_UTIL dependencies on QP_PRICE_FORMULAS_TL

Line 720: UPDATE QP_PRICE_FORMULAS_TL

716: , START_DATE_ACTIVE = p_FORMULA_rec.start_date_active
717: WHERE PRICE_FORMULA_ID = p_FORMULA_rec.price_formula_id
718: ;
719:
720: UPDATE QP_PRICE_FORMULAS_TL
721: SET DESCRIPTION = p_FORMULA_rec.description
722: , SOURCE_LANG = userenv('LANG')
723: , LAST_UPDATED_BY = p_FORMULA_rec.last_updated_by
724: , LAST_UPDATE_DATE = p_FORMULA_rec.last_update_date

Line 811: INSERT INTO QP_PRICE_FORMULAS_TL

807: , p_FORMULA_rec.price_formula_id
808: , p_FORMULA_rec.start_date_active
809: );
810:
811: INSERT INTO QP_PRICE_FORMULAS_TL
812: ( CREATED_BY
813: , CREATION_DATE
814: , DESCRIPTION
815: , LANGUAGE

Line 836: FROM QP_PRICE_FORMULAS_TL T

832: , userenv('LANG')
833: FROM FND_LANGUAGES L
834: WHERE L.INSTALLED_FLAG IN ('I', 'B')
835: AND NOT EXISTS (SELECT NULL
836: FROM QP_PRICE_FORMULAS_TL T
837: WHERE T.PRICE_FORMULA_ID = p_FORMULA_rec.price_formula_id
838: AND T.LANGUAGE = L.LANGUAGE_CODE);
839:
840: oe_debug_pub.add('Leaving proc Insert_Row in Formula Util Pkg');

Line 866: DELETE FROM QP_PRICE_FORMULAS_TL

862: IS
863: BEGIN
864:
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;

Line 957: FROM QP_PRICE_FORMULAS_TL

953: SELECT DESCRIPTION
954: , NAME
955: INTO l_FORMULA_rec.description
956: , l_FORMULA_rec.name
957: FROM QP_PRICE_FORMULAS_TL
958: WHERE PRICE_FORMULA_ID = p_price_formula_id
959: AND LANGUAGE = userenv('LANG');
960:
961: oe_debug_pub.add('Leaving proc Query_Row in Formula Util Pkg');