[Home] [Help]
PACKAGE: APPS.AMW_SCOPE_PVT_W
Source
1 package amw_scope_pvt_w as
2 /* $Header: amwwscps.pls 120.0 2005/05/31 18:17:58 appldev noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy amw_scope_pvt.sub_tbl_type, a0 JTF_VARCHAR2_TABLE_200
4 );
5 procedure rosetta_table_copy_out_p1(t amw_scope_pvt.sub_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
6 );
7
8 procedure rosetta_table_copy_in_p3(t out nocopy amw_scope_pvt.sub_new_tbl_type, a0 JTF_NUMBER_TABLE
9 );
10 procedure rosetta_table_copy_out_p3(t amw_scope_pvt.sub_new_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
11 );
12
13 procedure rosetta_table_copy_in_p5(t out nocopy amw_scope_pvt.lob_tbl_type, a0 JTF_VARCHAR2_TABLE_200
14 );
15 procedure rosetta_table_copy_out_p5(t amw_scope_pvt.lob_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
16 );
17
18 procedure rosetta_table_copy_in_p7(t out nocopy amw_scope_pvt.lob_new_tbl_type, a0 JTF_NUMBER_TABLE
19 );
20 procedure rosetta_table_copy_out_p7(t amw_scope_pvt.lob_new_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
21 );
22
23 procedure rosetta_table_copy_in_p9(t out nocopy amw_scope_pvt.org_tbl_type, a0 JTF_NUMBER_TABLE
24 );
25 procedure rosetta_table_copy_out_p9(t amw_scope_pvt.org_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
26 );
27
28 procedure rosetta_table_copy_in_p11(t out nocopy amw_scope_pvt.process_tbl_type, a0 JTF_NUMBER_TABLE
29 );
30 procedure rosetta_table_copy_out_p11(t amw_scope_pvt.process_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31 );
32
33 procedure rosetta_table_copy_in_p13(t out nocopy amw_scope_pvt.proc_hier_tbl_type, a0 JTF_NUMBER_TABLE
34 , a1 JTF_NUMBER_TABLE
35 , a2 JTF_NUMBER_TABLE
36 , a3 JTF_NUMBER_TABLE
37 );
38 procedure rosetta_table_copy_out_p13(t amw_scope_pvt.proc_hier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
39 , a1 out nocopy JTF_NUMBER_TABLE
40 , a2 out nocopy JTF_NUMBER_TABLE
41 , a3 out nocopy JTF_NUMBER_TABLE
42 );
43
44 procedure add_scope(p_api_version_number NUMBER
45 , p_init_msg_list VARCHAR2
46 , p_commit VARCHAR2
47 , p_validation_level NUMBER
48 , p_entity_id NUMBER
49 , p_entity_type VARCHAR2
50 , p_sub_vs VARCHAR2
51 , p_lob_vs VARCHAR2
52 , p8_a0 JTF_VARCHAR2_TABLE_200
53 , p9_a0 JTF_VARCHAR2_TABLE_200
54 , p10_a0 JTF_NUMBER_TABLE
55 , p11_a0 JTF_NUMBER_TABLE
56 , x_return_status out nocopy VARCHAR2
57 , x_msg_count out nocopy NUMBER
58 , x_msg_data out nocopy VARCHAR2
59 );
60 procedure populate_custom_hierarchy(p0_a0 JTF_NUMBER_TABLE
61 , p_entity_id NUMBER
62 , p_entity_type VARCHAR2
63 );
64 procedure generate_organization_list(p_entity_id NUMBER
65 , p_entity_type VARCHAR2
66 , p2_a0 JTF_NUMBER_TABLE
67 , p3_a0 out nocopy JTF_NUMBER_TABLE
68 );
69 procedure generate_subsidiary_list(p_entity_id NUMBER
70 , p_entity_type VARCHAR2
71 , p2_a0 JTF_NUMBER_TABLE
72 , p3_a0 JTF_VARCHAR2_TABLE_200
73 , p_sub_vs VARCHAR2
74 , p5_a0 out nocopy JTF_NUMBER_TABLE
75 );
76 procedure generate_lob_list(p_entity_id NUMBER
77 , p_entity_type VARCHAR2
78 , p2_a0 JTF_NUMBER_TABLE
79 , p3_a0 JTF_VARCHAR2_TABLE_200
80 , p_sub_vs VARCHAR2
81 , p5_a0 JTF_VARCHAR2_TABLE_200
82 , p_lob_vs VARCHAR2
83 , p7_a0 out nocopy JTF_NUMBER_TABLE
84 );
85 procedure populate_process_hierarchy(p_api_version_number NUMBER
86 , p_init_msg_list VARCHAR2
87 , p_commit VARCHAR2
88 , p_validation_level NUMBER
89 , p_entity_type VARCHAR2
90 , p_entity_id NUMBER
91 , p6_a0 JTF_NUMBER_TABLE
92 , p7_a0 JTF_NUMBER_TABLE
93 , x_return_status out nocopy VARCHAR2
94 , x_msg_count out nocopy NUMBER
95 , x_msg_data out nocopy VARCHAR2
96 );
97 procedure populate_denormalized_tables(p_entity_type VARCHAR2
98 , p_entity_id NUMBER
99 , p2_a0 JTF_NUMBER_TABLE
100 , p3_a0 JTF_NUMBER_TABLE
101 , p_mode VARCHAR2
102 );
103 procedure manage_processes(p_api_version_number NUMBER
104 , p_init_msg_list VARCHAR2
105 , p_commit VARCHAR2
106 , p_validation_level NUMBER
107 , p_entity_type VARCHAR2
108 , p_entity_id NUMBER
109 , p_organization_id NUMBER
110 , p7_a0 JTF_NUMBER_TABLE
111 , p7_a1 JTF_NUMBER_TABLE
112 , p7_a2 JTF_NUMBER_TABLE
113 , p7_a3 JTF_NUMBER_TABLE
114 , x_return_status out nocopy VARCHAR2
115 , x_msg_count out nocopy NUMBER
116 , x_msg_data out nocopy VARCHAR2
117 );
118 end amw_scope_pvt_w;