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_BTC_PVT_W dependencies on OKL_BTC_PVT

Line 1: package body okl_btc_pvt_w as

1: package body okl_btc_pvt_w as
2: /* $Header: OKLEBTCB.pls 120.4 2007/09/28 06:49:11 varangan 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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 25: procedure rosetta_table_copy_in_p2(t out nocopy okl_btc_pvt.btc_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_p2(t out nocopy okl_btc_pvt.btc_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_DATE_TABLE
28: , a3 JTF_DATE_TABLE
29: , a4 JTF_DATE_TABLE

Line 122: procedure rosetta_table_copy_out_p2(t okl_btc_pvt.btc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

118: end loop;
119: end if;
120: end if;
121: end rosetta_table_copy_in_p2;
122: procedure rosetta_table_copy_out_p2(t okl_btc_pvt.btc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
123: , a1 out nocopy JTF_NUMBER_TABLE
124: , a2 out nocopy JTF_DATE_TABLE
125: , a3 out nocopy JTF_DATE_TABLE
126: , a4 out nocopy JTF_DATE_TABLE

Line 341: procedure rosetta_table_copy_in_p5(t out nocopy okl_btc_pvt.okl_trx_csh_batch_tl_tbl_type, a0 JTF_NUMBER_TABLE

337: end if;
338: end if;
339: end rosetta_table_copy_out_p2;
340:
341: procedure rosetta_table_copy_in_p5(t out nocopy okl_btc_pvt.okl_trx_csh_batch_tl_tbl_type, a0 JTF_NUMBER_TABLE
342: , a1 JTF_VARCHAR2_TABLE_100
343: , a2 JTF_VARCHAR2_TABLE_100
344: , a3 JTF_VARCHAR2_TABLE_100
345: , a4 JTF_VARCHAR2_TABLE_200

Line 380: procedure rosetta_table_copy_out_p5(t okl_btc_pvt.okl_trx_csh_batch_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

376: end loop;
377: end if;
378: end if;
379: end rosetta_table_copy_in_p5;
380: procedure rosetta_table_copy_out_p5(t okl_btc_pvt.okl_trx_csh_batch_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
381: , a1 out nocopy JTF_VARCHAR2_TABLE_100
382: , a2 out nocopy JTF_VARCHAR2_TABLE_100
383: , a3 out nocopy JTF_VARCHAR2_TABLE_100
384: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 454: procedure rosetta_table_copy_in_p8(t out nocopy okl_btc_pvt.btcv_tbl_type, a0 JTF_NUMBER_TABLE

450: end if;
451: end if;
452: end rosetta_table_copy_out_p5;
453:
454: procedure rosetta_table_copy_in_p8(t out nocopy okl_btc_pvt.btcv_tbl_type, a0 JTF_NUMBER_TABLE
455: , a1 JTF_NUMBER_TABLE
456: , a2 JTF_VARCHAR2_TABLE_100
457: , a3 JTF_VARCHAR2_TABLE_200
458: , a4 JTF_DATE_TABLE

Line 557: procedure rosetta_table_copy_out_p8(t okl_btc_pvt.btcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

553: end loop;
554: end if;
555: end if;
556: end rosetta_table_copy_in_p8;
557: procedure rosetta_table_copy_out_p8(t okl_btc_pvt.btcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
558: , a1 out nocopy JTF_NUMBER_TABLE
559: , a2 out nocopy JTF_VARCHAR2_TABLE_100
560: , a3 out nocopy JTF_VARCHAR2_TABLE_200
561: , a4 out nocopy JTF_DATE_TABLE

Line 885: ddp_btcv_rec okl_btc_pvt.btcv_rec_type;

881: , p5_a42 NUMBER := 0-1962.0724
882: )
883:
884: as
885: ddp_btcv_rec okl_btc_pvt.btcv_rec_type;
886: ddx_btcv_rec okl_btc_pvt.btcv_rec_type;
887: ddindx binary_integer; indx binary_integer;
888: begin
889:

Line 886: ddx_btcv_rec okl_btc_pvt.btcv_rec_type;

882: )
883:
884: as
885: ddp_btcv_rec okl_btc_pvt.btcv_rec_type;
886: ddx_btcv_rec okl_btc_pvt.btcv_rec_type;
887: ddindx binary_integer; indx binary_integer;
888: begin
889:
890: -- copy data to the local IN or IN-OUT args, if any

Line 942: okl_btc_pvt.insert_row(p_api_version,

938: ddp_btcv_rec.remit_bank_id := rosetta_g_miss_num_map(p5_a42);
939:
940:
941: -- here's the delegated call to the old PL/SQL routine
942: okl_btc_pvt.insert_row(p_api_version,
943: p_init_msg_list,
944: x_return_status,
945: x_msg_count,
946: x_msg_data,

Line 1096: ddp_btcv_tbl okl_btc_pvt.btcv_tbl_type;

1092: , p6_a42 out nocopy JTF_NUMBER_TABLE
1093: )
1094:
1095: as
1096: ddp_btcv_tbl okl_btc_pvt.btcv_tbl_type;
1097: ddx_btcv_tbl okl_btc_pvt.btcv_tbl_type;
1098: ddindx binary_integer; indx binary_integer;
1099: begin
1100:

Line 1097: ddx_btcv_tbl okl_btc_pvt.btcv_tbl_type;

1093: )
1094:
1095: as
1096: ddp_btcv_tbl okl_btc_pvt.btcv_tbl_type;
1097: ddx_btcv_tbl okl_btc_pvt.btcv_tbl_type;
1098: ddindx binary_integer; indx binary_integer;
1099: begin
1100:
1101: -- copy data to the local IN or IN-OUT args, if any

Line 1107: okl_btc_pvt_w.rosetta_table_copy_in_p8(ddp_btcv_tbl, p5_a0

1103:
1104:
1105:
1106:
1107: okl_btc_pvt_w.rosetta_table_copy_in_p8(ddp_btcv_tbl, p5_a0
1108: , p5_a1
1109: , p5_a2
1110: , p5_a3
1111: , p5_a4

Line 1154: okl_btc_pvt.insert_row(p_api_version,

1150: );
1151:
1152:
1153: -- here's the delegated call to the old PL/SQL routine
1154: okl_btc_pvt.insert_row(p_api_version,
1155: p_init_msg_list,
1156: x_return_status,
1157: x_msg_count,
1158: x_msg_data,

Line 1169: okl_btc_pvt_w.rosetta_table_copy_out_p8(ddx_btcv_tbl, p6_a0

1165:
1166:
1167:
1168:
1169: okl_btc_pvt_w.rosetta_table_copy_out_p8(ddx_btcv_tbl, p6_a0
1170: , p6_a1
1171: , p6_a2
1172: , p6_a3
1173: , p6_a4

Line 1266: ddp_btcv_rec okl_btc_pvt.btcv_rec_type;

1262: , p5_a42 NUMBER := 0-1962.0724
1263: )
1264:
1265: as
1266: ddp_btcv_rec okl_btc_pvt.btcv_rec_type;
1267: ddindx binary_integer; indx binary_integer;
1268: begin
1269:
1270: -- copy data to the local IN or IN-OUT args, if any

Line 1321: okl_btc_pvt.lock_row(p_api_version,

1317: ddp_btcv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a41);
1318: ddp_btcv_rec.remit_bank_id := rosetta_g_miss_num_map(p5_a42);
1319:
1320: -- here's the delegated call to the old PL/SQL routine
1321: okl_btc_pvt.lock_row(p_api_version,
1322: p_init_msg_list,
1323: x_return_status,
1324: x_msg_count,
1325: x_msg_data,

Line 1387: ddp_btcv_tbl okl_btc_pvt.btcv_tbl_type;

1383: , p5_a42 JTF_NUMBER_TABLE
1384: )
1385:
1386: as
1387: ddp_btcv_tbl okl_btc_pvt.btcv_tbl_type;
1388: ddindx binary_integer; indx binary_integer;
1389: begin
1390:
1391: -- copy data to the local IN or IN-OUT args, if any

Line 1397: okl_btc_pvt_w.rosetta_table_copy_in_p8(ddp_btcv_tbl, p5_a0

1393:
1394:
1395:
1396:
1397: okl_btc_pvt_w.rosetta_table_copy_in_p8(ddp_btcv_tbl, p5_a0
1398: , p5_a1
1399: , p5_a2
1400: , p5_a3
1401: , p5_a4

Line 1443: okl_btc_pvt.lock_row(p_api_version,

1439: , p5_a42
1440: );
1441:
1442: -- here's the delegated call to the old PL/SQL routine
1443: okl_btc_pvt.lock_row(p_api_version,
1444: p_init_msg_list,
1445: x_return_status,
1446: x_msg_count,
1447: x_msg_data,

Line 1552: ddp_btcv_rec okl_btc_pvt.btcv_rec_type;

1548: , p5_a42 NUMBER := 0-1962.0724
1549: )
1550:
1551: as
1552: ddp_btcv_rec okl_btc_pvt.btcv_rec_type;
1553: ddx_btcv_rec okl_btc_pvt.btcv_rec_type;
1554: ddindx binary_integer; indx binary_integer;
1555: begin
1556:

Line 1553: ddx_btcv_rec okl_btc_pvt.btcv_rec_type;

1549: )
1550:
1551: as
1552: ddp_btcv_rec okl_btc_pvt.btcv_rec_type;
1553: ddx_btcv_rec okl_btc_pvt.btcv_rec_type;
1554: ddindx binary_integer; indx binary_integer;
1555: begin
1556:
1557: -- copy data to the local IN or IN-OUT args, if any

Line 1609: okl_btc_pvt.update_row(p_api_version,

1605: ddp_btcv_rec.remit_bank_id := rosetta_g_miss_num_map(p5_a42);
1606:
1607:
1608: -- here's the delegated call to the old PL/SQL routine
1609: okl_btc_pvt.update_row(p_api_version,
1610: p_init_msg_list,
1611: x_return_status,
1612: x_msg_count,
1613: x_msg_data,

Line 1763: ddp_btcv_tbl okl_btc_pvt.btcv_tbl_type;

1759: , p6_a42 out nocopy JTF_NUMBER_TABLE
1760: )
1761:
1762: as
1763: ddp_btcv_tbl okl_btc_pvt.btcv_tbl_type;
1764: ddx_btcv_tbl okl_btc_pvt.btcv_tbl_type;
1765: ddindx binary_integer; indx binary_integer;
1766: begin
1767:

Line 1764: ddx_btcv_tbl okl_btc_pvt.btcv_tbl_type;

1760: )
1761:
1762: as
1763: ddp_btcv_tbl okl_btc_pvt.btcv_tbl_type;
1764: ddx_btcv_tbl okl_btc_pvt.btcv_tbl_type;
1765: ddindx binary_integer; indx binary_integer;
1766: begin
1767:
1768: -- copy data to the local IN or IN-OUT args, if any

Line 1774: okl_btc_pvt_w.rosetta_table_copy_in_p8(ddp_btcv_tbl, p5_a0

1770:
1771:
1772:
1773:
1774: okl_btc_pvt_w.rosetta_table_copy_in_p8(ddp_btcv_tbl, p5_a0
1775: , p5_a1
1776: , p5_a2
1777: , p5_a3
1778: , p5_a4

Line 1821: okl_btc_pvt.update_row(p_api_version,

1817: );
1818:
1819:
1820: -- here's the delegated call to the old PL/SQL routine
1821: okl_btc_pvt.update_row(p_api_version,
1822: p_init_msg_list,
1823: x_return_status,
1824: x_msg_count,
1825: x_msg_data,

Line 1836: okl_btc_pvt_w.rosetta_table_copy_out_p8(ddx_btcv_tbl, p6_a0

1832:
1833:
1834:
1835:
1836: okl_btc_pvt_w.rosetta_table_copy_out_p8(ddx_btcv_tbl, p6_a0
1837: , p6_a1
1838: , p6_a2
1839: , p6_a3
1840: , p6_a4

Line 1933: ddp_btcv_rec okl_btc_pvt.btcv_rec_type;

1929: , p5_a42 NUMBER := 0-1962.0724
1930: )
1931:
1932: as
1933: ddp_btcv_rec okl_btc_pvt.btcv_rec_type;
1934: ddindx binary_integer; indx binary_integer;
1935: begin
1936:
1937: -- copy data to the local IN or IN-OUT args, if any

Line 1988: okl_btc_pvt.delete_row(p_api_version,

1984: ddp_btcv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a41);
1985: ddp_btcv_rec.remit_bank_id := rosetta_g_miss_num_map(p5_a42);
1986:
1987: -- here's the delegated call to the old PL/SQL routine
1988: okl_btc_pvt.delete_row(p_api_version,
1989: p_init_msg_list,
1990: x_return_status,
1991: x_msg_count,
1992: x_msg_data,

Line 2054: ddp_btcv_tbl okl_btc_pvt.btcv_tbl_type;

2050: , p5_a42 JTF_NUMBER_TABLE
2051: )
2052:
2053: as
2054: ddp_btcv_tbl okl_btc_pvt.btcv_tbl_type;
2055: ddindx binary_integer; indx binary_integer;
2056: begin
2057:
2058: -- copy data to the local IN or IN-OUT args, if any

Line 2064: okl_btc_pvt_w.rosetta_table_copy_in_p8(ddp_btcv_tbl, p5_a0

2060:
2061:
2062:
2063:
2064: okl_btc_pvt_w.rosetta_table_copy_in_p8(ddp_btcv_tbl, p5_a0
2065: , p5_a1
2066: , p5_a2
2067: , p5_a3
2068: , p5_a4

Line 2110: okl_btc_pvt.delete_row(p_api_version,

2106: , p5_a42
2107: );
2108:
2109: -- here's the delegated call to the old PL/SQL routine
2110: okl_btc_pvt.delete_row(p_api_version,
2111: p_init_msg_list,
2112: x_return_status,
2113: x_msg_count,
2114: x_msg_data,

Line 2176: ddp_btcv_rec okl_btc_pvt.btcv_rec_type;

2172: , p5_a42 NUMBER := 0-1962.0724
2173: )
2174:
2175: as
2176: ddp_btcv_rec okl_btc_pvt.btcv_rec_type;
2177: ddindx binary_integer; indx binary_integer;
2178: begin
2179:
2180: -- copy data to the local IN or IN-OUT args, if any

Line 2231: okl_btc_pvt.validate_row(p_api_version,

2227: ddp_btcv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a41);
2228: ddp_btcv_rec.remit_bank_id := rosetta_g_miss_num_map(p5_a42);
2229:
2230: -- here's the delegated call to the old PL/SQL routine
2231: okl_btc_pvt.validate_row(p_api_version,
2232: p_init_msg_list,
2233: x_return_status,
2234: x_msg_count,
2235: x_msg_data,

Line 2297: ddp_btcv_tbl okl_btc_pvt.btcv_tbl_type;

2293: , p5_a42 JTF_NUMBER_TABLE
2294: )
2295:
2296: as
2297: ddp_btcv_tbl okl_btc_pvt.btcv_tbl_type;
2298: ddindx binary_integer; indx binary_integer;
2299: begin
2300:
2301: -- copy data to the local IN or IN-OUT args, if any

Line 2307: okl_btc_pvt_w.rosetta_table_copy_in_p8(ddp_btcv_tbl, p5_a0

2303:
2304:
2305:
2306:
2307: okl_btc_pvt_w.rosetta_table_copy_in_p8(ddp_btcv_tbl, p5_a0
2308: , p5_a1
2309: , p5_a2
2310: , p5_a3
2311: , p5_a4

Line 2353: okl_btc_pvt.validate_row(p_api_version,

2349: , p5_a42
2350: );
2351:
2352: -- here's the delegated call to the old PL/SQL routine
2353: okl_btc_pvt.validate_row(p_api_version,
2354: p_init_msg_list,
2355: x_return_status,
2356: x_msg_count,
2357: x_msg_data,

Line 2368: end okl_btc_pvt_w;

2364:
2365:
2366: end;
2367:
2368: end okl_btc_pvt_w;