DBA Data[Home] [Help]

APPS.AHL_APPR_SPACE_CAPB_PUB_W dependencies on AHL_APPR_SPACE_CAPB_PUB

Line 1: package body ahl_appr_space_capb_pub_w as

1: package body ahl_appr_space_capb_pub_w as
2: /* $Header: AHLWSPCB.pls 120.1 2006/05/02 07:18 sathapli 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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_appr_space_capb_pub.space_tbl, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_appr_space_capb_pub.space_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE

Line 101: procedure rosetta_table_copy_out_p2(t ahl_appr_space_capb_pub.space_tbl, a0 out nocopy JTF_NUMBER_TABLE

97: end loop;
98: end if;
99: end if;
100: end rosetta_table_copy_in_p2;
101: procedure rosetta_table_copy_out_p2(t ahl_appr_space_capb_pub.space_tbl, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_VARCHAR2_TABLE_100
103: , a2 out nocopy JTF_DATE_TABLE
104: , a3 out nocopy JTF_NUMBER_TABLE
105: , a4 out nocopy JTF_DATE_TABLE

Line 290: procedure rosetta_table_copy_in_p3(t out nocopy ahl_appr_space_capb_pub.space_capbl_tbl, a0 JTF_NUMBER_TABLE

286: end if;
287: end if;
288: end rosetta_table_copy_out_p2;
289:
290: procedure rosetta_table_copy_in_p3(t out nocopy ahl_appr_space_capb_pub.space_capbl_tbl, a0 JTF_NUMBER_TABLE
291: , a1 JTF_DATE_TABLE
292: , a2 JTF_NUMBER_TABLE
293: , a3 JTF_DATE_TABLE
294: , a4 JTF_NUMBER_TABLE

Line 371: procedure rosetta_table_copy_out_p3(t ahl_appr_space_capb_pub.space_capbl_tbl, a0 out nocopy JTF_NUMBER_TABLE

367: end loop;
368: end if;
369: end if;
370: end rosetta_table_copy_in_p3;
371: procedure rosetta_table_copy_out_p3(t ahl_appr_space_capb_pub.space_capbl_tbl, a0 out nocopy JTF_NUMBER_TABLE
372: , a1 out nocopy JTF_DATE_TABLE
373: , a2 out nocopy JTF_NUMBER_TABLE
374: , a3 out nocopy JTF_DATE_TABLE
375: , a4 out nocopy JTF_NUMBER_TABLE

Line 627: ddp_x_space_rec ahl_appr_space_capb_pub.space_rec;

623: , x_msg_data out nocopy VARCHAR2
624: )
625:
626: as
627: ddp_x_space_rec ahl_appr_space_capb_pub.space_rec;
628: ddp_x_space_capbl_tbl ahl_appr_space_capb_pub.space_capbl_tbl;
629: ddindx binary_integer; indx binary_integer;
630: begin
631:

Line 628: ddp_x_space_capbl_tbl ahl_appr_space_capb_pub.space_capbl_tbl;

624: )
625:
626: as
627: ddp_x_space_rec ahl_appr_space_capb_pub.space_rec;
628: ddp_x_space_capbl_tbl ahl_appr_space_capb_pub.space_capbl_tbl;
629: ddindx binary_integer; indx binary_integer;
630: begin
631:
632: -- copy data to the local IN or IN-OUT args, if any

Line 673: ahl_appr_space_capb_pub_w.rosetta_table_copy_in_p3(ddp_x_space_capbl_tbl, p6_a0

669: ddp_x_space_rec.attribute14 := p5_a31;
670: ddp_x_space_rec.attribute15 := p5_a32;
671: ddp_x_space_rec.operation_flag := p5_a33;
672:
673: ahl_appr_space_capb_pub_w.rosetta_table_copy_in_p3(ddp_x_space_capbl_tbl, p6_a0
674: , p6_a1
675: , p6_a2
676: , p6_a3
677: , p6_a4

Line 711: ahl_appr_space_capb_pub.process_space_capbl(p_api_version,

707:
708:
709:
710: -- here's the delegated call to the old PL/SQL routine
711: ahl_appr_space_capb_pub.process_space_capbl(p_api_version,
712: p_init_msg_list,
713: p_commit,
714: p_validation_level,
715: p_module_type,

Line 763: ahl_appr_space_capb_pub_w.rosetta_table_copy_out_p3(ddp_x_space_capbl_tbl, p6_a0

759: p5_a31 := ddp_x_space_rec.attribute14;
760: p5_a32 := ddp_x_space_rec.attribute15;
761: p5_a33 := ddp_x_space_rec.operation_flag;
762:
763: ahl_appr_space_capb_pub_w.rosetta_table_copy_out_p3(ddp_x_space_capbl_tbl, p6_a0
764: , p6_a1
765: , p6_a2
766: , p6_a3
767: , p6_a4

Line 801: end ahl_appr_space_capb_pub_w;

797:
798:
799: end;
800:
801: end ahl_appr_space_capb_pub_w;