DBA Data[Home] [Help]

APPS.HZ_MIXNM_WEBUI_UTILITY_JW dependencies on JTF_VARCHAR2_TABLE_100

Line 63: procedure rosetta_table_copy_in_p1(t out nocopy hz_mixnm_webui_utility.varcharlist, a0 JTF_VARCHAR2_TABLE_100) as

59: end if;
60: end if;
61: end rosetta_table_copy_out_p0;
62:
63: procedure rosetta_table_copy_in_p1(t out nocopy hz_mixnm_webui_utility.varcharlist, a0 JTF_VARCHAR2_TABLE_100) as
64: ddindx binary_integer; indx binary_integer;
65: begin
66: if a0 is not null and a0.count > 0 then
67: if a0.count > 0 then

Line 81: procedure rosetta_table_copy_out_p1(t hz_mixnm_webui_utility.varcharlist, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

77: end loop;
78: end if;
79: end if;
80: end rosetta_table_copy_in_p1;
81: procedure rosetta_table_copy_out_p1(t hz_mixnm_webui_utility.varcharlist, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
82: ddindx binary_integer; indx binary_integer;
83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_VARCHAR2_TABLE_100();

Line 85: a0 := JTF_VARCHAR2_TABLE_100();

81: procedure rosetta_table_copy_out_p1(t hz_mixnm_webui_utility.varcharlist, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
82: ddindx binary_integer; indx binary_integer;
83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_VARCHAR2_TABLE_100();
86: else
87: a0 := JTF_VARCHAR2_TABLE_100();
88: if t.count > 0 then
89: a0.extend(t.count);

Line 87: a0 := JTF_VARCHAR2_TABLE_100();

83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_VARCHAR2_TABLE_100();
86: else
87: a0 := JTF_VARCHAR2_TABLE_100();
88: if t.count > 0 then
89: a0.extend(t.count);
90: ddindx := t.first;
91: indx := 1;

Line 108: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100

104: procedure create_rule_1(p_rule_type VARCHAR2
105: , p_rule_id in out nocopy NUMBER
106: , p_rule_name VARCHAR2
107: , p_entity_attr_id_tab JTF_NUMBER_TABLE
108: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
109: , p_flag_tab JTF_VARCHAR2_TABLE_100
110: , p_os_tab JTF_VARCHAR2_TABLE_100
111: )
112: as

Line 109: , p_flag_tab JTF_VARCHAR2_TABLE_100

105: , p_rule_id in out nocopy NUMBER
106: , p_rule_name VARCHAR2
107: , p_entity_attr_id_tab JTF_NUMBER_TABLE
108: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
109: , p_flag_tab JTF_VARCHAR2_TABLE_100
110: , p_os_tab JTF_VARCHAR2_TABLE_100
111: )
112: as
113: ddp_entity_attr_id_tab hz_mixnm_webui_utility.idlist;

Line 110: , p_os_tab JTF_VARCHAR2_TABLE_100

106: , p_rule_name VARCHAR2
107: , p_entity_attr_id_tab JTF_NUMBER_TABLE
108: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
109: , p_flag_tab JTF_VARCHAR2_TABLE_100
110: , p_os_tab JTF_VARCHAR2_TABLE_100
111: )
112: as
113: ddp_entity_attr_id_tab hz_mixnm_webui_utility.idlist;
114: ddp_attribute_group_name_tab hz_mixnm_webui_utility.varcharlist;

Line 154: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100

150: procedure update_rule_2(p_rule_type VARCHAR2
151: , p_rule_id NUMBER
152: , p_rule_name VARCHAR2
153: , p_entity_attr_id_tab JTF_NUMBER_TABLE
154: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
155: , p_flag_tab JTF_VARCHAR2_TABLE_100
156: , p_os_tab JTF_VARCHAR2_TABLE_100
157: )
158: as

Line 155: , p_flag_tab JTF_VARCHAR2_TABLE_100

151: , p_rule_id NUMBER
152: , p_rule_name VARCHAR2
153: , p_entity_attr_id_tab JTF_NUMBER_TABLE
154: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
155: , p_flag_tab JTF_VARCHAR2_TABLE_100
156: , p_os_tab JTF_VARCHAR2_TABLE_100
157: )
158: as
159: ddp_entity_attr_id_tab hz_mixnm_webui_utility.idlist;

Line 156: , p_os_tab JTF_VARCHAR2_TABLE_100

152: , p_rule_name VARCHAR2
153: , p_entity_attr_id_tab JTF_NUMBER_TABLE
154: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
155: , p_flag_tab JTF_VARCHAR2_TABLE_100
156: , p_os_tab JTF_VARCHAR2_TABLE_100
157: )
158: as
159: ddp_entity_attr_id_tab hz_mixnm_webui_utility.idlist;
160: ddp_attribute_group_name_tab hz_mixnm_webui_utility.varcharlist;

Line 198: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100

194: end;
195:
196: procedure update_thirdpartyrule_3(p_rule_exists VARCHAR2
197: , p_entity_attr_id_tab JTF_NUMBER_TABLE
198: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
199: , p_flag_tab JTF_VARCHAR2_TABLE_100
200: , p_os_tab JTF_VARCHAR2_TABLE_100
201: )
202: as

Line 199: , p_flag_tab JTF_VARCHAR2_TABLE_100

195:
196: procedure update_thirdpartyrule_3(p_rule_exists VARCHAR2
197: , p_entity_attr_id_tab JTF_NUMBER_TABLE
198: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
199: , p_flag_tab JTF_VARCHAR2_TABLE_100
200: , p_os_tab JTF_VARCHAR2_TABLE_100
201: )
202: as
203: ddp_entity_attr_id_tab hz_mixnm_webui_utility.idlist;

Line 200: , p_os_tab JTF_VARCHAR2_TABLE_100

196: procedure update_thirdpartyrule_3(p_rule_exists VARCHAR2
197: , p_entity_attr_id_tab JTF_NUMBER_TABLE
198: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
199: , p_flag_tab JTF_VARCHAR2_TABLE_100
200: , p_os_tab JTF_VARCHAR2_TABLE_100
201: )
202: as
203: ddp_entity_attr_id_tab hz_mixnm_webui_utility.idlist;
204: ddp_attribute_group_name_tab hz_mixnm_webui_utility.varcharlist;

Line 235: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100

231:
232: end;
233:
234: procedure set_datasources_4(p_entity_attr_id_tab JTF_NUMBER_TABLE
235: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
236: , p_range_tab JTF_NUMBER_TABLE
237: , p_data_sources_tab JTF_VARCHAR2_TABLE_100
238: , p_ranking_tab JTF_NUMBER_TABLE
239: )

Line 237: , p_data_sources_tab JTF_VARCHAR2_TABLE_100

233:
234: procedure set_datasources_4(p_entity_attr_id_tab JTF_NUMBER_TABLE
235: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
236: , p_range_tab JTF_NUMBER_TABLE
237: , p_data_sources_tab JTF_VARCHAR2_TABLE_100
238: , p_ranking_tab JTF_NUMBER_TABLE
239: )
240: as
241: ddp_entity_attr_id_tab hz_mixnm_webui_utility.idlist;

Line 277: , x_data_sources_tab out nocopy JTF_VARCHAR2_TABLE_100

273:
274: procedure get_datasourcesforagroup_5(p_entity_type VARCHAR2
275: , p_entity_attr_id_tab JTF_NUMBER_TABLE
276: , x_has_same_setup out nocopy VARCHAR2
277: , x_data_sources_tab out nocopy JTF_VARCHAR2_TABLE_100
278: , x_meaning_tab out nocopy JTF_VARCHAR2_TABLE_100
279: , x_ranking_tab out nocopy JTF_NUMBER_TABLE
280: )
281: as

Line 278: , x_meaning_tab out nocopy JTF_VARCHAR2_TABLE_100

274: procedure get_datasourcesforagroup_5(p_entity_type VARCHAR2
275: , p_entity_attr_id_tab JTF_NUMBER_TABLE
276: , x_has_same_setup out nocopy VARCHAR2
277: , x_data_sources_tab out nocopy JTF_VARCHAR2_TABLE_100
278: , x_meaning_tab out nocopy JTF_VARCHAR2_TABLE_100
279: , x_ranking_tab out nocopy JTF_NUMBER_TABLE
280: )
281: as
282: ddp_entity_attr_id_tab hz_mixnm_webui_utility.idlist;

Line 317: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100

313: hz_mixnm_webui_utility_jw.rosetta_table_copy_out_p0(ddx_ranking_tab, x_ranking_tab);
314: end;
315:
316: procedure set_datasourcesforagroup_6(p_entity_attr_id_tab JTF_NUMBER_TABLE
317: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
318: , p_data_sources_tab JTF_VARCHAR2_TABLE_100
319: , p_ranking_tab JTF_NUMBER_TABLE
320: )
321: as

Line 318: , p_data_sources_tab JTF_VARCHAR2_TABLE_100

314: end;
315:
316: procedure set_datasourcesforagroup_6(p_entity_attr_id_tab JTF_NUMBER_TABLE
317: , p_attribute_group_name_tab JTF_VARCHAR2_TABLE_100
318: , p_data_sources_tab JTF_VARCHAR2_TABLE_100
319: , p_ranking_tab JTF_NUMBER_TABLE
320: )
321: as
322: ddp_entity_attr_id_tab hz_mixnm_webui_utility.idlist;