DBA Data[Home] [Help]

APPS.HR_COMM_API SQL Statements

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

Line: 19

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

  insert into hr_comments
  (	comment_id,
	source_table_name,
	comment_text
  )
  Values
  (	p_rec.comment_id,
	p_rec.source_table_name,
	p_rec.comment_text
  );
Line: 40

End insert_dml;
Line: 49

Procedure update_dml(p_rec in out nocopy g_rec_type) is
--
  l_proc	varchar2(72) := g_package||'update_dml';
Line: 59

  update hr_comments
  set
  comment_id                        = p_rec.comment_id,
  source_table_name                 = p_rec.source_table_name,
  comment_text                      = p_rec.comment_text
  where comment_id = p_rec.comment_id;
Line: 67

End update_dml;
Line: 76

Procedure delete_dml(p_rec in g_rec_type) is
--
  l_proc	varchar2(72) := g_package||'delete_dml';
Line: 85

  delete from hr_comments
  where comment_id = p_rec.comment_id;
Line: 89

End delete_dml;
Line: 98

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

  Cursor C_Sel1 is select hr_comments_s.nextval from sys.dual;
Line: 115

End pre_insert;
Line: 124

Procedure pre_update(p_rec in g_rec_type) is
--
  l_proc	varchar2(72) := g_package||'pre_update';
Line: 132

End pre_update;
Line: 141

Procedure pre_delete(p_rec in g_rec_type) is
--
  l_proc	varchar2(72) := g_package||'pre_delete';
Line: 149

End pre_delete;
Line: 158

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

End post_insert;
Line: 175

Procedure post_update(p_rec in g_rec_type) is
--
  l_proc	varchar2(72) := g_package||'post_update';
Line: 183

End post_update;
Line: 192

Procedure post_delete(p_rec in g_rec_type) is
--
  l_proc	varchar2(72) := g_package||'post_delete';
Line: 200

End post_delete;
Line: 218

    select comment_id,
	   source_table_name,
	   comment_text
    from   hr_comments
    where  comment_id = p_comment_id
    for	update nowait;
Line: 342

Procedure insert_validate(p_rec in g_rec_type) is
--
  l_proc	varchar2(72) := g_package||'insert_validate';
Line: 352

End insert_validate;
Line: 361

Procedure update_validate(p_rec in g_rec_type) is
--
  l_proc	varchar2(72) := g_package||'update_validate';
Line: 371

End update_validate;
Line: 380

Procedure delete_validate(p_rec in g_rec_type) is
--
  l_proc	varchar2(72) := g_package||'delete_validate';
Line: 390

End delete_validate;
Line: 434

  insert_validate(p_rec);
Line: 438

  pre_insert(p_rec);
Line: 442

  insert_dml(p_rec);
Line: 446

  post_insert(p_rec);
Line: 587

    update_validate(convert_defs(p_rec));
Line: 591

    pre_update(p_rec);
Line: 595

    update_dml(p_rec);
Line: 599

    post_update(p_rec);
Line: 734

    delete_validate(p_rec);
Line: 738

    pre_delete(p_rec);
Line: 742

    delete_dml(p_rec);
Line: 746

    post_delete(p_rec);