APPS.WF_NTF_RULEMAPS_PKG SQL Statements

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

Line: 4

procedure insert_row(x_rule_name      in varchar2,
		     x_attribute_name in varchar2,
		     x_column_name    in varchar2)
is
begin
  insert into wf_ntf_rule_maps (
    rule_name,
    attribute_name,
    column_name,
    creation_date
  ) values (
    x_rule_name,
    x_attribute_name,
    x_column_name,
    sysdate);

Line: 21

    wf_core.context('Wf_ntf_rulemaps_pkg', 'Insert_Row',  x_rule_name, x_attribute_name);

Line: 23

end insert_row;

Line: 25

procedure delete_row(x_rule_name      in varchar2,
		     x_attribute_name in varchar2)
is
begin
  delete from wf_ntf_rule_maps
  where   rule_name      = x_rule_name
  and   attribute_name = x_attribute_name;

Line: 38

    wf_core.context('Wf_ntf_rulemaps_pkg', 'Delete_Row',  x_rule_name, x_attribute_name);

Line: 40

end delete_row;

Line: 42

procedure update_row(x_rule_name      in varchar2,
		     x_attribute_name in varchar2,
		     x_column_name    in varchar2)
is
begin
     update wf_ntf_rule_maps
     set   column_name    = x_column_name
     where   rule_name      = x_rule_name
     and   attribute_name = x_attribute_name;

Line: 57

    wf_core.context('Wf_ntf_rulemaps_pkg', 'Update_Row',  x_rule_name, x_attribute_name);

Line: 59

end update_row;

Line: 68

   Wf_ntf_rulemaps_pkg.update_row(x_rule_name,
			       x_attribute_name,
			       x_column_name);

Line: 74

     Wf_ntf_rulemaps_pkg.insert_row(x_rule_name,
				 x_attribute_name,
				 x_column_name);