APPS.OKE_KCOPY_PKG dependencies on OKE_K_USER_ATTRIBUTES

Line 248: from oke_k_user_attributes

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;

Line 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:

Line 254: l_k_user_attribute_id oke_k_user_attributes.k_user_attribute_id%type;

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:

Line 255: l_record_version_number oke_k_user_attributes.record_version_number%type;

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;

Line 265: oke_k_user_attributes_pkg.insert_row

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 ,

Line 322: from oke_k_user_attributes

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;

Line 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:

Line 328: l_k_user_attribute_id oke_k_user_attributes.k_user_attribute_id%type;

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:

Line 329: l_record_version_number oke_k_user_attributes.record_version_number%type;

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;

Line 339: oke_k_user_attributes_pkg.insert_row

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 ,