DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_PUB_W dependencies on OKL_SUBSIDY_PUB

Line 1: package body okl_subsidy_pub_w as

1: package body okl_subsidy_pub_w as
2: /* $Header: OKLUSUBB.pls 120.4 2005/10/30 04:50:55 appldev 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 134: ddp_subv_rec okl_subsidy_pub.subv_rec_type;

130: , p5_a51 NUMBER := 0-1962.0724
131: )
132:
133: as
134: ddp_subv_rec okl_subsidy_pub.subv_rec_type;
135: ddx_subv_rec okl_subsidy_pub.subv_rec_type;
136: ddindx binary_integer; indx binary_integer;
137: begin
138:

Line 135: ddx_subv_rec okl_subsidy_pub.subv_rec_type;

131: )
132:
133: as
134: ddp_subv_rec okl_subsidy_pub.subv_rec_type;
135: ddx_subv_rec okl_subsidy_pub.subv_rec_type;
136: ddindx binary_integer; indx binary_integer;
137: begin
138:
139: -- copy data to the local IN or IN-OUT args, if any

Line 200: okl_subsidy_pub.create_subsidy(p_api_version,

196: ddp_subv_rec.subsidy_pool_id := rosetta_g_miss_num_map(p5_a51);
197:
198:
199: -- here's the delegated call to the old PL/SQL routine
200: okl_subsidy_pub.create_subsidy(p_api_version,
201: p_init_msg_list,
202: x_return_status,
203: x_msg_count,
204: x_msg_data,

Line 381: ddp_subv_tbl okl_subsidy_pub.subv_tbl_type;

377: , p6_a51 out nocopy JTF_NUMBER_TABLE
378: )
379:
380: as
381: ddp_subv_tbl okl_subsidy_pub.subv_tbl_type;
382: ddx_subv_tbl okl_subsidy_pub.subv_tbl_type;
383: ddindx binary_integer; indx binary_integer;
384: begin
385:

Line 382: ddx_subv_tbl okl_subsidy_pub.subv_tbl_type;

378: )
379:
380: as
381: ddp_subv_tbl okl_subsidy_pub.subv_tbl_type;
382: ddx_subv_tbl okl_subsidy_pub.subv_tbl_type;
383: ddindx binary_integer; indx binary_integer;
384: begin
385:
386: -- copy data to the local IN or IN-OUT args, if any

Line 448: okl_subsidy_pub.create_subsidy(p_api_version,

444: );
445:
446:
447: -- here's the delegated call to the old PL/SQL routine
448: okl_subsidy_pub.create_subsidy(p_api_version,
449: p_init_msg_list,
450: x_return_status,
451: x_msg_count,
452: x_msg_data,

Line 630: ddp_subv_rec okl_subsidy_pub.subv_rec_type;

626: , p5_a51 NUMBER := 0-1962.0724
627: )
628:
629: as
630: ddp_subv_rec okl_subsidy_pub.subv_rec_type;
631: ddx_subv_rec okl_subsidy_pub.subv_rec_type;
632: ddindx binary_integer; indx binary_integer;
633: begin
634:

Line 631: ddx_subv_rec okl_subsidy_pub.subv_rec_type;

627: )
628:
629: as
630: ddp_subv_rec okl_subsidy_pub.subv_rec_type;
631: ddx_subv_rec okl_subsidy_pub.subv_rec_type;
632: ddindx binary_integer; indx binary_integer;
633: begin
634:
635: -- copy data to the local IN or IN-OUT args, if any

Line 696: okl_subsidy_pub.update_subsidy(p_api_version,

692: ddp_subv_rec.subsidy_pool_id := rosetta_g_miss_num_map(p5_a51);
693:
694:
695: -- here's the delegated call to the old PL/SQL routine
696: okl_subsidy_pub.update_subsidy(p_api_version,
697: p_init_msg_list,
698: x_return_status,
699: x_msg_count,
700: x_msg_data,

Line 877: ddp_subv_tbl okl_subsidy_pub.subv_tbl_type;

873: , p6_a51 out nocopy JTF_NUMBER_TABLE
874: )
875:
876: as
877: ddp_subv_tbl okl_subsidy_pub.subv_tbl_type;
878: ddx_subv_tbl okl_subsidy_pub.subv_tbl_type;
879: ddindx binary_integer; indx binary_integer;
880: begin
881:

Line 878: ddx_subv_tbl okl_subsidy_pub.subv_tbl_type;

874: )
875:
876: as
877: ddp_subv_tbl okl_subsidy_pub.subv_tbl_type;
878: ddx_subv_tbl okl_subsidy_pub.subv_tbl_type;
879: ddindx binary_integer; indx binary_integer;
880: begin
881:
882: -- copy data to the local IN or IN-OUT args, if any

Line 944: okl_subsidy_pub.update_subsidy(p_api_version,

940: );
941:
942:
943: -- here's the delegated call to the old PL/SQL routine
944: okl_subsidy_pub.update_subsidy(p_api_version,
945: p_init_msg_list,
946: x_return_status,
947: x_msg_count,
948: x_msg_data,

Line 1074: ddp_subv_rec okl_subsidy_pub.subv_rec_type;

1070: , p5_a51 NUMBER := 0-1962.0724
1071: )
1072:
1073: as
1074: ddp_subv_rec okl_subsidy_pub.subv_rec_type;
1075: ddindx binary_integer; indx binary_integer;
1076: begin
1077:
1078: -- copy data to the local IN or IN-OUT args, if any

Line 1138: okl_subsidy_pub.delete_subsidy(p_api_version,

1134: ddp_subv_rec.last_update_login := rosetta_g_miss_num_map(p5_a50);
1135: ddp_subv_rec.subsidy_pool_id := rosetta_g_miss_num_map(p5_a51);
1136:
1137: -- here's the delegated call to the old PL/SQL routine
1138: okl_subsidy_pub.delete_subsidy(p_api_version,
1139: p_init_msg_list,
1140: x_return_status,
1141: x_msg_count,
1142: x_msg_data,

Line 1213: ddp_subv_tbl okl_subsidy_pub.subv_tbl_type;

1209: , p5_a51 JTF_NUMBER_TABLE
1210: )
1211:
1212: as
1213: ddp_subv_tbl okl_subsidy_pub.subv_tbl_type;
1214: ddindx binary_integer; indx binary_integer;
1215: begin
1216:
1217: -- copy data to the local IN or IN-OUT args, if any

Line 1278: okl_subsidy_pub.delete_subsidy(p_api_version,

1274: , p5_a51
1275: );
1276:
1277: -- here's the delegated call to the old PL/SQL routine
1278: okl_subsidy_pub.delete_subsidy(p_api_version,
1279: p_init_msg_list,
1280: x_return_status,
1281: x_msg_count,
1282: x_msg_data,

Line 1353: ddp_subv_rec okl_subsidy_pub.subv_rec_type;

1349: , p5_a51 NUMBER := 0-1962.0724
1350: )
1351:
1352: as
1353: ddp_subv_rec okl_subsidy_pub.subv_rec_type;
1354: ddindx binary_integer; indx binary_integer;
1355: begin
1356:
1357: -- copy data to the local IN or IN-OUT args, if any

Line 1417: okl_subsidy_pub.lock_subsidy(p_api_version,

1413: ddp_subv_rec.last_update_login := rosetta_g_miss_num_map(p5_a50);
1414: ddp_subv_rec.subsidy_pool_id := rosetta_g_miss_num_map(p5_a51);
1415:
1416: -- here's the delegated call to the old PL/SQL routine
1417: okl_subsidy_pub.lock_subsidy(p_api_version,
1418: p_init_msg_list,
1419: x_return_status,
1420: x_msg_count,
1421: x_msg_data,

Line 1492: ddp_subv_tbl okl_subsidy_pub.subv_tbl_type;

1488: , p5_a51 JTF_NUMBER_TABLE
1489: )
1490:
1491: as
1492: ddp_subv_tbl okl_subsidy_pub.subv_tbl_type;
1493: ddindx binary_integer; indx binary_integer;
1494: begin
1495:
1496: -- copy data to the local IN or IN-OUT args, if any

Line 1557: okl_subsidy_pub.lock_subsidy(p_api_version,

1553: , p5_a51
1554: );
1555:
1556: -- here's the delegated call to the old PL/SQL routine
1557: okl_subsidy_pub.lock_subsidy(p_api_version,
1558: p_init_msg_list,
1559: x_return_status,
1560: x_msg_count,
1561: x_msg_data,

Line 1632: ddp_subv_rec okl_subsidy_pub.subv_rec_type;

1628: , p5_a51 NUMBER := 0-1962.0724
1629: )
1630:
1631: as
1632: ddp_subv_rec okl_subsidy_pub.subv_rec_type;
1633: ddindx binary_integer; indx binary_integer;
1634: begin
1635:
1636: -- copy data to the local IN or IN-OUT args, if any

Line 1696: okl_subsidy_pub.validate_subsidy(p_api_version,

1692: ddp_subv_rec.last_update_login := rosetta_g_miss_num_map(p5_a50);
1693: ddp_subv_rec.subsidy_pool_id := rosetta_g_miss_num_map(p5_a51);
1694:
1695: -- here's the delegated call to the old PL/SQL routine
1696: okl_subsidy_pub.validate_subsidy(p_api_version,
1697: p_init_msg_list,
1698: x_return_status,
1699: x_msg_count,
1700: x_msg_data,

Line 1771: ddp_subv_tbl okl_subsidy_pub.subv_tbl_type;

1767: , p5_a51 JTF_NUMBER_TABLE
1768: )
1769:
1770: as
1771: ddp_subv_tbl okl_subsidy_pub.subv_tbl_type;
1772: ddindx binary_integer; indx binary_integer;
1773: begin
1774:
1775: -- copy data to the local IN or IN-OUT args, if any

Line 1836: okl_subsidy_pub.validate_subsidy(p_api_version,

1832: , p5_a51
1833: );
1834:
1835: -- here's the delegated call to the old PL/SQL routine
1836: okl_subsidy_pub.validate_subsidy(p_api_version,
1837: p_init_msg_list,
1838: x_return_status,
1839: x_msg_count,
1840: x_msg_data,

Line 1927: ddp_sucv_rec okl_subsidy_pub.sucv_rec_type;

1923: , p5_a33 NUMBER := 0-1962.0724
1924: )
1925:
1926: as
1927: ddp_sucv_rec okl_subsidy_pub.sucv_rec_type;
1928: ddx_sucv_rec okl_subsidy_pub.sucv_rec_type;
1929: ddindx binary_integer; indx binary_integer;
1930: begin
1931:

Line 1928: ddx_sucv_rec okl_subsidy_pub.sucv_rec_type;

1924: )
1925:
1926: as
1927: ddp_sucv_rec okl_subsidy_pub.sucv_rec_type;
1928: ddx_sucv_rec okl_subsidy_pub.sucv_rec_type;
1929: ddindx binary_integer; indx binary_integer;
1930: begin
1931:
1932: -- copy data to the local IN or IN-OUT args, if any

Line 1975: okl_subsidy_pub.create_subsidy_criteria(p_api_version,

1971: ddp_sucv_rec.last_update_login := rosetta_g_miss_num_map(p5_a33);
1972:
1973:
1974: -- here's the delegated call to the old PL/SQL routine
1975: okl_subsidy_pub.create_subsidy_criteria(p_api_version,
1976: p_init_msg_list,
1977: x_return_status,
1978: x_msg_count,
1979: x_msg_data,

Line 2102: ddp_sucv_tbl okl_subsidy_pub.sucv_tbl_type;

2098: , p6_a33 out nocopy JTF_NUMBER_TABLE
2099: )
2100:
2101: as
2102: ddp_sucv_tbl okl_subsidy_pub.sucv_tbl_type;
2103: ddx_sucv_tbl okl_subsidy_pub.sucv_tbl_type;
2104: ddindx binary_integer; indx binary_integer;
2105: begin
2106:

Line 2103: ddx_sucv_tbl okl_subsidy_pub.sucv_tbl_type;

2099: )
2100:
2101: as
2102: ddp_sucv_tbl okl_subsidy_pub.sucv_tbl_type;
2103: ddx_sucv_tbl okl_subsidy_pub.sucv_tbl_type;
2104: ddindx binary_integer; indx binary_integer;
2105: begin
2106:
2107: -- copy data to the local IN or IN-OUT args, if any

Line 2151: okl_subsidy_pub.create_subsidy_criteria(p_api_version,

2147: );
2148:
2149:
2150: -- here's the delegated call to the old PL/SQL routine
2151: okl_subsidy_pub.create_subsidy_criteria(p_api_version,
2152: p_init_msg_list,
2153: x_return_status,
2154: x_msg_count,
2155: x_msg_data,

Line 2279: ddp_sucv_rec okl_subsidy_pub.sucv_rec_type;

2275: , p5_a33 NUMBER := 0-1962.0724
2276: )
2277:
2278: as
2279: ddp_sucv_rec okl_subsidy_pub.sucv_rec_type;
2280: ddx_sucv_rec okl_subsidy_pub.sucv_rec_type;
2281: ddindx binary_integer; indx binary_integer;
2282: begin
2283:

Line 2280: ddx_sucv_rec okl_subsidy_pub.sucv_rec_type;

2276: )
2277:
2278: as
2279: ddp_sucv_rec okl_subsidy_pub.sucv_rec_type;
2280: ddx_sucv_rec okl_subsidy_pub.sucv_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 2327: okl_subsidy_pub.update_subsidy_criteria(p_api_version,

2323: ddp_sucv_rec.last_update_login := rosetta_g_miss_num_map(p5_a33);
2324:
2325:
2326: -- here's the delegated call to the old PL/SQL routine
2327: okl_subsidy_pub.update_subsidy_criteria(p_api_version,
2328: p_init_msg_list,
2329: x_return_status,
2330: x_msg_count,
2331: x_msg_data,

Line 2454: ddp_sucv_tbl okl_subsidy_pub.sucv_tbl_type;

2450: , p6_a33 out nocopy JTF_NUMBER_TABLE
2451: )
2452:
2453: as
2454: ddp_sucv_tbl okl_subsidy_pub.sucv_tbl_type;
2455: ddx_sucv_tbl okl_subsidy_pub.sucv_tbl_type;
2456: ddindx binary_integer; indx binary_integer;
2457: begin
2458:

Line 2455: ddx_sucv_tbl okl_subsidy_pub.sucv_tbl_type;

2451: )
2452:
2453: as
2454: ddp_sucv_tbl okl_subsidy_pub.sucv_tbl_type;
2455: ddx_sucv_tbl okl_subsidy_pub.sucv_tbl_type;
2456: ddindx binary_integer; indx binary_integer;
2457: begin
2458:
2459: -- copy data to the local IN or IN-OUT args, if any

Line 2503: okl_subsidy_pub.update_subsidy_criteria(p_api_version,

2499: );
2500:
2501:
2502: -- here's the delegated call to the old PL/SQL routine
2503: okl_subsidy_pub.update_subsidy_criteria(p_api_version,
2504: p_init_msg_list,
2505: x_return_status,
2506: x_msg_count,
2507: x_msg_data,

Line 2597: ddp_sucv_rec okl_subsidy_pub.sucv_rec_type;

2593: , p5_a33 NUMBER := 0-1962.0724
2594: )
2595:
2596: as
2597: ddp_sucv_rec okl_subsidy_pub.sucv_rec_type;
2598: ddindx binary_integer; indx binary_integer;
2599: begin
2600:
2601: -- copy data to the local IN or IN-OUT args, if any

Line 2643: okl_subsidy_pub.delete_subsidy_criteria(p_api_version,

2639: ddp_sucv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a32);
2640: ddp_sucv_rec.last_update_login := rosetta_g_miss_num_map(p5_a33);
2641:
2642: -- here's the delegated call to the old PL/SQL routine
2643: okl_subsidy_pub.delete_subsidy_criteria(p_api_version,
2644: p_init_msg_list,
2645: x_return_status,
2646: x_msg_count,
2647: x_msg_data,

Line 2700: ddp_sucv_tbl okl_subsidy_pub.sucv_tbl_type;

2696: , p5_a33 JTF_NUMBER_TABLE
2697: )
2698:
2699: as
2700: ddp_sucv_tbl okl_subsidy_pub.sucv_tbl_type;
2701: ddindx binary_integer; indx binary_integer;
2702: begin
2703:
2704: -- copy data to the local IN or IN-OUT args, if any

Line 2747: okl_subsidy_pub.delete_subsidy_criteria(p_api_version,

2743: , p5_a33
2744: );
2745:
2746: -- here's the delegated call to the old PL/SQL routine
2747: okl_subsidy_pub.delete_subsidy_criteria(p_api_version,
2748: p_init_msg_list,
2749: x_return_status,
2750: x_msg_count,
2751: x_msg_data,

Line 2804: ddp_sucv_rec okl_subsidy_pub.sucv_rec_type;

2800: , p5_a33 NUMBER := 0-1962.0724
2801: )
2802:
2803: as
2804: ddp_sucv_rec okl_subsidy_pub.sucv_rec_type;
2805: ddindx binary_integer; indx binary_integer;
2806: begin
2807:
2808: -- copy data to the local IN or IN-OUT args, if any

Line 2850: okl_subsidy_pub.lock_subsidy_criteria(p_api_version,

2846: ddp_sucv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a32);
2847: ddp_sucv_rec.last_update_login := rosetta_g_miss_num_map(p5_a33);
2848:
2849: -- here's the delegated call to the old PL/SQL routine
2850: okl_subsidy_pub.lock_subsidy_criteria(p_api_version,
2851: p_init_msg_list,
2852: x_return_status,
2853: x_msg_count,
2854: x_msg_data,

Line 2907: ddp_sucv_tbl okl_subsidy_pub.sucv_tbl_type;

2903: , p5_a33 JTF_NUMBER_TABLE
2904: )
2905:
2906: as
2907: ddp_sucv_tbl okl_subsidy_pub.sucv_tbl_type;
2908: ddindx binary_integer; indx binary_integer;
2909: begin
2910:
2911: -- copy data to the local IN or IN-OUT args, if any

Line 2954: okl_subsidy_pub.lock_subsidy_criteria(p_api_version,

2950: , p5_a33
2951: );
2952:
2953: -- here's the delegated call to the old PL/SQL routine
2954: okl_subsidy_pub.lock_subsidy_criteria(p_api_version,
2955: p_init_msg_list,
2956: x_return_status,
2957: x_msg_count,
2958: x_msg_data,

Line 3011: ddp_sucv_rec okl_subsidy_pub.sucv_rec_type;

3007: , p5_a33 NUMBER := 0-1962.0724
3008: )
3009:
3010: as
3011: ddp_sucv_rec okl_subsidy_pub.sucv_rec_type;
3012: ddindx binary_integer; indx binary_integer;
3013: begin
3014:
3015: -- copy data to the local IN or IN-OUT args, if any

Line 3057: okl_subsidy_pub.validate_subsidy_criteria(p_api_version,

3053: ddp_sucv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a32);
3054: ddp_sucv_rec.last_update_login := rosetta_g_miss_num_map(p5_a33);
3055:
3056: -- here's the delegated call to the old PL/SQL routine
3057: okl_subsidy_pub.validate_subsidy_criteria(p_api_version,
3058: p_init_msg_list,
3059: x_return_status,
3060: x_msg_count,
3061: x_msg_data,

Line 3114: ddp_sucv_tbl okl_subsidy_pub.sucv_tbl_type;

3110: , p5_a33 JTF_NUMBER_TABLE
3111: )
3112:
3113: as
3114: ddp_sucv_tbl okl_subsidy_pub.sucv_tbl_type;
3115: ddindx binary_integer; indx binary_integer;
3116: begin
3117:
3118: -- copy data to the local IN or IN-OUT args, if any

Line 3161: okl_subsidy_pub.validate_subsidy_criteria(p_api_version,

3157: , p5_a33
3158: );
3159:
3160: -- here's the delegated call to the old PL/SQL routine
3161: okl_subsidy_pub.validate_subsidy_criteria(p_api_version,
3162: p_init_msg_list,
3163: x_return_status,
3164: x_msg_count,
3165: x_msg_data,

Line 3176: end okl_subsidy_pub_w;

3172:
3173:
3174: end;
3175:
3176: end okl_subsidy_pub_w;