DBA Data[Home] [Help]

APPS.WF_NTF_RULECRITERIA_PKG dependencies on WF_NTF_RULE_CRITERIA

Line 8: insert into wf_ntf_rule_criteria (

4: procedure insert_row(x_rule_name in varchar2,
5: x_msg_type in varchar2)
6: is
7: begin
8: insert into wf_ntf_rule_criteria (
9: rule_name,
10: message_type,
11: creation_date
12: ) values (

Line 26: delete from wf_ntf_rule_criteria

22: procedure delete_row(x_rule_name in varchar2,
23: x_msg_type in varchar2)
24: is
25: begin
26: delete from wf_ntf_rule_criteria
27: where rule_name = x_rule_name
28: and message_type = x_msg_type;
29:
30: if (sql%notfound) then

Line 43: update wf_ntf_rule_criteria

39: procedure update_row(x_rule_name in varchar2,
40: x_msg_type in varchar2)
41: is
42: begin
43: update wf_ntf_rule_criteria
44: set message_type = x_msg_type
45: where rule_name = x_rule_name;
46:
47: if SQL%NOTFOUND then