APPS.QP_PRICE_LIST_UTIL dependencies on QP_QUALIFIERS

Line 686: UPDATE qp_qualifiers

682: -- added for bug 2912834
683: IF p_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE
684: THEN
685:
686: UPDATE qp_qualifiers
687: SET active_flag = p_PRICE_LIST_rec.active_flag
688: WHERE list_header_id = p_PRICE_LIST_rec.list_header_id;
689:
690: -- Dynamic sourcing of attributes changes

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

693: update qp_pte_segments d set used_in_setup='Y'
694: where nvl(used_in_setup,'N')='N'
695: and exists
696: (select 'x'
697: from qp_segments_b a,qp_prc_contexts_b b,qp_qualifiers c
698: where c.list_header_id = p_PRICE_LIST_rec.list_header_id
699: and a.segment_mapping_column = c .qualifier_attribute
700: and a.segment_id = d.segment_id
701: and a.prc_context_id = b.prc_context_id

Line 1688: delete from qp_qualifiers

1684: end loop;
1685:
1686: /* delete all qualifiers which refer to this list_header_id */
1687:
1688: delete from qp_qualifiers
1689: where list_header_id = p_list_header_id
1690: or ( qualifier_attr_value = to_char(p_list_header_id)
1691: and qualifier_context = 'MODLIST'
1692: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE4' );