DBA Data[Home] [Help]

APPS.QP_FORMULA_LINES_UTIL dependencies on QP_PTE_SEGMENTS

Line 864: UPDATE qp_pte_segments SET used_in_setup='Y'

860: oe_debug_pub.add('Leaving proc Update_Row in FormulaLines Util Pkg');
861:
862: IF(p_FORMULA_LINES_rec.pricing_attribute_context IS NOT NULL) AND
863: (p_FORMULA_LINES_rec.pricing_attribute IS NOT NULL) THEN
864: UPDATE qp_pte_segments SET used_in_setup='Y'
865: WHERE nvl(used_in_setup,'N')='N'
866: AND segment_id IN
867: (SELECT a.segment_id
868: FROM qp_segments_b a,qp_prc_contexts_b b

Line 973: UPDATE qp_pte_segments SET used_in_setup='Y'

969: oe_debug_pub.add('Leaving proc Insert_Row in FormulaLines Util Pkg');
970:
971: IF(p_FORMULA_LINES_rec.pricing_attribute_context IS NOT NULL) AND
972: (p_FORMULA_LINES_rec.pricing_attribute IS NOT NULL) THEN
973: UPDATE qp_pte_segments SET used_in_setup='Y'
974: WHERE nvl(used_in_setup,'N')='N'
975: AND segment_id IN
976: (SELECT a.segment_id
977: FROM qp_segments_b a,qp_prc_contexts_b b