DBA Data[Home] [Help]

APPS.OKL_ACN_PVT_W dependencies on OKL_ACN_PVT

Line 1: package body okl_acn_pvt_w as

1: package body okl_acn_pvt_w as
2: /* $Header: OKLIACNB.pls 115.3 2002/12/19 23:24:15 gkadarka 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_acn_pvt.acn_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_acn_pvt.acn_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100

Line 135: procedure rosetta_table_copy_out_p2(t okl_acn_pvt.acn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

131: end loop;
132: end if;
133: end if;
134: end rosetta_table_copy_in_p2;
135: procedure rosetta_table_copy_out_p2(t okl_acn_pvt.acn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
136: , a1 out nocopy JTF_NUMBER_TABLE
137: , a2 out nocopy JTF_NUMBER_TABLE
138: , a3 out nocopy JTF_VARCHAR2_TABLE_100
139: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 394: procedure rosetta_table_copy_in_p5(t out nocopy okl_acn_pvt.oklassetcndtnlnstltbltype, a0 JTF_NUMBER_TABLE

390: end if;
391: end if;
392: end rosetta_table_copy_out_p2;
393:
394: procedure rosetta_table_copy_in_p5(t out nocopy okl_acn_pvt.oklassetcndtnlnstltbltype, a0 JTF_NUMBER_TABLE
395: , a1 JTF_VARCHAR2_TABLE_100
396: , a2 JTF_VARCHAR2_TABLE_100
397: , a3 JTF_VARCHAR2_TABLE_100
398: , a4 JTF_VARCHAR2_TABLE_2000

Line 437: procedure rosetta_table_copy_out_p5(t okl_acn_pvt.oklassetcndtnlnstltbltype, a0 out nocopy JTF_NUMBER_TABLE

433: end loop;
434: end if;
435: end if;
436: end rosetta_table_copy_in_p5;
437: procedure rosetta_table_copy_out_p5(t okl_acn_pvt.oklassetcndtnlnstltbltype, a0 out nocopy JTF_NUMBER_TABLE
438: , a1 out nocopy JTF_VARCHAR2_TABLE_100
439: , a2 out nocopy JTF_VARCHAR2_TABLE_100
440: , a3 out nocopy JTF_VARCHAR2_TABLE_100
441: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 521: procedure rosetta_table_copy_in_p8(t out nocopy okl_acn_pvt.acnv_tbl_type, a0 JTF_NUMBER_TABLE

517: end if;
518: end if;
519: end rosetta_table_copy_out_p5;
520:
521: procedure rosetta_table_copy_in_p8(t out nocopy okl_acn_pvt.acnv_tbl_type, a0 JTF_NUMBER_TABLE
522: , a1 JTF_NUMBER_TABLE
523: , a2 JTF_VARCHAR2_TABLE_100
524: , a3 JTF_VARCHAR2_TABLE_100
525: , a4 JTF_VARCHAR2_TABLE_100

Line 644: procedure rosetta_table_copy_out_p8(t okl_acn_pvt.acnv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

640: end loop;
641: end if;
642: end if;
643: end rosetta_table_copy_in_p8;
644: procedure rosetta_table_copy_out_p8(t okl_acn_pvt.acnv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
645: , a1 out nocopy JTF_NUMBER_TABLE
646: , a2 out nocopy JTF_VARCHAR2_TABLE_100
647: , a3 out nocopy JTF_VARCHAR2_TABLE_100
648: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1042: ddp_acnv_rec okl_acn_pvt.acnv_rec_type;

1038: , p5_a52 DATE := fnd_api.g_miss_date
1039: )
1040:
1041: as
1042: ddp_acnv_rec okl_acn_pvt.acnv_rec_type;
1043: ddx_acnv_rec okl_acn_pvt.acnv_rec_type;
1044: ddindx binary_integer; indx binary_integer;
1045: begin
1046:

Line 1043: ddx_acnv_rec okl_acn_pvt.acnv_rec_type;

1039: )
1040:
1041: as
1042: ddp_acnv_rec okl_acn_pvt.acnv_rec_type;
1043: ddx_acnv_rec okl_acn_pvt.acnv_rec_type;
1044: ddindx binary_integer; indx binary_integer;
1045: begin
1046:
1047: -- copy data to the local IN or IN-OUT args, if any

Line 1109: okl_acn_pvt.insert_row(p_api_version,

1105: ddp_acnv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a52);
1106:
1107:
1108: -- here's the delegated call to the old PL/SQL routine
1109: okl_acn_pvt.insert_row(p_api_version,
1110: p_init_msg_list,
1111: x_return_status,
1112: x_msg_count,
1113: x_msg_data,

Line 1293: ddp_acnv_tbl okl_acn_pvt.acnv_tbl_type;

1289: , p6_a52 out nocopy JTF_DATE_TABLE
1290: )
1291:
1292: as
1293: ddp_acnv_tbl okl_acn_pvt.acnv_tbl_type;
1294: ddx_acnv_tbl okl_acn_pvt.acnv_tbl_type;
1295: ddindx binary_integer; indx binary_integer;
1296: begin
1297:

Line 1294: ddx_acnv_tbl okl_acn_pvt.acnv_tbl_type;

1290: )
1291:
1292: as
1293: ddp_acnv_tbl okl_acn_pvt.acnv_tbl_type;
1294: ddx_acnv_tbl okl_acn_pvt.acnv_tbl_type;
1295: ddindx binary_integer; indx binary_integer;
1296: begin
1297:
1298: -- copy data to the local IN or IN-OUT args, if any

Line 1304: okl_acn_pvt_w.rosetta_table_copy_in_p8(ddp_acnv_tbl, p5_a0

1300:
1301:
1302:
1303:
1304: okl_acn_pvt_w.rosetta_table_copy_in_p8(ddp_acnv_tbl, p5_a0
1305: , p5_a1
1306: , p5_a2
1307: , p5_a3
1308: , p5_a4

Line 1361: okl_acn_pvt.insert_row(p_api_version,

1357: );
1358:
1359:
1360: -- here's the delegated call to the old PL/SQL routine
1361: okl_acn_pvt.insert_row(p_api_version,
1362: p_init_msg_list,
1363: x_return_status,
1364: x_msg_count,
1365: x_msg_data,

Line 1376: okl_acn_pvt_w.rosetta_table_copy_out_p8(ddx_acnv_tbl, p6_a0

1372:
1373:
1374:
1375:
1376: okl_acn_pvt_w.rosetta_table_copy_out_p8(ddx_acnv_tbl, p6_a0
1377: , p6_a1
1378: , p6_a2
1379: , p6_a3
1380: , p6_a4

Line 1493: ddp_acnv_rec okl_acn_pvt.acnv_rec_type;

1489: , p5_a52 DATE := fnd_api.g_miss_date
1490: )
1491:
1492: as
1493: ddp_acnv_rec okl_acn_pvt.acnv_rec_type;
1494: ddindx binary_integer; indx binary_integer;
1495: begin
1496:
1497: -- copy data to the local IN or IN-OUT args, if any

Line 1558: okl_acn_pvt.lock_row(p_api_version,

1554: ddp_acnv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a51);
1555: ddp_acnv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a52);
1556:
1557: -- here's the delegated call to the old PL/SQL routine
1558: okl_acn_pvt.lock_row(p_api_version,
1559: p_init_msg_list,
1560: x_return_status,
1561: x_msg_count,
1562: x_msg_data,

Line 1634: ddp_acnv_tbl okl_acn_pvt.acnv_tbl_type;

1630: , p5_a52 JTF_DATE_TABLE
1631: )
1632:
1633: as
1634: ddp_acnv_tbl okl_acn_pvt.acnv_tbl_type;
1635: ddindx binary_integer; indx binary_integer;
1636: begin
1637:
1638: -- copy data to the local IN or IN-OUT args, if any

Line 1644: okl_acn_pvt_w.rosetta_table_copy_in_p8(ddp_acnv_tbl, p5_a0

1640:
1641:
1642:
1643:
1644: okl_acn_pvt_w.rosetta_table_copy_in_p8(ddp_acnv_tbl, p5_a0
1645: , p5_a1
1646: , p5_a2
1647: , p5_a3
1648: , p5_a4

Line 1700: okl_acn_pvt.lock_row(p_api_version,

1696: , p5_a52
1697: );
1698:
1699: -- here's the delegated call to the old PL/SQL routine
1700: okl_acn_pvt.lock_row(p_api_version,
1701: p_init_msg_list,
1702: x_return_status,
1703: x_msg_count,
1704: x_msg_data,

Line 1829: ddp_acnv_rec okl_acn_pvt.acnv_rec_type;

1825: , p5_a52 DATE := fnd_api.g_miss_date
1826: )
1827:
1828: as
1829: ddp_acnv_rec okl_acn_pvt.acnv_rec_type;
1830: ddx_acnv_rec okl_acn_pvt.acnv_rec_type;
1831: ddindx binary_integer; indx binary_integer;
1832: begin
1833:

Line 1830: ddx_acnv_rec okl_acn_pvt.acnv_rec_type;

1826: )
1827:
1828: as
1829: ddp_acnv_rec okl_acn_pvt.acnv_rec_type;
1830: ddx_acnv_rec okl_acn_pvt.acnv_rec_type;
1831: ddindx binary_integer; indx binary_integer;
1832: begin
1833:
1834: -- copy data to the local IN or IN-OUT args, if any

Line 1896: okl_acn_pvt.update_row(p_api_version,

1892: ddp_acnv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a52);
1893:
1894:
1895: -- here's the delegated call to the old PL/SQL routine
1896: okl_acn_pvt.update_row(p_api_version,
1897: p_init_msg_list,
1898: x_return_status,
1899: x_msg_count,
1900: x_msg_data,

Line 2080: ddp_acnv_tbl okl_acn_pvt.acnv_tbl_type;

2076: , p6_a52 out nocopy JTF_DATE_TABLE
2077: )
2078:
2079: as
2080: ddp_acnv_tbl okl_acn_pvt.acnv_tbl_type;
2081: ddx_acnv_tbl okl_acn_pvt.acnv_tbl_type;
2082: ddindx binary_integer; indx binary_integer;
2083: begin
2084:

Line 2081: ddx_acnv_tbl okl_acn_pvt.acnv_tbl_type;

2077: )
2078:
2079: as
2080: ddp_acnv_tbl okl_acn_pvt.acnv_tbl_type;
2081: ddx_acnv_tbl okl_acn_pvt.acnv_tbl_type;
2082: ddindx binary_integer; indx binary_integer;
2083: begin
2084:
2085: -- copy data to the local IN or IN-OUT args, if any

Line 2091: okl_acn_pvt_w.rosetta_table_copy_in_p8(ddp_acnv_tbl, p5_a0

2087:
2088:
2089:
2090:
2091: okl_acn_pvt_w.rosetta_table_copy_in_p8(ddp_acnv_tbl, p5_a0
2092: , p5_a1
2093: , p5_a2
2094: , p5_a3
2095: , p5_a4

Line 2148: okl_acn_pvt.update_row(p_api_version,

2144: );
2145:
2146:
2147: -- here's the delegated call to the old PL/SQL routine
2148: okl_acn_pvt.update_row(p_api_version,
2149: p_init_msg_list,
2150: x_return_status,
2151: x_msg_count,
2152: x_msg_data,

Line 2163: okl_acn_pvt_w.rosetta_table_copy_out_p8(ddx_acnv_tbl, p6_a0

2159:
2160:
2161:
2162:
2163: okl_acn_pvt_w.rosetta_table_copy_out_p8(ddx_acnv_tbl, p6_a0
2164: , p6_a1
2165: , p6_a2
2166: , p6_a3
2167: , p6_a4

Line 2280: ddp_acnv_rec okl_acn_pvt.acnv_rec_type;

2276: , p5_a52 DATE := fnd_api.g_miss_date
2277: )
2278:
2279: as
2280: ddp_acnv_rec okl_acn_pvt.acnv_rec_type;
2281: ddindx binary_integer; indx binary_integer;
2282: begin
2283:
2284: -- copy data to the local IN or IN-OUT args, if any

Line 2345: okl_acn_pvt.delete_row(p_api_version,

2341: ddp_acnv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a51);
2342: ddp_acnv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a52);
2343:
2344: -- here's the delegated call to the old PL/SQL routine
2345: okl_acn_pvt.delete_row(p_api_version,
2346: p_init_msg_list,
2347: x_return_status,
2348: x_msg_count,
2349: x_msg_data,

Line 2421: ddp_acnv_tbl okl_acn_pvt.acnv_tbl_type;

2417: , p5_a52 JTF_DATE_TABLE
2418: )
2419:
2420: as
2421: ddp_acnv_tbl okl_acn_pvt.acnv_tbl_type;
2422: ddindx binary_integer; indx binary_integer;
2423: begin
2424:
2425: -- copy data to the local IN or IN-OUT args, if any

Line 2431: okl_acn_pvt_w.rosetta_table_copy_in_p8(ddp_acnv_tbl, p5_a0

2427:
2428:
2429:
2430:
2431: okl_acn_pvt_w.rosetta_table_copy_in_p8(ddp_acnv_tbl, p5_a0
2432: , p5_a1
2433: , p5_a2
2434: , p5_a3
2435: , p5_a4

Line 2487: okl_acn_pvt.delete_row(p_api_version,

2483: , p5_a52
2484: );
2485:
2486: -- here's the delegated call to the old PL/SQL routine
2487: okl_acn_pvt.delete_row(p_api_version,
2488: p_init_msg_list,
2489: x_return_status,
2490: x_msg_count,
2491: x_msg_data,

Line 2563: ddp_acnv_rec okl_acn_pvt.acnv_rec_type;

2559: , p5_a52 DATE := fnd_api.g_miss_date
2560: )
2561:
2562: as
2563: ddp_acnv_rec okl_acn_pvt.acnv_rec_type;
2564: ddindx binary_integer; indx binary_integer;
2565: begin
2566:
2567: -- copy data to the local IN or IN-OUT args, if any

Line 2628: okl_acn_pvt.validate_row(p_api_version,

2624: ddp_acnv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a51);
2625: ddp_acnv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a52);
2626:
2627: -- here's the delegated call to the old PL/SQL routine
2628: okl_acn_pvt.validate_row(p_api_version,
2629: p_init_msg_list,
2630: x_return_status,
2631: x_msg_count,
2632: x_msg_data,

Line 2704: ddp_acnv_tbl okl_acn_pvt.acnv_tbl_type;

2700: , p5_a52 JTF_DATE_TABLE
2701: )
2702:
2703: as
2704: ddp_acnv_tbl okl_acn_pvt.acnv_tbl_type;
2705: ddindx binary_integer; indx binary_integer;
2706: begin
2707:
2708: -- copy data to the local IN or IN-OUT args, if any

Line 2714: okl_acn_pvt_w.rosetta_table_copy_in_p8(ddp_acnv_tbl, p5_a0

2710:
2711:
2712:
2713:
2714: okl_acn_pvt_w.rosetta_table_copy_in_p8(ddp_acnv_tbl, p5_a0
2715: , p5_a1
2716: , p5_a2
2717: , p5_a3
2718: , p5_a4

Line 2770: okl_acn_pvt.validate_row(p_api_version,

2766: , p5_a52
2767: );
2768:
2769: -- here's the delegated call to the old PL/SQL routine
2770: okl_acn_pvt.validate_row(p_api_version,
2771: p_init_msg_list,
2772: x_return_status,
2773: x_msg_count,
2774: x_msg_data,

Line 2785: end okl_acn_pvt_w;

2781:
2782:
2783: end;
2784:
2785: end okl_acn_pvt_w;