DBA Data[Home] [Help]

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_TPL_PVT

Line 460: l_tplv_rec okl_tpl_pvt.tplv_rec_type ;

456: p_vendor_site_id IN NUMBER ,
457: x_request_id OUT NOCOPY NUMBER
458: ) IS
459:
460: l_tplv_rec okl_tpl_pvt.tplv_rec_type ;
461: l_tapv_rec okl_tap_pvt.tapv_rec_type ;
462:
463: x_tplv_rec okl_tpl_pvt.tplv_rec_type ;
464: x_tapv_rec okl_tap_pvt.tapv_rec_type ;

Line 463: x_tplv_rec okl_tpl_pvt.tplv_rec_type ;

459:
460: l_tplv_rec okl_tpl_pvt.tplv_rec_type ;
461: l_tapv_rec okl_tap_pvt.tapv_rec_type ;
462:
463: x_tplv_rec okl_tpl_pvt.tplv_rec_type ;
464: x_tapv_rec okl_tap_pvt.tapv_rec_type ;
465:
466: /* 22-JAN-2007 ANSETHUR BUILD: R12 B DISBURSEMENT Start Changes */
467: l_tplv_tbl okl_tpl_pvt.tplv_tbl_type ;

Line 467: l_tplv_tbl okl_tpl_pvt.tplv_tbl_type ;

463: x_tplv_rec okl_tpl_pvt.tplv_rec_type ;
464: x_tapv_rec okl_tap_pvt.tapv_rec_type ;
465:
466: /* 22-JAN-2007 ANSETHUR BUILD: R12 B DISBURSEMENT Start Changes */
467: l_tplv_tbl okl_tpl_pvt.tplv_tbl_type ;
468: x_tplv_tbl okl_tpl_pvt.tplv_tbl_type ;
469: /* 22-JAN-2007 ANSETHUR BUILD: R12 B DISBURSEMENT End Changes */
470:
471: CURSOR c_trx_type (cp_name VARCHAR2, cp_language VARCHAR2) IS

Line 468: x_tplv_tbl okl_tpl_pvt.tplv_tbl_type ;

464: x_tapv_rec okl_tap_pvt.tapv_rec_type ;
465:
466: /* 22-JAN-2007 ANSETHUR BUILD: R12 B DISBURSEMENT Start Changes */
467: l_tplv_tbl okl_tpl_pvt.tplv_tbl_type ;
468: x_tplv_tbl okl_tpl_pvt.tplv_tbl_type ;
469: /* 22-JAN-2007 ANSETHUR BUILD: R12 B DISBURSEMENT End Changes */
470:
471: CURSOR c_trx_type (cp_name VARCHAR2, cp_language VARCHAR2) IS
472: SELECT id

Line 761: l_tplv_rec okl_tpl_pvt.tplv_rec_type ;

757:
758: )
759:
760: IS
761: l_tplv_rec okl_tpl_pvt.tplv_rec_type ;
762: l_tapv_rec okl_tap_pvt.tapv_rec_type ;
763:
764: x_tplv_rec okl_tpl_pvt.tplv_rec_type ;
765: x_tapv_rec okl_tap_pvt.tapv_rec_type ;

Line 764: x_tplv_rec okl_tpl_pvt.tplv_rec_type ;

760: IS
761: l_tplv_rec okl_tpl_pvt.tplv_rec_type ;
762: l_tapv_rec okl_tap_pvt.tapv_rec_type ;
763:
764: x_tplv_rec okl_tpl_pvt.tplv_rec_type ;
765: x_tapv_rec okl_tap_pvt.tapv_rec_type ;
766:
767: /* 22-JAN-2007 ANSETHUR BUILD: R12 B DISBURSEMENT Start Changes */
768: l_tplv_tbl okl_tpl_pvt.tplv_tbl_type ;

Line 768: l_tplv_tbl okl_tpl_pvt.tplv_tbl_type ;

764: x_tplv_rec okl_tpl_pvt.tplv_rec_type ;
765: x_tapv_rec okl_tap_pvt.tapv_rec_type ;
766:
767: /* 22-JAN-2007 ANSETHUR BUILD: R12 B DISBURSEMENT Start Changes */
768: l_tplv_tbl okl_tpl_pvt.tplv_tbl_type ;
769: x_tplv_tbl okl_tpl_pvt.tplv_tbl_type ;
770: /* 22-JAN-2007 ANSETHUR BUILD: R12 B DISBURSEMENT End Changes */
771:
772: -- skgautam Added as part of fix of bug 4146178

Line 769: x_tplv_tbl okl_tpl_pvt.tplv_tbl_type ;

765: x_tapv_rec okl_tap_pvt.tapv_rec_type ;
766:
767: /* 22-JAN-2007 ANSETHUR BUILD: R12 B DISBURSEMENT Start Changes */
768: l_tplv_tbl okl_tpl_pvt.tplv_tbl_type ;
769: x_tplv_tbl okl_tpl_pvt.tplv_tbl_type ;
770: /* 22-JAN-2007 ANSETHUR BUILD: R12 B DISBURSEMENT End Changes */
771:
772: -- skgautam Added as part of fix of bug 4146178
773: l_vendor_id NUMBER;

Line 1616: l_tplv_rec okl_tpl_pvt.tplv_rec_type;

1612:
1613:
1614: l_tapv_rec Okl_tap_pvt.tapv_rec_type;
1615: lx_tapv_rec Okl_tap_pvt.tapv_rec_type;
1616: l_tplv_rec okl_tpl_pvt.tplv_rec_type;
1617: lx_tplv_rec okl_tpl_pvt.tplv_rec_type;
1618:
1619: li_months NUMBER ;
1620: l_total_lessor_premium NUMBER;

Line 1617: lx_tplv_rec okl_tpl_pvt.tplv_rec_type;

1613:
1614: l_tapv_rec Okl_tap_pvt.tapv_rec_type;
1615: lx_tapv_rec Okl_tap_pvt.tapv_rec_type;
1616: l_tplv_rec okl_tpl_pvt.tplv_rec_type;
1617: lx_tplv_rec okl_tpl_pvt.tplv_rec_type;
1618:
1619: li_months NUMBER ;
1620: l_total_lessor_premium NUMBER;
1621: ln_premium NUMBER;