DBA Data[Home] [Help]

APPS.OKL_CHECKLIST_PVT_W dependencies on OKL_CHECKLIST_PVT

Line 1: package body okl_checklist_pvt_w as

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:

Line 110: ddp_clhv_rec okl_checklist_pvt.clhv_rec_type;

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:

Line 111: ddx_clhv_rec okl_checklist_pvt.clhv_rec_type;

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

Line 164: okl_checklist_pvt.create_checklist_hdr(p_api_version,

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,

Line 309: ddp_clhv_rec okl_checklist_pvt.clhv_rec_type;

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:

Line 310: ddx_clhv_rec okl_checklist_pvt.clhv_rec_type;

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

Line 363: okl_checklist_pvt.update_checklist_hdr(p_api_version,

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,

Line 468: ddp_clhv_rec okl_checklist_pvt.clhv_rec_type;

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

Line 520: okl_checklist_pvt.delete_checklist_hdr(p_api_version,

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,

Line 623: ddp_cldv_tbl okl_checklist_pvt.cldv_tbl_type;

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:

Line 624: ddx_cldv_tbl okl_checklist_pvt.cldv_tbl_type;

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

Line 678: okl_checklist_pvt.create_checklist_dtl(p_api_version,

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,

Line 824: ddp_cldv_tbl okl_checklist_pvt.cldv_tbl_type;

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:

Line 825: ddx_cldv_tbl okl_checklist_pvt.cldv_tbl_type;

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

Line 879: okl_checklist_pvt.update_checklist_dtl(p_api_version,

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,

Line 985: ddp_cldv_tbl okl_checklist_pvt.cldv_tbl_type;

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

Line 1038: okl_checklist_pvt.delete_checklist_dtl(p_api_version,

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,

Line 1141: ddp_clhv_rec okl_checklist_pvt.clhv_rec_type;

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:

Line 1142: ddx_clhv_rec okl_checklist_pvt.clhv_rec_type;

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

Line 1195: okl_checklist_pvt.create_checklist_inst_hdr(p_api_version,

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,

Line 1340: ddp_clhv_rec okl_checklist_pvt.clhv_rec_type;

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:

Line 1341: ddx_clhv_rec okl_checklist_pvt.clhv_rec_type;

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

Line 1394: okl_checklist_pvt.update_checklist_inst_hdr(p_api_version,

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,

Line 1499: ddp_clhv_rec okl_checklist_pvt.clhv_rec_type;

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

Line 1551: okl_checklist_pvt.delete_checklist_inst_hdr(p_api_version,

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,

Line 1654: ddp_cldv_tbl okl_checklist_pvt.cldv_tbl_type;

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:

Line 1655: ddx_cldv_tbl okl_checklist_pvt.cldv_tbl_type;

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

Line 1709: okl_checklist_pvt.create_checklist_inst_dtl(p_api_version,

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,

Line 1855: ddp_cldv_tbl okl_checklist_pvt.cldv_tbl_type;

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:

Line 1856: ddx_cldv_tbl okl_checklist_pvt.cldv_tbl_type;

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

Line 1910: okl_checklist_pvt.update_checklist_inst_dtl(p_api_version,

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,

Line 2016: ddp_cldv_tbl okl_checklist_pvt.cldv_tbl_type;

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

Line 2069: okl_checklist_pvt.delete_checklist_inst_dtl(p_api_version,

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,

Line 2084: end okl_checklist_pvt_w;

2080:
2081:
2082: end;
2083:
2084: end okl_checklist_pvt_w;