Skip to content

Instantly share code, notes, and snippets.

@neuro-sys
Last active August 29, 2015 14:10
Show Gist options
  • Save neuro-sys/c1771af6da90f6859c18 to your computer and use it in GitHub Desktop.
Save neuro-sys/c1771af6da90f6859c18 to your computer and use it in GitHub Desktop.
Oracle JPublisher generated PL/SQL Procedure Calls/Types.
/*@lineinfo:filename=HltprvBreProvisionTyp*//*@lineinfo:user-code*//*@lineinfo:1^1*/package com.mycompany.health.provision.ejb.dao.bean;
import java.sql.SQLException;
import java.sql.Connection;
import oracle.jdbc.OracleTypes;
import oracle.sql.ORAData;
import oracle.sql.ORADataFactory;
import oracle.sql.Datum;
import oracle.sql.STRUCT;
import oracle.jpub.runtime.MutableStruct;
import sqlj.runtime.ref.DefaultContext;
import sqlj.runtime.ConnectionContext;
public class HltprvBreProvisionTyp implements ORAData, ORADataFactory
{
public static final String _SQL_NAME = "CUSTOMER.HLTPRV_BRE_PROVISION_TYP";
public static final int _SQL_TYPECODE = OracleTypes.STRUCT;
/* connection management */
protected Connection __onn = null;
protected javax.sql.DataSource __dataSource = null;
public void setDataSource(javax.sql.DataSource dataSource) throws SQLException
{ release(); __dataSource = dataSource; }
public void setDataSourceLocation(String dataSourceLocation) throws SQLException {
javax.sql.DataSource dataSource;
try {
Class cls = Class.forName("javax.naming.InitialContext");
Object ctx = cls.newInstance();
java.lang.reflect.Method meth = cls.getMethod("lookup", new Class[]{String.class});
dataSource = (javax.sql.DataSource) meth.invoke(ctx, new Object[]{"java:comp/env/" + dataSourceLocation});
setDataSource(dataSource);
} catch (Exception e) {
throw new java.sql.SQLException("Error initializing DataSource at " + dataSourceLocation + ": " + e.getMessage());
}
}
public Connection getConnection() throws SQLException
{
if (__onn!=null) return __onn;
else if (__tx!=null) return __tx.getConnection();
else if (__dataSource!=null) __onn= __dataSource.getConnection();
return __onn;
}
public void release() throws SQLException
{ if (__tx!=null && __onn!=null) __tx.close(ConnectionContext.KEEP_CONNECTION);
__onn = null; __tx = null;
__dataSource = null;
}
public void closeConnection(){
if (__dataSource!=null) {
try { if (__onn!=null) { __onn.close(); } } catch (java.sql.SQLException e) {}
try { if (__tx!=null) {__tx.close(); } } catch (java.sql.SQLException e) {}
__onn=null;
__tx=null;
}
}
protected DefaultContext __tx = null;
public void setConnectionContext(DefaultContext ctx) throws SQLException
{ release(); __tx = ctx; }
public DefaultContext getConnectionContext() throws SQLException
{ if (__tx==null)
{ __tx = (getConnection()==null) ? DefaultContext.getDefaultContext() : new DefaultContext(getConnection()); }
return __tx;
};
protected MutableStruct _struct;
protected static int[] _sqlType = { 2,91,12,2,2,91,12,2,2,2,2,12,2,2,2,2002,2002,2003,2003,2003,2002,2002,2002,2,2,2,2,2,12,2003,2,12,2,2,12,2003,2003,2,2,2,2,2,2003,91 };
protected static ORADataFactory[] _factory = new ORADataFactory[44];
static
{
_factory[15] = HltprvBrePolicyTyp.getORADataFactory();
_factory[16] = HltprvBrePartnerTyp.getORADataFactory();
_factory[17] = HltprvBreHealthprocessesTbl.getORADataFactory();
_factory[18] = HltprvBreDiseasesTbl.getORADataFactory();
_factory[19] = HltprvBrePrevclaimfilesTbl.getORADataFactory();
_factory[20] = HltprvBreInstconsumedlmtTyp.getORADataFactory();
_factory[21] = HltprvBreInstconsumedlmtTyp.getORADataFactory();
_factory[22] = HltprvBreInstconsumedlmtTyp.getORADataFactory();
_factory[29] = HltprvBreDecisionTbl.getORADataFactory();
_factory[35] = HltprvBreMedicineTbl.getORADataFactory();
_factory[36] = HltprvBreDecisionTbl.getORADataFactory();
_factory[42] = HltprvBreUwrejectTbl.getORADataFactory();
}
protected static final HltprvBreProvisionTyp _HltprvBreProvisionTypFactory = new HltprvBreProvisionTyp();
public static ORADataFactory getORADataFactory()
{ return _HltprvBreProvisionTypFactory; }
/* constructors */
protected void _init_struct(boolean init)
{ if (init) _struct = new MutableStruct(new Object[44], _sqlType, _factory); }
public HltprvBreProvisionTyp()
{ _init_struct(true); __tx = DefaultContext.getDefaultContext(); }
public HltprvBreProvisionTyp(DefaultContext c) /*throws SQLException*/
{ _init_struct(true); __tx = c; }
public HltprvBreProvisionTyp(Connection c) /*throws SQLException*/
{ _init_struct(true); __onn = c; }
public HltprvBreProvisionTyp(java.math.BigDecimal logid, java.sql.Timestamp origindate, String requestsystem, java.math.BigDecimal claimid, java.math.BigDecimal sfno, java.sql.Timestamp provisiondate, String provisionstatuscode, java.math.BigDecimal institutecode, java.math.BigDecimal institutegroupcode, java.math.BigDecimal institutegroupcode2, java.math.BigDecimal locationcode, String specialtysubject, java.math.BigDecimal isjudicial, java.math.BigDecimal mondialtype, java.math.BigDecimal isunlistedprocess, HltprvBrePolicyTyp policy, HltprvBrePartnerTyp insured, HltprvBreHealthprocessesTbl healthprocesses, HltprvBreDiseasesTbl diseases, HltprvBrePrevclaimfilesTbl prevclaimfiles, HltprvBreInstconsumedlmtTyp institutelimit, HltprvBreInstconsumedlmtTyp currentlocationlimit, HltprvBreInstconsumedlmtTyp currentlocspeclimit, java.math.BigDecimal requestamount, java.math.BigDecimal prevrequestamount, java.math.BigDecimal systemamount, java.math.BigDecimal indemnityamount, java.math.BigDecimal policysourcecompany, String breresultcode, HltprvBreDecisionTbl bredecisions, java.math.BigDecimal covercategorygroup, String applicationcode, java.math.BigDecimal pregnantrestriction, java.math.BigDecimal odnpregnantrestriction, String medicineflow, HltprvBreMedicineTbl medicine, HltprvBreDecisionTbl medicinebredecisions, java.math.BigDecimal secprocdelrejectcover, java.math.BigDecimal secprocchangerejectcover, java.math.BigDecimal secprocmanualchangereqamount, java.math.BigDecimal secprocprovcenterrejcover, java.math.BigDecimal secprococclaimwithoutproc, HltprvBreUwrejectTbl uwrejectlist, java.sql.Timestamp complaintstartdate) throws SQLException
{
_init_struct(true);
setLogid(logid);
setOrigindate(origindate);
setRequestsystem(requestsystem);
setClaimid(claimid);
setSfno(sfno);
setProvisiondate(provisiondate);
setProvisionstatuscode(provisionstatuscode);
setInstitutecode(institutecode);
setInstitutegroupcode(institutegroupcode);
setInstitutegroupcode2(institutegroupcode2);
setLocationcode(locationcode);
setSpecialtysubject(specialtysubject);
setIsjudicial(isjudicial);
setMondialtype(mondialtype);
setIsunlistedprocess(isunlistedprocess);
setPolicy(policy);
setInsured(insured);
setHealthprocesses(healthprocesses);
setDiseases(diseases);
setPrevclaimfiles(prevclaimfiles);
setInstitutelimit(institutelimit);
setCurrentlocationlimit(currentlocationlimit);
setCurrentlocspeclimit(currentlocspeclimit);
setRequestamount(requestamount);
setPrevrequestamount(prevrequestamount);
setSystemamount(systemamount);
setIndemnityamount(indemnityamount);
setPolicysourcecompany(policysourcecompany);
setBreresultcode(breresultcode);
setBredecisions(bredecisions);
setCovercategorygroup(covercategorygroup);
setApplicationcode(applicationcode);
setPregnantrestriction(pregnantrestriction);
setOdnpregnantrestriction(odnpregnantrestriction);
setMedicineflow(medicineflow);
setMedicine(medicine);
setMedicinebredecisions(medicinebredecisions);
setSecprocdelrejectcover(secprocdelrejectcover);
setSecprocchangerejectcover(secprocchangerejectcover);
setSecprocmanualchangereqamount(secprocmanualchangereqamount);
setSecprocprovcenterrejcover(secprocprovcenterrejcover);
setSecprococclaimwithoutproc(secprococclaimwithoutproc);
setUwrejectlist(uwrejectlist);
setComplaintstartdate(complaintstartdate);
}
/* ORAData interface */
public Datum toDatum(Connection c) throws SQLException
{
if (__tx!=null && __onn!=c) release();
__onn = c;
return _struct.toDatum(c, _SQL_NAME);
}
/* ORADataFactory interface */
public ORAData create(Datum d, int sqlType) throws SQLException
{ return create(null, d, sqlType); }
public void setFrom(HltprvBreProvisionTyp o) throws SQLException
{ setContextFrom(o); setValueFrom(o); }
protected void setContextFrom(HltprvBreProvisionTyp o) throws SQLException
{ release(); __tx = o.__tx; __onn = o.__onn; }
protected void setValueFrom(HltprvBreProvisionTyp o) { _struct = o._struct; }
protected ORAData create(HltprvBreProvisionTyp o, Datum d, int sqlType) throws SQLException
{
if (d == null) { if (o!=null) { o.release(); }; return null; }
if (o == null) o = new HltprvBreProvisionTyp();
o._struct = new MutableStruct((STRUCT) d, _sqlType, _factory);
o.__onn = ((STRUCT) d).getJavaSqlConnection();
return o;
}
/* accessor methods */
public java.math.BigDecimal getLogid() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(0); }
public void setLogid(java.math.BigDecimal logid) throws SQLException
{ _struct.setAttribute(0, logid); }
public java.sql.Timestamp getOrigindate() throws SQLException
{ return (java.sql.Timestamp) _struct.getAttribute(1); }
public void setOrigindate(java.sql.Timestamp origindate) throws SQLException
{ _struct.setAttribute(1, origindate); }
public String getRequestsystem() throws SQLException
{ return (String) _struct.getAttribute(2); }
public void setRequestsystem(String requestsystem) throws SQLException
{ _struct.setAttribute(2, requestsystem); }
public java.math.BigDecimal getClaimid() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(3); }
public void setClaimid(java.math.BigDecimal claimid) throws SQLException
{ _struct.setAttribute(3, claimid); }
public java.math.BigDecimal getSfno() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(4); }
public void setSfno(java.math.BigDecimal sfno) throws SQLException
{ _struct.setAttribute(4, sfno); }
public java.sql.Timestamp getProvisiondate() throws SQLException
{ return (java.sql.Timestamp) _struct.getAttribute(5); }
public void setProvisiondate(java.sql.Timestamp provisiondate) throws SQLException
{ _struct.setAttribute(5, provisiondate); }
public String getProvisionstatuscode() throws SQLException
{ return (String) _struct.getAttribute(6); }
public void setProvisionstatuscode(String provisionstatuscode) throws SQLException
{ _struct.setAttribute(6, provisionstatuscode); }
public java.math.BigDecimal getInstitutecode() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(7); }
public void setInstitutecode(java.math.BigDecimal institutecode) throws SQLException
{ _struct.setAttribute(7, institutecode); }
public java.math.BigDecimal getInstitutegroupcode() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(8); }
public void setInstitutegroupcode(java.math.BigDecimal institutegroupcode) throws SQLException
{ _struct.setAttribute(8, institutegroupcode); }
public java.math.BigDecimal getInstitutegroupcode2() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(9); }
public void setInstitutegroupcode2(java.math.BigDecimal institutegroupcode2) throws SQLException
{ _struct.setAttribute(9, institutegroupcode2); }
public java.math.BigDecimal getLocationcode() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(10); }
public void setLocationcode(java.math.BigDecimal locationcode) throws SQLException
{ _struct.setAttribute(10, locationcode); }
public String getSpecialtysubject() throws SQLException
{ return (String) _struct.getAttribute(11); }
public void setSpecialtysubject(String specialtysubject) throws SQLException
{ _struct.setAttribute(11, specialtysubject); }
public java.math.BigDecimal getIsjudicial() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(12); }
public void setIsjudicial(java.math.BigDecimal isjudicial) throws SQLException
{ _struct.setAttribute(12, isjudicial); }
public java.math.BigDecimal getMondialtype() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(13); }
public void setMondialtype(java.math.BigDecimal mondialtype) throws SQLException
{ _struct.setAttribute(13, mondialtype); }
public java.math.BigDecimal getIsunlistedprocess() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(14); }
public void setIsunlistedprocess(java.math.BigDecimal isunlistedprocess) throws SQLException
{ _struct.setAttribute(14, isunlistedprocess); }
public HltprvBrePolicyTyp getPolicy() throws SQLException
{ return (HltprvBrePolicyTyp) _struct.getAttribute(15); }
public void setPolicy(HltprvBrePolicyTyp policy) throws SQLException
{ _struct.setAttribute(15, policy); }
public HltprvBrePartnerTyp getInsured() throws SQLException
{ return (HltprvBrePartnerTyp) _struct.getAttribute(16); }
public void setInsured(HltprvBrePartnerTyp insured) throws SQLException
{ _struct.setAttribute(16, insured); }
public HltprvBreHealthprocessesTbl getHealthprocesses() throws SQLException
{ return (HltprvBreHealthprocessesTbl) _struct.getAttribute(17); }
public void setHealthprocesses(HltprvBreHealthprocessesTbl healthprocesses) throws SQLException
{ _struct.setAttribute(17, healthprocesses); }
public HltprvBreDiseasesTbl getDiseases() throws SQLException
{ return (HltprvBreDiseasesTbl) _struct.getAttribute(18); }
public void setDiseases(HltprvBreDiseasesTbl diseases) throws SQLException
{ _struct.setAttribute(18, diseases); }
public HltprvBrePrevclaimfilesTbl getPrevclaimfiles() throws SQLException
{ return (HltprvBrePrevclaimfilesTbl) _struct.getAttribute(19); }
public void setPrevclaimfiles(HltprvBrePrevclaimfilesTbl prevclaimfiles) throws SQLException
{ _struct.setAttribute(19, prevclaimfiles); }
public HltprvBreInstconsumedlmtTyp getInstitutelimit() throws SQLException
{ return (HltprvBreInstconsumedlmtTyp) _struct.getAttribute(20); }
public void setInstitutelimit(HltprvBreInstconsumedlmtTyp institutelimit) throws SQLException
{ _struct.setAttribute(20, institutelimit); }
public HltprvBreInstconsumedlmtTyp getCurrentlocationlimit() throws SQLException
{ return (HltprvBreInstconsumedlmtTyp) _struct.getAttribute(21); }
public void setCurrentlocationlimit(HltprvBreInstconsumedlmtTyp currentlocationlimit) throws SQLException
{ _struct.setAttribute(21, currentlocationlimit); }
public HltprvBreInstconsumedlmtTyp getCurrentlocspeclimit() throws SQLException
{ return (HltprvBreInstconsumedlmtTyp) _struct.getAttribute(22); }
public void setCurrentlocspeclimit(HltprvBreInstconsumedlmtTyp currentlocspeclimit) throws SQLException
{ _struct.setAttribute(22, currentlocspeclimit); }
public java.math.BigDecimal getRequestamount() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(23); }
public void setRequestamount(java.math.BigDecimal requestamount) throws SQLException
{ _struct.setAttribute(23, requestamount); }
public java.math.BigDecimal getPrevrequestamount() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(24); }
public void setPrevrequestamount(java.math.BigDecimal prevrequestamount) throws SQLException
{ _struct.setAttribute(24, prevrequestamount); }
public java.math.BigDecimal getSystemamount() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(25); }
public void setSystemamount(java.math.BigDecimal systemamount) throws SQLException
{ _struct.setAttribute(25, systemamount); }
public java.math.BigDecimal getIndemnityamount() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(26); }
public void setIndemnityamount(java.math.BigDecimal indemnityamount) throws SQLException
{ _struct.setAttribute(26, indemnityamount); }
public java.math.BigDecimal getPolicysourcecompany() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(27); }
public void setPolicysourcecompany(java.math.BigDecimal policysourcecompany) throws SQLException
{ _struct.setAttribute(27, policysourcecompany); }
public String getBreresultcode() throws SQLException
{ return (String) _struct.getAttribute(28); }
public void setBreresultcode(String breresultcode) throws SQLException
{ _struct.setAttribute(28, breresultcode); }
public HltprvBreDecisionTbl getBredecisions() throws SQLException
{ return (HltprvBreDecisionTbl) _struct.getAttribute(29); }
public void setBredecisions(HltprvBreDecisionTbl bredecisions) throws SQLException
{ _struct.setAttribute(29, bredecisions); }
public java.math.BigDecimal getCovercategorygroup() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(30); }
public void setCovercategorygroup(java.math.BigDecimal covercategorygroup) throws SQLException
{ _struct.setAttribute(30, covercategorygroup); }
public String getApplicationcode() throws SQLException
{ return (String) _struct.getAttribute(31); }
public void setApplicationcode(String applicationcode) throws SQLException
{ _struct.setAttribute(31, applicationcode); }
public java.math.BigDecimal getPregnantrestriction() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(32); }
public void setPregnantrestriction(java.math.BigDecimal pregnantrestriction) throws SQLException
{ _struct.setAttribute(32, pregnantrestriction); }
public java.math.BigDecimal getOdnpregnantrestriction() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(33); }
public void setOdnpregnantrestriction(java.math.BigDecimal odnpregnantrestriction) throws SQLException
{ _struct.setAttribute(33, odnpregnantrestriction); }
public String getMedicineflow() throws SQLException
{ return (String) _struct.getAttribute(34); }
public void setMedicineflow(String medicineflow) throws SQLException
{ _struct.setAttribute(34, medicineflow); }
public HltprvBreMedicineTbl getMedicine() throws SQLException
{ return (HltprvBreMedicineTbl) _struct.getAttribute(35); }
public void setMedicine(HltprvBreMedicineTbl medicine) throws SQLException
{ _struct.setAttribute(35, medicine); }
public HltprvBreDecisionTbl getMedicinebredecisions() throws SQLException
{ return (HltprvBreDecisionTbl) _struct.getAttribute(36); }
public void setMedicinebredecisions(HltprvBreDecisionTbl medicinebredecisions) throws SQLException
{ _struct.setAttribute(36, medicinebredecisions); }
public java.math.BigDecimal getSecprocdelrejectcover() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(37); }
public void setSecprocdelrejectcover(java.math.BigDecimal secprocdelrejectcover) throws SQLException
{ _struct.setAttribute(37, secprocdelrejectcover); }
public java.math.BigDecimal getSecprocchangerejectcover() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(38); }
public void setSecprocchangerejectcover(java.math.BigDecimal secprocchangerejectcover) throws SQLException
{ _struct.setAttribute(38, secprocchangerejectcover); }
public java.math.BigDecimal getSecprocmanualchangereqamount() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(39); }
public void setSecprocmanualchangereqamount(java.math.BigDecimal secprocmanualchangereqamount) throws SQLException
{ _struct.setAttribute(39, secprocmanualchangereqamount); }
public java.math.BigDecimal getSecprocprovcenterrejcover() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(40); }
public void setSecprocprovcenterrejcover(java.math.BigDecimal secprocprovcenterrejcover) throws SQLException
{ _struct.setAttribute(40, secprocprovcenterrejcover); }
public java.math.BigDecimal getSecprococclaimwithoutproc() throws SQLException
{ return (java.math.BigDecimal) _struct.getAttribute(41); }
public void setSecprococclaimwithoutproc(java.math.BigDecimal secprococclaimwithoutproc) throws SQLException
{ _struct.setAttribute(41, secprococclaimwithoutproc); }
public HltprvBreUwrejectTbl getUwrejectlist() throws SQLException
{ return (HltprvBreUwrejectTbl) _struct.getAttribute(42); }
public void setUwrejectlist(HltprvBreUwrejectTbl uwrejectlist) throws SQLException
{ _struct.setAttribute(42, uwrejectlist); }
public java.sql.Timestamp getComplaintstartdate() throws SQLException
{ return (java.sql.Timestamp) _struct.getAttribute(43); }
public void setComplaintstartdate(java.sql.Timestamp complaintstartdate) throws SQLException
{ _struct.setAttribute(43, complaintstartdate); }
public HltprvBreProvisionTyp dbmsOutputType ()
throws java.sql.SQLException
{
try {
HltprvBreProvisionTyp __jPt_temp = this;
/*@lineinfo:generated-code*//*@lineinfo:485^5*/
// ************************************************************
// #sql [getConnectionContext()] { BEGIN
// :__jPt_temp.DBMS_OUTPUT_TYPE();
// END;
// };
// ************************************************************
{
// declare temps
oracle.jdbc.OracleCallableStatement __sJT_st = null;
sqlj.runtime.ref.DefaultContext __sJT_cc = getConnectionContext(); if (__sJT_cc==null) sqlj.runtime.error.RuntimeRefErrors.raise_NULL_CONN_CTX();
sqlj.runtime.ExecutionContext.OracleContext __sJT_ec = ((__sJT_cc.getExecutionContext()==null) ? sqlj.runtime.ExecutionContext.raiseNullExecCtx() : __sJT_cc.getExecutionContext().getOracleContext());
try {
String theSqlTS = "BEGIN\n :1 .DBMS_OUTPUT_TYPE();\n END;";
__sJT_st = __sJT_ec.prepareOracleCall(__sJT_cc,"0com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp",theSqlTS);
if (__sJT_ec.isNew())
{
__sJT_st.registerOutParameter(1,2002,"CUSTOMER.HLTPRV_BRE_PROVISION_TYP");
}
// set IN parameters
if (__jPt_temp==null) __sJT_st.setNull(1,2002,"CUSTOMER.HLTPRV_BRE_PROVISION_TYP"); else __sJT_st.setORAData(1,__jPt_temp);
// execute statement
__sJT_ec.oracleExecuteUpdate();
// retrieve OUT parameters
__jPt_temp = (com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp)__sJT_st.getORAData(1,com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp.getORADataFactory());
} finally { __sJT_ec.oracleClose(); }
}
// ************************************************************
/*@lineinfo:user-code*//*@lineinfo:489^5*/
return __jPt_temp;
} catch(java.sql.SQLException _err) {
try {
getConnectionContext().getExecutionContext().close();
closeConnection();
if (__dataSource==null) throw _err;
HltprvBreProvisionTyp __jPt_temp = this;
/*@lineinfo:generated-code*//*@lineinfo:497^5*/
// ************************************************************
// #sql [getConnectionContext()] { BEGIN
// :__jPt_temp.DBMS_OUTPUT_TYPE();
// END;
// };
// ************************************************************
{
// declare temps
oracle.jdbc.OracleCallableStatement __sJT_st = null;
sqlj.runtime.ref.DefaultContext __sJT_cc = getConnectionContext(); if (__sJT_cc==null) sqlj.runtime.error.RuntimeRefErrors.raise_NULL_CONN_CTX();
sqlj.runtime.ExecutionContext.OracleContext __sJT_ec = ((__sJT_cc.getExecutionContext()==null) ? sqlj.runtime.ExecutionContext.raiseNullExecCtx() : __sJT_cc.getExecutionContext().getOracleContext());
try {
String theSqlTS = "BEGIN\n :1 .DBMS_OUTPUT_TYPE();\n END;";
__sJT_st = __sJT_ec.prepareOracleCall(__sJT_cc,"1com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp",theSqlTS);
if (__sJT_ec.isNew())
{
__sJT_st.registerOutParameter(1,2002,"CUSTOMER.HLTPRV_BRE_PROVISION_TYP");
}
// set IN parameters
if (__jPt_temp==null) __sJT_st.setNull(1,2002,"CUSTOMER.HLTPRV_BRE_PROVISION_TYP"); else __sJT_st.setORAData(1,__jPt_temp);
// execute statement
__sJT_ec.oracleExecuteUpdate();
// retrieve OUT parameters
__jPt_temp = (com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp)__sJT_st.getORAData(1,com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp.getORADataFactory());
} finally { __sJT_ec.oracleClose(); }
}
// ************************************************************
/*@lineinfo:user-code*//*@lineinfo:501^5*/
return __jPt_temp;
} catch (java.sql.SQLException _err2) {
try { getConnectionContext().getExecutionContext().close(); } catch (java.sql.SQLException _sqle) {}
throw _err;
}
}
}
public oracle.sql.CLOB gettypevalueinclob (
Integer P_INDENT_LEVEL)
throws java.sql.SQLException
{
HltprvBreProvisionTyp __jPt_temp = (HltprvBreProvisionTyp) this;
oracle.sql.CLOB __jPt_result;
try {
/*@lineinfo:generated-code*//*@lineinfo:517^5*/
// ************************************************************
// #sql [getConnectionContext()] { BEGIN
// :__jPt_result := :__jPt_temp.GETTYPEVALUEINCLOB(
// :P_INDENT_LEVEL);
// END;
// };
// ************************************************************
{
// declare temps
oracle.jdbc.OracleCallableStatement __sJT_st = null;
sqlj.runtime.ref.DefaultContext __sJT_cc = getConnectionContext(); if (__sJT_cc==null) sqlj.runtime.error.RuntimeRefErrors.raise_NULL_CONN_CTX();
sqlj.runtime.ExecutionContext.OracleContext __sJT_ec = ((__sJT_cc.getExecutionContext()==null) ? sqlj.runtime.ExecutionContext.raiseNullExecCtx() : __sJT_cc.getExecutionContext().getOracleContext());
try {
String theSqlTS = "BEGIN\n :1 := :2 .GETTYPEVALUEINCLOB(\n :3 );\n END;";
__sJT_st = __sJT_ec.prepareOracleCall(__sJT_cc,"2com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp",theSqlTS);
if (__sJT_ec.isNew())
{
__sJT_st.registerOutParameter(1,oracle.jdbc.OracleTypes.CLOB);
}
// set IN parameters
if (__jPt_temp==null) __sJT_st.setNull(2,2002,"CUSTOMER.HLTPRV_BRE_PROVISION_TYP"); else __sJT_st.setORAData(2,__jPt_temp);
if (P_INDENT_LEVEL == null) __sJT_st.setNull(3,oracle.jdbc.OracleTypes.INTEGER); else __sJT_st.setInt(3,P_INDENT_LEVEL.intValue());
// execute statement
__sJT_ec.oracleExecuteUpdate();
// retrieve OUT parameters
__jPt_result = (oracle.sql.CLOB)__sJT_st.getCLOB(1);
} finally { __sJT_ec.oracleClose(); }
}
// ************************************************************
/*@lineinfo:user-code*//*@lineinfo:522^5*/
} catch(java.sql.SQLException _err) {
try {
getConnectionContext().getExecutionContext().close();
closeConnection();
if (__dataSource==null) throw _err;
/*@lineinfo:generated-code*//*@lineinfo:528^5*/
// ************************************************************
// #sql [getConnectionContext()] { BEGIN
// :__jPt_result := :__jPt_temp.GETTYPEVALUEINCLOB(
// :P_INDENT_LEVEL);
// END;
// };
// ************************************************************
{
// declare temps
oracle.jdbc.OracleCallableStatement __sJT_st = null;
sqlj.runtime.ref.DefaultContext __sJT_cc = getConnectionContext(); if (__sJT_cc==null) sqlj.runtime.error.RuntimeRefErrors.raise_NULL_CONN_CTX();
sqlj.runtime.ExecutionContext.OracleContext __sJT_ec = ((__sJT_cc.getExecutionContext()==null) ? sqlj.runtime.ExecutionContext.raiseNullExecCtx() : __sJT_cc.getExecutionContext().getOracleContext());
try {
String theSqlTS = "BEGIN\n :1 := :2 .GETTYPEVALUEINCLOB(\n :3 );\n END;";
__sJT_st = __sJT_ec.prepareOracleCall(__sJT_cc,"3com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp",theSqlTS);
if (__sJT_ec.isNew())
{
__sJT_st.registerOutParameter(1,oracle.jdbc.OracleTypes.CLOB);
}
// set IN parameters
if (__jPt_temp==null) __sJT_st.setNull(2,2002,"CUSTOMER.HLTPRV_BRE_PROVISION_TYP"); else __sJT_st.setORAData(2,__jPt_temp);
if (P_INDENT_LEVEL == null) __sJT_st.setNull(3,oracle.jdbc.OracleTypes.INTEGER); else __sJT_st.setInt(3,P_INDENT_LEVEL.intValue());
// execute statement
__sJT_ec.oracleExecuteUpdate();
// retrieve OUT parameters
__jPt_result = (oracle.sql.CLOB)__sJT_st.getCLOB(1);
} finally { __sJT_ec.oracleClose(); }
}
// ************************************************************
/*@lineinfo:user-code*//*@lineinfo:533^5*/
} catch (java.sql.SQLException _err2) {
try { getConnectionContext().getExecutionContext().close(); } catch (java.sql.SQLException _sqle) {}
throw _err;
}
}
return __jPt_result;
}
public HltprvBreProvisionTyp hltprvBreProvisionTyp (
HltprvBreProvisionTyp __jPt_out[])
throws java.sql.SQLException
{
HltprvBreProvisionTyp __jPt_temp = (HltprvBreProvisionTyp) this;
HltprvBreProvisionTyp __jPt_result;
try {
/*@lineinfo:generated-code*//*@lineinfo:549^5*/
// ************************************************************
// #sql [getConnectionContext()] { BEGIN
// :__jPt_result := HLTPRV_BRE_PROVISION_TYP();
// END;
// };
// ************************************************************
{
// declare temps
oracle.jdbc.OracleCallableStatement __sJT_st = null;
sqlj.runtime.ref.DefaultContext __sJT_cc = getConnectionContext(); if (__sJT_cc==null) sqlj.runtime.error.RuntimeRefErrors.raise_NULL_CONN_CTX();
sqlj.runtime.ExecutionContext.OracleContext __sJT_ec = ((__sJT_cc.getExecutionContext()==null) ? sqlj.runtime.ExecutionContext.raiseNullExecCtx() : __sJT_cc.getExecutionContext().getOracleContext());
try {
String theSqlTS = "BEGIN\n :1 := HLTPRV_BRE_PROVISION_TYP();\n END;";
__sJT_st = __sJT_ec.prepareOracleCall(__sJT_cc,"4com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp",theSqlTS);
if (__sJT_ec.isNew())
{
__sJT_st.registerOutParameter(1,2002,"CUSTOMER.HLTPRV_BRE_PROVISION_TYP");
}
// execute statement
__sJT_ec.oracleExecuteUpdate();
// retrieve OUT parameters
__jPt_result = (com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp)__sJT_st.getORAData(1,com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp.getORADataFactory());
} finally { __sJT_ec.oracleClose(); }
}
// ************************************************************
/*@lineinfo:user-code*//*@lineinfo:553^5*/
__jPt_out[0] = __jPt_temp;
} catch(java.sql.SQLException _err) {
try {
getConnectionContext().getExecutionContext().close();
closeConnection();
if (__dataSource==null) throw _err;
/*@lineinfo:generated-code*//*@lineinfo:560^5*/
// ************************************************************
// #sql [getConnectionContext()] { BEGIN
// :__jPt_result := HLTPRV_BRE_PROVISION_TYP();
// END;
// };
// ************************************************************
{
// declare temps
oracle.jdbc.OracleCallableStatement __sJT_st = null;
sqlj.runtime.ref.DefaultContext __sJT_cc = getConnectionContext(); if (__sJT_cc==null) sqlj.runtime.error.RuntimeRefErrors.raise_NULL_CONN_CTX();
sqlj.runtime.ExecutionContext.OracleContext __sJT_ec = ((__sJT_cc.getExecutionContext()==null) ? sqlj.runtime.ExecutionContext.raiseNullExecCtx() : __sJT_cc.getExecutionContext().getOracleContext());
try {
String theSqlTS = "BEGIN\n :1 := HLTPRV_BRE_PROVISION_TYP();\n END;";
__sJT_st = __sJT_ec.prepareOracleCall(__sJT_cc,"5com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp",theSqlTS);
if (__sJT_ec.isNew())
{
__sJT_st.registerOutParameter(1,2002,"CUSTOMER.HLTPRV_BRE_PROVISION_TYP");
}
// execute statement
__sJT_ec.oracleExecuteUpdate();
// retrieve OUT parameters
__jPt_result = (com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp)__sJT_st.getORAData(1,com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp.getORADataFactory());
} finally { __sJT_ec.oracleClose(); }
}
// ************************************************************
/*@lineinfo:user-code*//*@lineinfo:564^5*/
__jPt_out[0] = __jPt_temp;
} catch (java.sql.SQLException _err2) {
try { getConnectionContext().getExecutionContext().close(); } catch (java.sql.SQLException _sqle) {}
throw _err;
}
}
return __jPt_result;
}
public HltprvBreProvisionTyp validateattributes ()
throws java.sql.SQLException
{
try {
HltprvBreProvisionTyp __jPt_temp = this;
/*@lineinfo:generated-code*//*@lineinfo:579^5*/
// ************************************************************
// #sql [getConnectionContext()] { BEGIN
// :__jPt_temp.VALIDATEATTRIBUTES();
// END;
// };
// ************************************************************
{
// declare temps
oracle.jdbc.OracleCallableStatement __sJT_st = null;
sqlj.runtime.ref.DefaultContext __sJT_cc = getConnectionContext(); if (__sJT_cc==null) sqlj.runtime.error.RuntimeRefErrors.raise_NULL_CONN_CTX();
sqlj.runtime.ExecutionContext.OracleContext __sJT_ec = ((__sJT_cc.getExecutionContext()==null) ? sqlj.runtime.ExecutionContext.raiseNullExecCtx() : __sJT_cc.getExecutionContext().getOracleContext());
try {
String theSqlTS = "BEGIN\n :1 .VALIDATEATTRIBUTES();\n END;";
__sJT_st = __sJT_ec.prepareOracleCall(__sJT_cc,"6com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp",theSqlTS);
if (__sJT_ec.isNew())
{
__sJT_st.registerOutParameter(1,2002,"CUSTOMER.HLTPRV_BRE_PROVISION_TYP");
}
// set IN parameters
if (__jPt_temp==null) __sJT_st.setNull(1,2002,"CUSTOMER.HLTPRV_BRE_PROVISION_TYP"); else __sJT_st.setORAData(1,__jPt_temp);
// execute statement
__sJT_ec.oracleExecuteUpdate();
// retrieve OUT parameters
__jPt_temp = (com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp)__sJT_st.getORAData(1,com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp.getORADataFactory());
} finally { __sJT_ec.oracleClose(); }
}
// ************************************************************
/*@lineinfo:user-code*//*@lineinfo:583^5*/
return __jPt_temp;
} catch(java.sql.SQLException _err) {
try {
getConnectionContext().getExecutionContext().close();
closeConnection();
if (__dataSource==null) throw _err;
HltprvBreProvisionTyp __jPt_temp = this;
/*@lineinfo:generated-code*//*@lineinfo:591^5*/
// ************************************************************
// #sql [getConnectionContext()] { BEGIN
// :__jPt_temp.VALIDATEATTRIBUTES();
// END;
// };
// ************************************************************
{
// declare temps
oracle.jdbc.OracleCallableStatement __sJT_st = null;
sqlj.runtime.ref.DefaultContext __sJT_cc = getConnectionContext(); if (__sJT_cc==null) sqlj.runtime.error.RuntimeRefErrors.raise_NULL_CONN_CTX();
sqlj.runtime.ExecutionContext.OracleContext __sJT_ec = ((__sJT_cc.getExecutionContext()==null) ? sqlj.runtime.ExecutionContext.raiseNullExecCtx() : __sJT_cc.getExecutionContext().getOracleContext());
try {
String theSqlTS = "BEGIN\n :1 .VALIDATEATTRIBUTES();\n END;";
__sJT_st = __sJT_ec.prepareOracleCall(__sJT_cc,"7com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp",theSqlTS);
if (__sJT_ec.isNew())
{
__sJT_st.registerOutParameter(1,2002,"CUSTOMER.HLTPRV_BRE_PROVISION_TYP");
}
// set IN parameters
if (__jPt_temp==null) __sJT_st.setNull(1,2002,"CUSTOMER.HLTPRV_BRE_PROVISION_TYP"); else __sJT_st.setORAData(1,__jPt_temp);
// execute statement
__sJT_ec.oracleExecuteUpdate();
// retrieve OUT parameters
__jPt_temp = (com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp)__sJT_st.getORAData(1,com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp.getORADataFactory());
} finally { __sJT_ec.oracleClose(); }
}
// ************************************************************
/*@lineinfo:user-code*//*@lineinfo:595^5*/
return __jPt_temp;
} catch (java.sql.SQLException _err2) {
try { getConnectionContext().getExecutionContext().close(); } catch (java.sql.SQLException _sqle) {}
throw _err;
}
}
}
public HltprvBreProvisionTyp writeobjecttolog (
java.math.BigDecimal P_LOGID)
throws java.sql.SQLException
{
try {
HltprvBreProvisionTyp __jPt_temp = this;
/*@lineinfo:generated-code*//*@lineinfo:610^5*/
// ************************************************************
// #sql [getConnectionContext()] { BEGIN
// :__jPt_temp.WRITEOBJECTTOLOG(
// :P_LOGID);
// END;
// };
// ************************************************************
{
// declare temps
oracle.jdbc.OracleCallableStatement __sJT_st = null;
sqlj.runtime.ref.DefaultContext __sJT_cc = getConnectionContext(); if (__sJT_cc==null) sqlj.runtime.error.RuntimeRefErrors.raise_NULL_CONN_CTX();
sqlj.runtime.ExecutionContext.OracleContext __sJT_ec = ((__sJT_cc.getExecutionContext()==null) ? sqlj.runtime.ExecutionContext.raiseNullExecCtx() : __sJT_cc.getExecutionContext().getOracleContext());
try {
String theSqlTS = "BEGIN\n :1 .WRITEOBJECTTOLOG(\n :2 );\n END;";
__sJT_st = __sJT_ec.prepareOracleCall(__sJT_cc,"8com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp",theSqlTS);
if (__sJT_ec.isNew())
{
__sJT_st.registerOutParameter(1,2002,"CUSTOMER.HLTPRV_BRE_PROVISION_TYP");
}
// set IN parameters
if (__jPt_temp==null) __sJT_st.setNull(1,2002,"CUSTOMER.HLTPRV_BRE_PROVISION_TYP"); else __sJT_st.setORAData(1,__jPt_temp);
__sJT_st.setBigDecimal(2,P_LOGID);
// execute statement
__sJT_ec.oracleExecuteUpdate();
// retrieve OUT parameters
__jPt_temp = (com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp)__sJT_st.getORAData(1,com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp.getORADataFactory());
} finally { __sJT_ec.oracleClose(); }
}
// ************************************************************
/*@lineinfo:user-code*//*@lineinfo:615^5*/
return __jPt_temp;
} catch(java.sql.SQLException _err) {
try {
getConnectionContext().getExecutionContext().close();
closeConnection();
if (__dataSource==null) throw _err;
HltprvBreProvisionTyp __jPt_temp = this;
/*@lineinfo:generated-code*//*@lineinfo:623^5*/
// ************************************************************
// #sql [getConnectionContext()] { BEGIN
// :__jPt_temp.WRITEOBJECTTOLOG(
// :P_LOGID);
// END;
// };
// ************************************************************
{
// declare temps
oracle.jdbc.OracleCallableStatement __sJT_st = null;
sqlj.runtime.ref.DefaultContext __sJT_cc = getConnectionContext(); if (__sJT_cc==null) sqlj.runtime.error.RuntimeRefErrors.raise_NULL_CONN_CTX();
sqlj.runtime.ExecutionContext.OracleContext __sJT_ec = ((__sJT_cc.getExecutionContext()==null) ? sqlj.runtime.ExecutionContext.raiseNullExecCtx() : __sJT_cc.getExecutionContext().getOracleContext());
try {
String theSqlTS = "BEGIN\n :1 .WRITEOBJECTTOLOG(\n :2 );\n END;";
__sJT_st = __sJT_ec.prepareOracleCall(__sJT_cc,"9com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp",theSqlTS);
if (__sJT_ec.isNew())
{
__sJT_st.registerOutParameter(1,2002,"CUSTOMER.HLTPRV_BRE_PROVISION_TYP");
}
// set IN parameters
if (__jPt_temp==null) __sJT_st.setNull(1,2002,"CUSTOMER.HLTPRV_BRE_PROVISION_TYP"); else __sJT_st.setORAData(1,__jPt_temp);
__sJT_st.setBigDecimal(2,P_LOGID);
// execute statement
__sJT_ec.oracleExecuteUpdate();
// retrieve OUT parameters
__jPt_temp = (com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp)__sJT_st.getORAData(1,com.mycompany.health.provision.ejb.dao.bean.HltprvBreProvisionTyp.getORADataFactory());
} finally { __sJT_ec.oracleClose(); }
}
// ************************************************************
/*@lineinfo:user-code*//*@lineinfo:628^5*/
return __jPt_temp;
} catch (java.sql.SQLException _err2) {
try { getConnectionContext().getExecutionContext().close(); } catch (java.sql.SQLException _sqle) {}
throw _err;
}
}
}
}/*@lineinfo:generated-code*/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment