DBA Data[Home] [Help]

APPS.QP_QUALIFIERS_UTIL dependencies on QP_PTE_SEGMENTS

Line 1174: UPDATE qp_pte_segments SET used_in_setup='Y'

1170:
1171: IF(p_QUALIFIERS_rec.qualifier_context IS NOT NULL) AND
1172: (p_QUALIFIERS_rec.qualifier_attribute IS NOT NULL) THEN
1173:
1174: UPDATE qp_pte_segments SET used_in_setup='Y'
1175: WHERE nvl(used_in_setup,'N')='N'
1176: AND segment_id IN
1177: (SELECT a.segment_id
1178: FROM qp_segments_b a,qp_prc_contexts_b b

Line 1444: update qp_pte_segments set used_in_setup='Y'

1440:
1441:
1442: for i in update_pte_cur(p_QUALIFIERS_rec.qualifier_context, p_QUALIFIERS_rec.qualifier_attribute) loop
1443:
1444: update qp_pte_segments set used_in_setup='Y'
1445: where nvl(used_in_Setup,'N')='N'
1446: and segment_id = i.segment_id;
1447:
1448:

Line 1458: UPDATE qp_pte_segments SET used_in_setup='Y'

1454: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1455: IF(p_QUALIFIERS_rec.qualifier_context IS NOT NULL) AND
1456: (p_QUALIFIERS_rec.qualifier_attribute IS NOT NULL) THEN
1457:
1458: UPDATE qp_pte_segments SET used_in_setup='Y'
1459: WHERE nvl(used_in_setup,'N')='N'
1460: AND segment_id IN
1461: (SELECT a.segment_id
1462: FROM qp_segments_b a,qp_prc_contexts_b b

Line 1998: UPDATE qp_pte_segments SET used_in_setup='N'

1994: l_status:=QP_UTIL.Is_Used('QUALIFIER',
1995: l_qualifiers_rec.qualifier_context,
1996: l_qualifiers_rec.qualifier_attribute);
1997: IF l_status='N' THEN
1998: UPDATE qp_pte_segments SET used_in_setup='N'
1999: WHERE
2000: segment_id IN
2001: (SELECT a.segment_id
2002: FROM qp_segments_b a,qp_prc_contexts_b b