DBA Data[Home] [Help]

APPS.AHL_DI_SUBSCRIPTION_PUB_W dependencies on AHL_DI_SUBSCRIPTION_PUB

Line 1: package body ahl_di_subscription_pub_w as

1: package body ahl_di_subscription_pub_w as
2: /* $Header: AHLSUBWB.pls 115.10 2003/07/28 07:30:49 pbarman 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 13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_di_subscription_pub.subscription_tbl, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_di_subscription_pub.subscription_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_NUMBER_TABLE

Line 112: procedure rosetta_table_copy_out_p1(t ahl_di_subscription_pub.subscription_tbl, a0 out nocopy JTF_NUMBER_TABLE

108: end loop;
109: end if;
110: end if;
111: end rosetta_table_copy_in_p1;
112: procedure rosetta_table_copy_out_p1(t ahl_di_subscription_pub.subscription_tbl, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_VARCHAR2_TABLE_100
115: , a3 out nocopy JTF_VARCHAR2_TABLE_100
116: , a4 out nocopy JTF_NUMBER_TABLE

Line 389: ddp_x_subscription_tbl ahl_di_subscription_pub.subscription_tbl;

385: , x_msg_data out nocopy VARCHAR2
386: )
387:
388: as
389: ddp_x_subscription_tbl ahl_di_subscription_pub.subscription_tbl;
390: ddindx binary_integer; indx binary_integer;
391: begin
392:
393: -- copy data to the local IN or IN-OUT args, if any

Line 399: ahl_di_subscription_pub_w.rosetta_table_copy_in_p1(ddp_x_subscription_tbl, p5_a0

395:
396:
397:
398:
399: ahl_di_subscription_pub_w.rosetta_table_copy_in_p1(ddp_x_subscription_tbl, p5_a0
400: , p5_a1
401: , p5_a2
402: , p5_a3
403: , p5_a4

Line 447: ahl_di_subscription_pub.create_subscription(p_api_version,

443:
444:
445:
446: -- here's the delegated call to the old PL/SQL routine
447: ahl_di_subscription_pub.create_subscription(p_api_version,
448: p_init_msg_list,
449: p_commit,
450: p_validate_only,
451: p_validation_level,

Line 464: ahl_di_subscription_pub_w.rosetta_table_copy_out_p1(ddp_x_subscription_tbl, p5_a0

460:
461:
462:
463:
464: ahl_di_subscription_pub_w.rosetta_table_copy_out_p1(ddp_x_subscription_tbl, p5_a0
465: , p5_a1
466: , p5_a2
467: , p5_a3
468: , p5_a4

Line 565: ddp_x_subscription_tbl ahl_di_subscription_pub.subscription_tbl;

561: , x_msg_data out nocopy VARCHAR2
562: )
563:
564: as
565: ddp_x_subscription_tbl ahl_di_subscription_pub.subscription_tbl;
566: ddindx binary_integer; indx binary_integer;
567: begin
568:
569: -- copy data to the local IN or IN-OUT args, if any

Line 575: ahl_di_subscription_pub_w.rosetta_table_copy_in_p1(ddp_x_subscription_tbl, p5_a0

571:
572:
573:
574:
575: ahl_di_subscription_pub_w.rosetta_table_copy_in_p1(ddp_x_subscription_tbl, p5_a0
576: , p5_a1
577: , p5_a2
578: , p5_a3
579: , p5_a4

Line 623: ahl_di_subscription_pub.modify_subscription(p_api_version,

619:
620:
621:
622: -- here's the delegated call to the old PL/SQL routine
623: ahl_di_subscription_pub.modify_subscription(p_api_version,
624: p_init_msg_list,
625: p_commit,
626: p_validate_only,
627: p_validation_level,

Line 640: ahl_di_subscription_pub_w.rosetta_table_copy_out_p1(ddp_x_subscription_tbl, p5_a0

636:
637:
638:
639:
640: ahl_di_subscription_pub_w.rosetta_table_copy_out_p1(ddp_x_subscription_tbl, p5_a0
641: , p5_a1
642: , p5_a2
643: , p5_a3
644: , p5_a4

Line 688: end ahl_di_subscription_pub_w;

684:
685:
686: end;
687:
688: end ahl_di_subscription_pub_w;