APPS.WF_NTF_RULES_PKG dependencies on WF_NTF_RULES_PKG

Line 1: package body WF_NTF_RULES_PKG as

1: package body WF_NTF_RULES_PKG as
2: /* $Header: WFNTFRLB.pls 120.3 2005/12/15 22:06:24 hgandiko noship $ */
3:
4: --Private Variables
5: type txt_tbl_type is table of varchar2(240) index by binary_integer;

Line 75: wf_core.context('Wf_ntf_rules_pkg', 'Insert_Row', x_owner_tag, x_rule_name);

71: where t.rule_name = x_rule_name
72: and t.language = l.code);
73: exception
74: when others then
75: wf_core.context('Wf_ntf_rules_pkg', 'Insert_Row', x_owner_tag, x_rule_name);
76: raise;
77: end insert_row;
78:
79: procedure delete_row(x_owner_tag in varchar2,

Line 101: wf_core.context('Wf_ntf_rules_pkg', 'Delete_Row', x_owner_tag, x_rule_name);

97: end if;
98:
99: exception
100: when others then
101: wf_core.context('Wf_ntf_rules_pkg', 'Delete_Row', x_owner_tag, x_rule_name);
102: raise;
103: end delete_row;
104:
105: procedure update_row(x_owner_tag in varchar2,

Line 136: wf_core.context('WF_NTF_RULES_PKG','UPDATE_ROW',

132: and userenv('LANG') in (language, source_lang);
133: else
134: -- User is not seed
135: if l_update_allowed = 'N' then
136: wf_core.context('WF_NTF_RULES_PKG','UPDATE_ROW',
137: x_rule_name,
138: l_custom_level,
139: X_CUSTOMIZATION_LEVEL);
140: return;

Line 175: wf_core.context('Wf_ntf_rules_pkg', 'Update_Row', x_owner_tag, x_rule_name);

171: end if;
172: end if;
173: exception
174: when others then
175: wf_core.context('Wf_ntf_rules_pkg', 'Update_Row', x_owner_tag, x_rule_name);
176: raise;
177: end update_row;
178:
179: procedure load_row(x_owner_tag in varchar2,

Line 190: wf_ntf_rules_pkg.g_mode := 'FORCE';

186: x_custom_mode in varchar2)
187: is
188: begin
189: if x_customization_level = 'C' or x_customization_level = 'L' then
190: wf_ntf_rules_pkg.g_mode := 'FORCE';
191: else
192: wf_ntf_rules_pkg.g_mode := x_custom_mode;
193: end if;
194:

Line 192: wf_ntf_rules_pkg.g_mode := x_custom_mode;

188: begin
189: if x_customization_level = 'C' or x_customization_level = 'L' then
190: wf_ntf_rules_pkg.g_mode := 'FORCE';
191: else
192: wf_ntf_rules_pkg.g_mode := x_custom_mode;
193: end if;
194:
195: if wf_ntf_rules_pkg.g_mode = 'FORCE' then
196: wf_ntf_rules_pkg.update_row(x_owner_tag,

Line 195: if wf_ntf_rules_pkg.g_mode = 'FORCE' then

191: else
192: wf_ntf_rules_pkg.g_mode := x_custom_mode;
193: end if;
194:
195: if wf_ntf_rules_pkg.g_mode = 'FORCE' then
196: wf_ntf_rules_pkg.update_row(x_owner_tag,
197: x_rule_name,
198: x_user_rule_name,
199: x_description,

Line 196: wf_ntf_rules_pkg.update_row(x_owner_tag,

192: wf_ntf_rules_pkg.g_mode := x_custom_mode;
193: end if;
194:
195: if wf_ntf_rules_pkg.g_mode = 'FORCE' then
196: wf_ntf_rules_pkg.update_row(x_owner_tag,
197: x_rule_name,
198: x_user_rule_name,
199: x_description,
200: x_customization_level,

Line 206: wf_ntf_rules_pkg.insert_row(x_owner_tag,

202: x_status);
203: end if;
204: exception
205: when others then
206: wf_ntf_rules_pkg.insert_row(x_owner_tag,
207: x_rule_name,
208: x_user_rule_name,
209: x_description,
210: x_customization_level,

Line 288: wf_core.context('Wf_ntf_rules_Pkg', 'Add_Language');

284: t.rule_name,t.language
285: from wf_ntf_rules_tl t) ;
286: exception
287: when others then
288: wf_core.context('Wf_ntf_rules_Pkg', 'Add_Language');
289: raise;
290: end add_language;
291:
292: procedure translate_row(x_rule_name in varchar2,

Line 305: wf_core.context('Wf_NTF_Rules_Pkg', 'Translate_Row');

301: where rule_name=x_rule_name
302: and userenv('LANG') in (language, source_lang);
303: exception
304: when others then
305: wf_core.context('Wf_NTF_Rules_Pkg', 'Translate_Row');
306: raise;
307: end translate_row;
308:
309: end WF_NTF_RULES_PKG;

Line 309: end WF_NTF_RULES_PKG;

305: wf_core.context('Wf_NTF_Rules_Pkg', 'Translate_Row');
306: raise;
307: end translate_row;
308:
309: end WF_NTF_RULES_PKG;
310: