APPS.FF_ARC_INS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 53

Procedure insert_dml(p_rec in out nocopy ff_arc_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 59

  l_last_update_date    ff_archive_items.last_update_date%TYPE;

Line: 60

  l_last_updated_by     ff_archive_items.last_updated_by%TYPE;

Line: 61

  l_last_update_login   ff_archive_items.last_update_login%TYPE;

Line: 73

  l_last_update_date   := sysdate;

Line: 74

  l_last_updated_by    := fnd_global.user_id;

Line: 75

  l_last_update_login  := fnd_global.login_id;

Line: 79

  insert into ff_archive_items
  (	archive_item_id,
	user_entity_id,
        archive_type,
	context1,
	value,
        last_update_date,
        last_updated_by,
        last_update_login,
        created_by,
        creation_date,
	object_version_number
  )
  Values
  (	p_rec.archive_item_id,
	p_rec.user_entity_id,
        p_rec.archive_type,
	p_rec.context1,
	p_rec.value,
        l_last_update_date,
        l_last_updated_by,
        l_last_update_login,
        l_created_by,
        l_creation_date,
	p_rec.object_version_number
  );

Line: 128

End insert_dml;

Line: 167

Procedure pre_insert(p_rec  in out nocopy ff_arc_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'pre_insert';

Line: 171

  Cursor C_Sel1 is select ff_archive_items_s.nextval from sys.dual;

Line: 184

End pre_insert;

Line: 218

Procedure post_insert(p_rec in ff_arc_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_insert';

Line: 226

End post_insert;

Line: 243

  ff_arc_bus.insert_validate(p_rec);

Line: 247

  pre_insert(p_rec);

Line: 251

  insert_dml(p_rec);

Line: 255

  post_insert(p_rec);