APPS.WF_NTF_RULECRITERIA_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_msg_type   in varchar2)
is
begin
  insert into wf_ntf_rule_criteria (
    rule_name,
    message_type,
    creation_date
  ) values (
    x_rule_name,
    x_msg_type,
    sysdate);

Line: 18

    wf_core.context('Wf_ntf_rulecriteria_pkg', 'Insert_Row', x_rule_name, x_msg_type);

Line: 20

end insert_row;

Line: 22

procedure delete_row(x_rule_name  in varchar2,
     		     x_msg_type   in varchar2)
is
begin
  delete from wf_ntf_rule_criteria
  where   rule_name = x_rule_name
  and   message_type = x_msg_type;

Line: 35

    wf_core.context('Wf_ntf_rulecriteria_pkg', 'Delete_Row',  x_rule_name, x_msg_type);

Line: 37

end delete_row;

Line: 39

procedure update_row(x_rule_name  in varchar2,
		     x_msg_type   in varchar2)
is
begin
       update wf_ntf_rule_criteria
       set    message_type = x_msg_type
       where  rule_name = x_rule_name;

Line: 52

    wf_core.context('Wf_ntf_rulecriteria_pkg', 'Update_Row',  x_rule_name, x_msg_type);

Line: 54

end update_row;

Line: 61

   wf_ntf_rulecriteria_pkg.update_row(x_rule_name,
                                   x_msg_type);

Line: 66

   wf_ntf_rulecriteria_pkg.insert_row(x_rule_name,
                                   x_msg_type);