APPS.QP_LIMITS_UTIL dependencies on QP_PTE_SEGMENTS

Line 1251: UPDATE qp_pte_segments SET used_in_setup='Y'

1247: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1248:
1249: IF(p_LIMITS_rec.multival_attr1_context IS NOT NULL) AND
1250: (p_LIMITS_rec.multival_attribute1 IS NOT NULL) THEN
1251: UPDATE qp_pte_segments SET used_in_setup='Y'
1252: WHERE nvl(used_in_setup,'N')='N'
1253: AND segment_id IN
1254: (SELECT a.segment_id
1255: FROM qp_segments_b a,qp_prc_contexts_b b

Line 1264: UPDATE qp_pte_segments SET used_in_setup='Y'

1260: END IF;
1261:
1262: IF(p_LIMITS_rec.multival_attr2_context IS NOT NULL) AND
1263: (p_LIMITS_rec.multival_attribute2 IS NOT NULL) THEN
1264: UPDATE qp_pte_segments SET used_in_setup='Y'
1265: WHERE nvl(used_in_setup,'N')='N'
1266: AND segment_id IN
1267: (SELECT a.segment_id
1268: FROM qp_segments_b a,qp_prc_contexts_b b

Line 1432: UPDATE qp_pte_segments SET used_in_setup='Y'

1428: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1429: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1430: IF(p_LIMITS_rec.multival_attr1_context IS NOT NULL) AND
1431: (p_LIMITS_rec.multival_attribute1 IS NOT NULL) THEN
1432: UPDATE qp_pte_segments SET used_in_setup='Y'
1433: WHERE nvl(used_in_setup,'N')='N'
1434: AND segment_id IN
1435: (SELECT a.segment_id
1436: FROM qp_segments_b a,qp_prc_contexts_b b

Line 1445: UPDATE qp_pte_segments SET used_in_setup='Y'

1441: END IF;
1442:
1443: IF(p_LIMITS_rec.multival_attr2_context IS NOT NULL) AND
1444: (p_LIMITS_rec.multival_attribute2 IS NOT NULL) THEN
1445: UPDATE qp_pte_segments SET used_in_setup='Y'
1446: WHERE nvl(used_in_setup,'N')='N'
1447: AND segment_id IN
1448: (SELECT a.segment_id
1449: FROM qp_segments_b a,qp_prc_contexts_b b