Scripting for Oracle Database.

Web, Mobile & Software Dev Scripts & Utilities Posted 1 year ago

Hourly Job

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

Skills Required:

Client Activity on this Job

Last Viewed: 1 year ago

Applicants: 5

Hired: 1


About the Client

(5.00) 2 reviews

United States
Westlake Village 05:55 PM

5 Jobs Posted
60% Hire Rate, 1 Open Job

Over $10,000 Total Spent
5 Hires, 2 Active

$8.80/hr Avg Hourly Rate Paid
2,242 Hours

Member Since Oct 8, 2013