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_ART_PVT_W dependencies on OKL_ART_PVT

Line 1: package body okl_art_pvt_w as

1: package body okl_art_pvt_w as
2: /* $Header: OKLIARTB.pls 120.3 2007/11/14 19:35:38 rmunjulu ship $ */
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_art_pvt.art_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_art_pvt.art_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 157: procedure rosetta_table_copy_out_p2(t okl_art_pvt.art_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

153: end loop;
154: end if;
155: end if;
156: end rosetta_table_copy_in_p2;
157: procedure rosetta_table_copy_out_p2(t okl_art_pvt.art_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
158: , a1 out nocopy JTF_NUMBER_TABLE
159: , a2 out nocopy JTF_NUMBER_TABLE
160: , a3 out nocopy JTF_NUMBER_TABLE
161: , a4 out nocopy JTF_NUMBER_TABLE

Line 471: procedure rosetta_table_copy_in_p5(t out nocopy okl_art_pvt.okl_asset_returns_tl_tbl_type, a0 JTF_NUMBER_TABLE

467: end if;
468: end if;
469: end rosetta_table_copy_out_p2;
470:
471: procedure rosetta_table_copy_in_p5(t out nocopy okl_art_pvt.okl_asset_returns_tl_tbl_type, a0 JTF_NUMBER_TABLE
472: , a1 JTF_VARCHAR2_TABLE_100
473: , a2 JTF_VARCHAR2_TABLE_100
474: , a3 JTF_VARCHAR2_TABLE_100
475: , a4 JTF_VARCHAR2_TABLE_2000

Line 510: procedure rosetta_table_copy_out_p5(t okl_art_pvt.okl_asset_returns_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

506: end loop;
507: end if;
508: end if;
509: end rosetta_table_copy_in_p5;
510: procedure rosetta_table_copy_out_p5(t okl_art_pvt.okl_asset_returns_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
511: , a1 out nocopy JTF_VARCHAR2_TABLE_100
512: , a2 out nocopy JTF_VARCHAR2_TABLE_100
513: , a3 out nocopy JTF_VARCHAR2_TABLE_100
514: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 584: procedure rosetta_table_copy_in_p8(t out nocopy okl_art_pvt.artv_tbl_type, a0 JTF_NUMBER_TABLE

580: end if;
581: end if;
582: end rosetta_table_copy_out_p5;
583:
584: procedure rosetta_table_copy_in_p8(t out nocopy okl_art_pvt.artv_tbl_type, a0 JTF_NUMBER_TABLE
585: , a1 JTF_NUMBER_TABLE
586: , a2 JTF_VARCHAR2_TABLE_100
587: , a3 JTF_NUMBER_TABLE
588: , a4 JTF_NUMBER_TABLE

Line 725: procedure rosetta_table_copy_out_p8(t okl_art_pvt.artv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

721: end loop;
722: end if;
723: end if;
724: end rosetta_table_copy_in_p8;
725: procedure rosetta_table_copy_out_p8(t okl_art_pvt.artv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
726: , a1 out nocopy JTF_NUMBER_TABLE
727: , a2 out nocopy JTF_VARCHAR2_TABLE_100
728: , a3 out nocopy JTF_NUMBER_TABLE
729: , a4 out nocopy JTF_NUMBER_TABLE

Line 1186: ddp_artv_rec okl_art_pvt.artv_rec_type;

1182: , p5_a61 NUMBER := 0-1962.0724
1183: )
1184:
1185: as
1186: ddp_artv_rec okl_art_pvt.artv_rec_type;
1187: ddx_artv_rec okl_art_pvt.artv_rec_type;
1188: ddindx binary_integer; indx binary_integer;
1189: begin
1190:

Line 1187: ddx_artv_rec okl_art_pvt.artv_rec_type;

1183: )
1184:
1185: as
1186: ddp_artv_rec okl_art_pvt.artv_rec_type;
1187: ddx_artv_rec okl_art_pvt.artv_rec_type;
1188: ddindx binary_integer; indx binary_integer;
1189: begin
1190:
1191: -- copy data to the local IN or IN-OUT args, if any

Line 1262: okl_art_pvt.insert_row(p_api_version,

1258: ddp_artv_rec.asset_fmv_amount := rosetta_g_miss_num_map(p5_a61);
1259:
1260:
1261: -- here's the delegated call to the old PL/SQL routine
1262: okl_art_pvt.insert_row(p_api_version,
1263: p_init_msg_list,
1264: x_return_status,
1265: x_msg_count,
1266: x_msg_data,

Line 1473: ddp_artv_tbl okl_art_pvt.artv_tbl_type;

1469: , p6_a61 out nocopy JTF_NUMBER_TABLE
1470: )
1471:
1472: as
1473: ddp_artv_tbl okl_art_pvt.artv_tbl_type;
1474: ddx_artv_tbl okl_art_pvt.artv_tbl_type;
1475: ddindx binary_integer; indx binary_integer;
1476: begin
1477:

Line 1474: ddx_artv_tbl okl_art_pvt.artv_tbl_type;

1470: )
1471:
1472: as
1473: ddp_artv_tbl okl_art_pvt.artv_tbl_type;
1474: ddx_artv_tbl okl_art_pvt.artv_tbl_type;
1475: ddindx binary_integer; indx binary_integer;
1476: begin
1477:
1478: -- copy data to the local IN or IN-OUT args, if any

Line 1484: okl_art_pvt_w.rosetta_table_copy_in_p8(ddp_artv_tbl, p5_a0

1480:
1481:
1482:
1483:
1484: okl_art_pvt_w.rosetta_table_copy_in_p8(ddp_artv_tbl, p5_a0
1485: , p5_a1
1486: , p5_a2
1487: , p5_a3
1488: , p5_a4

Line 1550: okl_art_pvt.insert_row(p_api_version,

1546: );
1547:
1548:
1549: -- here's the delegated call to the old PL/SQL routine
1550: okl_art_pvt.insert_row(p_api_version,
1551: p_init_msg_list,
1552: x_return_status,
1553: x_msg_count,
1554: x_msg_data,

Line 1565: okl_art_pvt_w.rosetta_table_copy_out_p8(ddx_artv_tbl, p6_a0

1561:
1562:
1563:
1564:
1565: okl_art_pvt_w.rosetta_table_copy_out_p8(ddx_artv_tbl, p6_a0
1566: , p6_a1
1567: , p6_a2
1568: , p6_a3
1569: , p6_a4

Line 1700: ddp_artv_rec okl_art_pvt.artv_rec_type;

1696: , p5_a61 NUMBER := 0-1962.0724
1697: )
1698:
1699: as
1700: ddp_artv_rec okl_art_pvt.artv_rec_type;
1701: ddindx binary_integer; indx binary_integer;
1702: begin
1703:
1704: -- copy data to the local IN or IN-OUT args, if any

Line 1774: okl_art_pvt.lock_row(p_api_version,

1770: ddp_artv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a60);
1771: ddp_artv_rec.asset_fmv_amount := rosetta_g_miss_num_map(p5_a61);
1772:
1773: -- here's the delegated call to the old PL/SQL routine
1774: okl_art_pvt.lock_row(p_api_version,
1775: p_init_msg_list,
1776: x_return_status,
1777: x_msg_count,
1778: x_msg_data,

Line 1859: ddp_artv_tbl okl_art_pvt.artv_tbl_type;

1855: , p5_a61 JTF_NUMBER_TABLE
1856: )
1857:
1858: as
1859: ddp_artv_tbl okl_art_pvt.artv_tbl_type;
1860: ddindx binary_integer; indx binary_integer;
1861: begin
1862:
1863: -- copy data to the local IN or IN-OUT args, if any

Line 1869: okl_art_pvt_w.rosetta_table_copy_in_p8(ddp_artv_tbl, p5_a0

1865:
1866:
1867:
1868:
1869: okl_art_pvt_w.rosetta_table_copy_in_p8(ddp_artv_tbl, p5_a0
1870: , p5_a1
1871: , p5_a2
1872: , p5_a3
1873: , p5_a4

Line 1934: okl_art_pvt.lock_row(p_api_version,

1930: , p5_a61
1931: );
1932:
1933: -- here's the delegated call to the old PL/SQL routine
1934: okl_art_pvt.lock_row(p_api_version,
1935: p_init_msg_list,
1936: x_return_status,
1937: x_msg_count,
1938: x_msg_data,

Line 2081: ddp_artv_rec okl_art_pvt.artv_rec_type;

2077: , p5_a61 NUMBER := 0-1962.0724
2078: )
2079:
2080: as
2081: ddp_artv_rec okl_art_pvt.artv_rec_type;
2082: ddx_artv_rec okl_art_pvt.artv_rec_type;
2083: ddindx binary_integer; indx binary_integer;
2084: begin
2085:

Line 2082: ddx_artv_rec okl_art_pvt.artv_rec_type;

2078: )
2079:
2080: as
2081: ddp_artv_rec okl_art_pvt.artv_rec_type;
2082: ddx_artv_rec okl_art_pvt.artv_rec_type;
2083: ddindx binary_integer; indx binary_integer;
2084: begin
2085:
2086: -- copy data to the local IN or IN-OUT args, if any

Line 2157: okl_art_pvt.update_row(p_api_version,

2153: ddp_artv_rec.asset_fmv_amount := rosetta_g_miss_num_map(p5_a61);
2154:
2155:
2156: -- here's the delegated call to the old PL/SQL routine
2157: okl_art_pvt.update_row(p_api_version,
2158: p_init_msg_list,
2159: x_return_status,
2160: x_msg_count,
2161: x_msg_data,

Line 2368: ddp_artv_tbl okl_art_pvt.artv_tbl_type;

2364: , p6_a61 out nocopy JTF_NUMBER_TABLE
2365: )
2366:
2367: as
2368: ddp_artv_tbl okl_art_pvt.artv_tbl_type;
2369: ddx_artv_tbl okl_art_pvt.artv_tbl_type;
2370: ddindx binary_integer; indx binary_integer;
2371: begin
2372:

Line 2369: ddx_artv_tbl okl_art_pvt.artv_tbl_type;

2365: )
2366:
2367: as
2368: ddp_artv_tbl okl_art_pvt.artv_tbl_type;
2369: ddx_artv_tbl okl_art_pvt.artv_tbl_type;
2370: ddindx binary_integer; indx binary_integer;
2371: begin
2372:
2373: -- copy data to the local IN or IN-OUT args, if any

Line 2379: okl_art_pvt_w.rosetta_table_copy_in_p8(ddp_artv_tbl, p5_a0

2375:
2376:
2377:
2378:
2379: okl_art_pvt_w.rosetta_table_copy_in_p8(ddp_artv_tbl, p5_a0
2380: , p5_a1
2381: , p5_a2
2382: , p5_a3
2383: , p5_a4

Line 2445: okl_art_pvt.update_row(p_api_version,

2441: );
2442:
2443:
2444: -- here's the delegated call to the old PL/SQL routine
2445: okl_art_pvt.update_row(p_api_version,
2446: p_init_msg_list,
2447: x_return_status,
2448: x_msg_count,
2449: x_msg_data,

Line 2460: okl_art_pvt_w.rosetta_table_copy_out_p8(ddx_artv_tbl, p6_a0

2456:
2457:
2458:
2459:
2460: okl_art_pvt_w.rosetta_table_copy_out_p8(ddx_artv_tbl, p6_a0
2461: , p6_a1
2462: , p6_a2
2463: , p6_a3
2464: , p6_a4

Line 2595: ddp_artv_rec okl_art_pvt.artv_rec_type;

2591: , p5_a61 NUMBER := 0-1962.0724
2592: )
2593:
2594: as
2595: ddp_artv_rec okl_art_pvt.artv_rec_type;
2596: ddindx binary_integer; indx binary_integer;
2597: begin
2598:
2599: -- copy data to the local IN or IN-OUT args, if any

Line 2669: okl_art_pvt.delete_row(p_api_version,

2665: ddp_artv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a60);
2666: ddp_artv_rec.asset_fmv_amount := rosetta_g_miss_num_map(p5_a61);
2667:
2668: -- here's the delegated call to the old PL/SQL routine
2669: okl_art_pvt.delete_row(p_api_version,
2670: p_init_msg_list,
2671: x_return_status,
2672: x_msg_count,
2673: x_msg_data,

Line 2754: ddp_artv_tbl okl_art_pvt.artv_tbl_type;

2750: , p5_a61 JTF_NUMBER_TABLE
2751: )
2752:
2753: as
2754: ddp_artv_tbl okl_art_pvt.artv_tbl_type;
2755: ddindx binary_integer; indx binary_integer;
2756: begin
2757:
2758: -- copy data to the local IN or IN-OUT args, if any

Line 2764: okl_art_pvt_w.rosetta_table_copy_in_p8(ddp_artv_tbl, p5_a0

2760:
2761:
2762:
2763:
2764: okl_art_pvt_w.rosetta_table_copy_in_p8(ddp_artv_tbl, p5_a0
2765: , p5_a1
2766: , p5_a2
2767: , p5_a3
2768: , p5_a4

Line 2829: okl_art_pvt.delete_row(p_api_version,

2825: , p5_a61
2826: );
2827:
2828: -- here's the delegated call to the old PL/SQL routine
2829: okl_art_pvt.delete_row(p_api_version,
2830: p_init_msg_list,
2831: x_return_status,
2832: x_msg_count,
2833: x_msg_data,

Line 2914: ddp_artv_rec okl_art_pvt.artv_rec_type;

2910: , p5_a61 NUMBER := 0-1962.0724
2911: )
2912:
2913: as
2914: ddp_artv_rec okl_art_pvt.artv_rec_type;
2915: ddindx binary_integer; indx binary_integer;
2916: begin
2917:
2918: -- copy data to the local IN or IN-OUT args, if any

Line 2988: okl_art_pvt.validate_row(p_api_version,

2984: ddp_artv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a60);
2985: ddp_artv_rec.asset_fmv_amount := rosetta_g_miss_num_map(p5_a61);
2986:
2987: -- here's the delegated call to the old PL/SQL routine
2988: okl_art_pvt.validate_row(p_api_version,
2989: p_init_msg_list,
2990: x_return_status,
2991: x_msg_count,
2992: x_msg_data,

Line 3073: ddp_artv_tbl okl_art_pvt.artv_tbl_type;

3069: , p5_a61 JTF_NUMBER_TABLE
3070: )
3071:
3072: as
3073: ddp_artv_tbl okl_art_pvt.artv_tbl_type;
3074: ddindx binary_integer; indx binary_integer;
3075: begin
3076:
3077: -- copy data to the local IN or IN-OUT args, if any

Line 3083: okl_art_pvt_w.rosetta_table_copy_in_p8(ddp_artv_tbl, p5_a0

3079:
3080:
3081:
3082:
3083: okl_art_pvt_w.rosetta_table_copy_in_p8(ddp_artv_tbl, p5_a0
3084: , p5_a1
3085: , p5_a2
3086: , p5_a3
3087: , p5_a4

Line 3148: okl_art_pvt.validate_row(p_api_version,

3144: , p5_a61
3145: );
3146:
3147: -- here's the delegated call to the old PL/SQL routine
3148: okl_art_pvt.validate_row(p_api_version,
3149: p_init_msg_list,
3150: x_return_status,
3151: x_msg_count,
3152: x_msg_data,

Line 3163: end okl_art_pvt_w;

3159:
3160:
3161: end;
3162:
3163: end okl_art_pvt_w;