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_SFE_PVT_W dependencies on OKL_SFE_PVT

Line 1: package body okl_sfe_pvt_w as

1: package body okl_sfe_pvt_w as
2: /* $Header: OKLISFEB.pls 120.3 2005/10/11 06:38:53 rgooty 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_p2(t out nocopy okl_sfe_pvt.sfe_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_p2(t out nocopy okl_sfe_pvt.sfe_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 149: procedure rosetta_table_copy_out_p2(t okl_sfe_pvt.sfe_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

145: end loop;
146: end if;
147: end if;
148: end rosetta_table_copy_in_p2;
149: procedure rosetta_table_copy_out_p2(t okl_sfe_pvt.sfe_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
150: , a1 out nocopy JTF_VARCHAR2_TABLE_100
151: , a2 out nocopy JTF_DATE_TABLE
152: , a3 out nocopy JTF_DATE_TABLE
153: , a4 out nocopy JTF_NUMBER_TABLE

Line 443: procedure rosetta_table_copy_in_p5(t out nocopy okl_sfe_pvt.sfev_tbl_type, a0 JTF_NUMBER_TABLE

439: end if;
440: end if;
441: end rosetta_table_copy_out_p2;
442:
443: procedure rosetta_table_copy_in_p5(t out nocopy okl_sfe_pvt.sfev_tbl_type, a0 JTF_NUMBER_TABLE
444: , a1 JTF_VARCHAR2_TABLE_100
445: , a2 JTF_DATE_TABLE
446: , a3 JTF_DATE_TABLE
447: , a4 JTF_NUMBER_TABLE

Line 570: procedure rosetta_table_copy_out_p5(t okl_sfe_pvt.sfev_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

566: end loop;
567: end if;
568: end if;
569: end rosetta_table_copy_in_p5;
570: procedure rosetta_table_copy_out_p5(t okl_sfe_pvt.sfev_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
571: , a1 out nocopy JTF_VARCHAR2_TABLE_100
572: , a2 out nocopy JTF_DATE_TABLE
573: , a3 out nocopy JTF_DATE_TABLE
574: , a4 out nocopy JTF_NUMBER_TABLE

Line 982: ddp_sfev_rec okl_sfe_pvt.sfev_rec_type;

978: , p5_a54 NUMBER := 0-1962.0724
979: )
980:
981: as
982: ddp_sfev_rec okl_sfe_pvt.sfev_rec_type;
983: ddx_sfev_rec okl_sfe_pvt.sfev_rec_type;
984: ddindx binary_integer; indx binary_integer;
985: begin
986:

Line 983: ddx_sfev_rec okl_sfe_pvt.sfev_rec_type;

979: )
980:
981: as
982: ddp_sfev_rec okl_sfe_pvt.sfev_rec_type;
983: ddx_sfev_rec okl_sfe_pvt.sfev_rec_type;
984: ddindx binary_integer; indx binary_integer;
985: begin
986:
987: -- copy data to the local IN or IN-OUT args, if any

Line 1051: okl_sfe_pvt.insert_row(p_api_version,

1047: ddp_sfev_rec.down_payment_amount := rosetta_g_miss_num_map(p5_a54);
1048:
1049:
1050: -- here's the delegated call to the old PL/SQL routine
1051: okl_sfe_pvt.insert_row(p_api_version,
1052: p_init_msg_list,
1053: x_return_status,
1054: x_msg_count,
1055: x_msg_data,

Line 1241: ddp_sfev_tbl okl_sfe_pvt.sfev_tbl_type;

1237: , p6_a54 out nocopy JTF_NUMBER_TABLE
1238: )
1239:
1240: as
1241: ddp_sfev_tbl okl_sfe_pvt.sfev_tbl_type;
1242: ddx_sfev_tbl okl_sfe_pvt.sfev_tbl_type;
1243: ddindx binary_integer; indx binary_integer;
1244: begin
1245:

Line 1242: ddx_sfev_tbl okl_sfe_pvt.sfev_tbl_type;

1238: )
1239:
1240: as
1241: ddp_sfev_tbl okl_sfe_pvt.sfev_tbl_type;
1242: ddx_sfev_tbl okl_sfe_pvt.sfev_tbl_type;
1243: ddindx binary_integer; indx binary_integer;
1244: begin
1245:
1246: -- copy data to the local IN or IN-OUT args, if any

Line 1252: okl_sfe_pvt_w.rosetta_table_copy_in_p5(ddp_sfev_tbl, p5_a0

1248:
1249:
1250:
1251:
1252: okl_sfe_pvt_w.rosetta_table_copy_in_p5(ddp_sfev_tbl, p5_a0
1253: , p5_a1
1254: , p5_a2
1255: , p5_a3
1256: , p5_a4

Line 1311: okl_sfe_pvt.insert_row(p_api_version,

1307: );
1308:
1309:
1310: -- here's the delegated call to the old PL/SQL routine
1311: okl_sfe_pvt.insert_row(p_api_version,
1312: p_init_msg_list,
1313: x_return_status,
1314: x_msg_count,
1315: x_msg_data,

Line 1326: okl_sfe_pvt_w.rosetta_table_copy_out_p5(ddx_sfev_tbl, p6_a0

1322:
1323:
1324:
1325:
1326: okl_sfe_pvt_w.rosetta_table_copy_out_p5(ddx_sfev_tbl, p6_a0
1327: , p6_a1
1328: , p6_a2
1329: , p6_a3
1330: , p6_a4

Line 1447: ddp_sfev_rec okl_sfe_pvt.sfev_rec_type;

1443: , p5_a54 NUMBER := 0-1962.0724
1444: )
1445:
1446: as
1447: ddp_sfev_rec okl_sfe_pvt.sfev_rec_type;
1448: ddindx binary_integer; indx binary_integer;
1449: begin
1450:
1451: -- copy data to the local IN or IN-OUT args, if any

Line 1514: okl_sfe_pvt.lock_row(p_api_version,

1510: ddp_sfev_rec.last_update_login := rosetta_g_miss_num_map(p5_a53);
1511: ddp_sfev_rec.down_payment_amount := rosetta_g_miss_num_map(p5_a54);
1512:
1513: -- here's the delegated call to the old PL/SQL routine
1514: okl_sfe_pvt.lock_row(p_api_version,
1515: p_init_msg_list,
1516: x_return_status,
1517: x_msg_count,
1518: x_msg_data,

Line 1592: ddp_sfev_tbl okl_sfe_pvt.sfev_tbl_type;

1588: , p5_a54 JTF_NUMBER_TABLE
1589: )
1590:
1591: as
1592: ddp_sfev_tbl okl_sfe_pvt.sfev_tbl_type;
1593: ddindx binary_integer; indx binary_integer;
1594: begin
1595:
1596: -- copy data to the local IN or IN-OUT args, if any

Line 1602: okl_sfe_pvt_w.rosetta_table_copy_in_p5(ddp_sfev_tbl, p5_a0

1598:
1599:
1600:
1601:
1602: okl_sfe_pvt_w.rosetta_table_copy_in_p5(ddp_sfev_tbl, p5_a0
1603: , p5_a1
1604: , p5_a2
1605: , p5_a3
1606: , p5_a4

Line 1660: okl_sfe_pvt.lock_row(p_api_version,

1656: , p5_a54
1657: );
1658:
1659: -- here's the delegated call to the old PL/SQL routine
1660: okl_sfe_pvt.lock_row(p_api_version,
1661: p_init_msg_list,
1662: x_return_status,
1663: x_msg_count,
1664: x_msg_data,

Line 1793: ddp_sfev_rec okl_sfe_pvt.sfev_rec_type;

1789: , p5_a54 NUMBER := 0-1962.0724
1790: )
1791:
1792: as
1793: ddp_sfev_rec okl_sfe_pvt.sfev_rec_type;
1794: ddx_sfev_rec okl_sfe_pvt.sfev_rec_type;
1795: ddindx binary_integer; indx binary_integer;
1796: begin
1797:

Line 1794: ddx_sfev_rec okl_sfe_pvt.sfev_rec_type;

1790: )
1791:
1792: as
1793: ddp_sfev_rec okl_sfe_pvt.sfev_rec_type;
1794: ddx_sfev_rec okl_sfe_pvt.sfev_rec_type;
1795: ddindx binary_integer; indx binary_integer;
1796: begin
1797:
1798: -- copy data to the local IN or IN-OUT args, if any

Line 1862: okl_sfe_pvt.update_row(p_api_version,

1858: ddp_sfev_rec.down_payment_amount := rosetta_g_miss_num_map(p5_a54);
1859:
1860:
1861: -- here's the delegated call to the old PL/SQL routine
1862: okl_sfe_pvt.update_row(p_api_version,
1863: p_init_msg_list,
1864: x_return_status,
1865: x_msg_count,
1866: x_msg_data,

Line 2052: ddp_sfev_tbl okl_sfe_pvt.sfev_tbl_type;

2048: , p6_a54 out nocopy JTF_NUMBER_TABLE
2049: )
2050:
2051: as
2052: ddp_sfev_tbl okl_sfe_pvt.sfev_tbl_type;
2053: ddx_sfev_tbl okl_sfe_pvt.sfev_tbl_type;
2054: ddindx binary_integer; indx binary_integer;
2055: begin
2056:

Line 2053: ddx_sfev_tbl okl_sfe_pvt.sfev_tbl_type;

2049: )
2050:
2051: as
2052: ddp_sfev_tbl okl_sfe_pvt.sfev_tbl_type;
2053: ddx_sfev_tbl okl_sfe_pvt.sfev_tbl_type;
2054: ddindx binary_integer; indx binary_integer;
2055: begin
2056:
2057: -- copy data to the local IN or IN-OUT args, if any

Line 2063: okl_sfe_pvt_w.rosetta_table_copy_in_p5(ddp_sfev_tbl, p5_a0

2059:
2060:
2061:
2062:
2063: okl_sfe_pvt_w.rosetta_table_copy_in_p5(ddp_sfev_tbl, p5_a0
2064: , p5_a1
2065: , p5_a2
2066: , p5_a3
2067: , p5_a4

Line 2122: okl_sfe_pvt.update_row(p_api_version,

2118: );
2119:
2120:
2121: -- here's the delegated call to the old PL/SQL routine
2122: okl_sfe_pvt.update_row(p_api_version,
2123: p_init_msg_list,
2124: x_return_status,
2125: x_msg_count,
2126: x_msg_data,

Line 2137: okl_sfe_pvt_w.rosetta_table_copy_out_p5(ddx_sfev_tbl, p6_a0

2133:
2134:
2135:
2136:
2137: okl_sfe_pvt_w.rosetta_table_copy_out_p5(ddx_sfev_tbl, p6_a0
2138: , p6_a1
2139: , p6_a2
2140: , p6_a3
2141: , p6_a4

Line 2258: ddp_sfev_rec okl_sfe_pvt.sfev_rec_type;

2254: , p5_a54 NUMBER := 0-1962.0724
2255: )
2256:
2257: as
2258: ddp_sfev_rec okl_sfe_pvt.sfev_rec_type;
2259: ddindx binary_integer; indx binary_integer;
2260: begin
2261:
2262: -- copy data to the local IN or IN-OUT args, if any

Line 2325: okl_sfe_pvt.delete_row(p_api_version,

2321: ddp_sfev_rec.last_update_login := rosetta_g_miss_num_map(p5_a53);
2322: ddp_sfev_rec.down_payment_amount := rosetta_g_miss_num_map(p5_a54);
2323:
2324: -- here's the delegated call to the old PL/SQL routine
2325: okl_sfe_pvt.delete_row(p_api_version,
2326: p_init_msg_list,
2327: x_return_status,
2328: x_msg_count,
2329: x_msg_data,

Line 2403: ddp_sfev_tbl okl_sfe_pvt.sfev_tbl_type;

2399: , p5_a54 JTF_NUMBER_TABLE
2400: )
2401:
2402: as
2403: ddp_sfev_tbl okl_sfe_pvt.sfev_tbl_type;
2404: ddindx binary_integer; indx binary_integer;
2405: begin
2406:
2407: -- copy data to the local IN or IN-OUT args, if any

Line 2413: okl_sfe_pvt_w.rosetta_table_copy_in_p5(ddp_sfev_tbl, p5_a0

2409:
2410:
2411:
2412:
2413: okl_sfe_pvt_w.rosetta_table_copy_in_p5(ddp_sfev_tbl, p5_a0
2414: , p5_a1
2415: , p5_a2
2416: , p5_a3
2417: , p5_a4

Line 2471: okl_sfe_pvt.delete_row(p_api_version,

2467: , p5_a54
2468: );
2469:
2470: -- here's the delegated call to the old PL/SQL routine
2471: okl_sfe_pvt.delete_row(p_api_version,
2472: p_init_msg_list,
2473: x_return_status,
2474: x_msg_count,
2475: x_msg_data,

Line 2549: ddp_sfev_rec okl_sfe_pvt.sfev_rec_type;

2545: , p5_a54 NUMBER := 0-1962.0724
2546: )
2547:
2548: as
2549: ddp_sfev_rec okl_sfe_pvt.sfev_rec_type;
2550: ddindx binary_integer; indx binary_integer;
2551: begin
2552:
2553: -- copy data to the local IN or IN-OUT args, if any

Line 2616: okl_sfe_pvt.validate_row(p_api_version,

2612: ddp_sfev_rec.last_update_login := rosetta_g_miss_num_map(p5_a53);
2613: ddp_sfev_rec.down_payment_amount := rosetta_g_miss_num_map(p5_a54);
2614:
2615: -- here's the delegated call to the old PL/SQL routine
2616: okl_sfe_pvt.validate_row(p_api_version,
2617: p_init_msg_list,
2618: x_return_status,
2619: x_msg_count,
2620: x_msg_data,

Line 2694: ddp_sfev_tbl okl_sfe_pvt.sfev_tbl_type;

2690: , p5_a54 JTF_NUMBER_TABLE
2691: )
2692:
2693: as
2694: ddp_sfev_tbl okl_sfe_pvt.sfev_tbl_type;
2695: ddindx binary_integer; indx binary_integer;
2696: begin
2697:
2698: -- copy data to the local IN or IN-OUT args, if any

Line 2704: okl_sfe_pvt_w.rosetta_table_copy_in_p5(ddp_sfev_tbl, p5_a0

2700:
2701:
2702:
2703:
2704: okl_sfe_pvt_w.rosetta_table_copy_in_p5(ddp_sfev_tbl, p5_a0
2705: , p5_a1
2706: , p5_a2
2707: , p5_a3
2708: , p5_a4

Line 2762: okl_sfe_pvt.validate_row(p_api_version,

2758: , p5_a54
2759: );
2760:
2761: -- here's the delegated call to the old PL/SQL routine
2762: okl_sfe_pvt.validate_row(p_api_version,
2763: p_init_msg_list,
2764: x_return_status,
2765: x_msg_count,
2766: x_msg_data,

Line 2777: end okl_sfe_pvt_w;

2773:
2774:
2775: end;
2776:
2777: end okl_sfe_pvt_w;