APPS.QP_LIMIT_BALANCES_UTIL dependencies on QP_PTE_SEGMENTS

Line 1096: UPDATE qp_pte_segments SET used_in_setup='Y'

1092: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1093:
1094: IF(p_LIMIT_BALANCES_rec.multival_attr1_context IS NOT NULL)
1095: AND (p_LIMIT_BALANCES_rec.multival_attribute1 IS NOT NULL) THEN
1096: UPDATE qp_pte_segments SET used_in_setup='Y'
1097: WHERE nvl(used_in_setup,'N')='N'
1098: AND segment_id IN
1099: (SELECT a.segment_id
1100: FROM qp_segments_b a,qp_prc_contexts_b b

Line 1109: UPDATE qp_pte_segments SET used_in_setup='Y'

1105: END IF;
1106:
1107: IF(p_LIMIT_BALANCES_rec.multival_attr2_context IS NOT NULL) AND
1108: (p_LIMIT_BALANCES_rec.multival_attribute2 IS NOT NULL) THEN
1109: UPDATE qp_pte_segments SET used_in_setup='Y'
1110: WHERE nvl(used_in_setup,'N')='N'
1111: AND segment_id IN
1112: (SELECT a.segment_id
1113: FROM qp_segments_b a,qp_prc_contexts_b b

Line 1248: UPDATE qp_pte_segments SET used_in_setup='Y'

1244: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1245: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1246: IF(p_LIMIT_BALANCES_rec.multival_attr1_context IS NOT NULL)
1247: AND (p_LIMIT_BALANCES_rec.multival_attribute1 IS NOT NULL) THEN
1248: UPDATE qp_pte_segments SET used_in_setup='Y'
1249: WHERE nvl(used_in_setup,'N')='N'
1250: AND segment_id IN
1251: (SELECT a.segment_id
1252: FROM qp_segments_b a,qp_prc_contexts_b b

Line 1261: UPDATE qp_pte_segments SET used_in_setup='Y'

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