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_SUB_PVT_W dependencies on OKL_SUB_PVT

Line 1: package body okl_sub_pvt_w as

1: package body okl_sub_pvt_w as
2: /* $Header: OKLISUBB.pls 120.4 2005/10/30 04:18:43 appldev 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_sub_pvt.subv_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_sub_pvt.subv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 143: procedure rosetta_table_copy_out_p2(t okl_sub_pvt.subv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

139: end loop;
140: end if;
141: end if;
142: end rosetta_table_copy_in_p2;
143: procedure rosetta_table_copy_out_p2(t okl_sub_pvt.subv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
144: , a1 out nocopy JTF_NUMBER_TABLE
145: , a2 out nocopy JTF_VARCHAR2_TABLE_100
146: , a3 out nocopy JTF_NUMBER_TABLE
147: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 422: procedure rosetta_table_copy_in_p5(t out nocopy okl_sub_pvt.subt_tbl_type, a0 JTF_NUMBER_TABLE

418: end if;
419: end if;
420: end rosetta_table_copy_out_p2;
421:
422: procedure rosetta_table_copy_in_p5(t out nocopy okl_sub_pvt.subt_tbl_type, a0 JTF_NUMBER_TABLE
423: , a1 JTF_VARCHAR2_TABLE_200
424: , a2 JTF_VARCHAR2_TABLE_2000
425: , a3 JTF_VARCHAR2_TABLE_100
426: , a4 JTF_VARCHAR2_TABLE_100

Line 461: procedure rosetta_table_copy_out_p5(t okl_sub_pvt.subt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

457: end loop;
458: end if;
459: end if;
460: end rosetta_table_copy_in_p5;
461: procedure rosetta_table_copy_out_p5(t okl_sub_pvt.subt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
462: , a1 out nocopy JTF_VARCHAR2_TABLE_200
463: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
464: , a3 out nocopy JTF_VARCHAR2_TABLE_100
465: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 535: procedure rosetta_table_copy_in_p8(t out nocopy okl_sub_pvt.subb_tbl_type, a0 JTF_NUMBER_TABLE

531: end if;
532: end if;
533: end rosetta_table_copy_out_p5;
534:
535: procedure rosetta_table_copy_in_p8(t out nocopy okl_sub_pvt.subb_tbl_type, a0 JTF_NUMBER_TABLE
536: , a1 JTF_NUMBER_TABLE
537: , a2 JTF_NUMBER_TABLE
538: , a3 JTF_VARCHAR2_TABLE_100
539: , a4 JTF_DATE_TABLE

Line 650: procedure rosetta_table_copy_out_p8(t okl_sub_pvt.subb_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

646: end loop;
647: end if;
648: end if;
649: end rosetta_table_copy_in_p8;
650: procedure rosetta_table_copy_out_p8(t okl_sub_pvt.subb_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
651: , a1 out nocopy JTF_NUMBER_TABLE
652: , a2 out nocopy JTF_NUMBER_TABLE
653: , a3 out nocopy JTF_VARCHAR2_TABLE_100
654: , a4 out nocopy JTF_DATE_TABLE

Line 1026: ddp_subv_rec okl_sub_pvt.subv_rec_type;

1022: , p5_a51 NUMBER := 0-1962.0724
1023: )
1024:
1025: as
1026: ddp_subv_rec okl_sub_pvt.subv_rec_type;
1027: ddx_subv_rec okl_sub_pvt.subv_rec_type;
1028: ddindx binary_integer; indx binary_integer;
1029: begin
1030:

Line 1027: ddx_subv_rec okl_sub_pvt.subv_rec_type;

1023: )
1024:
1025: as
1026: ddp_subv_rec okl_sub_pvt.subv_rec_type;
1027: ddx_subv_rec okl_sub_pvt.subv_rec_type;
1028: ddindx binary_integer; indx binary_integer;
1029: begin
1030:
1031: -- copy data to the local IN or IN-OUT args, if any

Line 1092: okl_sub_pvt.insert_row(p_api_version,

1088: ddp_subv_rec.subsidy_pool_id := rosetta_g_miss_num_map(p5_a51);
1089:
1090:
1091: -- here's the delegated call to the old PL/SQL routine
1092: okl_sub_pvt.insert_row(p_api_version,
1093: p_init_msg_list,
1094: x_return_status,
1095: x_msg_count,
1096: x_msg_data,

Line 1273: ddp_subv_tbl okl_sub_pvt.subv_tbl_type;

1269: , p6_a51 out nocopy JTF_NUMBER_TABLE
1270: )
1271:
1272: as
1273: ddp_subv_tbl okl_sub_pvt.subv_tbl_type;
1274: ddx_subv_tbl okl_sub_pvt.subv_tbl_type;
1275: ddindx binary_integer; indx binary_integer;
1276: begin
1277:

Line 1274: ddx_subv_tbl okl_sub_pvt.subv_tbl_type;

1270: )
1271:
1272: as
1273: ddp_subv_tbl okl_sub_pvt.subv_tbl_type;
1274: ddx_subv_tbl okl_sub_pvt.subv_tbl_type;
1275: ddindx binary_integer; indx binary_integer;
1276: begin
1277:
1278: -- copy data to the local IN or IN-OUT args, if any

Line 1284: okl_sub_pvt_w.rosetta_table_copy_in_p2(ddp_subv_tbl, p5_a0

1280:
1281:
1282:
1283:
1284: okl_sub_pvt_w.rosetta_table_copy_in_p2(ddp_subv_tbl, p5_a0
1285: , p5_a1
1286: , p5_a2
1287: , p5_a3
1288: , p5_a4

Line 1340: okl_sub_pvt.insert_row(p_api_version,

1336: );
1337:
1338:
1339: -- here's the delegated call to the old PL/SQL routine
1340: okl_sub_pvt.insert_row(p_api_version,
1341: p_init_msg_list,
1342: x_return_status,
1343: x_msg_count,
1344: x_msg_data,

Line 1355: okl_sub_pvt_w.rosetta_table_copy_out_p2(ddx_subv_tbl, p6_a0

1351:
1352:
1353:
1354:
1355: okl_sub_pvt_w.rosetta_table_copy_out_p2(ddx_subv_tbl, p6_a0
1356: , p6_a1
1357: , p6_a2
1358: , p6_a3
1359: , p6_a4

Line 1470: ddp_subv_rec okl_sub_pvt.subv_rec_type;

1466: , p5_a51 NUMBER := 0-1962.0724
1467: )
1468:
1469: as
1470: ddp_subv_rec okl_sub_pvt.subv_rec_type;
1471: ddindx binary_integer; indx binary_integer;
1472: begin
1473:
1474: -- copy data to the local IN or IN-OUT args, if any

Line 1534: okl_sub_pvt.lock_row(p_api_version,

1530: ddp_subv_rec.last_update_login := rosetta_g_miss_num_map(p5_a50);
1531: ddp_subv_rec.subsidy_pool_id := rosetta_g_miss_num_map(p5_a51);
1532:
1533: -- here's the delegated call to the old PL/SQL routine
1534: okl_sub_pvt.lock_row(p_api_version,
1535: p_init_msg_list,
1536: x_return_status,
1537: x_msg_count,
1538: x_msg_data,

Line 1609: ddp_subv_tbl okl_sub_pvt.subv_tbl_type;

1605: , p5_a51 JTF_NUMBER_TABLE
1606: )
1607:
1608: as
1609: ddp_subv_tbl okl_sub_pvt.subv_tbl_type;
1610: ddindx binary_integer; indx binary_integer;
1611: begin
1612:
1613: -- copy data to the local IN or IN-OUT args, if any

Line 1619: okl_sub_pvt_w.rosetta_table_copy_in_p2(ddp_subv_tbl, p5_a0

1615:
1616:
1617:
1618:
1619: okl_sub_pvt_w.rosetta_table_copy_in_p2(ddp_subv_tbl, p5_a0
1620: , p5_a1
1621: , p5_a2
1622: , p5_a3
1623: , p5_a4

Line 1674: okl_sub_pvt.lock_row(p_api_version,

1670: , p5_a51
1671: );
1672:
1673: -- here's the delegated call to the old PL/SQL routine
1674: okl_sub_pvt.lock_row(p_api_version,
1675: p_init_msg_list,
1676: x_return_status,
1677: x_msg_count,
1678: x_msg_data,

Line 1801: ddp_subv_rec okl_sub_pvt.subv_rec_type;

1797: , p5_a51 NUMBER := 0-1962.0724
1798: )
1799:
1800: as
1801: ddp_subv_rec okl_sub_pvt.subv_rec_type;
1802: ddx_subv_rec okl_sub_pvt.subv_rec_type;
1803: ddindx binary_integer; indx binary_integer;
1804: begin
1805:

Line 1802: ddx_subv_rec okl_sub_pvt.subv_rec_type;

1798: )
1799:
1800: as
1801: ddp_subv_rec okl_sub_pvt.subv_rec_type;
1802: ddx_subv_rec okl_sub_pvt.subv_rec_type;
1803: ddindx binary_integer; indx binary_integer;
1804: begin
1805:
1806: -- copy data to the local IN or IN-OUT args, if any

Line 1867: okl_sub_pvt.update_row(p_api_version,

1863: ddp_subv_rec.subsidy_pool_id := rosetta_g_miss_num_map(p5_a51);
1864:
1865:
1866: -- here's the delegated call to the old PL/SQL routine
1867: okl_sub_pvt.update_row(p_api_version,
1868: p_init_msg_list,
1869: x_return_status,
1870: x_msg_count,
1871: x_msg_data,

Line 2048: ddp_subv_tbl okl_sub_pvt.subv_tbl_type;

2044: , p6_a51 out nocopy JTF_NUMBER_TABLE
2045: )
2046:
2047: as
2048: ddp_subv_tbl okl_sub_pvt.subv_tbl_type;
2049: ddx_subv_tbl okl_sub_pvt.subv_tbl_type;
2050: ddindx binary_integer; indx binary_integer;
2051: begin
2052:

Line 2049: ddx_subv_tbl okl_sub_pvt.subv_tbl_type;

2045: )
2046:
2047: as
2048: ddp_subv_tbl okl_sub_pvt.subv_tbl_type;
2049: ddx_subv_tbl okl_sub_pvt.subv_tbl_type;
2050: ddindx binary_integer; indx binary_integer;
2051: begin
2052:
2053: -- copy data to the local IN or IN-OUT args, if any

Line 2059: okl_sub_pvt_w.rosetta_table_copy_in_p2(ddp_subv_tbl, p5_a0

2055:
2056:
2057:
2058:
2059: okl_sub_pvt_w.rosetta_table_copy_in_p2(ddp_subv_tbl, p5_a0
2060: , p5_a1
2061: , p5_a2
2062: , p5_a3
2063: , p5_a4

Line 2115: okl_sub_pvt.update_row(p_api_version,

2111: );
2112:
2113:
2114: -- here's the delegated call to the old PL/SQL routine
2115: okl_sub_pvt.update_row(p_api_version,
2116: p_init_msg_list,
2117: x_return_status,
2118: x_msg_count,
2119: x_msg_data,

Line 2130: okl_sub_pvt_w.rosetta_table_copy_out_p2(ddx_subv_tbl, p6_a0

2126:
2127:
2128:
2129:
2130: okl_sub_pvt_w.rosetta_table_copy_out_p2(ddx_subv_tbl, p6_a0
2131: , p6_a1
2132: , p6_a2
2133: , p6_a3
2134: , p6_a4

Line 2245: ddp_subv_rec okl_sub_pvt.subv_rec_type;

2241: , p5_a51 NUMBER := 0-1962.0724
2242: )
2243:
2244: as
2245: ddp_subv_rec okl_sub_pvt.subv_rec_type;
2246: ddindx binary_integer; indx binary_integer;
2247: begin
2248:
2249: -- copy data to the local IN or IN-OUT args, if any

Line 2309: okl_sub_pvt.delete_row(p_api_version,

2305: ddp_subv_rec.last_update_login := rosetta_g_miss_num_map(p5_a50);
2306: ddp_subv_rec.subsidy_pool_id := rosetta_g_miss_num_map(p5_a51);
2307:
2308: -- here's the delegated call to the old PL/SQL routine
2309: okl_sub_pvt.delete_row(p_api_version,
2310: p_init_msg_list,
2311: x_return_status,
2312: x_msg_count,
2313: x_msg_data,

Line 2384: ddp_subv_tbl okl_sub_pvt.subv_tbl_type;

2380: , p5_a51 JTF_NUMBER_TABLE
2381: )
2382:
2383: as
2384: ddp_subv_tbl okl_sub_pvt.subv_tbl_type;
2385: ddindx binary_integer; indx binary_integer;
2386: begin
2387:
2388: -- copy data to the local IN or IN-OUT args, if any

Line 2394: okl_sub_pvt_w.rosetta_table_copy_in_p2(ddp_subv_tbl, p5_a0

2390:
2391:
2392:
2393:
2394: okl_sub_pvt_w.rosetta_table_copy_in_p2(ddp_subv_tbl, p5_a0
2395: , p5_a1
2396: , p5_a2
2397: , p5_a3
2398: , p5_a4

Line 2449: okl_sub_pvt.delete_row(p_api_version,

2445: , p5_a51
2446: );
2447:
2448: -- here's the delegated call to the old PL/SQL routine
2449: okl_sub_pvt.delete_row(p_api_version,
2450: p_init_msg_list,
2451: x_return_status,
2452: x_msg_count,
2453: x_msg_data,

Line 2524: ddp_subv_rec okl_sub_pvt.subv_rec_type;

2520: , p5_a51 NUMBER := 0-1962.0724
2521: )
2522:
2523: as
2524: ddp_subv_rec okl_sub_pvt.subv_rec_type;
2525: ddindx binary_integer; indx binary_integer;
2526: begin
2527:
2528: -- copy data to the local IN or IN-OUT args, if any

Line 2588: okl_sub_pvt.validate_row(p_api_version,

2584: ddp_subv_rec.last_update_login := rosetta_g_miss_num_map(p5_a50);
2585: ddp_subv_rec.subsidy_pool_id := rosetta_g_miss_num_map(p5_a51);
2586:
2587: -- here's the delegated call to the old PL/SQL routine
2588: okl_sub_pvt.validate_row(p_api_version,
2589: p_init_msg_list,
2590: x_return_status,
2591: x_msg_count,
2592: x_msg_data,

Line 2663: ddp_subv_tbl okl_sub_pvt.subv_tbl_type;

2659: , p5_a51 JTF_NUMBER_TABLE
2660: )
2661:
2662: as
2663: ddp_subv_tbl okl_sub_pvt.subv_tbl_type;
2664: ddindx binary_integer; indx binary_integer;
2665: begin
2666:
2667: -- copy data to the local IN or IN-OUT args, if any

Line 2673: okl_sub_pvt_w.rosetta_table_copy_in_p2(ddp_subv_tbl, p5_a0

2669:
2670:
2671:
2672:
2673: okl_sub_pvt_w.rosetta_table_copy_in_p2(ddp_subv_tbl, p5_a0
2674: , p5_a1
2675: , p5_a2
2676: , p5_a3
2677: , p5_a4

Line 2728: okl_sub_pvt.validate_row(p_api_version,

2724: , p5_a51
2725: );
2726:
2727: -- here's the delegated call to the old PL/SQL routine
2728: okl_sub_pvt.validate_row(p_api_version,
2729: p_init_msg_list,
2730: x_return_status,
2731: x_msg_count,
2732: x_msg_data,

Line 2743: end okl_sub_pvt_w;

2739:
2740:
2741: end;
2742:
2743: end okl_sub_pvt_w;