APPS.QP_PRICING_ATTR_UTIL dependencies on QP_PTE_SEGMENTS

Line 1537: UPDATE qp_pte_segments set used_in_setup='Y'

1533:
1534: IF(p_PRICING_ATTR_rec.pricing_attribute_context IS NOT NULL) AND
1535: (p_PRICING_ATTR_rec.pricing_attribute IS NOT NULL) THEN
1536:
1537: UPDATE qp_pte_segments set used_in_setup='Y'
1538: WHERE nvl(used_in_setup,'N')='N'
1539: AND segment_id IN
1540: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1541: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.pricing_attribute

Line 1551: UPDATE qp_pte_segments set used_in_setup='Y'

1547:
1548: IF(p_PRICING_ATTR_rec.product_attribute_context IS NOT NULL) AND
1549: (p_PRICING_ATTR_rec.product_attribute IS NOT NULL) THEN
1550:
1551: UPDATE qp_pte_segments set used_in_setup='Y'
1552: WHERE nvl(used_in_setup,'N')='N'
1553: AND segment_id IN
1554: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1555: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.product_attribute

Line 1801: UPDATE qp_pte_segments set used_in_setup='Y'

1797: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1798: IF(p_PRICING_ATTR_rec.pricing_attribute_context IS NOT NULL) AND
1799: (p_PRICING_ATTR_rec.pricing_attribute IS NOT NULL) THEN
1800:
1801: UPDATE qp_pte_segments set used_in_setup='Y'
1802: WHERE nvl(used_in_setup,'N')='N'
1803: AND segment_id IN
1804: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1805: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.pricing_attribute

Line 1816: UPDATE qp_pte_segments set used_in_setup='Y'

1812:
1813: IF(p_PRICING_ATTR_rec.product_attribute_context IS NOT NULL) AND
1814: (p_PRICING_ATTR_rec.product_attribute IS NOT NULL) THEN
1815:
1816: UPDATE qp_pte_segments set used_in_setup='Y'
1817: WHERE nvl(used_in_setup,'N')='N'
1818: AND segment_id IN
1819: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1820: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.product_attribute