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

I am looking for a mix of experience and value

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:

Client Activity on this Job

Last Viewed: 2 years ago

Hired: 1


About the Client

(5.00) 2 reviews

United States
Westlake Village 10:39 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