APPS.OZF_GENERATE_XML_CLOB_PVT dependencies on DBMS_LOB

Line 32: dbms_lob.createtemporary(l_clob,true,dbms_lob.session);

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);
33:
34: l_ctx := dbms_xmlquery.newContext(l_sql);
35:
36: dbms_xmlquery.setbindvalue( l_ctx, 'list_header_id', l_list_header_id );

Line 71: dbms_lob.createtemporary(l_clob,true,dbms_lob.session);

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);
72:
73: l_ctx := dbms_xmlquery.newContext(l_sql);
74:
75: dbms_xmlquery.setbindvalue( l_ctx, 'fund_id', l_fund_id );

Line 110: dbms_lob.createtemporary(l_clob,true,dbms_lob.session);

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);
111:
112: l_ctx := dbms_xmlquery.newContext(l_sql);
113:
114: dbms_xmlquery.setbindvalue( l_ctx, 'account_allocation_id', l_account_allocation_id );

Line 148: l_out := dbms_lob.istemporary(p_event.GetEventData());

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();
151:
152: