APPS.OZF_GENERATE_XML_CLOB_PVT dependencies on WF_EVENT

Line 28: l_list_header_id := wf_event.GetValueForParameter('P_OFFER_ID',p_parameter_list);

24: l_sql VARCHAR2(32000);
25:
26: BEGIN
27:
28: l_list_header_id := wf_event.GetValueForParameter('P_OFFER_ID',p_parameter_list);
29:
30: l_sql := 'select offer from ozf_offer_clob_v where list_header_id = :list_header_id';
31:
32: dbms_lob.createtemporary(l_clob,true,dbms_lob.session);

Line 67: l_fund_id := wf_event.GetValueForParameter('P_FUND_ID',p_parameter_list);

63: l_sql VARCHAR2(32000);
64:
65: BEGIN
66:
67: l_fund_id := wf_event.GetValueForParameter('P_FUND_ID',p_parameter_list);
68:
69: l_sql := 'select quota from ozf_quota_clob_v where fund_id = :fund_id';
70:
71: dbms_lob.createtemporary(l_clob,true,dbms_lob.session);

Line 106: l_account_allocation_id := wf_event.GetValueForParameter('P_ACCOUNT_ALLOCATION_ID',p_parameter_list);

102: l_sql VARCHAR2(32000);
103:
104: BEGIN
105:
106: l_account_allocation_id := wf_event.GetValueForParameter('P_ACCOUNT_ALLOCATION_ID',p_parameter_list);
107:
108: l_sql := 'select target from ozf_target_clob_v where account_allocation_id = :account_allocation_id';
109:
110: dbms_lob.createtemporary(l_clob,true,dbms_lob.session);

Line 130: p_event in out nocopy wf_event_t) return varchar2

126: raise;
127: END generate_target_clob;
128:
129: FUNCTION test(p_subscription_guid in raw,
130: p_event in out nocopy wf_event_t) return varchar2
131: IS
132: l_parameter_list wf_parameter_list_t;
133: l_offer_id VARCHAR2(30);
134:

Line 146: l_offer_id := wf_event.GetValueForParameter('P_OFFER_ID',l_parameter_list);

142:
143: l_parameter_list := WF_PARAMETER_LIST_T();
144: l_parameter_list := p_event.GetParameterList;
145:
146: l_offer_id := wf_event.GetValueForParameter('P_OFFER_ID',l_parameter_list);
147:
148: l_out := dbms_lob.istemporary(p_event.GetEventData());
149:
150: l_msg := p_event.GetEventData();

Line 164: WF_EVENT.setErrorInfo(p_event, 'ERROR');

160: /*
161: EXCEPTION
162: when others then
163: WF_CORE.CONTEXT('aml_import_event', 'test', p_event.getEventName(), p_subscription_guid);
164: WF_EVENT.setErrorInfo(p_event, 'ERROR');
165: raise;
166: return 'ERROR';
167: */
168: END test;