APPS.QP_PLL_PRICING_ATTR_UTIL dependencies on QP_PTE_SEGMENTS

Line 1246: UPDATE qp_pte_segments set used_in_setup='Y'

1242:
1243: IF(p_PRICING_ATTR_rec.pricing_attribute_context IS NOT NULL) AND
1244: (p_PRICING_ATTR_rec.pricing_attribute IS NOT NULL) THEN
1245:
1246: UPDATE qp_pte_segments set used_in_setup='Y'
1247: WHERE nvl(used_in_setup,'N')='N'
1248: AND segment_id IN
1249: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1250: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.pricing_attribute

Line 1260: UPDATE qp_pte_segments set used_in_setup='Y'

1256:
1257: IF(p_PRICING_ATTR_rec.product_attribute_context IS NOT NULL) AND
1258: (p_PRICING_ATTR_rec.product_attribute IS NOT NULL) THEN
1259:
1260: UPDATE qp_pte_segments set used_in_setup='Y'
1261: WHERE nvl(used_in_setup,'N')='N'
1262: AND segment_id IN
1263: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1264: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.product_attribute

Line 1443: UPDATE qp_pte_segments set used_in_setup='Y'

1439: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1440: IF(p_PRICING_ATTR_rec.pricing_attribute_context IS NOT NULL) AND
1441: (p_PRICING_ATTR_rec.pricing_attribute IS NOT NULL) THEN
1442:
1443: UPDATE qp_pte_segments set used_in_setup='Y'
1444: WHERE nvl(used_in_setup,'N')='N'
1445: AND segment_id IN
1446: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1447: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.pricing_attribute

Line 1458: UPDATE qp_pte_segments set used_in_setup='Y'

1454:
1455: IF(p_PRICING_ATTR_rec.product_attribute_context IS NOT NULL) AND
1456: (p_PRICING_ATTR_rec.product_attribute IS NOT NULL) THEN
1457:
1458: UPDATE qp_pte_segments set used_in_setup='Y'
1459: WHERE nvl(used_in_setup,'N')='N'
1460: AND segment_id IN
1461: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1462: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.product_attribute