58: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
59:
60: CURSOR C_PRIC_QUALIFIERS IS
61: SELECT QUALIFIER_ID
62: FROM QP_QUALIFIERS
63: WHERE LIST_HEADER_ID=LIST_FROM;
64:
65: CURSOR C_PRIC_LINES IS
66: SELECT LIST_LINE_ID
287: l_orig_sys_qualifier_ref varchar2(50);
288:
289: Begin
290: fnd_file.put_line(fnd_file.log, 'In EXPORT_TMP_QUALIFIERS ');
291: l_QUALIFIER_rec := QP_QUALIFIERS_UTIL.Query_Row
292: ( p_qualifier_id => list_from
293: );
294: fnd_file.put_line(fnd_file.log, 'Inserting Qualifier '||to_char(l_QUALIFIER_rec.qualifier_id));
295: if g_interface_action = 'INSERT' then
298: else
299: begin
300: select orig_sys_qualifier_ref, orig_sys_header_ref
301: into l_orig_sys_qualifier_ref, l_orig_sys_header_ref
302: from qp_qualifiers
303: where qualifier_id = l_QUALIFIER_rec.qualifier_id;
304: exception
305: when others then
306: null;