1: package body okl_df_ctgy_rmk_tms_pub_w as
2: /* $Header: OKLUDCTB.pls 120.2 2005/12/08 18:01:51 stmathew 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:
52: , p6_a12 out nocopy JTF_NUMBER_TABLE
53: )
54:
55: as
56: ddp_dctv_tbl okl_df_ctgy_rmk_tms_pub.dctv_tbl_type;
57: ddx_dctv_tbl okl_df_ctgy_rmk_tms_pub.dctv_tbl_type;
58: ddindx binary_integer; indx binary_integer;
59: begin
60:
53: )
54:
55: as
56: ddp_dctv_tbl okl_df_ctgy_rmk_tms_pub.dctv_tbl_type;
57: ddx_dctv_tbl okl_df_ctgy_rmk_tms_pub.dctv_tbl_type;
58: ddindx binary_integer; indx binary_integer;
59: begin
60:
61: -- copy data to the local IN or IN-OUT args, if any
80: );
81:
82:
83: -- here's the delegated call to the old PL/SQL routine
84: okl_df_ctgy_rmk_tms_pub.insert_df_ctgy_rmk_tms(p_api_version,
85: p_init_msg_list,
86: x_return_status,
87: x_msg_count,
88: x_msg_data,
145: , p5_a12 NUMBER := 0-1962.0724
146: )
147:
148: as
149: ddp_dctv_rec okl_df_ctgy_rmk_tms_pub.dctv_rec_type;
150: ddx_dctv_rec okl_df_ctgy_rmk_tms_pub.dctv_rec_type;
151: ddindx binary_integer; indx binary_integer;
152: begin
153:
146: )
147:
148: as
149: ddp_dctv_rec okl_df_ctgy_rmk_tms_pub.dctv_rec_type;
150: ddx_dctv_rec okl_df_ctgy_rmk_tms_pub.dctv_rec_type;
151: ddindx binary_integer; indx binary_integer;
152: begin
153:
154: -- copy data to the local IN or IN-OUT args, if any
172: ddp_dctv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
173:
174:
175: -- here's the delegated call to the old PL/SQL routine
176: okl_df_ctgy_rmk_tms_pub.insert_df_ctgy_rmk_tms(p_api_version,
177: p_init_msg_list,
178: x_return_status,
179: x_msg_count,
180: x_msg_data,
223: , p5_a12 JTF_NUMBER_TABLE
224: )
225:
226: as
227: ddp_dctv_tbl okl_df_ctgy_rmk_tms_pub.dctv_tbl_type;
228: ddindx binary_integer; indx binary_integer;
229: begin
230:
231: -- copy data to the local IN or IN-OUT args, if any
249: , p5_a12
250: );
251:
252: -- here's the delegated call to the old PL/SQL routine
253: okl_df_ctgy_rmk_tms_pub.lock_df_ctgy_rmk_tms(p_api_version,
254: p_init_msg_list,
255: x_return_status,
256: x_msg_count,
257: x_msg_data,
285: , p5_a12 NUMBER := 0-1962.0724
286: )
287:
288: as
289: ddp_dctv_rec okl_df_ctgy_rmk_tms_pub.dctv_rec_type;
290: ddindx binary_integer; indx binary_integer;
291: begin
292:
293: -- copy data to the local IN or IN-OUT args, if any
310: ddp_dctv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a11);
311: ddp_dctv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
312:
313: -- here's the delegated call to the old PL/SQL routine
314: okl_df_ctgy_rmk_tms_pub.lock_df_ctgy_rmk_tms(p_api_version,
315: p_init_msg_list,
316: x_return_status,
317: x_msg_count,
318: x_msg_data,
359: , p6_a12 out nocopy JTF_NUMBER_TABLE
360: )
361:
362: as
363: ddp_dctv_tbl okl_df_ctgy_rmk_tms_pub.dctv_tbl_type;
364: ddx_dctv_tbl okl_df_ctgy_rmk_tms_pub.dctv_tbl_type;
365: ddindx binary_integer; indx binary_integer;
366: begin
367:
360: )
361:
362: as
363: ddp_dctv_tbl okl_df_ctgy_rmk_tms_pub.dctv_tbl_type;
364: ddx_dctv_tbl okl_df_ctgy_rmk_tms_pub.dctv_tbl_type;
365: ddindx binary_integer; indx binary_integer;
366: begin
367:
368: -- copy data to the local IN or IN-OUT args, if any
387: );
388:
389:
390: -- here's the delegated call to the old PL/SQL routine
391: okl_df_ctgy_rmk_tms_pub.update_df_ctgy_rmk_tms(p_api_version,
392: p_init_msg_list,
393: x_return_status,
394: x_msg_count,
395: x_msg_data,
452: , p5_a12 NUMBER := 0-1962.0724
453: )
454:
455: as
456: ddp_dctv_rec okl_df_ctgy_rmk_tms_pub.dctv_rec_type;
457: ddx_dctv_rec okl_df_ctgy_rmk_tms_pub.dctv_rec_type;
458: ddindx binary_integer; indx binary_integer;
459: begin
460:
453: )
454:
455: as
456: ddp_dctv_rec okl_df_ctgy_rmk_tms_pub.dctv_rec_type;
457: ddx_dctv_rec okl_df_ctgy_rmk_tms_pub.dctv_rec_type;
458: ddindx binary_integer; indx binary_integer;
459: begin
460:
461: -- copy data to the local IN or IN-OUT args, if any
479: ddp_dctv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
480:
481:
482: -- here's the delegated call to the old PL/SQL routine
483: okl_df_ctgy_rmk_tms_pub.update_df_ctgy_rmk_tms(p_api_version,
484: p_init_msg_list,
485: x_return_status,
486: x_msg_count,
487: x_msg_data,
530: , p5_a12 JTF_NUMBER_TABLE
531: )
532:
533: as
534: ddp_dctv_tbl okl_df_ctgy_rmk_tms_pub.dctv_tbl_type;
535: ddindx binary_integer; indx binary_integer;
536: begin
537:
538: -- copy data to the local IN or IN-OUT args, if any
556: , p5_a12
557: );
558:
559: -- here's the delegated call to the old PL/SQL routine
560: okl_df_ctgy_rmk_tms_pub.delete_df_ctgy_rmk_tms(p_api_version,
561: p_init_msg_list,
562: x_return_status,
563: x_msg_count,
564: x_msg_data,
592: , p5_a12 NUMBER := 0-1962.0724
593: )
594:
595: as
596: ddp_dctv_rec okl_df_ctgy_rmk_tms_pub.dctv_rec_type;
597: ddindx binary_integer; indx binary_integer;
598: begin
599:
600: -- copy data to the local IN or IN-OUT args, if any
617: ddp_dctv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a11);
618: ddp_dctv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
619:
620: -- here's the delegated call to the old PL/SQL routine
621: okl_df_ctgy_rmk_tms_pub.delete_df_ctgy_rmk_tms(p_api_version,
622: p_init_msg_list,
623: x_return_status,
624: x_msg_count,
625: x_msg_data,
653: , p5_a12 JTF_NUMBER_TABLE
654: )
655:
656: as
657: ddp_dctv_tbl okl_df_ctgy_rmk_tms_pub.dctv_tbl_type;
658: ddindx binary_integer; indx binary_integer;
659: begin
660:
661: -- copy data to the local IN or IN-OUT args, if any
679: , p5_a12
680: );
681:
682: -- here's the delegated call to the old PL/SQL routine
683: okl_df_ctgy_rmk_tms_pub.validate_df_ctgy_rmk_tms(p_api_version,
684: p_init_msg_list,
685: x_return_status,
686: x_msg_count,
687: x_msg_data,
715: , p5_a12 NUMBER := 0-1962.0724
716: )
717:
718: as
719: ddp_dctv_rec okl_df_ctgy_rmk_tms_pub.dctv_rec_type;
720: ddindx binary_integer; indx binary_integer;
721: begin
722:
723: -- copy data to the local IN or IN-OUT args, if any
740: ddp_dctv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a11);
741: ddp_dctv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
742:
743: -- here's the delegated call to the old PL/SQL routine
744: okl_df_ctgy_rmk_tms_pub.validate_df_ctgy_rmk_tms(p_api_version,
745: p_init_msg_list,
746: x_return_status,
747: x_msg_count,
748: x_msg_data,
755:
756:
757: end;
758:
759: end okl_df_ctgy_rmk_tms_pub_w;