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