DBA Data[Home] [Help]

APPS.OKL_INS_CLASS_CATS_PUB_W dependencies on OKL_INS_CLASS_CATS_PUB

Line 1: package body okl_ins_class_cats_pub_w as

1: package body okl_ins_class_cats_pub_w as
2: /* $Header: OKLOICGB.pls 120.1 2005/08/01 06:23:23 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 52: ddp_icgv_tbl okl_ins_class_cats_pub.icgv_tbl_type;

48: , p6_a10 out nocopy JTF_NUMBER_TABLE
49: )
50:
51: as
52: ddp_icgv_tbl okl_ins_class_cats_pub.icgv_tbl_type;
53: ddx_icgv_tbl okl_ins_class_cats_pub.icgv_tbl_type;
54: ddindx binary_integer; indx binary_integer;
55: begin
56:

Line 53: ddx_icgv_tbl okl_ins_class_cats_pub.icgv_tbl_type;

49: )
50:
51: as
52: ddp_icgv_tbl okl_ins_class_cats_pub.icgv_tbl_type;
53: ddx_icgv_tbl okl_ins_class_cats_pub.icgv_tbl_type;
54: ddindx binary_integer; indx binary_integer;
55: begin
56:
57: -- copy data to the local IN or IN-OUT args, if any

Line 78: okl_ins_class_cats_pub.insert_ins_class_cats(p_api_version,

74: );
75:
76:
77: -- here's the delegated call to the old PL/SQL routine
78: okl_ins_class_cats_pub.insert_ins_class_cats(p_api_version,
79: p_init_msg_list,
80: x_return_status,
81: x_msg_count,
82: x_msg_data,

Line 137: ddp_icgv_rec okl_ins_class_cats_pub.icgv_rec_type;

133: , p5_a10 NUMBER := 0-1962.0724
134: )
135:
136: as
137: ddp_icgv_rec okl_ins_class_cats_pub.icgv_rec_type;
138: ddx_icgv_rec okl_ins_class_cats_pub.icgv_rec_type;
139: ddindx binary_integer; indx binary_integer;
140: begin
141:

Line 138: ddx_icgv_rec okl_ins_class_cats_pub.icgv_rec_type;

134: )
135:
136: as
137: ddp_icgv_rec okl_ins_class_cats_pub.icgv_rec_type;
138: ddx_icgv_rec okl_ins_class_cats_pub.icgv_rec_type;
139: ddindx binary_integer; indx binary_integer;
140: begin
141:
142: -- copy data to the local IN or IN-OUT args, if any

Line 162: okl_ins_class_cats_pub.insert_ins_class_cats(p_api_version,

158: ddp_icgv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
159:
160:
161: -- here's the delegated call to the old PL/SQL routine
162: okl_ins_class_cats_pub.insert_ins_class_cats(p_api_version,
163: p_init_msg_list,
164: x_return_status,
165: x_msg_count,
166: x_msg_data,

Line 209: ddp_icgv_tbl okl_ins_class_cats_pub.icgv_tbl_type;

205: , p5_a10 JTF_NUMBER_TABLE
206: )
207:
208: as
209: ddp_icgv_tbl okl_ins_class_cats_pub.icgv_tbl_type;
210: ddindx binary_integer; indx binary_integer;
211: begin
212:
213: -- copy data to the local IN or IN-OUT args, if any

Line 233: okl_ins_class_cats_pub.lock_ins_class_cats(p_api_version,

229: , p5_a10
230: );
231:
232: -- here's the delegated call to the old PL/SQL routine
233: okl_ins_class_cats_pub.lock_ins_class_cats(p_api_version,
234: p_init_msg_list,
235: x_return_status,
236: x_msg_count,
237: x_msg_data,

Line 267: ddp_icgv_rec okl_ins_class_cats_pub.icgv_rec_type;

263: , p5_a10 NUMBER := 0-1962.0724
264: )
265:
266: as
267: ddp_icgv_rec okl_ins_class_cats_pub.icgv_rec_type;
268: ddindx binary_integer; indx binary_integer;
269: begin
270:
271: -- copy data to the local IN or IN-OUT args, if any

Line 290: okl_ins_class_cats_pub.lock_ins_class_cats(p_api_version,

286: ddp_icgv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a9);
287: ddp_icgv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
288:
289: -- here's the delegated call to the old PL/SQL routine
290: okl_ins_class_cats_pub.lock_ins_class_cats(p_api_version,
291: p_init_msg_list,
292: x_return_status,
293: x_msg_count,
294: x_msg_data,

Line 335: ddp_icgv_tbl okl_ins_class_cats_pub.icgv_tbl_type;

331: , p6_a10 out nocopy JTF_NUMBER_TABLE
332: )
333:
334: as
335: ddp_icgv_tbl okl_ins_class_cats_pub.icgv_tbl_type;
336: ddx_icgv_tbl okl_ins_class_cats_pub.icgv_tbl_type;
337: ddindx binary_integer; indx binary_integer;
338: begin
339:

Line 336: ddx_icgv_tbl okl_ins_class_cats_pub.icgv_tbl_type;

332: )
333:
334: as
335: ddp_icgv_tbl okl_ins_class_cats_pub.icgv_tbl_type;
336: ddx_icgv_tbl okl_ins_class_cats_pub.icgv_tbl_type;
337: ddindx binary_integer; indx binary_integer;
338: begin
339:
340: -- copy data to the local IN or IN-OUT args, if any

Line 361: okl_ins_class_cats_pub.update_ins_class_cats(p_api_version,

357: );
358:
359:
360: -- here's the delegated call to the old PL/SQL routine
361: okl_ins_class_cats_pub.update_ins_class_cats(p_api_version,
362: p_init_msg_list,
363: x_return_status,
364: x_msg_count,
365: x_msg_data,

Line 420: ddp_icgv_rec okl_ins_class_cats_pub.icgv_rec_type;

416: , p5_a10 NUMBER := 0-1962.0724
417: )
418:
419: as
420: ddp_icgv_rec okl_ins_class_cats_pub.icgv_rec_type;
421: ddx_icgv_rec okl_ins_class_cats_pub.icgv_rec_type;
422: ddindx binary_integer; indx binary_integer;
423: begin
424:

Line 421: ddx_icgv_rec okl_ins_class_cats_pub.icgv_rec_type;

417: )
418:
419: as
420: ddp_icgv_rec okl_ins_class_cats_pub.icgv_rec_type;
421: ddx_icgv_rec okl_ins_class_cats_pub.icgv_rec_type;
422: ddindx binary_integer; indx binary_integer;
423: begin
424:
425: -- copy data to the local IN or IN-OUT args, if any

Line 445: okl_ins_class_cats_pub.update_ins_class_cats(p_api_version,

441: ddp_icgv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
442:
443:
444: -- here's the delegated call to the old PL/SQL routine
445: okl_ins_class_cats_pub.update_ins_class_cats(p_api_version,
446: p_init_msg_list,
447: x_return_status,
448: x_msg_count,
449: x_msg_data,

Line 492: ddp_icgv_tbl okl_ins_class_cats_pub.icgv_tbl_type;

488: , p5_a10 JTF_NUMBER_TABLE
489: )
490:
491: as
492: ddp_icgv_tbl okl_ins_class_cats_pub.icgv_tbl_type;
493: ddindx binary_integer; indx binary_integer;
494: begin
495:
496: -- copy data to the local IN or IN-OUT args, if any

Line 516: okl_ins_class_cats_pub.delete_ins_class_cats(p_api_version,

512: , p5_a10
513: );
514:
515: -- here's the delegated call to the old PL/SQL routine
516: okl_ins_class_cats_pub.delete_ins_class_cats(p_api_version,
517: p_init_msg_list,
518: x_return_status,
519: x_msg_count,
520: x_msg_data,

Line 550: ddp_icgv_rec okl_ins_class_cats_pub.icgv_rec_type;

546: , p5_a10 NUMBER := 0-1962.0724
547: )
548:
549: as
550: ddp_icgv_rec okl_ins_class_cats_pub.icgv_rec_type;
551: ddindx binary_integer; indx binary_integer;
552: begin
553:
554: -- copy data to the local IN or IN-OUT args, if any

Line 573: okl_ins_class_cats_pub.delete_ins_class_cats(p_api_version,

569: ddp_icgv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a9);
570: ddp_icgv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
571:
572: -- here's the delegated call to the old PL/SQL routine
573: okl_ins_class_cats_pub.delete_ins_class_cats(p_api_version,
574: p_init_msg_list,
575: x_return_status,
576: x_msg_count,
577: x_msg_data,

Line 607: ddp_icgv_tbl okl_ins_class_cats_pub.icgv_tbl_type;

603: , p5_a10 JTF_NUMBER_TABLE
604: )
605:
606: as
607: ddp_icgv_tbl okl_ins_class_cats_pub.icgv_tbl_type;
608: ddindx binary_integer; indx binary_integer;
609: begin
610:
611: -- copy data to the local IN or IN-OUT args, if any

Line 631: okl_ins_class_cats_pub.validate_ins_class_cats(p_api_version,

627: , p5_a10
628: );
629:
630: -- here's the delegated call to the old PL/SQL routine
631: okl_ins_class_cats_pub.validate_ins_class_cats(p_api_version,
632: p_init_msg_list,
633: x_return_status,
634: x_msg_count,
635: x_msg_data,

Line 665: ddp_icgv_rec okl_ins_class_cats_pub.icgv_rec_type;

661: , p5_a10 NUMBER := 0-1962.0724
662: )
663:
664: as
665: ddp_icgv_rec okl_ins_class_cats_pub.icgv_rec_type;
666: ddindx binary_integer; indx binary_integer;
667: begin
668:
669: -- copy data to the local IN or IN-OUT args, if any

Line 688: okl_ins_class_cats_pub.validate_ins_class_cats(p_api_version,

684: ddp_icgv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a9);
685: ddp_icgv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
686:
687: -- here's the delegated call to the old PL/SQL routine
688: okl_ins_class_cats_pub.validate_ins_class_cats(p_api_version,
689: p_init_msg_list,
690: x_return_status,
691: x_msg_count,
692: x_msg_data,

Line 703: end okl_ins_class_cats_pub_w;

699:
700:
701: end;
702:
703: end okl_ins_class_cats_pub_w;