DBA Data[Home] [Help]

APPS.OKL_KRP_PVT_W dependencies on OKL_KRP_PVT

Line 1: package body okl_krp_pvt_w as

1: package body okl_krp_pvt_w as
2: /* $Header: OKLEKRPB.pls 120.2 2005/11/22 23:40:01 ramurt 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_krp_pvt.krpv_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_krp_pvt.krpv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 137: procedure rosetta_table_copy_out_p2(t okl_krp_pvt.krpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

133: end loop;
134: end if;
135: end if;
136: end rosetta_table_copy_in_p2;
137: procedure rosetta_table_copy_out_p2(t okl_krp_pvt.krpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
138: , a1 out nocopy JTF_VARCHAR2_TABLE_100
139: , a2 out nocopy JTF_DATE_TABLE
140: , a3 out nocopy JTF_DATE_TABLE
141: , a4 out nocopy JTF_NUMBER_TABLE

Line 401: procedure rosetta_table_copy_in_p5(t out nocopy okl_krp_pvt.krp_tbl_type, a0 JTF_NUMBER_TABLE

397: end if;
398: end if;
399: end rosetta_table_copy_out_p2;
400:
401: procedure rosetta_table_copy_in_p5(t out nocopy okl_krp_pvt.krp_tbl_type, a0 JTF_NUMBER_TABLE
402: , a1 JTF_VARCHAR2_TABLE_100
403: , a2 JTF_DATE_TABLE
404: , a3 JTF_DATE_TABLE
405: , a4 JTF_NUMBER_TABLE

Line 516: procedure rosetta_table_copy_out_p5(t okl_krp_pvt.krp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

512: end loop;
513: end if;
514: end if;
515: end rosetta_table_copy_in_p5;
516: procedure rosetta_table_copy_out_p5(t okl_krp_pvt.krp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
517: , a1 out nocopy JTF_VARCHAR2_TABLE_100
518: , a2 out nocopy JTF_DATE_TABLE
519: , a3 out nocopy JTF_DATE_TABLE
520: , a4 out nocopy JTF_NUMBER_TABLE

Line 886: ddp_krpv_rec okl_krp_pvt.krpv_rec_type;

882: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
883: )
884:
885: as
886: ddp_krpv_rec okl_krp_pvt.krpv_rec_type;
887: ddx_krpv_rec okl_krp_pvt.krpv_rec_type;
888: ddindx binary_integer; indx binary_integer;
889: begin
890:

Line 887: ddx_krpv_rec okl_krp_pvt.krpv_rec_type;

883: )
884:
885: as
886: ddp_krpv_rec okl_krp_pvt.krpv_rec_type;
887: ddx_krpv_rec okl_krp_pvt.krpv_rec_type;
888: ddindx binary_integer; indx binary_integer;
889: begin
890:
891: -- copy data to the local IN or IN-OUT args, if any

Line 949: okl_krp_pvt.insert_row(p_api_version,

945: ddp_krpv_rec.catchup_frequency_code := p5_a48;
946:
947:
948: -- here's the delegated call to the old PL/SQL routine
949: okl_krp_pvt.insert_row(p_api_version,
950: p_init_msg_list,
951: x_return_status,
952: x_msg_count,
953: x_msg_data,

Line 1121: ddp_krpv_tbl okl_krp_pvt.krpv_tbl_type;

1117: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100
1118: )
1119:
1120: as
1121: ddp_krpv_tbl okl_krp_pvt.krpv_tbl_type;
1122: ddx_krpv_tbl okl_krp_pvt.krpv_tbl_type;
1123: ddindx binary_integer; indx binary_integer;
1124: begin
1125:

Line 1122: ddx_krpv_tbl okl_krp_pvt.krpv_tbl_type;

1118: )
1119:
1120: as
1121: ddp_krpv_tbl okl_krp_pvt.krpv_tbl_type;
1122: ddx_krpv_tbl okl_krp_pvt.krpv_tbl_type;
1123: ddindx binary_integer; indx binary_integer;
1124: begin
1125:
1126: -- copy data to the local IN or IN-OUT args, if any

Line 1132: okl_krp_pvt_w.rosetta_table_copy_in_p2(ddp_krpv_tbl, p5_a0

1128:
1129:
1130:
1131:
1132: okl_krp_pvt_w.rosetta_table_copy_in_p2(ddp_krpv_tbl, p5_a0
1133: , p5_a1
1134: , p5_a2
1135: , p5_a3
1136: , p5_a4

Line 1185: okl_krp_pvt.insert_row(p_api_version,

1181: );
1182:
1183:
1184: -- here's the delegated call to the old PL/SQL routine
1185: okl_krp_pvt.insert_row(p_api_version,
1186: p_init_msg_list,
1187: x_return_status,
1188: x_msg_count,
1189: x_msg_data,

Line 1200: okl_krp_pvt_w.rosetta_table_copy_out_p2(ddx_krpv_tbl, p6_a0

1196:
1197:
1198:
1199:
1200: okl_krp_pvt_w.rosetta_table_copy_out_p2(ddx_krpv_tbl, p6_a0
1201: , p6_a1
1202: , p6_a2
1203: , p6_a3
1204: , p6_a4

Line 1309: ddp_krpv_rec okl_krp_pvt.krpv_rec_type;

1305: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1306: )
1307:
1308: as
1309: ddp_krpv_rec okl_krp_pvt.krpv_rec_type;
1310: ddindx binary_integer; indx binary_integer;
1311: begin
1312:
1313: -- copy data to the local IN or IN-OUT args, if any

Line 1370: okl_krp_pvt.lock_row(p_api_version,

1366: ddp_krpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a47);
1367: ddp_krpv_rec.catchup_frequency_code := p5_a48;
1368:
1369: -- here's the delegated call to the old PL/SQL routine
1370: okl_krp_pvt.lock_row(p_api_version,
1371: p_init_msg_list,
1372: x_return_status,
1373: x_msg_count,
1374: x_msg_data,

Line 1442: ddp_krpv_tbl okl_krp_pvt.krpv_tbl_type;

1438: , p5_a48 JTF_VARCHAR2_TABLE_100
1439: )
1440:
1441: as
1442: ddp_krpv_tbl okl_krp_pvt.krpv_tbl_type;
1443: ddindx binary_integer; indx binary_integer;
1444: begin
1445:
1446: -- copy data to the local IN or IN-OUT args, if any

Line 1452: okl_krp_pvt_w.rosetta_table_copy_in_p2(ddp_krpv_tbl, p5_a0

1448:
1449:
1450:
1451:
1452: okl_krp_pvt_w.rosetta_table_copy_in_p2(ddp_krpv_tbl, p5_a0
1453: , p5_a1
1454: , p5_a2
1455: , p5_a3
1456: , p5_a4

Line 1504: okl_krp_pvt.lock_row(p_api_version,

1500: , p5_a48
1501: );
1502:
1503: -- here's the delegated call to the old PL/SQL routine
1504: okl_krp_pvt.lock_row(p_api_version,
1505: p_init_msg_list,
1506: x_return_status,
1507: x_msg_count,
1508: x_msg_data,

Line 1625: ddp_krpv_rec okl_krp_pvt.krpv_rec_type;

1621: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1622: )
1623:
1624: as
1625: ddp_krpv_rec okl_krp_pvt.krpv_rec_type;
1626: ddx_krpv_rec okl_krp_pvt.krpv_rec_type;
1627: ddindx binary_integer; indx binary_integer;
1628: begin
1629:

Line 1626: ddx_krpv_rec okl_krp_pvt.krpv_rec_type;

1622: )
1623:
1624: as
1625: ddp_krpv_rec okl_krp_pvt.krpv_rec_type;
1626: ddx_krpv_rec okl_krp_pvt.krpv_rec_type;
1627: ddindx binary_integer; indx binary_integer;
1628: begin
1629:
1630: -- copy data to the local IN or IN-OUT args, if any

Line 1688: okl_krp_pvt.update_row(p_api_version,

1684: ddp_krpv_rec.catchup_frequency_code := p5_a48;
1685:
1686:
1687: -- here's the delegated call to the old PL/SQL routine
1688: okl_krp_pvt.update_row(p_api_version,
1689: p_init_msg_list,
1690: x_return_status,
1691: x_msg_count,
1692: x_msg_data,

Line 1860: ddp_krpv_tbl okl_krp_pvt.krpv_tbl_type;

1856: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100
1857: )
1858:
1859: as
1860: ddp_krpv_tbl okl_krp_pvt.krpv_tbl_type;
1861: ddx_krpv_tbl okl_krp_pvt.krpv_tbl_type;
1862: ddindx binary_integer; indx binary_integer;
1863: begin
1864:

Line 1861: ddx_krpv_tbl okl_krp_pvt.krpv_tbl_type;

1857: )
1858:
1859: as
1860: ddp_krpv_tbl okl_krp_pvt.krpv_tbl_type;
1861: ddx_krpv_tbl okl_krp_pvt.krpv_tbl_type;
1862: ddindx binary_integer; indx binary_integer;
1863: begin
1864:
1865: -- copy data to the local IN or IN-OUT args, if any

Line 1871: okl_krp_pvt_w.rosetta_table_copy_in_p2(ddp_krpv_tbl, p5_a0

1867:
1868:
1869:
1870:
1871: okl_krp_pvt_w.rosetta_table_copy_in_p2(ddp_krpv_tbl, p5_a0
1872: , p5_a1
1873: , p5_a2
1874: , p5_a3
1875: , p5_a4

Line 1924: okl_krp_pvt.update_row(p_api_version,

1920: );
1921:
1922:
1923: -- here's the delegated call to the old PL/SQL routine
1924: okl_krp_pvt.update_row(p_api_version,
1925: p_init_msg_list,
1926: x_return_status,
1927: x_msg_count,
1928: x_msg_data,

Line 1939: okl_krp_pvt_w.rosetta_table_copy_out_p2(ddx_krpv_tbl, p6_a0

1935:
1936:
1937:
1938:
1939: okl_krp_pvt_w.rosetta_table_copy_out_p2(ddx_krpv_tbl, p6_a0
1940: , p6_a1
1941: , p6_a2
1942: , p6_a3
1943: , p6_a4

Line 2048: ddp_krpv_rec okl_krp_pvt.krpv_rec_type;

2044: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
2045: )
2046:
2047: as
2048: ddp_krpv_rec okl_krp_pvt.krpv_rec_type;
2049: ddindx binary_integer; indx binary_integer;
2050: begin
2051:
2052: -- copy data to the local IN or IN-OUT args, if any

Line 2109: okl_krp_pvt.delete_row(p_api_version,

2105: ddp_krpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a47);
2106: ddp_krpv_rec.catchup_frequency_code := p5_a48;
2107:
2108: -- here's the delegated call to the old PL/SQL routine
2109: okl_krp_pvt.delete_row(p_api_version,
2110: p_init_msg_list,
2111: x_return_status,
2112: x_msg_count,
2113: x_msg_data,

Line 2181: ddp_krpv_tbl okl_krp_pvt.krpv_tbl_type;

2177: , p5_a48 JTF_VARCHAR2_TABLE_100
2178: )
2179:
2180: as
2181: ddp_krpv_tbl okl_krp_pvt.krpv_tbl_type;
2182: ddindx binary_integer; indx binary_integer;
2183: begin
2184:
2185: -- copy data to the local IN or IN-OUT args, if any

Line 2191: okl_krp_pvt_w.rosetta_table_copy_in_p2(ddp_krpv_tbl, p5_a0

2187:
2188:
2189:
2190:
2191: okl_krp_pvt_w.rosetta_table_copy_in_p2(ddp_krpv_tbl, p5_a0
2192: , p5_a1
2193: , p5_a2
2194: , p5_a3
2195: , p5_a4

Line 2243: okl_krp_pvt.delete_row(p_api_version,

2239: , p5_a48
2240: );
2241:
2242: -- here's the delegated call to the old PL/SQL routine
2243: okl_krp_pvt.delete_row(p_api_version,
2244: p_init_msg_list,
2245: x_return_status,
2246: x_msg_count,
2247: x_msg_data,

Line 2315: ddp_krpv_rec okl_krp_pvt.krpv_rec_type;

2311: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
2312: )
2313:
2314: as
2315: ddp_krpv_rec okl_krp_pvt.krpv_rec_type;
2316: ddindx binary_integer; indx binary_integer;
2317: begin
2318:
2319: -- copy data to the local IN or IN-OUT args, if any

Line 2376: okl_krp_pvt.validate_row(p_api_version,

2372: ddp_krpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a47);
2373: ddp_krpv_rec.catchup_frequency_code := p5_a48;
2374:
2375: -- here's the delegated call to the old PL/SQL routine
2376: okl_krp_pvt.validate_row(p_api_version,
2377: p_init_msg_list,
2378: x_return_status,
2379: x_msg_count,
2380: x_msg_data,

Line 2448: ddp_krpv_tbl okl_krp_pvt.krpv_tbl_type;

2444: , p5_a48 JTF_VARCHAR2_TABLE_100
2445: )
2446:
2447: as
2448: ddp_krpv_tbl okl_krp_pvt.krpv_tbl_type;
2449: ddindx binary_integer; indx binary_integer;
2450: begin
2451:
2452: -- copy data to the local IN or IN-OUT args, if any

Line 2458: okl_krp_pvt_w.rosetta_table_copy_in_p2(ddp_krpv_tbl, p5_a0

2454:
2455:
2456:
2457:
2458: okl_krp_pvt_w.rosetta_table_copy_in_p2(ddp_krpv_tbl, p5_a0
2459: , p5_a1
2460: , p5_a2
2461: , p5_a3
2462: , p5_a4

Line 2510: okl_krp_pvt.validate_row(p_api_version,

2506: , p5_a48
2507: );
2508:
2509: -- here's the delegated call to the old PL/SQL routine
2510: okl_krp_pvt.validate_row(p_api_version,
2511: p_init_msg_list,
2512: x_return_status,
2513: x_msg_count,
2514: x_msg_data,

Line 2587: ddp_krpv_tbl okl_krp_pvt.krpv_tbl_type;

2583: , p_validate_flag VARCHAR2
2584: )
2585:
2586: as
2587: ddp_krpv_tbl okl_krp_pvt.krpv_tbl_type;
2588: ddindx binary_integer; indx binary_integer;
2589: begin
2590:
2591: -- copy data to the local IN or IN-OUT args, if any

Line 2600: okl_krp_pvt_w.rosetta_table_copy_in_p2(ddp_krpv_tbl, p8_a0

2596:
2597:
2598:
2599:
2600: okl_krp_pvt_w.rosetta_table_copy_in_p2(ddp_krpv_tbl, p8_a0
2601: , p8_a1
2602: , p8_a2
2603: , p8_a3
2604: , p8_a4

Line 2654: okl_krp_pvt.validate_row(p_api_version,

2650:
2651:
2652:
2653: -- here's the delegated call to the old PL/SQL routine
2654: okl_krp_pvt.validate_row(p_api_version,
2655: p_init_msg_list,
2656: x_return_status,
2657: x_msg_count,
2658: x_msg_data,

Line 2679: end okl_krp_pvt_w;

2675:
2676:
2677: end;
2678:
2679: end okl_krp_pvt_w;