APPS.QP_PLL_PRICING_ATTR_UTIL dependencies on QP_PTE_SEGMENTS

Line 1230: UPDATE qp_pte_segments set used_in_setup='Y'

1226:
1227: IF(p_PRICING_ATTR_rec.pricing_attribute_context IS NOT NULL) AND
1228: (p_PRICING_ATTR_rec.pricing_attribute IS NOT NULL) THEN
1229:
1230: UPDATE qp_pte_segments set used_in_setup='Y'
1231: WHERE nvl(used_in_setup,'N')='N'
1232: AND segment_id IN
1233: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1234: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.pricing_attribute

Line 1244: UPDATE qp_pte_segments set used_in_setup='Y'

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

Line 1427: UPDATE qp_pte_segments set used_in_setup='Y'

1423: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1424: IF(p_PRICING_ATTR_rec.pricing_attribute_context IS NOT NULL) AND
1425: (p_PRICING_ATTR_rec.pricing_attribute IS NOT NULL) THEN
1426:
1427: UPDATE qp_pte_segments set used_in_setup='Y'
1428: WHERE nvl(used_in_setup,'N')='N'
1429: AND segment_id IN
1430: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1431: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.pricing_attribute

Line 1442: UPDATE qp_pte_segments set used_in_setup='Y'

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