21: SELECT pos_approv_reject_supp_seq.nextval
22: INTO l_itemkey
23: FROM dual;
24:
25: wf_event.addparametertolist(p_name => 'PARAM1',
26: p_value => param1,
27: p_parameterlist => l_parameter_list);
28:
29: wf_event.addparametertolist(p_name => 'PARAM2',
25: wf_event.addparametertolist(p_name => 'PARAM1',
26: p_value => param1,
27: p_parameterlist => l_parameter_list);
28:
29: wf_event.addparametertolist(p_name => 'PARAM2',
30: p_value => param2,
31: p_parameterlist => l_parameter_list);
32:
33:
31: p_parameterlist => l_parameter_list);
32:
33:
34: /*
35: wf_event.raise(p_event_name => p_event_name,
36: p_event_key => l_itemkey);
37: */
38:
39: wf_event.raise(
35: wf_event.raise(p_event_name => p_event_name,
36: p_event_key => l_itemkey);
37: */
38:
39: wf_event.raise(
40: p_event_name => p_event_name,
41: p_event_key => l_itemkey,
42: p_parameters => l_parameter_list);
43:
55: ROLLBACK;
56: END raise_appr_rej_supp_event;
57: ------------------------------------
58: FUNCTION app_supp_subscription(p_subscription_guid IN RAW,
59: p_event IN OUT NOCOPY wf_event_t)
60: RETURN VARCHAR2 IS
61:
62: l_abc VARCHAR2(50) := 'Test';
63: BEGIN
75: RETURN 'FAILURE';
76: END app_supp_subscription;
77: ----------------------------------------
78: FUNCTION app_supp_user_subscription(p_subscription_guid IN RAW,
79: p_event IN OUT NOCOPY wf_event_t)
80: RETURN VARCHAR2 IS
81:
82: l_abc VARCHAR2(50) := 'Test';
83: BEGIN
95: RETURN 'FAILURE';
96: END app_supp_user_subscription;
97: ----------------------------------------------
98: FUNCTION rej_supp_subscription(p_subscription_guid IN RAW,
99: p_event IN OUT NOCOPY wf_event_t)
100: RETURN VARCHAR2 IS
101:
102: l_abc VARCHAR2(50) := 'Test';
103: BEGIN
113: RETURN 'FAILURE';
114: END rej_supp_subscription;
115: --------------------------------------
116: FUNCTION rej_supp_user_subscription(p_subscription_guid IN RAW,
117: p_event IN OUT NOCOPY wf_event_t)
118: RETURN VARCHAR2 IS
119:
120: l_abc VARCHAR2(50) := 'Test';
121: BEGIN