eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_QUICK_QUOTES_PVT_W dependencies on OKL_QUICK_QUOTES_PVT

Line 1: package body okl_quick_quotes_pvt_w as

1: package body okl_quick_quotes_pvt_w as
2: /* $Header: OKLEQQHB.pls 120.3 2006/02/10 07:40:49 asawanka noship $ */
3: procedure rosetta_table_copy_in_p8(t out nocopy okl_quick_quotes_pvt.rent_payments_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p8(t out nocopy okl_quick_quotes_pvt.rent_payments_tbl, a0 JTF_NUMBER_TABLE

1: package body okl_quick_quotes_pvt_w as
2: /* $Header: OKLEQQHB.pls 120.3 2006/02/10 07:40:49 asawanka noship $ */
3: procedure rosetta_table_copy_in_p8(t out nocopy okl_quick_quotes_pvt.rent_payments_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 32: procedure rosetta_table_copy_out_p8(t okl_quick_quotes_pvt.rent_payments_tbl, a0 out nocopy JTF_NUMBER_TABLE

28: end loop;
29: end if;
30: end if;
31: end rosetta_table_copy_in_p8;
32: procedure rosetta_table_copy_out_p8(t okl_quick_quotes_pvt.rent_payments_tbl, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_NUMBER_TABLE

Line 81: procedure rosetta_table_copy_in_p10(t out nocopy okl_quick_quotes_pvt.fee_service_payments_tbl, a0 JTF_VARCHAR2_TABLE_100

77: end if;
78: end if;
79: end rosetta_table_copy_out_p8;
80:
81: procedure rosetta_table_copy_in_p10(t out nocopy okl_quick_quotes_pvt.fee_service_payments_tbl, a0 JTF_VARCHAR2_TABLE_100
82: , a1 JTF_NUMBER_TABLE
83: , a2 JTF_NUMBER_TABLE
84: , a3 JTF_DATE_TABLE
85: ) as

Line 106: procedure rosetta_table_copy_out_p10(t okl_quick_quotes_pvt.fee_service_payments_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100

102: end loop;
103: end if;
104: end if;
105: end rosetta_table_copy_in_p10;
106: procedure rosetta_table_copy_out_p10(t okl_quick_quotes_pvt.fee_service_payments_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
107: , a1 out nocopy JTF_NUMBER_TABLE
108: , a2 out nocopy JTF_NUMBER_TABLE
109: , a3 out nocopy JTF_DATE_TABLE
110: ) as

Line 145: procedure rosetta_table_copy_in_p12(t out nocopy okl_quick_quotes_pvt.item_order_estimate_tbl, a0 JTF_VARCHAR2_TABLE_300

141: end if;
142: end if;
143: end rosetta_table_copy_out_p10;
144:
145: procedure rosetta_table_copy_in_p12(t out nocopy okl_quick_quotes_pvt.item_order_estimate_tbl, a0 JTF_VARCHAR2_TABLE_300
146: , a1 JTF_VARCHAR2_TABLE_300
147: , a2 JTF_NUMBER_TABLE
148: , a3 JTF_NUMBER_TABLE
149: , a4 JTF_NUMBER_TABLE

Line 178: procedure rosetta_table_copy_out_p12(t okl_quick_quotes_pvt.item_order_estimate_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300

174: end loop;
175: end if;
176: end if;
177: end rosetta_table_copy_in_p12;
178: procedure rosetta_table_copy_out_p12(t okl_quick_quotes_pvt.item_order_estimate_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
179: , a1 out nocopy JTF_VARCHAR2_TABLE_300
180: , a2 out nocopy JTF_NUMBER_TABLE
181: , a3 out nocopy JTF_NUMBER_TABLE
182: , a4 out nocopy JTF_NUMBER_TABLE

Line 415: ddp_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;

411: , p8_a30 out nocopy JTF_VARCHAR2_TABLE_2000
412: )
413:
414: as
415: ddp_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
416: ddx_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
417: ddp_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
418: ddx_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
419: ddindx binary_integer; indx binary_integer;

Line 416: ddx_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;

412: )
413:
414: as
415: ddp_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
416: ddx_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
417: ddp_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
418: ddx_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
419: ddindx binary_integer; indx binary_integer;
420: begin

Line 417: ddp_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;

413:
414: as
415: ddp_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
416: ddx_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
417: ddp_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
418: ddx_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
419: ddindx binary_integer; indx binary_integer;
420: begin
421:

Line 418: ddx_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;

414: as
415: ddp_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
416: ddx_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
417: ddp_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
418: ddx_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
419: ddindx binary_integer; indx binary_integer;
420: begin
421:
422: -- copy data to the local IN or IN-OUT args, if any

Line 519: okl_quick_quotes_pvt.create_quick_qte(p_api_version,

515: );
516:
517:
518: -- here's the delegated call to the old PL/SQL routine
519: okl_quick_quotes_pvt.create_quick_qte(p_api_version,
520: p_init_msg_list,
521: x_return_status,
522: x_msg_count,
523: x_msg_data,

Line 804: ddp_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;

800: , p8_a30 out nocopy JTF_VARCHAR2_TABLE_2000
801: )
802:
803: as
804: ddp_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
805: ddx_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
806: ddp_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
807: ddx_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
808: ddindx binary_integer; indx binary_integer;

Line 805: ddx_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;

801: )
802:
803: as
804: ddp_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
805: ddx_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
806: ddp_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
807: ddx_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
808: ddindx binary_integer; indx binary_integer;
809: begin

Line 806: ddp_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;

802:
803: as
804: ddp_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
805: ddx_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
806: ddp_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
807: ddx_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
808: ddindx binary_integer; indx binary_integer;
809: begin
810:

Line 807: ddx_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;

803: as
804: ddp_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
805: ddx_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
806: ddp_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
807: ddx_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
808: ddindx binary_integer; indx binary_integer;
809: begin
810:
811: -- copy data to the local IN or IN-OUT args, if any

Line 908: okl_quick_quotes_pvt.update_quick_qte(p_api_version,

904: );
905:
906:
907: -- here's the delegated call to the old PL/SQL routine
908: okl_quick_quotes_pvt.update_quick_qte(p_api_version,
909: p_init_msg_list,
910: x_return_status,
911: x_msg_count,
912: x_msg_data,

Line 1054: ddp_qqlv_rec_type okl_quick_quotes_pvt.qqlv_rec_type;

1050: , p5_a30 VARCHAR2
1051: )
1052:
1053: as
1054: ddp_qqlv_rec_type okl_quick_quotes_pvt.qqlv_rec_type;
1055: ddindx binary_integer; indx binary_integer;
1056: begin
1057:
1058: -- copy data to the local IN or IN-OUT args, if any

Line 1097: okl_quick_quotes_pvt.delete_qql(p_api_version,

1093: ddp_qqlv_rec_type.description := p5_a29;
1094: ddp_qqlv_rec_type.comments := p5_a30;
1095:
1096: -- here's the delegated call to the old PL/SQL routine
1097: okl_quick_quotes_pvt.delete_qql(p_api_version,
1098: p_init_msg_list,
1099: x_return_status,
1100: x_msg_count,
1101: x_msg_data,

Line 1151: ddp_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;

1147: , p5_a30 JTF_VARCHAR2_TABLE_2000
1148: )
1149:
1150: as
1151: ddp_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
1152: ddindx binary_integer; indx binary_integer;
1153: begin
1154:
1155: -- copy data to the local IN or IN-OUT args, if any

Line 1195: okl_quick_quotes_pvt.delete_qql(p_api_version,

1191: , p5_a30
1192: );
1193:
1194: -- here's the delegated call to the old PL/SQL routine
1195: okl_quick_quotes_pvt.delete_qql(p_api_version,
1196: p_init_msg_list,
1197: x_return_status,
1198: x_msg_count,
1199: x_msg_data,

Line 1444: ddp_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;

1440: , p16_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1441: )
1442:
1443: as
1444: ddp_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
1445: ddp_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
1446: ddp_cfh_rec_type okl_quick_quotes_pvt.cashflow_hdr_rec;
1447: ddp_cfl_tbl_type okl_quick_quotes_pvt.cashflow_level_tbl;
1448: ddx_payment_rec okl_quick_quotes_pvt.payment_rec_type;

Line 1445: ddp_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;

1441: )
1442:
1443: as
1444: ddp_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
1445: ddp_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
1446: ddp_cfh_rec_type okl_quick_quotes_pvt.cashflow_hdr_rec;
1447: ddp_cfl_tbl_type okl_quick_quotes_pvt.cashflow_level_tbl;
1448: ddx_payment_rec okl_quick_quotes_pvt.payment_rec_type;
1449: ddx_rent_payments_tbl okl_quick_quotes_pvt.rent_payments_tbl;

Line 1446: ddp_cfh_rec_type okl_quick_quotes_pvt.cashflow_hdr_rec;

1442:
1443: as
1444: ddp_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
1445: ddp_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
1446: ddp_cfh_rec_type okl_quick_quotes_pvt.cashflow_hdr_rec;
1447: ddp_cfl_tbl_type okl_quick_quotes_pvt.cashflow_level_tbl;
1448: ddx_payment_rec okl_quick_quotes_pvt.payment_rec_type;
1449: ddx_rent_payments_tbl okl_quick_quotes_pvt.rent_payments_tbl;
1450: ddx_fee_payments_tbl okl_quick_quotes_pvt.fee_service_payments_tbl;

Line 1447: ddp_cfl_tbl_type okl_quick_quotes_pvt.cashflow_level_tbl;

1443: as
1444: ddp_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
1445: ddp_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
1446: ddp_cfh_rec_type okl_quick_quotes_pvt.cashflow_hdr_rec;
1447: ddp_cfl_tbl_type okl_quick_quotes_pvt.cashflow_level_tbl;
1448: ddx_payment_rec okl_quick_quotes_pvt.payment_rec_type;
1449: ddx_rent_payments_tbl okl_quick_quotes_pvt.rent_payments_tbl;
1450: ddx_fee_payments_tbl okl_quick_quotes_pvt.fee_service_payments_tbl;
1451: ddx_item_tbl okl_quick_quotes_pvt.item_order_estimate_tbl;

Line 1448: ddx_payment_rec okl_quick_quotes_pvt.payment_rec_type;

1444: ddp_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
1445: ddp_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
1446: ddp_cfh_rec_type okl_quick_quotes_pvt.cashflow_hdr_rec;
1447: ddp_cfl_tbl_type okl_quick_quotes_pvt.cashflow_level_tbl;
1448: ddx_payment_rec okl_quick_quotes_pvt.payment_rec_type;
1449: ddx_rent_payments_tbl okl_quick_quotes_pvt.rent_payments_tbl;
1450: ddx_fee_payments_tbl okl_quick_quotes_pvt.fee_service_payments_tbl;
1451: ddx_item_tbl okl_quick_quotes_pvt.item_order_estimate_tbl;
1452: ddx_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;

Line 1449: ddx_rent_payments_tbl okl_quick_quotes_pvt.rent_payments_tbl;

1445: ddp_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
1446: ddp_cfh_rec_type okl_quick_quotes_pvt.cashflow_hdr_rec;
1447: ddp_cfl_tbl_type okl_quick_quotes_pvt.cashflow_level_tbl;
1448: ddx_payment_rec okl_quick_quotes_pvt.payment_rec_type;
1449: ddx_rent_payments_tbl okl_quick_quotes_pvt.rent_payments_tbl;
1450: ddx_fee_payments_tbl okl_quick_quotes_pvt.fee_service_payments_tbl;
1451: ddx_item_tbl okl_quick_quotes_pvt.item_order_estimate_tbl;
1452: ddx_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
1453: ddx_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;

Line 1450: ddx_fee_payments_tbl okl_quick_quotes_pvt.fee_service_payments_tbl;

1446: ddp_cfh_rec_type okl_quick_quotes_pvt.cashflow_hdr_rec;
1447: ddp_cfl_tbl_type okl_quick_quotes_pvt.cashflow_level_tbl;
1448: ddx_payment_rec okl_quick_quotes_pvt.payment_rec_type;
1449: ddx_rent_payments_tbl okl_quick_quotes_pvt.rent_payments_tbl;
1450: ddx_fee_payments_tbl okl_quick_quotes_pvt.fee_service_payments_tbl;
1451: ddx_item_tbl okl_quick_quotes_pvt.item_order_estimate_tbl;
1452: ddx_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
1453: ddx_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
1454: ddindx binary_integer; indx binary_integer;

Line 1451: ddx_item_tbl okl_quick_quotes_pvt.item_order_estimate_tbl;

1447: ddp_cfl_tbl_type okl_quick_quotes_pvt.cashflow_level_tbl;
1448: ddx_payment_rec okl_quick_quotes_pvt.payment_rec_type;
1449: ddx_rent_payments_tbl okl_quick_quotes_pvt.rent_payments_tbl;
1450: ddx_fee_payments_tbl okl_quick_quotes_pvt.fee_service_payments_tbl;
1451: ddx_item_tbl okl_quick_quotes_pvt.item_order_estimate_tbl;
1452: ddx_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
1453: ddx_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
1454: ddindx binary_integer; indx binary_integer;
1455: begin

Line 1452: ddx_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;

1448: ddx_payment_rec okl_quick_quotes_pvt.payment_rec_type;
1449: ddx_rent_payments_tbl okl_quick_quotes_pvt.rent_payments_tbl;
1450: ddx_fee_payments_tbl okl_quick_quotes_pvt.fee_service_payments_tbl;
1451: ddx_item_tbl okl_quick_quotes_pvt.item_order_estimate_tbl;
1452: ddx_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
1453: ddx_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
1454: ddindx binary_integer; indx binary_integer;
1455: begin
1456:

Line 1453: ddx_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;

1449: ddx_rent_payments_tbl okl_quick_quotes_pvt.rent_payments_tbl;
1450: ddx_fee_payments_tbl okl_quick_quotes_pvt.fee_service_payments_tbl;
1451: ddx_item_tbl okl_quick_quotes_pvt.item_order_estimate_tbl;
1452: ddx_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
1453: ddx_qqlv_tbl_type okl_quick_quotes_pvt.qqlv_tbl_type;
1454: ddindx binary_integer; indx binary_integer;
1455: begin
1456:
1457: -- copy data to the local IN or IN-OUT args, if any

Line 1587: okl_quick_quotes_pvt.handle_quick_quote(p_api_version,

1583:
1584:
1585:
1586: -- here's the delegated call to the old PL/SQL routine
1587: okl_quick_quotes_pvt.handle_quick_quote(p_api_version,
1588: p_init_msg_list,
1589: x_return_status,
1590: x_msg_count,
1591: x_msg_data,

Line 1630: okl_quick_quotes_pvt_w.rosetta_table_copy_out_p8(ddx_rent_payments_tbl, p12_a0

1626: p11_a9 := ddx_payment_rec.sub_after_tax_irr;
1627: p11_a10 := ddx_payment_rec.sub_book_yield;
1628: p11_a11 := ddx_payment_rec.sub_iir;
1629:
1630: okl_quick_quotes_pvt_w.rosetta_table_copy_out_p8(ddx_rent_payments_tbl, p12_a0
1631: , p12_a1
1632: , p12_a2
1633: , p12_a3
1634: , p12_a4

Line 1638: okl_quick_quotes_pvt_w.rosetta_table_copy_out_p10(ddx_fee_payments_tbl, p13_a0

1634: , p12_a4
1635: , p12_a5
1636: );
1637:
1638: okl_quick_quotes_pvt_w.rosetta_table_copy_out_p10(ddx_fee_payments_tbl, p13_a0
1639: , p13_a1
1640: , p13_a2
1641: , p13_a3
1642: );

Line 1644: okl_quick_quotes_pvt_w.rosetta_table_copy_out_p12(ddx_item_tbl, p14_a0

1640: , p13_a2
1641: , p13_a3
1642: );
1643:
1644: okl_quick_quotes_pvt_w.rosetta_table_copy_out_p12(ddx_item_tbl, p14_a0
1645: , p14_a1
1646: , p14_a2
1647: , p14_a3
1648: , p14_a4

Line 1859: ddp_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;

1855: , p6_a53 out nocopy VARCHAR2
1856: )
1857:
1858: as
1859: ddp_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
1860: ddx_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
1861: ddindx binary_integer; indx binary_integer;
1862: begin
1863:

Line 1860: ddx_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;

1856: )
1857:
1858: as
1859: ddp_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
1860: ddx_qqhv_rec_type okl_quick_quotes_pvt.qqhv_rec_type;
1861: ddindx binary_integer; indx binary_integer;
1862: begin
1863:
1864: -- copy data to the local IN or IN-OUT args, if any

Line 1927: okl_quick_quotes_pvt.cancel_quick_quote(p_api_version,

1923: ddp_qqhv_rec_type.sts_code := p5_a53;
1924:
1925:
1926: -- here's the delegated call to the old PL/SQL routine
1927: okl_quick_quotes_pvt.cancel_quick_quote(p_api_version,
1928: p_init_msg_list,
1929: x_return_status,
1930: x_msg_count,
1931: x_msg_data,

Line 1998: end okl_quick_quotes_pvt_w;

1994: p6_a52 := ddx_qqhv_rec_type.comments;
1995: p6_a53 := ddx_qqhv_rec_type.sts_code;
1996: end;
1997:
1998: end okl_quick_quotes_pvt_w;