APPS.QP_INT_LOADER_PUB dependencies on QP_LIST_LINES

Line 261: delete from qp_list_lines qp_ll where qp_ll.list_header_id = l_list_header_id;

257: -- obtain list_header_id
258: SELECT qp_lhdr_tl.list_header_id INTO l_list_header_id FROM qp_list_headers_tl qp_lhdr_tl WHERE qp_lhdr_tl.name = l_name AND qp_lhdr_tl.language='US' ;
259:
260: delete from qp_pricing_attributes qp_prc_att where qp_prc_att.list_header_id = l_list_header_id;
261: delete from qp_list_lines qp_ll where qp_ll.list_header_id = l_list_header_id;
262: delete from qp_qualifiers qp_qual where qp_qual.list_header_id = l_list_header_id;
263: delete from qp_list_headers_b qp_lhdr_b where qp_lhdr_b.list_header_id = l_list_header_id;
264: delete from qp_list_headers_tl qp_lhdr_tl where qp_lhdr_tl.list_header_id = l_list_header_id;
265:

Line 275: select qp_ll.list_line_id INTO l_list_line_id from qp_list_lines qp_ll where qp_ll.list_header_id = l_list_header_id;

271: commit;
272:
273: --extra for modifier
274: IF (l_list_type_code = 'SLT') THEN
275: select qp_ll.list_line_id INTO l_list_line_id from qp_list_lines qp_ll where qp_ll.list_header_id = l_list_header_id;
276: delete from qp_rltd_modifiers where qp_rltd_modifiers.from_rltd_modifier_id = l_list_line_id;
277: commit;
278: END IF;
279: