APPS.OZF_GENERATE_XML_CLOB_PVT dependencies on DBMS_XMLQUERY

Line 34: l_ctx := dbms_xmlquery.newContext(l_sql);

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 );
37: dbms_xmlquery.setRaiseNoRowsException( l_ctx,false );
38:

Line 36: dbms_xmlquery.setbindvalue( l_ctx, 'list_header_id', l_list_header_id );

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 );
37: dbms_xmlquery.setRaiseNoRowsException( l_ctx,false );
38:
39: l_clob := dbms_xmlquery.getXml(l_ctx);
40:

Line 37: dbms_xmlquery.setRaiseNoRowsException( l_ctx,false );

33:
34: l_ctx := dbms_xmlquery.newContext(l_sql);
35:
36: dbms_xmlquery.setbindvalue( l_ctx, 'list_header_id', l_list_header_id );
37: dbms_xmlquery.setRaiseNoRowsException( l_ctx,false );
38:
39: l_clob := dbms_xmlquery.getXml(l_ctx);
40:
41: dbms_xmlquery.closeContext(l_ctx);

Line 39: l_clob := dbms_xmlquery.getXml(l_ctx);

35:
36: dbms_xmlquery.setbindvalue( l_ctx, 'list_header_id', l_list_header_id );
37: dbms_xmlquery.setRaiseNoRowsException( l_ctx,false );
38:
39: l_clob := dbms_xmlquery.getXml(l_ctx);
40:
41: dbms_xmlquery.closeContext(l_ctx);
42:
43: return l_clob ;

Line 41: dbms_xmlquery.closeContext(l_ctx);

37: dbms_xmlquery.setRaiseNoRowsException( l_ctx,false );
38:
39: l_clob := dbms_xmlquery.getXml(l_ctx);
40:
41: dbms_xmlquery.closeContext(l_ctx);
42:
43: return l_clob ;
44:
45: EXCEPTION

Line 47: dbms_xmlquery.closeContext(l_ctx);

43: return l_clob ;
44:
45: EXCEPTION
46: WHEN others THEN
47: dbms_xmlquery.closeContext(l_ctx);
48: raise;
49: END generate_offer_clob;
50:
51: FUNCTION generate_quota_clob (p_event_name in varchar2,

Line 73: l_ctx := dbms_xmlquery.newContext(l_sql);

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 );
76: dbms_xmlquery.setRaiseNoRowsException( l_ctx,false );
77:

Line 75: dbms_xmlquery.setbindvalue( l_ctx, 'fund_id', l_fund_id );

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 );
76: dbms_xmlquery.setRaiseNoRowsException( l_ctx,false );
77:
78: l_clob := dbms_xmlquery.getXml(l_ctx);
79:

Line 76: dbms_xmlquery.setRaiseNoRowsException( l_ctx,false );

72:
73: l_ctx := dbms_xmlquery.newContext(l_sql);
74:
75: dbms_xmlquery.setbindvalue( l_ctx, 'fund_id', l_fund_id );
76: dbms_xmlquery.setRaiseNoRowsException( l_ctx,false );
77:
78: l_clob := dbms_xmlquery.getXml(l_ctx);
79:
80: dbms_xmlquery.closeContext(l_ctx);

Line 78: l_clob := dbms_xmlquery.getXml(l_ctx);

74:
75: dbms_xmlquery.setbindvalue( l_ctx, 'fund_id', l_fund_id );
76: dbms_xmlquery.setRaiseNoRowsException( l_ctx,false );
77:
78: l_clob := dbms_xmlquery.getXml(l_ctx);
79:
80: dbms_xmlquery.closeContext(l_ctx);
81:
82: return l_clob;

Line 80: dbms_xmlquery.closeContext(l_ctx);

76: dbms_xmlquery.setRaiseNoRowsException( l_ctx,false );
77:
78: l_clob := dbms_xmlquery.getXml(l_ctx);
79:
80: dbms_xmlquery.closeContext(l_ctx);
81:
82: return l_clob;
83:
84: EXCEPTION

Line 86: dbms_xmlquery.closeContext(l_ctx);

82: return l_clob;
83:
84: EXCEPTION
85: WHEN others THEN
86: dbms_xmlquery.closeContext(l_ctx);
87: raise;
88: END generate_quota_clob;
89:
90: FUNCTION generate_target_clob (p_event_name in varchar2,

Line 112: l_ctx := dbms_xmlquery.newContext(l_sql);

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 );
115: dbms_xmlquery.setRaiseNoRowsException( l_ctx,false );
116:

Line 114: dbms_xmlquery.setbindvalue( l_ctx, 'account_allocation_id', l_account_allocation_id );

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 );
115: dbms_xmlquery.setRaiseNoRowsException( l_ctx,false );
116:
117: l_clob := dbms_xmlquery.getXml(l_ctx);
118:

Line 115: dbms_xmlquery.setRaiseNoRowsException( l_ctx,false );

111:
112: l_ctx := dbms_xmlquery.newContext(l_sql);
113:
114: dbms_xmlquery.setbindvalue( l_ctx, 'account_allocation_id', l_account_allocation_id );
115: dbms_xmlquery.setRaiseNoRowsException( l_ctx,false );
116:
117: l_clob := dbms_xmlquery.getXml(l_ctx);
118:
119: dbms_xmlquery.closeContext(l_ctx);

Line 117: l_clob := dbms_xmlquery.getXml(l_ctx);

113:
114: dbms_xmlquery.setbindvalue( l_ctx, 'account_allocation_id', l_account_allocation_id );
115: dbms_xmlquery.setRaiseNoRowsException( l_ctx,false );
116:
117: l_clob := dbms_xmlquery.getXml(l_ctx);
118:
119: dbms_xmlquery.closeContext(l_ctx);
120:
121: return l_clob;

Line 119: dbms_xmlquery.closeContext(l_ctx);

115: dbms_xmlquery.setRaiseNoRowsException( l_ctx,false );
116:
117: l_clob := dbms_xmlquery.getXml(l_ctx);
118:
119: dbms_xmlquery.closeContext(l_ctx);
120:
121: return l_clob;
122:
123: EXCEPTION

Line 125: dbms_xmlquery.closeContext(l_ctx);

121: return l_clob;
122:
123: EXCEPTION
124: WHEN others THEN
125: dbms_xmlquery.closeContext(l_ctx);
126: raise;
127: END generate_target_clob;
128:
129: FUNCTION test(p_subscription_guid in raw,