eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_NTF_RULES_PKG dependencies on WF_NTF_RULES

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 17: from wf_ntf_rules

13: is
14: begin
15: select customization_level
16: into x_customization_level
17: from wf_ntf_rules
18: where owner_tag = x_owner_tag
19: and rule_name = x_rule_name;
20:
21: exception

Line 38: insert into wf_ntf_rules (

34: x_phase in number,
35: x_status in varchar2)
36: is
37: begin
38: insert into wf_ntf_rules (
39: owner_tag,
40: creation_date,
41: rule_name,
42: customization_level,

Line 53: insert into wf_ntf_rules_tl (

49: x_customization_level,
50: x_phase,
51: x_status);
52:
53: insert into wf_ntf_rules_tl (
54: rule_name,
55: user_rule_name,
56: description,
57: language,

Line 70: from wf_ntf_rules_tl t

66: from wf_languages l
67: where l.installed_flag = 'Y'
68: and not exists
69: (select null
70: from wf_ntf_rules_tl t
71: where t.rule_name = x_rule_name
72: and t.language = l.code);
73: exception
74: when others then

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 84: delete from wf_ntf_rules_tl

80: x_rule_name in varchar2)
81: is
82: begin
83:
84: delete from wf_ntf_rules_tl
85: where rule_name = x_rule_name;
86:
87: if (sql%notfound) then
88: raise no_data_found;

Line 91: delete from wf_ntf_rules

87: if (sql%notfound) then
88: raise no_data_found;
89: end if;
90:
91: delete from wf_ntf_rules
92: where owner_tag = x_owner_tag
93: and rule_name = x_rule_name;
94:
95: if (sql%notfound) then

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 120: update wf_ntf_rules

116: fetch_custom_level(x_owner_tag,x_rule_name,l_custom_level);
117: l_update_allowed := is_update_allowed(x_customization_level,l_custom_level);
118:
119: if g_mode = 'FORCE' then
120: update wf_ntf_rules
121: set status = x_status,
122: customization_level = x_customization_level,
123: phase = x_phase
124: where owner_tag = x_owner_tag

Line 127: update wf_ntf_rules_tl

123: phase = x_phase
124: where owner_tag = x_owner_tag
125: and rule_name = x_rule_name;
126:
127: update wf_ntf_rules_tl
128: set user_rule_name = x_user_rule_name,
129: description = x_description,
130: source_lang = userenv('LANG')
131: where rule_name = x_rule_name

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 144: update wf_ntf_rules

140: return;
141: end if;
142:
143: if x_customization_level ='L' then
144: update wf_ntf_rules
145: set status = x_status
146: where owner_tag = x_owner_tag
147: and rule_name = x_rule_name;
148:

Line 151: update wf_ntf_rules

147: and rule_name = x_rule_name;
148:
149: elsif x_customization_level = 'U' then
150: if g_mode ='CUSTOM' then
151: update wf_ntf_rules
152: set status = x_status,
153: customization_level = x_customization_level,
154: phase = x_phase
155: where owner_tag = x_owner_tag

Line 158: update wf_ntf_rules_tl

154: phase = x_phase
155: where owner_tag = x_owner_tag
156: and rule_name = x_rule_name;
157:
158: update wf_ntf_rules_tl
159: set user_rule_name = x_user_rule_name,
160: description = x_description,
161: source_lang = userenv('LANG')
162: where rule_name = x_rule_name

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 265: insert into wf_ntf_rules_tl (

261:
262: procedure add_language
263: is
264: begin
265: insert into wf_ntf_rules_tl (
266: rule_name,
267: user_rule_name,
268: description,
269: language,

Line 279: from WF_ntf_rules_tl b, wf_languages l

275: b.description,
276: l.code,
277: b.source_lang,
278: sysdate
279: from WF_ntf_rules_tl b, wf_languages l
280: where l.installed_flag = 'Y'
281: and b.language = userenv('LANG')
282: and (b.rule_name,l.code) not in
283: (select /*+ hash_aj index_ffs(T,WF_NTF_RULES_TL_PK) */

Line 283: (select /+ hash_aj index_ffs(T,WF_NTF_RULES_TL_PK) /

279: from WF_ntf_rules_tl b, wf_languages l
280: where l.installed_flag = 'Y'
281: and b.language = userenv('LANG')
282: and (b.rule_name,l.code) not in
283: (select /*+ hash_aj index_ffs(T,WF_NTF_RULES_TL_PK) */
284: t.rule_name,t.language
285: from wf_ntf_rules_tl t) ;
286: exception
287: when others then

Line 285: from wf_ntf_rules_tl t) ;

281: and b.language = userenv('LANG')
282: and (b.rule_name,l.code) not in
283: (select /*+ hash_aj index_ffs(T,WF_NTF_RULES_TL_PK) */
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;

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 297: update wf_ntf_rules_tl

293: x_user_rule_name in varchar2,
294: x_description in varchar2)
295: is
296: begin
297: update wf_ntf_rules_tl
298: set user_rule_name=x_user_rule_name,
299: description=x_description,
300: source_lang=userenv('LANG')
301: where rule_name=x_rule_name

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: