DBA Data[Home] [Help]

APPS.OKL_ASSET_SUBSIDY_PVT_W dependencies on OKL_ASSET_SUBSIDY_PVT

Line 1: package body okl_asset_subsidy_pvt_w as

1: package body okl_asset_subsidy_pvt_w as
2: /* $Header: OKLEASBB.pls 115.1 2003/10/16 07:55:26 avsingh 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_p1(t out nocopy okl_asset_subsidy_pvt.asb_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_p1(t out nocopy okl_asset_subsidy_pvt.asb_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_NUMBER_TABLE

Line 61: procedure rosetta_table_copy_out_p1(t okl_asset_subsidy_pvt.asb_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

57: end loop;
58: end if;
59: end if;
60: end rosetta_table_copy_in_p1;
61: procedure rosetta_table_copy_out_p1(t okl_asset_subsidy_pvt.asb_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_NUMBER_TABLE
63: , a2 out nocopy JTF_VARCHAR2_TABLE_100
64: , a3 out nocopy JTF_VARCHAR2_TABLE_200
65: , a4 out nocopy JTF_NUMBER_TABLE

Line 165: ddp_asb_rec okl_asset_subsidy_pvt.asb_rec_type;

161: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
162: )
163:
164: as
165: ddp_asb_rec okl_asset_subsidy_pvt.asb_rec_type;
166: ddx_asb_rec okl_asset_subsidy_pvt.asb_rec_type;
167: ddindx binary_integer; indx binary_integer;
168: begin
169:

Line 166: ddx_asb_rec okl_asset_subsidy_pvt.asb_rec_type;

162: )
163:
164: as
165: ddp_asb_rec okl_asset_subsidy_pvt.asb_rec_type;
166: ddx_asb_rec okl_asset_subsidy_pvt.asb_rec_type;
167: ddindx binary_integer; indx binary_integer;
168: begin
169:
170: -- copy data to the local IN or IN-OUT args, if any

Line 190: okl_asset_subsidy_pvt.create_asset_subsidy(p_api_version,

186: ddp_asb_rec.vendor_name := p5_a10;
187:
188:
189: -- here's the delegated call to the old PL/SQL routine
190: okl_asset_subsidy_pvt.create_asset_subsidy(p_api_version,
191: p_init_msg_list,
192: x_return_status,
193: x_msg_count,
194: x_msg_data,

Line 248: ddp_asb_tbl okl_asset_subsidy_pvt.asb_tbl_type;

244: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
245: )
246:
247: as
248: ddp_asb_tbl okl_asset_subsidy_pvt.asb_tbl_type;
249: ddx_asb_tbl okl_asset_subsidy_pvt.asb_tbl_type;
250: ddindx binary_integer; indx binary_integer;
251: begin
252:

Line 249: ddx_asb_tbl okl_asset_subsidy_pvt.asb_tbl_type;

245: )
246:
247: as
248: ddp_asb_tbl okl_asset_subsidy_pvt.asb_tbl_type;
249: ddx_asb_tbl okl_asset_subsidy_pvt.asb_tbl_type;
250: ddindx binary_integer; indx binary_integer;
251: begin
252:
253: -- copy data to the local IN or IN-OUT args, if any

Line 259: okl_asset_subsidy_pvt_w.rosetta_table_copy_in_p1(ddp_asb_tbl, p5_a0

255:
256:
257:
258:
259: okl_asset_subsidy_pvt_w.rosetta_table_copy_in_p1(ddp_asb_tbl, p5_a0
260: , p5_a1
261: , p5_a2
262: , p5_a3
263: , p5_a4

Line 274: okl_asset_subsidy_pvt.create_asset_subsidy(p_api_version,

270: );
271:
272:
273: -- here's the delegated call to the old PL/SQL routine
274: okl_asset_subsidy_pvt.create_asset_subsidy(p_api_version,
275: p_init_msg_list,
276: x_return_status,
277: x_msg_count,
278: x_msg_data,

Line 289: okl_asset_subsidy_pvt_w.rosetta_table_copy_out_p1(ddx_asb_tbl, p6_a0

285:
286:
287:
288:
289: okl_asset_subsidy_pvt_w.rosetta_table_copy_out_p1(ddx_asb_tbl, p6_a0
290: , p6_a1
291: , p6_a2
292: , p6_a3
293: , p6_a4

Line 333: ddp_asb_rec okl_asset_subsidy_pvt.asb_rec_type;

329: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
330: )
331:
332: as
333: ddp_asb_rec okl_asset_subsidy_pvt.asb_rec_type;
334: ddx_asb_rec okl_asset_subsidy_pvt.asb_rec_type;
335: ddindx binary_integer; indx binary_integer;
336: begin
337:

Line 334: ddx_asb_rec okl_asset_subsidy_pvt.asb_rec_type;

330: )
331:
332: as
333: ddp_asb_rec okl_asset_subsidy_pvt.asb_rec_type;
334: ddx_asb_rec okl_asset_subsidy_pvt.asb_rec_type;
335: ddindx binary_integer; indx binary_integer;
336: begin
337:
338: -- copy data to the local IN or IN-OUT args, if any

Line 358: okl_asset_subsidy_pvt.update_asset_subsidy(p_api_version,

354: ddp_asb_rec.vendor_name := p5_a10;
355:
356:
357: -- here's the delegated call to the old PL/SQL routine
358: okl_asset_subsidy_pvt.update_asset_subsidy(p_api_version,
359: p_init_msg_list,
360: x_return_status,
361: x_msg_count,
362: x_msg_data,

Line 416: ddp_asb_tbl okl_asset_subsidy_pvt.asb_tbl_type;

412: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
413: )
414:
415: as
416: ddp_asb_tbl okl_asset_subsidy_pvt.asb_tbl_type;
417: ddx_asb_tbl okl_asset_subsidy_pvt.asb_tbl_type;
418: ddindx binary_integer; indx binary_integer;
419: begin
420:

Line 417: ddx_asb_tbl okl_asset_subsidy_pvt.asb_tbl_type;

413: )
414:
415: as
416: ddp_asb_tbl okl_asset_subsidy_pvt.asb_tbl_type;
417: ddx_asb_tbl okl_asset_subsidy_pvt.asb_tbl_type;
418: ddindx binary_integer; indx binary_integer;
419: begin
420:
421: -- copy data to the local IN or IN-OUT args, if any

Line 427: okl_asset_subsidy_pvt_w.rosetta_table_copy_in_p1(ddp_asb_tbl, p5_a0

423:
424:
425:
426:
427: okl_asset_subsidy_pvt_w.rosetta_table_copy_in_p1(ddp_asb_tbl, p5_a0
428: , p5_a1
429: , p5_a2
430: , p5_a3
431: , p5_a4

Line 442: okl_asset_subsidy_pvt.update_asset_subsidy(p_api_version,

438: );
439:
440:
441: -- here's the delegated call to the old PL/SQL routine
442: okl_asset_subsidy_pvt.update_asset_subsidy(p_api_version,
443: p_init_msg_list,
444: x_return_status,
445: x_msg_count,
446: x_msg_data,

Line 457: okl_asset_subsidy_pvt_w.rosetta_table_copy_out_p1(ddx_asb_tbl, p6_a0

453:
454:
455:
456:
457: okl_asset_subsidy_pvt_w.rosetta_table_copy_out_p1(ddx_asb_tbl, p6_a0
458: , p6_a1
459: , p6_a2
460: , p6_a3
461: , p6_a4

Line 490: ddp_asb_rec okl_asset_subsidy_pvt.asb_rec_type;

486: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
487: )
488:
489: as
490: ddp_asb_rec okl_asset_subsidy_pvt.asb_rec_type;
491: ddindx binary_integer; indx binary_integer;
492: begin
493:
494: -- copy data to the local IN or IN-OUT args, if any

Line 513: okl_asset_subsidy_pvt.delete_asset_subsidy(p_api_version,

509: ddp_asb_rec.vendor_id := rosetta_g_miss_num_map(p5_a9);
510: ddp_asb_rec.vendor_name := p5_a10;
511:
512: -- here's the delegated call to the old PL/SQL routine
513: okl_asset_subsidy_pvt.delete_asset_subsidy(p_api_version,
514: p_init_msg_list,
515: x_return_status,
516: x_msg_count,
517: x_msg_data,

Line 547: ddp_asb_tbl okl_asset_subsidy_pvt.asb_tbl_type;

543: , p5_a10 JTF_VARCHAR2_TABLE_300
544: )
545:
546: as
547: ddp_asb_tbl okl_asset_subsidy_pvt.asb_tbl_type;
548: ddindx binary_integer; indx binary_integer;
549: begin
550:
551: -- copy data to the local IN or IN-OUT args, if any

Line 557: okl_asset_subsidy_pvt_w.rosetta_table_copy_in_p1(ddp_asb_tbl, p5_a0

553:
554:
555:
556:
557: okl_asset_subsidy_pvt_w.rosetta_table_copy_in_p1(ddp_asb_tbl, p5_a0
558: , p5_a1
559: , p5_a2
560: , p5_a3
561: , p5_a4

Line 571: okl_asset_subsidy_pvt.delete_asset_subsidy(p_api_version,

567: , p5_a10
568: );
569:
570: -- here's the delegated call to the old PL/SQL routine
571: okl_asset_subsidy_pvt.delete_asset_subsidy(p_api_version,
572: p_init_msg_list,
573: x_return_status,
574: x_msg_count,
575: x_msg_data,

Line 605: ddp_asb_rec okl_asset_subsidy_pvt.asb_rec_type;

601: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
602: )
603:
604: as
605: ddp_asb_rec okl_asset_subsidy_pvt.asb_rec_type;
606: ddindx binary_integer; indx binary_integer;
607: begin
608:
609: -- copy data to the local IN or IN-OUT args, if any

Line 628: okl_asset_subsidy_pvt.validate_asset_subsidy(p_api_version,

624: ddp_asb_rec.vendor_id := rosetta_g_miss_num_map(p5_a9);
625: ddp_asb_rec.vendor_name := p5_a10;
626:
627: -- here's the delegated call to the old PL/SQL routine
628: okl_asset_subsidy_pvt.validate_asset_subsidy(p_api_version,
629: p_init_msg_list,
630: x_return_status,
631: x_msg_count,
632: x_msg_data,

Line 662: ddp_asb_tbl okl_asset_subsidy_pvt.asb_tbl_type;

658: , p5_a10 JTF_VARCHAR2_TABLE_300
659: )
660:
661: as
662: ddp_asb_tbl okl_asset_subsidy_pvt.asb_tbl_type;
663: ddindx binary_integer; indx binary_integer;
664: begin
665:
666: -- copy data to the local IN or IN-OUT args, if any

Line 672: okl_asset_subsidy_pvt_w.rosetta_table_copy_in_p1(ddp_asb_tbl, p5_a0

668:
669:
670:
671:
672: okl_asset_subsidy_pvt_w.rosetta_table_copy_in_p1(ddp_asb_tbl, p5_a0
673: , p5_a1
674: , p5_a2
675: , p5_a3
676: , p5_a4

Line 686: okl_asset_subsidy_pvt.validate_asset_subsidy(p_api_version,

682: , p5_a10
683: );
684:
685: -- here's the delegated call to the old PL/SQL routine
686: okl_asset_subsidy_pvt.validate_asset_subsidy(p_api_version,
687: p_init_msg_list,
688: x_return_status,
689: x_msg_count,
690: x_msg_data,

Line 731: ddp_asb_rec okl_asset_subsidy_pvt.asb_rec_type;

727: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
728: )
729:
730: as
731: ddp_asb_rec okl_asset_subsidy_pvt.asb_rec_type;
732: ddx_asb_rec okl_asset_subsidy_pvt.asb_rec_type;
733: ddindx binary_integer; indx binary_integer;
734: begin
735:

Line 732: ddx_asb_rec okl_asset_subsidy_pvt.asb_rec_type;

728: )
729:
730: as
731: ddp_asb_rec okl_asset_subsidy_pvt.asb_rec_type;
732: ddx_asb_rec okl_asset_subsidy_pvt.asb_rec_type;
733: ddindx binary_integer; indx binary_integer;
734: begin
735:
736: -- copy data to the local IN or IN-OUT args, if any

Line 756: okl_asset_subsidy_pvt.calculate_asset_subsidy(p_api_version,

752: ddp_asb_rec.vendor_name := p5_a10;
753:
754:
755: -- here's the delegated call to the old PL/SQL routine
756: okl_asset_subsidy_pvt.calculate_asset_subsidy(p_api_version,
757: p_init_msg_list,
758: x_return_status,
759: x_msg_count,
760: x_msg_data,

Line 814: ddp_asb_tbl okl_asset_subsidy_pvt.asb_tbl_type;

810: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
811: )
812:
813: as
814: ddp_asb_tbl okl_asset_subsidy_pvt.asb_tbl_type;
815: ddx_asb_tbl okl_asset_subsidy_pvt.asb_tbl_type;
816: ddindx binary_integer; indx binary_integer;
817: begin
818:

Line 815: ddx_asb_tbl okl_asset_subsidy_pvt.asb_tbl_type;

811: )
812:
813: as
814: ddp_asb_tbl okl_asset_subsidy_pvt.asb_tbl_type;
815: ddx_asb_tbl okl_asset_subsidy_pvt.asb_tbl_type;
816: ddindx binary_integer; indx binary_integer;
817: begin
818:
819: -- copy data to the local IN or IN-OUT args, if any

Line 825: okl_asset_subsidy_pvt_w.rosetta_table_copy_in_p1(ddp_asb_tbl, p5_a0

821:
822:
823:
824:
825: okl_asset_subsidy_pvt_w.rosetta_table_copy_in_p1(ddp_asb_tbl, p5_a0
826: , p5_a1
827: , p5_a2
828: , p5_a3
829: , p5_a4

Line 840: okl_asset_subsidy_pvt.calculate_asset_subsidy(p_api_version,

836: );
837:
838:
839: -- here's the delegated call to the old PL/SQL routine
840: okl_asset_subsidy_pvt.calculate_asset_subsidy(p_api_version,
841: p_init_msg_list,
842: x_return_status,
843: x_msg_count,
844: x_msg_data,

Line 855: okl_asset_subsidy_pvt_w.rosetta_table_copy_out_p1(ddx_asb_tbl, p6_a0

851:
852:
853:
854:
855: okl_asset_subsidy_pvt_w.rosetta_table_copy_out_p1(ddx_asb_tbl, p6_a0
856: , p6_a1
857: , p6_a2
858: , p6_a3
859: , p6_a4

Line 869: end okl_asset_subsidy_pvt_w;

865: , p6_a10
866: );
867: end;
868:
869: end okl_asset_subsidy_pvt_w;