APPS.QP_MODIFIER_LIST_UTIL dependencies on QP_QUALIFIERS

Line 1018: Update QP_QUALIFIERS

1014: END IF;
1015:
1016: IF p_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1017:
1018: Update QP_QUALIFIERS
1019: set active_flag = p_MODIFIER_LIST_rec.active_flag
1020: where list_header_id = p_MODIFIER_LIST_rec.list_header_id;
1021:
1022: IF p_MODIFIER_LIST_rec.active_flag = 'Y'

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

1024: update qp_pte_segments set used_in_setup='Y'
1025: where nvl(used_in_setup,'N')='N'
1026: and segment_id in
1027: (select a.segment_id
1028: from qp_segments_b a,qp_prc_contexts_b b,qp_qualifiers c
1029: where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
1030: and a.segment_mapping_column = c .qualifier_attribute
1031: and a.prc_context_id = b.prc_context_id
1032: and b.prc_context_type = 'QUALIFIER'

Line 2295: DELETE FROM QP_QUALIFIERS

2291:
2292: DELETE FROM QP_LIST_LINES
2293: WHERE LIST_HEADER_ID = p_list_header_id;
2294:
2295: DELETE FROM QP_QUALIFIERS
2296: WHERE LIST_HEADER_ID = p_list_header_id;
2297:
2298: DELETE FROM QP_LIST_HEADERS_TL
2299: WHERE LIST_HEADER_ID = p_list_header_id;

Line 3269: from qp_qualifiers

3265: ) return varchar2
3266: is
3267: cursor c_qualifiers is
3268: select qualifier_context, qualifier_attribute
3269: from qp_qualifiers
3270: where list_header_id = p_list_header_id
3271: and ((qualifier_grouping_no = p_qualifier_grouping_no) OR (qualifier_grouping_no = -1))
3272: and list_line_id = p_list_line_id;
3273: