Scripting for Oracle Database.

Web, Mobile & Software Dev Scripts & Utilities Posted 2 years ago

Hourly

More than 30 hrs/week
1 to 3 months
$$

Intermediate Level

Start Date

October 27, 2013

Details

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

  • Other Skills:

Activity on this Job

Last Viewed by Client: 2 years ago

Hired: 1


About the Client

(5.00) 2 reviews

United States
Westlake Village 11:36 PM

6 Jobs Posted
67% Hire Rate, 1 Open Job

Over $30,000 Total Spent
6 Hires, 3 Active

$13.57/hr Avg Hourly Rate Paid
2,588 Hours

Member Since Oct 8, 2013