APPS.QP_PRICE_LIST_UTIL dependencies on QP_QUALIFIERS

Line 736: UPDATE qp_qualifiers

732: -- added for bug 2912834
733: IF p_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE
734: THEN
735:
736: UPDATE qp_qualifiers
737: SET active_flag = p_PRICE_LIST_rec.active_flag
738: WHERE list_header_id = p_PRICE_LIST_rec.list_header_id;
739:
740: -- Dynamic sourcing of attributes changes

Line 747: from qp_segments_b a,qp_prc_contexts_b b,qp_qualifiers c

743: update qp_pte_segments d set used_in_setup='Y'
744: where nvl(used_in_setup,'N')='N'
745: and exists
746: (select 'x'
747: from qp_segments_b a,qp_prc_contexts_b b,qp_qualifiers c
748: where c.list_header_id = p_PRICE_LIST_rec.list_header_id
749: and a.segment_mapping_column = c .qualifier_attribute
750: and a.segment_id = d.segment_id
751: and a.prc_context_id = b.prc_context_id

Line 1827: delete from qp_qualifiers

1823: end loop;
1824:
1825: /* delete all qualifiers which refer to this list_header_id */
1826:
1827: delete from qp_qualifiers
1828: where list_header_id = p_list_header_id
1829: or ( qualifier_attr_value = to_char(p_list_header_id)
1830: and qualifier_context = 'MODLIST'
1831: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE4' );