APPS.QP_LIMITS_UTIL dependencies on QP_PTE_SEGMENTS

Line 1220: UPDATE qp_pte_segments SET used_in_setup='Y'

1216: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1217:
1218: IF(p_LIMITS_rec.multival_attr1_context IS NOT NULL) AND
1219: (p_LIMITS_rec.multival_attribute1 IS NOT NULL) THEN
1220: UPDATE qp_pte_segments SET used_in_setup='Y'
1221: WHERE nvl(used_in_setup,'N')='N'
1222: AND segment_id IN
1223: (SELECT a.segment_id
1224: FROM qp_segments_b a,qp_prc_contexts_b b

Line 1233: UPDATE qp_pte_segments SET used_in_setup='Y'

1229: END IF;
1230:
1231: IF(p_LIMITS_rec.multival_attr2_context IS NOT NULL) AND
1232: (p_LIMITS_rec.multival_attribute2 IS NOT NULL) THEN
1233: UPDATE qp_pte_segments SET used_in_setup='Y'
1234: WHERE nvl(used_in_setup,'N')='N'
1235: AND segment_id IN
1236: (SELECT a.segment_id
1237: FROM qp_segments_b a,qp_prc_contexts_b b

Line 1401: UPDATE qp_pte_segments SET used_in_setup='Y'

1397: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1398: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1399: IF(p_LIMITS_rec.multival_attr1_context IS NOT NULL) AND
1400: (p_LIMITS_rec.multival_attribute1 IS NOT NULL) THEN
1401: UPDATE qp_pte_segments SET used_in_setup='Y'
1402: WHERE nvl(used_in_setup,'N')='N'
1403: AND segment_id IN
1404: (SELECT a.segment_id
1405: FROM qp_segments_b a,qp_prc_contexts_b b

Line 1414: UPDATE qp_pte_segments SET used_in_setup='Y'

1410: END IF;
1411:
1412: IF(p_LIMITS_rec.multival_attr2_context IS NOT NULL) AND
1413: (p_LIMITS_rec.multival_attribute2 IS NOT NULL) THEN
1414: UPDATE qp_pte_segments SET used_in_setup='Y'
1415: WHERE nvl(used_in_setup,'N')='N'
1416: AND segment_id IN
1417: (SELECT a.segment_id
1418: FROM qp_segments_b a,qp_prc_contexts_b b