APPS.WF_NTF_RULE dependencies on WF_NTF_RULE

Line 1: package body WF_NTF_RULE as

1: package body WF_NTF_RULE as
2: /* $Header: WFNRULEB.pls 120.4 2006/01/25 15:34:10 smayze noship $ */
3:
4: --Variables
5: hashbase number:=1;

Line 24: from wf_ntf_rules wnr,

20: org_resp_appl_id number;
21:
22: cursor c_rules is
23: select distinct wnrc.message_type
24: from wf_ntf_rules wnr,
25: wf_ntf_rule_criteria wnrc
26: where wnr.rule_name = l_rule_name
27: and wnr.rule_name = wnrc.rule_name;
28: begin

Line 25: wf_ntf_rule_criteria wnrc

21:
22: cursor c_rules is
23: select distinct wnrc.message_type
24: from wf_ntf_rules wnr,
25: wf_ntf_rule_criteria wnrc
26: where wnr.rule_name = l_rule_name
27: and wnr.rule_name = wnrc.rule_name;
28: begin
29: org_user_id := fnd_global.user_id;

Line 58: wf_core.context('WF_NTF_RULE','Submit_Conc_Program_RF',p_event.getEventName(),rawtohex(p_sub_guid));

54:
55: return 'SUCCESS';
56: exception
57: when others then
58: wf_core.context('WF_NTF_RULE','Submit_Conc_Program_RF',p_event.getEventName(),rawtohex(p_sub_guid));
59: WF_EVENT.setErrorInfo(p_event, 'ERROR');
60: return 'ERROR';
61: end Submit_Conc_Program_RF;
62:

Line 76: from wf_ntf_rules wnr,

72: wnr.phase,
73: wnrm.attribute_name,
74: wnr.customization_level,
75: wnr.rule_name
76: from wf_ntf_rules wnr,
77: wf_ntf_rule_criteria wnrc,
78: wf_ntf_rule_maps wnrm
79: where wnr.rule_name = wnrc.rule_name
80: and wnr.rule_name = wnrm.rule_name

Line 77: wf_ntf_rule_criteria wnrc,

73: wnrm.attribute_name,
74: wnr.customization_level,
75: wnr.rule_name
76: from wf_ntf_rules wnr,
77: wf_ntf_rule_criteria wnrc,
78: wf_ntf_rule_maps wnrm
79: where wnr.rule_name = wnrc.rule_name
80: and wnr.rule_name = wnrm.rule_name
81: and wnr.status = 'ENABLED'

Line 78: wf_ntf_rule_maps wnrm

74: wnr.customization_level,
75: wnr.rule_name
76: from wf_ntf_rules wnr,
77: wf_ntf_rule_criteria wnrc,
78: wf_ntf_rule_maps wnrm
79: where wnr.rule_name = wnrc.rule_name
80: and wnr.rule_name = wnrm.rule_name
81: and wnr.status = 'ENABLED'
82: and wnrc.message_type = p_message_type

Line 147: wf_core.context('WF_NTF_RULE','Simulate', p_message_type, p_message_name, p_customization_level);

143: end loop;
144:
145: exception
146: when others then
147: wf_core.context('WF_NTF_RULE','Simulate', p_message_type, p_message_name, p_customization_level);
148: raise;
149: end simulate_rules;
150:
151: end WF_NTF_RULE;

Line 151: end WF_NTF_RULE;

147: wf_core.context('WF_NTF_RULE','Simulate', p_message_type, p_message_name, p_customization_level);
148: raise;
149: end simulate_rules;
150:
151: end WF_NTF_RULE;
152: