DBA Data[Home] [Help]

APPS.QP_LIMIT_ATTRS_UTIL dependencies on QP_PTE_SEGMENTS

Line 866: UPDATE qp_pte_segments SET used_in_setup='Y'

862: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
863:
864: IF(p_LIMIT_ATTRS_rec.limit_attribute_context IS NOT NULL)
865: AND (p_LIMIT_ATTRS_rec.limit_attribute IS NOT NULL) THEN
866: UPDATE qp_pte_segments SET used_in_setup='Y'
867: WHERE nvl(used_in_setup,'N')='N'
868: AND segment_id IN
869: (SELECT a.segment_id
870: FROM qp_segments_b a,qp_prc_contexts_b b

Line 985: UPDATE qp_pte_segments SET used_in_setup='Y'

981: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
982: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
983: IF(p_LIMIT_ATTRS_rec.limit_attribute_context IS NOT NULL)
984: AND (p_LIMIT_ATTRS_rec.limit_attribute IS NOT NULL) THEN
985: UPDATE qp_pte_segments SET used_in_setup='Y'
986: WHERE nvl(used_in_setup,'N')='N'
987: AND segment_id IN
988: (SELECT a.segment_id
989: FROM qp_segments_b a,qp_prc_contexts_b b