APPS.AHL_UC_TREE_PVT_W dependencies on AHL_UC_TREE_PVT

Line 1: package body ahl_uc_tree_pvt_w as

1: package body ahl_uc_tree_pvt_w as
2: /* $Header: AHLWUCTB.pls 120.0.12010000.2 2008/11/06 11:00:33 sathapli ship $ */
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_p1(t out nocopy ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100

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_p1(t out nocopy ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE

Line 55: procedure rosetta_table_copy_out_p1(t ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

51: end loop;
52: end if;
53: end if;
54: end rosetta_table_copy_in_p1;
55: procedure rosetta_table_copy_out_p1(t ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , a1 out nocopy JTF_NUMBER_TABLE
57: , a2 out nocopy JTF_NUMBER_TABLE
58: , a3 out nocopy JTF_VARCHAR2_TABLE_100
59: , a4 out nocopy JTF_NUMBER_TABLE

Line 150: ddx_uc_descendant_tbl ahl_uc_tree_pvt.uc_descendant_tbl_type;

146: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
147: )
148:
149: as
150: ddx_uc_descendant_tbl ahl_uc_tree_pvt.uc_descendant_tbl_type;
151: ddindx binary_integer; indx binary_integer;
152: begin
153:
154: -- copy data to the local IN or IN-OUT args, if any

Line 164: ahl_uc_tree_pvt.get_whole_uc_tree(p_api_version,

160:
161:
162:
163: -- here's the delegated call to the old PL/SQL routine
164: ahl_uc_tree_pvt.get_whole_uc_tree(p_api_version,
165: p_init_msg_list,
166: p_validation_level,
167: x_return_status,
168: x_msg_count,

Line 181: ahl_uc_tree_pvt_w.rosetta_table_copy_out_p1(ddx_uc_descendant_tbl, p7_a0

177:
178:
179:
180:
181: ahl_uc_tree_pvt_w.rosetta_table_copy_out_p1(ddx_uc_descendant_tbl, p7_a0
182: , p7_a1
183: , p7_a2
184: , p7_a3
185: , p7_a4

Line 195: end ahl_uc_tree_pvt_w;

191: , p7_a10
192: );
193: end;
194:
195: end ahl_uc_tree_pvt_w;