DBA Data[Home] [Help]

APPS.OKL_BKT_PVT_W dependencies on OKL_BKT_PVT

Line 1: package body okl_bkt_pvt_w as

1: package body okl_bkt_pvt_w as
2: /* $Header: OKLIBKTB.pls 120.1 2005/07/07 12:47:28 asawanka 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_bkt_pvt.bkt_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_bkt_pvt.bkt_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 73: procedure rosetta_table_copy_out_p2(t okl_bkt_pvt.bkt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

69: end loop;
70: end if;
71: end if;
72: end rosetta_table_copy_in_p2;
73: procedure rosetta_table_copy_out_p2(t okl_bkt_pvt.bkt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
74: , a1 out nocopy JTF_NUMBER_TABLE
75: , a2 out nocopy JTF_VARCHAR2_TABLE_100
76: , a3 out nocopy JTF_NUMBER_TABLE
77: , a4 out nocopy JTF_NUMBER_TABLE

Line 177: procedure rosetta_table_copy_in_p5(t out nocopy okl_bkt_pvt.bktv_tbl_type, a0 JTF_NUMBER_TABLE

173: end if;
174: end if;
175: end rosetta_table_copy_out_p2;
176:
177: procedure rosetta_table_copy_in_p5(t out nocopy okl_bkt_pvt.bktv_tbl_type, a0 JTF_NUMBER_TABLE
178: , a1 JTF_NUMBER_TABLE
179: , a2 JTF_NUMBER_TABLE
180: , a3 JTF_VARCHAR2_TABLE_100
181: , a4 JTF_VARCHAR2_TABLE_2000

Line 228: procedure rosetta_table_copy_out_p5(t okl_bkt_pvt.bktv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

224: end loop;
225: end if;
226: end if;
227: end rosetta_table_copy_in_p5;
228: procedure rosetta_table_copy_out_p5(t okl_bkt_pvt.bktv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
229: , a1 out nocopy JTF_NUMBER_TABLE
230: , a2 out nocopy JTF_NUMBER_TABLE
231: , a3 out nocopy JTF_VARCHAR2_TABLE_100
232: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 374: ddp_bktv_rec okl_bkt_pvt.bktv_rec_type;

370: , p5_a16 NUMBER := 0-1962.0724
371: )
372:
373: as
374: ddp_bktv_rec okl_bkt_pvt.bktv_rec_type;
375: ddx_bktv_rec okl_bkt_pvt.bktv_rec_type;
376: ddindx binary_integer; indx binary_integer;
377: begin
378:

Line 375: ddx_bktv_rec okl_bkt_pvt.bktv_rec_type;

371: )
372:
373: as
374: ddp_bktv_rec okl_bkt_pvt.bktv_rec_type;
375: ddx_bktv_rec okl_bkt_pvt.bktv_rec_type;
376: ddindx binary_integer; indx binary_integer;
377: begin
378:
379: -- copy data to the local IN or IN-OUT args, if any

Line 405: okl_bkt_pvt.insert_row(p_api_version,

401: ddp_bktv_rec.last_update_login := rosetta_g_miss_num_map(p5_a16);
402:
403:
404: -- here's the delegated call to the old PL/SQL routine
405: okl_bkt_pvt.insert_row(p_api_version,
406: p_init_msg_list,
407: x_return_status,
408: x_msg_count,
409: x_msg_data,

Line 481: ddp_bktv_tbl okl_bkt_pvt.bktv_tbl_type;

477: , p6_a16 out nocopy JTF_NUMBER_TABLE
478: )
479:
480: as
481: ddp_bktv_tbl okl_bkt_pvt.bktv_tbl_type;
482: ddx_bktv_tbl okl_bkt_pvt.bktv_tbl_type;
483: ddindx binary_integer; indx binary_integer;
484: begin
485:

Line 482: ddx_bktv_tbl okl_bkt_pvt.bktv_tbl_type;

478: )
479:
480: as
481: ddp_bktv_tbl okl_bkt_pvt.bktv_tbl_type;
482: ddx_bktv_tbl okl_bkt_pvt.bktv_tbl_type;
483: ddindx binary_integer; indx binary_integer;
484: begin
485:
486: -- copy data to the local IN or IN-OUT args, if any

Line 492: okl_bkt_pvt_w.rosetta_table_copy_in_p5(ddp_bktv_tbl, p5_a0

488:
489:
490:
491:
492: okl_bkt_pvt_w.rosetta_table_copy_in_p5(ddp_bktv_tbl, p5_a0
493: , p5_a1
494: , p5_a2
495: , p5_a3
496: , p5_a4

Line 513: okl_bkt_pvt.insert_row(p_api_version,

509: );
510:
511:
512: -- here's the delegated call to the old PL/SQL routine
513: okl_bkt_pvt.insert_row(p_api_version,
514: p_init_msg_list,
515: x_return_status,
516: x_msg_count,
517: x_msg_data,

Line 528: okl_bkt_pvt_w.rosetta_table_copy_out_p5(ddx_bktv_tbl, p6_a0

524:
525:
526:
527:
528: okl_bkt_pvt_w.rosetta_table_copy_out_p5(ddx_bktv_tbl, p6_a0
529: , p6_a1
530: , p6_a2
531: , p6_a3
532: , p6_a4

Line 573: ddp_bktv_rec okl_bkt_pvt.bktv_rec_type;

569: , p5_a16 NUMBER := 0-1962.0724
570: )
571:
572: as
573: ddp_bktv_rec okl_bkt_pvt.bktv_rec_type;
574: ddindx binary_integer; indx binary_integer;
575: begin
576:
577: -- copy data to the local IN or IN-OUT args, if any

Line 602: okl_bkt_pvt.lock_row(p_api_version,

598: ddp_bktv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a15);
599: ddp_bktv_rec.last_update_login := rosetta_g_miss_num_map(p5_a16);
600:
601: -- here's the delegated call to the old PL/SQL routine
602: okl_bkt_pvt.lock_row(p_api_version,
603: p_init_msg_list,
604: x_return_status,
605: x_msg_count,
606: x_msg_data,

Line 642: ddp_bktv_tbl okl_bkt_pvt.bktv_tbl_type;

638: , p5_a16 JTF_NUMBER_TABLE
639: )
640:
641: as
642: ddp_bktv_tbl okl_bkt_pvt.bktv_tbl_type;
643: ddindx binary_integer; indx binary_integer;
644: begin
645:
646: -- copy data to the local IN or IN-OUT args, if any

Line 652: okl_bkt_pvt_w.rosetta_table_copy_in_p5(ddp_bktv_tbl, p5_a0

648:
649:
650:
651:
652: okl_bkt_pvt_w.rosetta_table_copy_in_p5(ddp_bktv_tbl, p5_a0
653: , p5_a1
654: , p5_a2
655: , p5_a3
656: , p5_a4

Line 672: okl_bkt_pvt.lock_row(p_api_version,

668: , p5_a16
669: );
670:
671: -- here's the delegated call to the old PL/SQL routine
672: okl_bkt_pvt.lock_row(p_api_version,
673: p_init_msg_list,
674: x_return_status,
675: x_msg_count,
676: x_msg_data,

Line 729: ddp_bktv_rec okl_bkt_pvt.bktv_rec_type;

725: , p5_a16 NUMBER := 0-1962.0724
726: )
727:
728: as
729: ddp_bktv_rec okl_bkt_pvt.bktv_rec_type;
730: ddx_bktv_rec okl_bkt_pvt.bktv_rec_type;
731: ddindx binary_integer; indx binary_integer;
732: begin
733:

Line 730: ddx_bktv_rec okl_bkt_pvt.bktv_rec_type;

726: )
727:
728: as
729: ddp_bktv_rec okl_bkt_pvt.bktv_rec_type;
730: ddx_bktv_rec okl_bkt_pvt.bktv_rec_type;
731: ddindx binary_integer; indx binary_integer;
732: begin
733:
734: -- copy data to the local IN or IN-OUT args, if any

Line 760: okl_bkt_pvt.update_row(p_api_version,

756: ddp_bktv_rec.last_update_login := rosetta_g_miss_num_map(p5_a16);
757:
758:
759: -- here's the delegated call to the old PL/SQL routine
760: okl_bkt_pvt.update_row(p_api_version,
761: p_init_msg_list,
762: x_return_status,
763: x_msg_count,
764: x_msg_data,

Line 836: ddp_bktv_tbl okl_bkt_pvt.bktv_tbl_type;

832: , p6_a16 out nocopy JTF_NUMBER_TABLE
833: )
834:
835: as
836: ddp_bktv_tbl okl_bkt_pvt.bktv_tbl_type;
837: ddx_bktv_tbl okl_bkt_pvt.bktv_tbl_type;
838: ddindx binary_integer; indx binary_integer;
839: begin
840:

Line 837: ddx_bktv_tbl okl_bkt_pvt.bktv_tbl_type;

833: )
834:
835: as
836: ddp_bktv_tbl okl_bkt_pvt.bktv_tbl_type;
837: ddx_bktv_tbl okl_bkt_pvt.bktv_tbl_type;
838: ddindx binary_integer; indx binary_integer;
839: begin
840:
841: -- copy data to the local IN or IN-OUT args, if any

Line 847: okl_bkt_pvt_w.rosetta_table_copy_in_p5(ddp_bktv_tbl, p5_a0

843:
844:
845:
846:
847: okl_bkt_pvt_w.rosetta_table_copy_in_p5(ddp_bktv_tbl, p5_a0
848: , p5_a1
849: , p5_a2
850: , p5_a3
851: , p5_a4

Line 868: okl_bkt_pvt.update_row(p_api_version,

864: );
865:
866:
867: -- here's the delegated call to the old PL/SQL routine
868: okl_bkt_pvt.update_row(p_api_version,
869: p_init_msg_list,
870: x_return_status,
871: x_msg_count,
872: x_msg_data,

Line 883: okl_bkt_pvt_w.rosetta_table_copy_out_p5(ddx_bktv_tbl, p6_a0

879:
880:
881:
882:
883: okl_bkt_pvt_w.rosetta_table_copy_out_p5(ddx_bktv_tbl, p6_a0
884: , p6_a1
885: , p6_a2
886: , p6_a3
887: , p6_a4

Line 928: ddp_bktv_rec okl_bkt_pvt.bktv_rec_type;

924: , p5_a16 NUMBER := 0-1962.0724
925: )
926:
927: as
928: ddp_bktv_rec okl_bkt_pvt.bktv_rec_type;
929: ddindx binary_integer; indx binary_integer;
930: begin
931:
932: -- copy data to the local IN or IN-OUT args, if any

Line 957: okl_bkt_pvt.delete_row(p_api_version,

953: ddp_bktv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a15);
954: ddp_bktv_rec.last_update_login := rosetta_g_miss_num_map(p5_a16);
955:
956: -- here's the delegated call to the old PL/SQL routine
957: okl_bkt_pvt.delete_row(p_api_version,
958: p_init_msg_list,
959: x_return_status,
960: x_msg_count,
961: x_msg_data,

Line 997: ddp_bktv_tbl okl_bkt_pvt.bktv_tbl_type;

993: , p5_a16 JTF_NUMBER_TABLE
994: )
995:
996: as
997: ddp_bktv_tbl okl_bkt_pvt.bktv_tbl_type;
998: ddindx binary_integer; indx binary_integer;
999: begin
1000:
1001: -- copy data to the local IN or IN-OUT args, if any

Line 1007: okl_bkt_pvt_w.rosetta_table_copy_in_p5(ddp_bktv_tbl, p5_a0

1003:
1004:
1005:
1006:
1007: okl_bkt_pvt_w.rosetta_table_copy_in_p5(ddp_bktv_tbl, p5_a0
1008: , p5_a1
1009: , p5_a2
1010: , p5_a3
1011: , p5_a4

Line 1027: okl_bkt_pvt.delete_row(p_api_version,

1023: , p5_a16
1024: );
1025:
1026: -- here's the delegated call to the old PL/SQL routine
1027: okl_bkt_pvt.delete_row(p_api_version,
1028: p_init_msg_list,
1029: x_return_status,
1030: x_msg_count,
1031: x_msg_data,

Line 1067: ddp_bktv_rec okl_bkt_pvt.bktv_rec_type;

1063: , p5_a16 NUMBER := 0-1962.0724
1064: )
1065:
1066: as
1067: ddp_bktv_rec okl_bkt_pvt.bktv_rec_type;
1068: ddindx binary_integer; indx binary_integer;
1069: begin
1070:
1071: -- copy data to the local IN or IN-OUT args, if any

Line 1096: okl_bkt_pvt.validate_row(p_api_version,

1092: ddp_bktv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a15);
1093: ddp_bktv_rec.last_update_login := rosetta_g_miss_num_map(p5_a16);
1094:
1095: -- here's the delegated call to the old PL/SQL routine
1096: okl_bkt_pvt.validate_row(p_api_version,
1097: p_init_msg_list,
1098: x_return_status,
1099: x_msg_count,
1100: x_msg_data,

Line 1136: ddp_bktv_tbl okl_bkt_pvt.bktv_tbl_type;

1132: , p5_a16 JTF_NUMBER_TABLE
1133: )
1134:
1135: as
1136: ddp_bktv_tbl okl_bkt_pvt.bktv_tbl_type;
1137: ddindx binary_integer; indx binary_integer;
1138: begin
1139:
1140: -- copy data to the local IN or IN-OUT args, if any

Line 1146: okl_bkt_pvt_w.rosetta_table_copy_in_p5(ddp_bktv_tbl, p5_a0

1142:
1143:
1144:
1145:
1146: okl_bkt_pvt_w.rosetta_table_copy_in_p5(ddp_bktv_tbl, p5_a0
1147: , p5_a1
1148: , p5_a2
1149: , p5_a3
1150: , p5_a4

Line 1166: okl_bkt_pvt.validate_row(p_api_version,

1162: , p5_a16
1163: );
1164:
1165: -- here's the delegated call to the old PL/SQL routine
1166: okl_bkt_pvt.validate_row(p_api_version,
1167: p_init_msg_list,
1168: x_return_status,
1169: x_msg_count,
1170: x_msg_data,

Line 1181: end okl_bkt_pvt_w;

1177:
1178:
1179: end;
1180:
1181: end okl_bkt_pvt_w;