DBA Data[Home] [Help]

PACKAGE: APPS.AHL_UC_TREE_PVT_W

Source


1 package ahl_uc_tree_pvt_w as
2   /* $Header: AHLWUCTS.pls 120.0.12010000.2 2008/11/06 10:59:33 sathapli ship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_VARCHAR2_TABLE_100
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_NUMBER_TABLE
9     , a6 JTF_VARCHAR2_TABLE_100
10     , a7 JTF_VARCHAR2_TABLE_100
11     , a8 JTF_VARCHAR2_TABLE_100
12     , a9 JTF_VARCHAR2_TABLE_100
13     , a10 JTF_VARCHAR2_TABLE_100
14     );
15   procedure rosetta_table_copy_out_p1(t ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
16     , a1 out nocopy JTF_NUMBER_TABLE
17     , a2 out nocopy JTF_NUMBER_TABLE
18     , a3 out nocopy JTF_VARCHAR2_TABLE_100
19     , a4 out nocopy JTF_NUMBER_TABLE
20     , a5 out nocopy JTF_NUMBER_TABLE
21     , a6 out nocopy JTF_VARCHAR2_TABLE_100
22     , a7 out nocopy JTF_VARCHAR2_TABLE_100
23     , a8 out nocopy JTF_VARCHAR2_TABLE_100
24     , a9 out nocopy JTF_VARCHAR2_TABLE_100
25     , a10 out nocopy JTF_VARCHAR2_TABLE_100
26     );
27 
28   procedure get_whole_uc_tree(p_api_version  NUMBER
29     , p_init_msg_list  VARCHAR2
30     , p_validation_level  NUMBER
31     , x_return_status out nocopy  VARCHAR2
32     , x_msg_count out nocopy  NUMBER
33     , x_msg_data out nocopy  VARCHAR2
34     , p_uc_header_id  NUMBER
35     , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
36     , p7_a1 out nocopy JTF_NUMBER_TABLE
37     , p7_a2 out nocopy JTF_NUMBER_TABLE
38     , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
39     , p7_a4 out nocopy JTF_NUMBER_TABLE
40     , p7_a5 out nocopy JTF_NUMBER_TABLE
41     , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
42     , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
43     , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
44     , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
45     , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
46   );
47 end ahl_uc_tree_pvt_w;