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_POOL_PVT_W dependencies on OKL_POOL_PVT

Line 1: package body okl_pool_pvt_w as

1: package body okl_pool_pvt_w as
2: /* $Header: OKLESZPB.pls 120.5 2007/12/14 11:10:17 ssdeshpa 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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 25: procedure rosetta_table_copy_in_p46(t out nocopy okl_pool_pvt.polsrch_tbl_type, a0 JTF_NUMBER_TABLE

21: if n=b then return a; end if;
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p46(t out nocopy okl_pool_pvt.polsrch_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_400
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_VARCHAR2_TABLE_200

Line 122: procedure rosetta_table_copy_out_p46(t okl_pool_pvt.polsrch_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

118: end loop;
119: end if;
120: end if;
121: end rosetta_table_copy_in_p46;
122: procedure rosetta_table_copy_out_p46(t okl_pool_pvt.polsrch_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
123: , a1 out nocopy JTF_VARCHAR2_TABLE_400
124: , a2 out nocopy JTF_VARCHAR2_TABLE_100
125: , a3 out nocopy JTF_NUMBER_TABLE
126: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 341: procedure rosetta_table_copy_in_p48(t out nocopy okl_pool_pvt.poc_uv_tbl_type, a0 JTF_NUMBER_TABLE

337: end if;
338: end if;
339: end rosetta_table_copy_out_p46;
340:
341: procedure rosetta_table_copy_in_p48(t out nocopy okl_pool_pvt.poc_uv_tbl_type, a0 JTF_NUMBER_TABLE
342: , a1 JTF_VARCHAR2_TABLE_200
343: , a2 JTF_VARCHAR2_TABLE_200
344: , a3 JTF_VARCHAR2_TABLE_400
345: , a4 JTF_VARCHAR2_TABLE_200

Line 376: procedure rosetta_table_copy_out_p48(t okl_pool_pvt.poc_uv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

372: end loop;
373: end if;
374: end if;
375: end rosetta_table_copy_in_p48;
376: procedure rosetta_table_copy_out_p48(t okl_pool_pvt.poc_uv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
377: , a1 out nocopy JTF_VARCHAR2_TABLE_200
378: , a2 out nocopy JTF_VARCHAR2_TABLE_200
379: , a3 out nocopy JTF_VARCHAR2_TABLE_400
380: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 536: ddp_polv_rec okl_pool_pvt.polv_rec_type;

532: , p5_a43 NUMBER := 0-1962.0724
533: )
534:
535: as
536: ddp_polv_rec okl_pool_pvt.polv_rec_type;
537: ddx_polv_rec okl_pool_pvt.polv_rec_type;
538: ddindx binary_integer; indx binary_integer;
539: begin
540:

Line 537: ddx_polv_rec okl_pool_pvt.polv_rec_type;

533: )
534:
535: as
536: ddp_polv_rec okl_pool_pvt.polv_rec_type;
537: ddx_polv_rec okl_pool_pvt.polv_rec_type;
538: ddindx binary_integer; indx binary_integer;
539: begin
540:
541: -- copy data to the local IN or IN-OUT args, if any

Line 594: okl_pool_pvt.create_pool(p_api_version,

590: ddp_polv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a43);
591:
592:
593: -- here's the delegated call to the old PL/SQL routine
594: okl_pool_pvt.create_pool(p_api_version,
595: p_init_msg_list,
596: x_return_status,
597: x_msg_count,
598: x_msg_data,

Line 751: ddp_polv_rec okl_pool_pvt.polv_rec_type;

747: , p5_a43 NUMBER := 0-1962.0724
748: )
749:
750: as
751: ddp_polv_rec okl_pool_pvt.polv_rec_type;
752: ddx_polv_rec okl_pool_pvt.polv_rec_type;
753: ddindx binary_integer; indx binary_integer;
754: begin
755:

Line 752: ddx_polv_rec okl_pool_pvt.polv_rec_type;

748: )
749:
750: as
751: ddp_polv_rec okl_pool_pvt.polv_rec_type;
752: ddx_polv_rec okl_pool_pvt.polv_rec_type;
753: ddindx binary_integer; indx binary_integer;
754: begin
755:
756: -- copy data to the local IN or IN-OUT args, if any

Line 809: okl_pool_pvt.update_pool(p_api_version,

805: ddp_polv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a43);
806:
807:
808: -- here's the delegated call to the old PL/SQL routine
809: okl_pool_pvt.update_pool(p_api_version,
810: p_init_msg_list,
811: x_return_status,
812: x_msg_count,
813: x_msg_data,

Line 922: ddp_polv_rec okl_pool_pvt.polv_rec_type;

918: , p5_a43 NUMBER := 0-1962.0724
919: )
920:
921: as
922: ddp_polv_rec okl_pool_pvt.polv_rec_type;
923: ddindx binary_integer; indx binary_integer;
924: begin
925:
926: -- copy data to the local IN or IN-OUT args, if any

Line 978: okl_pool_pvt.delete_pool(p_api_version,

974: ddp_polv_rec.last_update_login := rosetta_g_miss_num_map(p5_a42);
975: ddp_polv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a43);
976:
977: -- here's the delegated call to the old PL/SQL routine
978: okl_pool_pvt.delete_pool(p_api_version,
979: p_init_msg_list,
980: x_return_status,
981: x_msg_count,
982: x_msg_data,

Line 1081: ddp_pocv_rec okl_pool_pvt.pocv_rec_type;

1077: , p5_a39 NUMBER := 0-1962.0724
1078: )
1079:
1080: as
1081: ddp_pocv_rec okl_pool_pvt.pocv_rec_type;
1082: ddx_pocv_rec okl_pool_pvt.pocv_rec_type;
1083: ddindx binary_integer; indx binary_integer;
1084: begin
1085:

Line 1082: ddx_pocv_rec okl_pool_pvt.pocv_rec_type;

1078: )
1079:
1080: as
1081: ddp_pocv_rec okl_pool_pvt.pocv_rec_type;
1082: ddx_pocv_rec okl_pool_pvt.pocv_rec_type;
1083: ddindx binary_integer; indx binary_integer;
1084: begin
1085:
1086: -- copy data to the local IN or IN-OUT args, if any

Line 1135: okl_pool_pvt.create_pool_contents(p_api_version,

1131: ddp_pocv_rec.last_update_login := rosetta_g_miss_num_map(p5_a39);
1132:
1133:
1134: -- here's the delegated call to the old PL/SQL routine
1135: okl_pool_pvt.create_pool_contents(p_api_version,
1136: p_init_msg_list,
1137: x_return_status,
1138: x_msg_count,
1139: x_msg_data,

Line 1280: ddp_pocv_tbl okl_pool_pvt.pocv_tbl_type;

1276: , p6_a39 out nocopy JTF_NUMBER_TABLE
1277: )
1278:
1279: as
1280: ddp_pocv_tbl okl_pool_pvt.pocv_tbl_type;
1281: ddx_pocv_tbl okl_pool_pvt.pocv_tbl_type;
1282: ddindx binary_integer; indx binary_integer;
1283: begin
1284:

Line 1281: ddx_pocv_tbl okl_pool_pvt.pocv_tbl_type;

1277: )
1278:
1279: as
1280: ddp_pocv_tbl okl_pool_pvt.pocv_tbl_type;
1281: ddx_pocv_tbl okl_pool_pvt.pocv_tbl_type;
1282: ddindx binary_integer; indx binary_integer;
1283: begin
1284:
1285: -- copy data to the local IN or IN-OUT args, if any

Line 1335: okl_pool_pvt.create_pool_contents(p_api_version,

1331: );
1332:
1333:
1334: -- here's the delegated call to the old PL/SQL routine
1335: okl_pool_pvt.create_pool_contents(p_api_version,
1336: p_init_msg_list,
1337: x_return_status,
1338: x_msg_count,
1339: x_msg_data,

Line 1481: ddp_pocv_rec okl_pool_pvt.pocv_rec_type;

1477: , p5_a39 NUMBER := 0-1962.0724
1478: )
1479:
1480: as
1481: ddp_pocv_rec okl_pool_pvt.pocv_rec_type;
1482: ddx_pocv_rec okl_pool_pvt.pocv_rec_type;
1483: ddindx binary_integer; indx binary_integer;
1484: begin
1485:

Line 1482: ddx_pocv_rec okl_pool_pvt.pocv_rec_type;

1478: )
1479:
1480: as
1481: ddp_pocv_rec okl_pool_pvt.pocv_rec_type;
1482: ddx_pocv_rec okl_pool_pvt.pocv_rec_type;
1483: ddindx binary_integer; indx binary_integer;
1484: begin
1485:
1486: -- copy data to the local IN or IN-OUT args, if any

Line 1535: okl_pool_pvt.update_pool_contents(p_api_version,

1531: ddp_pocv_rec.last_update_login := rosetta_g_miss_num_map(p5_a39);
1532:
1533:
1534: -- here's the delegated call to the old PL/SQL routine
1535: okl_pool_pvt.update_pool_contents(p_api_version,
1536: p_init_msg_list,
1537: x_return_status,
1538: x_msg_count,
1539: x_msg_data,

Line 1680: ddp_pocv_tbl okl_pool_pvt.pocv_tbl_type;

1676: , p6_a39 out nocopy JTF_NUMBER_TABLE
1677: )
1678:
1679: as
1680: ddp_pocv_tbl okl_pool_pvt.pocv_tbl_type;
1681: ddx_pocv_tbl okl_pool_pvt.pocv_tbl_type;
1682: ddindx binary_integer; indx binary_integer;
1683: begin
1684:

Line 1681: ddx_pocv_tbl okl_pool_pvt.pocv_tbl_type;

1677: )
1678:
1679: as
1680: ddp_pocv_tbl okl_pool_pvt.pocv_tbl_type;
1681: ddx_pocv_tbl okl_pool_pvt.pocv_tbl_type;
1682: ddindx binary_integer; indx binary_integer;
1683: begin
1684:
1685: -- copy data to the local IN or IN-OUT args, if any

Line 1735: okl_pool_pvt.update_pool_contents(p_api_version,

1731: );
1732:
1733:
1734: -- here's the delegated call to the old PL/SQL routine
1735: okl_pool_pvt.update_pool_contents(p_api_version,
1736: p_init_msg_list,
1737: x_return_status,
1738: x_msg_count,
1739: x_msg_data,

Line 1841: ddp_pocv_rec okl_pool_pvt.pocv_rec_type;

1837: , p5_a39 NUMBER := 0-1962.0724
1838: )
1839:
1840: as
1841: ddp_pocv_rec okl_pool_pvt.pocv_rec_type;
1842: ddindx binary_integer; indx binary_integer;
1843: begin
1844:
1845: -- copy data to the local IN or IN-OUT args, if any

Line 1893: okl_pool_pvt.delete_pool_contents(p_api_version,

1889: ddp_pocv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a38);
1890: ddp_pocv_rec.last_update_login := rosetta_g_miss_num_map(p5_a39);
1891:
1892: -- here's the delegated call to the old PL/SQL routine
1893: okl_pool_pvt.delete_pool_contents(p_api_version,
1894: p_init_msg_list,
1895: x_return_status,
1896: x_msg_count,
1897: x_msg_data,

Line 1956: ddp_pocv_tbl okl_pool_pvt.pocv_tbl_type;

1952: , p5_a39 JTF_NUMBER_TABLE
1953: )
1954:
1955: as
1956: ddp_pocv_tbl okl_pool_pvt.pocv_tbl_type;
1957: ddindx binary_integer; indx binary_integer;
1958: begin
1959:
1960: -- copy data to the local IN or IN-OUT args, if any

Line 2009: okl_pool_pvt.delete_pool_contents(p_api_version,

2005: , p5_a39
2006: );
2007:
2008: -- here's the delegated call to the old PL/SQL routine
2009: okl_pool_pvt.delete_pool_contents(p_api_version,
2010: p_init_msg_list,
2011: x_return_status,
2012: x_msg_count,
2013: x_msg_data,

Line 2112: ddp_poxv_rec okl_pool_pvt.poxv_rec_type;

2108: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2109: )
2110:
2111: as
2112: ddp_poxv_rec okl_pool_pvt.poxv_rec_type;
2113: ddx_poxv_rec okl_pool_pvt.poxv_rec_type;
2114: ddindx binary_integer; indx binary_integer;
2115: begin
2116:

Line 2113: ddx_poxv_rec okl_pool_pvt.poxv_rec_type;

2109: )
2110:
2111: as
2112: ddp_poxv_rec okl_pool_pvt.poxv_rec_type;
2113: ddx_poxv_rec okl_pool_pvt.poxv_rec_type;
2114: ddindx binary_integer; indx binary_integer;
2115: begin
2116:
2117: -- copy data to the local IN or IN-OUT args, if any

Line 2166: okl_pool_pvt.create_pool_transaction(p_api_version,

2162: ddp_poxv_rec.transaction_status := p5_a39;
2163:
2164:
2165: -- here's the delegated call to the old PL/SQL routine
2166: okl_pool_pvt.create_pool_transaction(p_api_version,
2167: p_init_msg_list,
2168: x_return_status,
2169: x_msg_count,
2170: x_msg_data,

Line 2311: ddp_poxv_rec okl_pool_pvt.poxv_rec_type;

2307: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2308: )
2309:
2310: as
2311: ddp_poxv_rec okl_pool_pvt.poxv_rec_type;
2312: ddx_poxv_rec okl_pool_pvt.poxv_rec_type;
2313: ddindx binary_integer; indx binary_integer;
2314: begin
2315:

Line 2312: ddx_poxv_rec okl_pool_pvt.poxv_rec_type;

2308: )
2309:
2310: as
2311: ddp_poxv_rec okl_pool_pvt.poxv_rec_type;
2312: ddx_poxv_rec okl_pool_pvt.poxv_rec_type;
2313: ddindx binary_integer; indx binary_integer;
2314: begin
2315:
2316: -- copy data to the local IN or IN-OUT args, if any

Line 2365: okl_pool_pvt.update_pool_transaction(p_api_version,

2361: ddp_poxv_rec.transaction_status := p5_a39;
2362:
2363:
2364: -- here's the delegated call to the old PL/SQL routine
2365: okl_pool_pvt.update_pool_transaction(p_api_version,
2366: p_init_msg_list,
2367: x_return_status,
2368: x_msg_count,
2369: x_msg_data,

Line 2470: ddp_poxv_rec okl_pool_pvt.poxv_rec_type;

2466: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2467: )
2468:
2469: as
2470: ddp_poxv_rec okl_pool_pvt.poxv_rec_type;
2471: ddindx binary_integer; indx binary_integer;
2472: begin
2473:
2474: -- copy data to the local IN or IN-OUT args, if any

Line 2522: okl_pool_pvt.delete_pool_transaction(p_api_version,

2518: ddp_poxv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a38);
2519: ddp_poxv_rec.transaction_status := p5_a39;
2520:
2521: -- here's the delegated call to the old PL/SQL routine
2522: okl_pool_pvt.delete_pool_transaction(p_api_version,
2523: p_init_msg_list,
2524: x_return_status,
2525: x_msg_count,
2526: x_msg_data,

Line 2629: okl_pool_pvt.add_pool_contents(p_api_version,

2625:
2626:
2627:
2628: -- here's the delegated call to the old PL/SQL routine
2629: okl_pool_pvt.add_pool_contents(p_api_version,
2630: p_init_msg_list,
2631: x_return_status,
2632: x_msg_count,
2633: x_msg_data,

Line 2755: ddx_poc_uv_tbl okl_pool_pvt.poc_uv_tbl_type;

2751: ddp_end_from_date date;
2752: ddp_end_to_date date;
2753: ddp_streams_from_date date;
2754: ddp_streams_to_date date;
2755: ddx_poc_uv_tbl okl_pool_pvt.poc_uv_tbl_type;
2756: ddindx binary_integer; indx binary_integer;
2757: begin
2758:
2759: -- copy data to the local IN or IN-OUT args, if any

Line 2801: okl_pool_pvt.cleanup_pool_contents(p_api_version,

2797:
2798:
2799:
2800: -- here's the delegated call to the old PL/SQL routine
2801: okl_pool_pvt.cleanup_pool_contents(p_api_version,
2802: p_init_msg_list,
2803: x_return_status,
2804: x_msg_count,
2805: x_msg_data,

Line 2870: okl_pool_pvt_w.rosetta_table_copy_out_p48(ddx_poc_uv_tbl, p33_a0

2866:
2867:
2868:
2869:
2870: okl_pool_pvt_w.rosetta_table_copy_out_p48(ddx_poc_uv_tbl, p33_a0
2871: , p33_a1
2872: , p33_a2
2873: , p33_a3
2874: , p33_a4

Line 2936: ddp_polv_rec okl_pool_pvt.polv_rec_type;

2932: , p3_a43 NUMBER := 0-1962.0724
2933: )
2934:
2935: as
2936: ddp_polv_rec okl_pool_pvt.polv_rec_type;
2937: ddindx binary_integer; indx binary_integer;
2938: begin
2939:
2940: -- copy data to the local IN or IN-OUT args, if any

Line 2994: okl_pool_pvt.validate_pool(p_api_version,

2990:
2991:
2992:
2993: -- here's the delegated call to the old PL/SQL routine
2994: okl_pool_pvt.validate_pool(p_api_version,
2995: p_init_msg_list,
2996: p_api_name,
2997: ddp_polv_rec,
2998: p_action,

Line 3013: end okl_pool_pvt_w;

3009:
3010:
3011: end;
3012:
3013: end okl_pool_pvt_w;