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_INS_QUOTE_PVT_W dependencies on OKL_INS_QUOTE_PVT

Line 1: package body okl_ins_quote_pvt_w as

1: package body okl_ins_quote_pvt_w as
2: /* $Header: OKLEINQB.pls 120.2 2005/09/19 11:35:35 pagarg noship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 22: procedure rosetta_table_copy_in_p1(t out nocopy okl_ins_quote_pvt.ipyv_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy okl_ins_quote_pvt.ipyv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_VARCHAR2_TABLE_600
26: , a4 JTF_VARCHAR2_TABLE_300

Line 191: procedure rosetta_table_copy_out_p1(t okl_ins_quote_pvt.ipyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

187: end loop;
188: end if;
189: end if;
190: end rosetta_table_copy_in_p1;
191: procedure rosetta_table_copy_out_p1(t okl_ins_quote_pvt.ipyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
192: , a1 out nocopy JTF_VARCHAR2_TABLE_100
193: , a2 out nocopy JTF_VARCHAR2_TABLE_300
194: , a3 out nocopy JTF_VARCHAR2_TABLE_600
195: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 590: procedure rosetta_table_copy_in_p3(t out nocopy okl_ins_quote_pvt.inav_tbl_type, a0 JTF_NUMBER_TABLE

586: end if;
587: end if;
588: end rosetta_table_copy_out_p1;
589:
590: procedure rosetta_table_copy_in_p3(t out nocopy okl_ins_quote_pvt.inav_tbl_type, a0 JTF_NUMBER_TABLE
591: , a1 JTF_NUMBER_TABLE
592: , a2 JTF_NUMBER_TABLE
593: , a3 JTF_NUMBER_TABLE
594: , a4 JTF_NUMBER_TABLE

Line 673: procedure rosetta_table_copy_out_p3(t okl_ins_quote_pvt.inav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

669: end loop;
670: end if;
671: end if;
672: end rosetta_table_copy_in_p3;
673: procedure rosetta_table_copy_out_p3(t okl_ins_quote_pvt.inav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
674: , a1 out nocopy JTF_NUMBER_TABLE
675: , a2 out nocopy JTF_NUMBER_TABLE
676: , a3 out nocopy JTF_NUMBER_TABLE
677: , a4 out nocopy JTF_NUMBER_TABLE

Line 857: procedure rosetta_table_copy_in_p5(t out nocopy okl_ins_quote_pvt.iasset_tbl_type, a0 JTF_NUMBER_TABLE

853: end if;
854: end if;
855: end rosetta_table_copy_out_p3;
856:
857: procedure rosetta_table_copy_in_p5(t out nocopy okl_ins_quote_pvt.iasset_tbl_type, a0 JTF_NUMBER_TABLE
858: , a1 JTF_NUMBER_TABLE
859: , a2 JTF_NUMBER_TABLE
860: ) as
861: ddindx binary_integer; indx binary_integer;

Line 880: procedure rosetta_table_copy_out_p5(t okl_ins_quote_pvt.iasset_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

876: end loop;
877: end if;
878: end if;
879: end rosetta_table_copy_in_p5;
880: procedure rosetta_table_copy_out_p5(t okl_ins_quote_pvt.iasset_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
881: , a1 out nocopy JTF_NUMBER_TABLE
882: , a2 out nocopy JTF_NUMBER_TABLE
883: ) as
884: ddindx binary_integer; indx binary_integer;

Line 914: procedure rosetta_table_copy_in_p7(t out nocopy okl_ins_quote_pvt.policy_tbl_type, a0 JTF_VARCHAR2_TABLE_100

910: end if;
911: end if;
912: end rosetta_table_copy_out_p5;
913:
914: procedure rosetta_table_copy_in_p7(t out nocopy okl_ins_quote_pvt.policy_tbl_type, a0 JTF_VARCHAR2_TABLE_100
915: , a1 JTF_VARCHAR2_TABLE_200
916: ) as
917: ddindx binary_integer; indx binary_integer;
918: begin

Line 935: procedure rosetta_table_copy_out_p7(t okl_ins_quote_pvt.policy_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

931: end loop;
932: end if;
933: end if;
934: end rosetta_table_copy_in_p7;
935: procedure rosetta_table_copy_out_p7(t okl_ins_quote_pvt.policy_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
936: , a1 out nocopy JTF_VARCHAR2_TABLE_200
937: ) as
938: ddindx binary_integer; indx binary_integer;
939: begin

Line 964: procedure rosetta_table_copy_in_p9(t out nocopy okl_ins_quote_pvt.payment_tbl_type, a0 JTF_NUMBER_TABLE

960: end if;
961: end if;
962: end rosetta_table_copy_out_p7;
963:
964: procedure rosetta_table_copy_in_p9(t out nocopy okl_ins_quote_pvt.payment_tbl_type, a0 JTF_NUMBER_TABLE
965: , a1 JTF_DATE_TABLE
966: ) as
967: ddindx binary_integer; indx binary_integer;
968: begin

Line 985: procedure rosetta_table_copy_out_p9(t okl_ins_quote_pvt.payment_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

981: end loop;
982: end if;
983: end if;
984: end rosetta_table_copy_in_p9;
985: procedure rosetta_table_copy_out_p9(t okl_ins_quote_pvt.payment_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
986: , a1 out nocopy JTF_DATE_TABLE
987: ) as
988: ddindx binary_integer; indx binary_integer;
989: begin

Line 1014: procedure rosetta_table_copy_in_p11(t out nocopy okl_ins_quote_pvt.insexp_tbl_type, a0 JTF_NUMBER_TABLE

1010: end if;
1011: end if;
1012: end rosetta_table_copy_out_p9;
1013:
1014: procedure rosetta_table_copy_in_p11(t out nocopy okl_ins_quote_pvt.insexp_tbl_type, a0 JTF_NUMBER_TABLE
1015: , a1 JTF_NUMBER_TABLE
1016: ) as
1017: ddindx binary_integer; indx binary_integer;
1018: begin

Line 1035: procedure rosetta_table_copy_out_p11(t okl_ins_quote_pvt.insexp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1031: end loop;
1032: end if;
1033: end if;
1034: end rosetta_table_copy_in_p11;
1035: procedure rosetta_table_copy_out_p11(t okl_ins_quote_pvt.insexp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1036: , a1 out nocopy JTF_NUMBER_TABLE
1037: ) as
1038: ddindx binary_integer; indx binary_integer;
1039: begin

Line 1149: ddpx_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;

1145: , x_message out nocopy VARCHAR2
1146: )
1147:
1148: as
1149: ddpx_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;
1150: ddindx binary_integer; indx binary_integer;
1151: begin
1152:
1153: -- copy data to the local IN or IN-OUT args, if any

Line 1238: okl_ins_quote_pvt.save_quote(p_api_version,

1234: ddpx_ipyv_rec.lease_application_id := rosetta_g_miss_num_map(p5_a75);
1235:
1236:
1237: -- here's the delegated call to the old PL/SQL routine
1238: okl_ins_quote_pvt.save_quote(p_api_version,
1239: p_init_msg_list,
1240: x_return_status,
1241: x_msg_count,
1242: x_msg_data,

Line 1416: ddp_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;

1412: , p5_a75 NUMBER := 0-1962.0724
1413: )
1414:
1415: as
1416: ddp_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;
1417: ddindx binary_integer; indx binary_integer;
1418: begin
1419:
1420: -- copy data to the local IN or IN-OUT args, if any

Line 1505: okl_ins_quote_pvt.save_accept_quote(p_api_version,

1501: ddp_ipyv_rec.lease_application_id := rosetta_g_miss_num_map(p5_a75);
1502:
1503:
1504: -- here's the delegated call to the old PL/SQL routine
1505: okl_ins_quote_pvt.save_accept_quote(p_api_version,
1506: p_init_msg_list,
1507: x_return_status,
1508: x_msg_count,
1509: x_msg_data,

Line 1606: ddp_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;

1602: , p5_a75 NUMBER := 0-1962.0724
1603: )
1604:
1605: as
1606: ddp_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;
1607: ddindx binary_integer; indx binary_integer;
1608: begin
1609:
1610: -- copy data to the local IN or IN-OUT args, if any

Line 1694: okl_ins_quote_pvt.create_ins_streams(p_api_version,

1690: ddp_ipyv_rec.last_update_login := rosetta_g_miss_num_map(p5_a74);
1691: ddp_ipyv_rec.lease_application_id := rosetta_g_miss_num_map(p5_a75);
1692:
1693: -- here's the delegated call to the old PL/SQL routine
1694: okl_ins_quote_pvt.create_ins_streams(p_api_version,
1695: p_init_msg_list,
1696: x_return_status,
1697: x_msg_count,
1698: x_msg_data,

Line 1797: ddpx_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;

1793: , p7_a2 out nocopy JTF_NUMBER_TABLE
1794: )
1795:
1796: as
1797: ddpx_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;
1798: ddx_iasset_tbl okl_ins_quote_pvt.iasset_tbl_type;
1799: ddindx binary_integer; indx binary_integer;
1800: begin
1801:

Line 1798: ddx_iasset_tbl okl_ins_quote_pvt.iasset_tbl_type;

1794: )
1795:
1796: as
1797: ddpx_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;
1798: ddx_iasset_tbl okl_ins_quote_pvt.iasset_tbl_type;
1799: ddindx binary_integer; indx binary_integer;
1800: begin
1801:
1802: -- copy data to the local IN or IN-OUT args, if any

Line 1888: okl_ins_quote_pvt.calc_lease_premium(p_api_version,

1884:
1885:
1886:
1887: -- here's the delegated call to the old PL/SQL routine
1888: okl_ins_quote_pvt.calc_lease_premium(p_api_version,
1889: p_init_msg_list,
1890: x_return_status,
1891: x_msg_count,
1892: x_msg_data,

Line 1981: okl_ins_quote_pvt_w.rosetta_table_copy_out_p5(ddx_iasset_tbl, p7_a0

1977: p5_a74 := rosetta_g_miss_num_map(ddpx_ipyv_rec.last_update_login);
1978: p5_a75 := rosetta_g_miss_num_map(ddpx_ipyv_rec.lease_application_id);
1979:
1980:
1981: okl_ins_quote_pvt_w.rosetta_table_copy_out_p5(ddx_iasset_tbl, p7_a0
1982: , p7_a1
1983: , p7_a2
1984: );
1985: end;

Line 2148: ddp_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;

2144: , p5_a75 NUMBER := 0-1962.0724
2145: )
2146:
2147: as
2148: ddp_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;
2149: ddx_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;
2150: ddindx binary_integer; indx binary_integer;
2151: begin
2152:

Line 2149: ddx_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;

2145: )
2146:
2147: as
2148: ddp_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;
2149: ddx_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;
2150: ddindx binary_integer; indx binary_integer;
2151: begin
2152:
2153: -- copy data to the local IN or IN-OUT args, if any

Line 2239: okl_ins_quote_pvt.calc_optional_premium(p_api_version,

2235:
2236:
2237:
2238: -- here's the delegated call to the old PL/SQL routine
2239: okl_ins_quote_pvt.calc_optional_premium(p_api_version,
2240: p_init_msg_list,
2241: x_return_status,
2242: x_msg_count,
2243: x_msg_data,

Line 2418: ddp_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;

2414: , p5_a75 NUMBER := 0-1962.0724
2415: )
2416:
2417: as
2418: ddp_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;
2419: ddindx binary_integer; indx binary_integer;
2420: begin
2421:
2422: -- copy data to the local IN or IN-OUT args, if any

Line 2506: okl_ins_quote_pvt.activate_ins_stream(p_api_version,

2502: ddp_ipyv_rec.last_update_login := rosetta_g_miss_num_map(p5_a74);
2503: ddp_ipyv_rec.lease_application_id := rosetta_g_miss_num_map(p5_a75);
2504:
2505: -- here's the delegated call to the old PL/SQL routine
2506: okl_ins_quote_pvt.activate_ins_stream(p_api_version,
2507: p_init_msg_list,
2508: x_return_status,
2509: x_msg_count,
2510: x_msg_data,

Line 2681: ddp_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;

2677: , p5_a75 NUMBER := 0-1962.0724
2678: )
2679:
2680: as
2681: ddp_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;
2682: ddx_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;
2683: ddindx binary_integer; indx binary_integer;
2684: begin
2685:

Line 2682: ddx_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;

2678: )
2679:
2680: as
2681: ddp_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;
2682: ddx_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;
2683: ddindx binary_integer; indx binary_integer;
2684: begin
2685:
2686: -- copy data to the local IN or IN-OUT args, if any

Line 2771: okl_ins_quote_pvt.create_third_prt_ins(p_api_version,

2767: ddp_ipyv_rec.lease_application_id := rosetta_g_miss_num_map(p5_a75);
2768:
2769:
2770: -- here's the delegated call to the old PL/SQL routine
2771: okl_ins_quote_pvt.create_third_prt_ins(p_api_version,
2772: p_init_msg_list,
2773: x_return_status,
2774: x_msg_count,
2775: x_msg_data,

Line 3024: ddp_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;

3020: , p5_a75 NUMBER := 0-1962.0724
3021: )
3022:
3023: as
3024: ddp_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;
3025: ddx_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;
3026: ddindx binary_integer; indx binary_integer;
3027: begin
3028:

Line 3025: ddx_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;

3021: )
3022:
3023: as
3024: ddp_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;
3025: ddx_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;
3026: ddindx binary_integer; indx binary_integer;
3027: begin
3028:
3029: -- copy data to the local IN or IN-OUT args, if any

Line 3114: okl_ins_quote_pvt.crt_lseapp_thrdprt_ins(p_api_version,

3110: ddp_ipyv_rec.lease_application_id := rosetta_g_miss_num_map(p5_a75);
3111:
3112:
3113: -- here's the delegated call to the old PL/SQL routine
3114: okl_ins_quote_pvt.crt_lseapp_thrdprt_ins(p_api_version,
3115: p_init_msg_list,
3116: x_return_status,
3117: x_msg_count,
3118: x_msg_data,

Line 3292: ddx_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;

3288: , p6_a75 out nocopy NUMBER
3289: )
3290:
3291: as
3292: ddx_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;
3293: ddindx binary_integer; indx binary_integer;
3294: begin
3295:
3296: -- copy data to the local IN or IN-OUT args, if any

Line 3305: okl_ins_quote_pvt.lseapp_thrdprty_to_ctrct(p_api_version,

3301:
3302:
3303:
3304: -- here's the delegated call to the old PL/SQL routine
3305: okl_ins_quote_pvt.lseapp_thrdprty_to_ctrct(p_api_version,
3306: p_init_msg_list,
3307: x_return_status,
3308: x_msg_count,
3309: x_msg_data,

Line 3398: end okl_ins_quote_pvt_w;

3394: p6_a74 := rosetta_g_miss_num_map(ddx_ipyv_rec.last_update_login);
3395: p6_a75 := rosetta_g_miss_num_map(ddx_ipyv_rec.lease_application_id);
3396: end;
3397:
3398: end okl_ins_quote_pvt_w;