DBA Data[Home] [Help]

APPS.WF_NTFRULE_UTIL dependencies on WF_NTF_RULE

Line 20: message_type in (select message_type from wf_ntf_rule_criteria where rule_name = ruleName);

16:
17: cursor ntfrule_cursor is
18: select distinct display_name from wf_message_attributes_vl where
19: name = attributeName and type = attributeType and
20: message_type in (select message_type from wf_ntf_rule_criteria where rule_name = ruleName);
21:
22: Begin
23:
24: FOR rec IN ntfrule_cursor

Line 211: procedure rosetta_table_copy_in_p1(t out nocopy wf_ntf_rule.custom_col_type, a0 JTF_VARCHAR2_TABLE_100

207:
208: /*Rosetta Wrapper Generated Code for Simulation -- Start*/
209:
210:
211: procedure rosetta_table_copy_in_p1(t out nocopy wf_ntf_rule.custom_col_type, a0 JTF_VARCHAR2_TABLE_100
212: , a1 JTF_VARCHAR2_TABLE_100
213: , a2 JTF_VARCHAR2_TABLE_100
214: , a3 JTF_VARCHAR2_TABLE_32767
215: , a4 JTF_VARCHAR2_TABLE_100

Line 243: procedure rosetta_table_copy_out_p1(t wf_ntf_rule.custom_col_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

239: end if;
240: end if;
241: end rosetta_table_copy_in_p1;
242:
243: procedure rosetta_table_copy_out_p1(t wf_ntf_rule.custom_col_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
244: , a1 out nocopy JTF_VARCHAR2_TABLE_100
245: , a2 out nocopy JTF_VARCHAR2_TABLE_100
246: , a3 out nocopy JTF_VARCHAR2_TABLE_32767
247: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 310: ddx_custom_col_tbl wf_ntf_rule.custom_col_type;

306: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
307: )
308:
309: as
310: ddx_custom_col_tbl wf_ntf_rule.custom_col_type;
311: ddindx binary_integer; indx binary_integer;
312: begin
313:
314: -- copy data to the local IN or IN-OUT args, if any

Line 320: wf_ntf_rule.simulate_rules(p_message_type,

316:
317:
318:
319: -- here's the delegated call to the old PL/SQL routine
320: wf_ntf_rule.simulate_rules(p_message_type,
321: p_message_name,
322: p_customization_level,
323: ddx_custom_col_tbl);
324: