2: /* $Header: ARHXWUJS.pls 120.2 2005/06/18 04:28:30 jhuang noship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy hz_mixnm_webui_utility.idlist, a0 JTF_NUMBER_TABLE);
4: procedure rosetta_table_copy_out_p0(t hz_mixnm_webui_utility.idlist, a0 out nocopy JTF_NUMBER_TABLE);
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy hz_mixnm_webui_utility.varcharlist, a0 JTF_VARCHAR2_TABLE_100);
7: procedure rosetta_table_copy_out_p1(t hz_mixnm_webui_utility.varcharlist, a0 out nocopy JTF_VARCHAR2_TABLE_100);
8:
9: procedure create_rule_1(p_rule_type VARCHAR2
10: , p_rule_id in out nocopy NUMBER
3: procedure rosetta_table_copy_in_p0(t out nocopy hz_mixnm_webui_utility.idlist, a0 JTF_NUMBER_TABLE);
4: procedure rosetta_table_copy_out_p0(t hz_mixnm_webui_utility.idlist, a0 out nocopy JTF_NUMBER_TABLE);
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy hz_mixnm_webui_utility.varcharlist, a0 JTF_VARCHAR2_TABLE_100);
7: procedure rosetta_table_copy_out_p1(t hz_mixnm_webui_utility.varcharlist, a0 out nocopy JTF_VARCHAR2_TABLE_100);
8:
9: procedure create_rule_1(p_rule_type VARCHAR2
10: , p_rule_id in out nocopy NUMBER
11: , p_rule_name VARCHAR2
9: procedure create_rule_1(p_rule_type VARCHAR2
10: , p_rule_id in out nocopy NUMBER
11: , p_rule_name VARCHAR2
12: , p_entity_attr_id_tab JTF_NUMBER_TABLE
13: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
14: , p_flag_tab JTF_VARCHAR2_TABLE_100
15: , p_os_tab JTF_VARCHAR2_TABLE_100
16: );
17: procedure update_rule_2(p_rule_type VARCHAR2
10: , p_rule_id in out nocopy NUMBER
11: , p_rule_name VARCHAR2
12: , p_entity_attr_id_tab JTF_NUMBER_TABLE
13: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
14: , p_flag_tab JTF_VARCHAR2_TABLE_100
15: , p_os_tab JTF_VARCHAR2_TABLE_100
16: );
17: procedure update_rule_2(p_rule_type VARCHAR2
18: , p_rule_id NUMBER
11: , p_rule_name VARCHAR2
12: , p_entity_attr_id_tab JTF_NUMBER_TABLE
13: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
14: , p_flag_tab JTF_VARCHAR2_TABLE_100
15: , p_os_tab JTF_VARCHAR2_TABLE_100
16: );
17: procedure update_rule_2(p_rule_type VARCHAR2
18: , p_rule_id NUMBER
19: , p_rule_name VARCHAR2
17: procedure update_rule_2(p_rule_type VARCHAR2
18: , p_rule_id NUMBER
19: , p_rule_name VARCHAR2
20: , p_entity_attr_id_tab JTF_NUMBER_TABLE
21: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
22: , p_flag_tab JTF_VARCHAR2_TABLE_100
23: , p_os_tab JTF_VARCHAR2_TABLE_100
24: );
25: procedure update_thirdpartyrule_3(p_rule_exists VARCHAR2
18: , p_rule_id NUMBER
19: , p_rule_name VARCHAR2
20: , p_entity_attr_id_tab JTF_NUMBER_TABLE
21: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
22: , p_flag_tab JTF_VARCHAR2_TABLE_100
23: , p_os_tab JTF_VARCHAR2_TABLE_100
24: );
25: procedure update_thirdpartyrule_3(p_rule_exists VARCHAR2
26: , p_entity_attr_id_tab JTF_NUMBER_TABLE
19: , p_rule_name VARCHAR2
20: , p_entity_attr_id_tab JTF_NUMBER_TABLE
21: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
22: , p_flag_tab JTF_VARCHAR2_TABLE_100
23: , p_os_tab JTF_VARCHAR2_TABLE_100
24: );
25: procedure update_thirdpartyrule_3(p_rule_exists VARCHAR2
26: , p_entity_attr_id_tab JTF_NUMBER_TABLE
27: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
23: , p_os_tab JTF_VARCHAR2_TABLE_100
24: );
25: procedure update_thirdpartyrule_3(p_rule_exists VARCHAR2
26: , p_entity_attr_id_tab JTF_NUMBER_TABLE
27: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
28: , p_flag_tab JTF_VARCHAR2_TABLE_100
29: , p_os_tab JTF_VARCHAR2_TABLE_100
30: );
31: procedure set_datasources_4(p_entity_attr_id_tab JTF_NUMBER_TABLE
24: );
25: procedure update_thirdpartyrule_3(p_rule_exists VARCHAR2
26: , p_entity_attr_id_tab JTF_NUMBER_TABLE
27: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
28: , p_flag_tab JTF_VARCHAR2_TABLE_100
29: , p_os_tab JTF_VARCHAR2_TABLE_100
30: );
31: procedure set_datasources_4(p_entity_attr_id_tab JTF_NUMBER_TABLE
32: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
25: procedure update_thirdpartyrule_3(p_rule_exists VARCHAR2
26: , p_entity_attr_id_tab JTF_NUMBER_TABLE
27: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
28: , p_flag_tab JTF_VARCHAR2_TABLE_100
29: , p_os_tab JTF_VARCHAR2_TABLE_100
30: );
31: procedure set_datasources_4(p_entity_attr_id_tab JTF_NUMBER_TABLE
32: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
33: , p_range_tab JTF_NUMBER_TABLE
28: , p_flag_tab JTF_VARCHAR2_TABLE_100
29: , p_os_tab JTF_VARCHAR2_TABLE_100
30: );
31: procedure set_datasources_4(p_entity_attr_id_tab JTF_NUMBER_TABLE
32: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
33: , p_range_tab JTF_NUMBER_TABLE
34: , p_data_sources_tab JTF_VARCHAR2_TABLE_100
35: , p_ranking_tab JTF_NUMBER_TABLE
36: );
30: );
31: procedure set_datasources_4(p_entity_attr_id_tab JTF_NUMBER_TABLE
32: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
33: , p_range_tab JTF_NUMBER_TABLE
34: , p_data_sources_tab JTF_VARCHAR2_TABLE_100
35: , p_ranking_tab JTF_NUMBER_TABLE
36: );
37: procedure get_datasourcesforagroup_5(p_entity_type VARCHAR2
38: , p_entity_attr_id_tab JTF_NUMBER_TABLE
36: );
37: procedure get_datasourcesforagroup_5(p_entity_type VARCHAR2
38: , p_entity_attr_id_tab JTF_NUMBER_TABLE
39: , x_has_same_setup out nocopy VARCHAR2
40: , x_data_sources_tab out nocopy JTF_VARCHAR2_TABLE_100
41: , x_meaning_tab out nocopy JTF_VARCHAR2_TABLE_100
42: , x_ranking_tab out nocopy JTF_NUMBER_TABLE
43: );
44: procedure set_datasourcesforagroup_6(p_entity_attr_id_tab JTF_NUMBER_TABLE
37: procedure get_datasourcesforagroup_5(p_entity_type VARCHAR2
38: , p_entity_attr_id_tab JTF_NUMBER_TABLE
39: , x_has_same_setup out nocopy VARCHAR2
40: , x_data_sources_tab out nocopy JTF_VARCHAR2_TABLE_100
41: , x_meaning_tab out nocopy JTF_VARCHAR2_TABLE_100
42: , x_ranking_tab out nocopy JTF_NUMBER_TABLE
43: );
44: procedure set_datasourcesforagroup_6(p_entity_attr_id_tab JTF_NUMBER_TABLE
45: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
41: , x_meaning_tab out nocopy JTF_VARCHAR2_TABLE_100
42: , x_ranking_tab out nocopy JTF_NUMBER_TABLE
43: );
44: procedure set_datasourcesforagroup_6(p_entity_attr_id_tab JTF_NUMBER_TABLE
45: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
46: , p_data_sources_tab JTF_VARCHAR2_TABLE_100
47: , p_ranking_tab JTF_NUMBER_TABLE
48: );
49: end hz_mixnm_webui_utility_jw;
42: , x_ranking_tab out nocopy JTF_NUMBER_TABLE
43: );
44: procedure set_datasourcesforagroup_6(p_entity_attr_id_tab JTF_NUMBER_TABLE
45: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
46: , p_data_sources_tab JTF_VARCHAR2_TABLE_100
47: , p_ranking_tab JTF_NUMBER_TABLE
48: );
49: end hz_mixnm_webui_utility_jw;