APPS.WF_NTF_RULES_PKG dependencies on WF_NTF_RULES_TL

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 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 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 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 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 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