13:
14:
15:
16: Type r_pref_node_value is Record
17: ( pref_hierarchy_id hxc_pref_hierarchies.pref_hierarchy_id%TYPE
18: ,pref_definition_id hxc_pref_hierarchies.pref_definition_id%TYPE
19: ,attribute1 varchar(150)
20: ,attribute2 varchar(150)
21: ,attribute3 varchar(150)
14:
15:
16: Type r_pref_node_value is Record
17: ( pref_hierarchy_id hxc_pref_hierarchies.pref_hierarchy_id%TYPE
18: ,pref_definition_id hxc_pref_hierarchies.pref_definition_id%TYPE
19: ,attribute1 varchar(150)
20: ,attribute2 varchar(150)
21: ,attribute3 varchar(150)
22: ,attribute4 varchar(150)
45: ,attribute27 varchar(150)
46: ,attribute28 varchar(150)
47: ,attribute29 varchar(150)
48: ,attribute30 varchar(150)
49: ,edit_allowed hxc_pref_hierarchies.edit_allowed%TYPE
50: ,displayed hxc_pref_hierarchies.displayed%TYPE
51: ,name hxc_pref_hierarchies.name%TYPE
52: ,top_level_parent_id hxc_pref_hierarchies.top_level_parent_id%TYPE
53: ,code hxc_pref_hierarchies.code%TYPE);
46: ,attribute28 varchar(150)
47: ,attribute29 varchar(150)
48: ,attribute30 varchar(150)
49: ,edit_allowed hxc_pref_hierarchies.edit_allowed%TYPE
50: ,displayed hxc_pref_hierarchies.displayed%TYPE
51: ,name hxc_pref_hierarchies.name%TYPE
52: ,top_level_parent_id hxc_pref_hierarchies.top_level_parent_id%TYPE
53: ,code hxc_pref_hierarchies.code%TYPE);
54:
47: ,attribute29 varchar(150)
48: ,attribute30 varchar(150)
49: ,edit_allowed hxc_pref_hierarchies.edit_allowed%TYPE
50: ,displayed hxc_pref_hierarchies.displayed%TYPE
51: ,name hxc_pref_hierarchies.name%TYPE
52: ,top_level_parent_id hxc_pref_hierarchies.top_level_parent_id%TYPE
53: ,code hxc_pref_hierarchies.code%TYPE);
54:
55: Type t_pref_node_value is Table of
48: ,attribute30 varchar(150)
49: ,edit_allowed hxc_pref_hierarchies.edit_allowed%TYPE
50: ,displayed hxc_pref_hierarchies.displayed%TYPE
51: ,name hxc_pref_hierarchies.name%TYPE
52: ,top_level_parent_id hxc_pref_hierarchies.top_level_parent_id%TYPE
53: ,code hxc_pref_hierarchies.code%TYPE);
54:
55: Type t_pref_node_value is Table of
56: r_pref_node_value
49: ,edit_allowed hxc_pref_hierarchies.edit_allowed%TYPE
50: ,displayed hxc_pref_hierarchies.displayed%TYPE
51: ,name hxc_pref_hierarchies.name%TYPE
52: ,top_level_parent_id hxc_pref_hierarchies.top_level_parent_id%TYPE
53: ,code hxc_pref_hierarchies.code%TYPE);
54:
55: Type t_pref_node_value is Table of
56: r_pref_node_value
57: Index By BINARY_INTEGER;
105: attribute30 VARCHAR(150),
106: start_date DATE,
107: end_date DATE,
108: rule_evaluation_order hxc_resource_rules.rule_evaluation_order%TYPE,
109: edit_allowed hxc_pref_hierarchies.edit_allowed%TYPE,
110: displayed hxc_pref_hierarchies.displayed%TYPE,
111: name hxc_pref_hierarchies.name%TYPE);
112:
113: g_maxloop NUMBER := 50000;
106: start_date DATE,
107: end_date DATE,
108: rule_evaluation_order hxc_resource_rules.rule_evaluation_order%TYPE,
109: edit_allowed hxc_pref_hierarchies.edit_allowed%TYPE,
110: displayed hxc_pref_hierarchies.displayed%TYPE,
111: name hxc_pref_hierarchies.name%TYPE);
112:
113: g_maxloop NUMBER := 50000;
114: g_loop_count NUMBER;
107: end_date DATE,
108: rule_evaluation_order hxc_resource_rules.rule_evaluation_order%TYPE,
109: edit_allowed hxc_pref_hierarchies.edit_allowed%TYPE,
110: displayed hxc_pref_hierarchies.displayed%TYPE,
111: name hxc_pref_hierarchies.name%TYPE);
112:
113: g_maxloop NUMBER := 50000;
114: g_loop_count NUMBER;
115: