Scripting for Oracle Database.

Scripting for Oracle Database.

Closed - This job posting has been filled.

Job Description

We need some additional help in creating scripts for our database to pull information into our Web Portal.

Sample script we did recently:

if '${one.policynum}' is null or '${one.policyseq}' is null or '${poleffective}' is null or '${one.revenueorg}' is null
fail MVR Fees can only be created when on a complete policy
end if
input title: MVRs Ordered
[mvrs]
default: 1
prompt: Enter # of MVRs ordered
input title: MVR Charge
[amount]
default: 10.00
prompt: Enter Fee Charged Per MVR
input title: Invoice Description
[inv_comm]
default: MVR Fee
prompt: Enter Description for Invoice
set variable bill=${mvrs}*${amount}
set variable inv_comm='${inv_comm}'
if '${stdout} ' = ' '
fail Invoice Cancelled
end if
velocity api CreateInvoice

[customer]
level1org=${one.level1org}
custnum=${one.custnum}

[invoice]
printflag=o
policynum=${one.policynum}
policyseq=${one.policyseq}
invdate=${sysdate}
effdate=${one.poleffective}
commagencypercent=100
level2org=${one.revenueorg}
invoicetype=in

[account]
velocity api CreateInvoiceLine

[customer]
level1org=${one.level1org}
custnum=${one.custnum}

[invoice]
invoicenum=${invoicenum}

#invoicelines
invoicelines_[0]_sequence=10
invoicelines_[0]_linetype=fr
invoicelines_[0]_tranamount=${bill}
invoicelines_[0]_linecode=6080
invoicelines_[0]_description=${inv_comm}
invoicelines_[0]_policynum=${one.policynum}
invoicelines_[0]_policyseq=${one.policyseq}
invoicelines_[0]_agencyamt=${bill}
invoicelines_[0]_commagencypercent=100
velocity api PrintInvoice

[customer]
level1org=${one.level1org}
custnum=${one.custnum}

[invoice]
invoicenum=${invoicenum}
display MVR Fee(s) Billed.
return OK