1: package body okl_checklist_pvt_w as
2: /* $Header: OKLECKLB.pls 120.4 2006/03/27 10:56:30 pagarg 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:
106: , p5_a39 NUMBER := 0-1962.0724
107: )
108:
109: as
110: ddp_clhv_rec okl_checklist_pvt.clhv_rec_type;
111: ddx_clhv_rec okl_checklist_pvt.clhv_rec_type;
112: ddindx binary_integer; indx binary_integer;
113: begin
114:
107: )
108:
109: as
110: ddp_clhv_rec okl_checklist_pvt.clhv_rec_type;
111: ddx_clhv_rec okl_checklist_pvt.clhv_rec_type;
112: ddindx binary_integer; indx binary_integer;
113: begin
114:
115: -- copy data to the local IN or IN-OUT args, if any
160: ddp_clhv_rec.ckl_id := rosetta_g_miss_num_map(p5_a39);
161:
162:
163: -- here's the delegated call to the old PL/SQL routine
164: okl_checklist_pvt.create_checklist_hdr(p_api_version,
165: p_init_msg_list,
166: x_return_status,
167: x_msg_count,
168: x_msg_data,
305: , p5_a39 NUMBER := 0-1962.0724
306: )
307:
308: as
309: ddp_clhv_rec okl_checklist_pvt.clhv_rec_type;
310: ddx_clhv_rec okl_checklist_pvt.clhv_rec_type;
311: ddindx binary_integer; indx binary_integer;
312: begin
313:
306: )
307:
308: as
309: ddp_clhv_rec okl_checklist_pvt.clhv_rec_type;
310: ddx_clhv_rec okl_checklist_pvt.clhv_rec_type;
311: ddindx binary_integer; indx binary_integer;
312: begin
313:
314: -- copy data to the local IN or IN-OUT args, if any
359: ddp_clhv_rec.ckl_id := rosetta_g_miss_num_map(p5_a39);
360:
361:
362: -- here's the delegated call to the old PL/SQL routine
363: okl_checklist_pvt.update_checklist_hdr(p_api_version,
364: p_init_msg_list,
365: x_return_status,
366: x_msg_count,
367: x_msg_data,
464: , p5_a39 NUMBER := 0-1962.0724
465: )
466:
467: as
468: ddp_clhv_rec okl_checklist_pvt.clhv_rec_type;
469: ddindx binary_integer; indx binary_integer;
470: begin
471:
472: -- copy data to the local IN or IN-OUT args, if any
516: ddp_clhv_rec.checklist_obj_type_code := p5_a38;
517: ddp_clhv_rec.ckl_id := rosetta_g_miss_num_map(p5_a39);
518:
519: -- here's the delegated call to the old PL/SQL routine
520: okl_checklist_pvt.delete_checklist_hdr(p_api_version,
521: p_init_msg_list,
522: x_return_status,
523: x_msg_count,
524: x_msg_data,
619: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
620: )
621:
622: as
623: ddp_cldv_tbl okl_checklist_pvt.cldv_tbl_type;
624: ddx_cldv_tbl okl_checklist_pvt.cldv_tbl_type;
625: ddindx binary_integer; indx binary_integer;
626: begin
627:
620: )
621:
622: as
623: ddp_cldv_tbl okl_checklist_pvt.cldv_tbl_type;
624: ddx_cldv_tbl okl_checklist_pvt.cldv_tbl_type;
625: ddindx binary_integer; indx binary_integer;
626: begin
627:
628: -- copy data to the local IN or IN-OUT args, if any
674: );
675:
676:
677: -- here's the delegated call to the old PL/SQL routine
678: okl_checklist_pvt.create_checklist_dtl(p_api_version,
679: p_init_msg_list,
680: x_return_status,
681: x_msg_count,
682: x_msg_data,
820: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
821: )
822:
823: as
824: ddp_cldv_tbl okl_checklist_pvt.cldv_tbl_type;
825: ddx_cldv_tbl okl_checklist_pvt.cldv_tbl_type;
826: ddindx binary_integer; indx binary_integer;
827: begin
828:
821: )
822:
823: as
824: ddp_cldv_tbl okl_checklist_pvt.cldv_tbl_type;
825: ddx_cldv_tbl okl_checklist_pvt.cldv_tbl_type;
826: ddindx binary_integer; indx binary_integer;
827: begin
828:
829: -- copy data to the local IN or IN-OUT args, if any
875: );
876:
877:
878: -- here's the delegated call to the old PL/SQL routine
879: okl_checklist_pvt.update_checklist_dtl(p_api_version,
880: p_init_msg_list,
881: x_return_status,
882: x_msg_count,
883: x_msg_data,
981: , p5_a39 JTF_VARCHAR2_TABLE_100
982: )
983:
984: as
985: ddp_cldv_tbl okl_checklist_pvt.cldv_tbl_type;
986: ddindx binary_integer; indx binary_integer;
987: begin
988:
989: -- copy data to the local IN or IN-OUT args, if any
1034: , p5_a39
1035: );
1036:
1037: -- here's the delegated call to the old PL/SQL routine
1038: okl_checklist_pvt.delete_checklist_dtl(p_api_version,
1039: p_init_msg_list,
1040: x_return_status,
1041: x_msg_count,
1042: x_msg_data,
1137: , p5_a39 NUMBER := 0-1962.0724
1138: )
1139:
1140: as
1141: ddp_clhv_rec okl_checklist_pvt.clhv_rec_type;
1142: ddx_clhv_rec okl_checklist_pvt.clhv_rec_type;
1143: ddindx binary_integer; indx binary_integer;
1144: begin
1145:
1138: )
1139:
1140: as
1141: ddp_clhv_rec okl_checklist_pvt.clhv_rec_type;
1142: ddx_clhv_rec okl_checklist_pvt.clhv_rec_type;
1143: ddindx binary_integer; indx binary_integer;
1144: begin
1145:
1146: -- copy data to the local IN or IN-OUT args, if any
1191: ddp_clhv_rec.ckl_id := rosetta_g_miss_num_map(p5_a39);
1192:
1193:
1194: -- here's the delegated call to the old PL/SQL routine
1195: okl_checklist_pvt.create_checklist_inst_hdr(p_api_version,
1196: p_init_msg_list,
1197: x_return_status,
1198: x_msg_count,
1199: x_msg_data,
1336: , p5_a39 NUMBER := 0-1962.0724
1337: )
1338:
1339: as
1340: ddp_clhv_rec okl_checklist_pvt.clhv_rec_type;
1341: ddx_clhv_rec okl_checklist_pvt.clhv_rec_type;
1342: ddindx binary_integer; indx binary_integer;
1343: begin
1344:
1337: )
1338:
1339: as
1340: ddp_clhv_rec okl_checklist_pvt.clhv_rec_type;
1341: ddx_clhv_rec okl_checklist_pvt.clhv_rec_type;
1342: ddindx binary_integer; indx binary_integer;
1343: begin
1344:
1345: -- copy data to the local IN or IN-OUT args, if any
1390: ddp_clhv_rec.ckl_id := rosetta_g_miss_num_map(p5_a39);
1391:
1392:
1393: -- here's the delegated call to the old PL/SQL routine
1394: okl_checklist_pvt.update_checklist_inst_hdr(p_api_version,
1395: p_init_msg_list,
1396: x_return_status,
1397: x_msg_count,
1398: x_msg_data,
1495: , p5_a39 NUMBER := 0-1962.0724
1496: )
1497:
1498: as
1499: ddp_clhv_rec okl_checklist_pvt.clhv_rec_type;
1500: ddindx binary_integer; indx binary_integer;
1501: begin
1502:
1503: -- copy data to the local IN or IN-OUT args, if any
1547: ddp_clhv_rec.checklist_obj_type_code := p5_a38;
1548: ddp_clhv_rec.ckl_id := rosetta_g_miss_num_map(p5_a39);
1549:
1550: -- here's the delegated call to the old PL/SQL routine
1551: okl_checklist_pvt.delete_checklist_inst_hdr(p_api_version,
1552: p_init_msg_list,
1553: x_return_status,
1554: x_msg_count,
1555: x_msg_data,
1650: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
1651: )
1652:
1653: as
1654: ddp_cldv_tbl okl_checklist_pvt.cldv_tbl_type;
1655: ddx_cldv_tbl okl_checklist_pvt.cldv_tbl_type;
1656: ddindx binary_integer; indx binary_integer;
1657: begin
1658:
1651: )
1652:
1653: as
1654: ddp_cldv_tbl okl_checklist_pvt.cldv_tbl_type;
1655: ddx_cldv_tbl okl_checklist_pvt.cldv_tbl_type;
1656: ddindx binary_integer; indx binary_integer;
1657: begin
1658:
1659: -- copy data to the local IN or IN-OUT args, if any
1705: );
1706:
1707:
1708: -- here's the delegated call to the old PL/SQL routine
1709: okl_checklist_pvt.create_checklist_inst_dtl(p_api_version,
1710: p_init_msg_list,
1711: x_return_status,
1712: x_msg_count,
1713: x_msg_data,
1851: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
1852: )
1853:
1854: as
1855: ddp_cldv_tbl okl_checklist_pvt.cldv_tbl_type;
1856: ddx_cldv_tbl okl_checklist_pvt.cldv_tbl_type;
1857: ddindx binary_integer; indx binary_integer;
1858: begin
1859:
1852: )
1853:
1854: as
1855: ddp_cldv_tbl okl_checklist_pvt.cldv_tbl_type;
1856: ddx_cldv_tbl okl_checklist_pvt.cldv_tbl_type;
1857: ddindx binary_integer; indx binary_integer;
1858: begin
1859:
1860: -- copy data to the local IN or IN-OUT args, if any
1906: );
1907:
1908:
1909: -- here's the delegated call to the old PL/SQL routine
1910: okl_checklist_pvt.update_checklist_inst_dtl(p_api_version,
1911: p_init_msg_list,
1912: x_return_status,
1913: x_msg_count,
1914: x_msg_data,
2012: , p5_a39 JTF_VARCHAR2_TABLE_100
2013: )
2014:
2015: as
2016: ddp_cldv_tbl okl_checklist_pvt.cldv_tbl_type;
2017: ddindx binary_integer; indx binary_integer;
2018: begin
2019:
2020: -- copy data to the local IN or IN-OUT args, if any
2065: , p5_a39
2066: );
2067:
2068: -- here's the delegated call to the old PL/SQL routine
2069: okl_checklist_pvt.delete_checklist_inst_dtl(p_api_version,
2070: p_init_msg_list,
2071: x_return_status,
2072: x_msg_count,
2073: x_msg_data,
2080:
2081:
2082: end;
2083:
2084: end okl_checklist_pvt_w;