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 1445: update qp_pte_segments set used_in_setup='Y'

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

Line 1459: UPDATE qp_pte_segments SET used_in_setup='Y'

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

Line 1999: UPDATE qp_pte_segments SET used_in_setup='N'

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