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:
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: );
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:
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: );
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
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
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
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
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