244: p_k_header_id_new in number) is
245:
246: cursor oke_user_attributes_cur is
247: select *
248: from oke_k_user_attributes
249: where k_header_id = p_k_header_id
250: and k_line_id is null;
251:
252: l_user_att_rec oke_k_user_attributes%rowtype;
248: from oke_k_user_attributes
249: where k_header_id = p_k_header_id
250: and k_line_id is null;
251:
252: l_user_att_rec oke_k_user_attributes%rowtype;
253: l_row_id varchar2(5000);
254: l_k_user_attribute_id oke_k_user_attributes.k_user_attribute_id%type;
255: l_record_version_number oke_k_user_attributes.record_version_number%type;
256:
250: and k_line_id is null;
251:
252: l_user_att_rec oke_k_user_attributes%rowtype;
253: l_row_id varchar2(5000);
254: l_k_user_attribute_id oke_k_user_attributes.k_user_attribute_id%type;
255: l_record_version_number oke_k_user_attributes.record_version_number%type;
256:
257: begin
258:
251:
252: l_user_att_rec oke_k_user_attributes%rowtype;
253: l_row_id varchar2(5000);
254: l_k_user_attribute_id oke_k_user_attributes.k_user_attribute_id%type;
255: l_record_version_number oke_k_user_attributes.record_version_number%type;
256:
257: begin
258:
259: open oke_user_attributes_cur;
261:
262: fetch oke_user_attributes_cur into l_user_att_rec;
263: exit when oke_user_attributes_cur%notfound;
264:
265: oke_k_user_attributes_pkg.insert_row
266: (x_rowid => l_row_id ,
267: x_k_user_attribute_id => l_k_user_attribute_id ,
268: x_record_version_number => l_record_version_number ,
269: x_creation_date => sysdate ,
318: p_k_line_id in number ,
319: p_k_line_id_new in number ) is
320: cursor oke_user_attributes_cur2 is
321: select *
322: from oke_k_user_attributes
323: where k_header_id = p_k_header_id
324: and k_line_id = p_k_line_id;
325:
326: l_user_att_rec oke_k_user_attributes%rowtype;
322: from oke_k_user_attributes
323: where k_header_id = p_k_header_id
324: and k_line_id = p_k_line_id;
325:
326: l_user_att_rec oke_k_user_attributes%rowtype;
327: l_row_id varchar2(5000);
328: l_k_user_attribute_id oke_k_user_attributes.k_user_attribute_id%type;
329: l_record_version_number oke_k_user_attributes.record_version_number%type;
330:
324: and k_line_id = p_k_line_id;
325:
326: l_user_att_rec oke_k_user_attributes%rowtype;
327: l_row_id varchar2(5000);
328: l_k_user_attribute_id oke_k_user_attributes.k_user_attribute_id%type;
329: l_record_version_number oke_k_user_attributes.record_version_number%type;
330:
331: begin
332:
325:
326: l_user_att_rec oke_k_user_attributes%rowtype;
327: l_row_id varchar2(5000);
328: l_k_user_attribute_id oke_k_user_attributes.k_user_attribute_id%type;
329: l_record_version_number oke_k_user_attributes.record_version_number%type;
330:
331: begin
332:
333: open oke_user_attributes_cur2;
335:
336: fetch oke_user_attributes_cur2 into l_user_att_rec;
337: exit when oke_user_attributes_cur2%notfound;
338:
339: oke_k_user_attributes_pkg.insert_row
340: (x_rowid => l_row_id ,
341: x_k_user_attribute_id => l_k_user_attribute_id ,
342: x_record_version_number => l_record_version_number ,
343: x_creation_date => sysdate ,