61: procedure get_act_attr_expanded_info
62: (p_item_type in wf_items.item_type%type
63: ,p_item_key in wf_items.item_key%type
64: ,p_actid in wf_activity_attr_values.process_activity_id%type
65: ,p_name in wf_activity_attributes.name%type
66: ,p_exists out nocopy boolean
67: ,p_subtype out nocopy wf_activity_attributes.subtype%type
68: ,p_type out nocopy wf_activity_attributes.type%type
69: ,p_format out nocopy wf_activity_attributes.format%type
63: ,p_item_key in wf_items.item_key%type
64: ,p_actid in wf_activity_attr_values.process_activity_id%type
65: ,p_name in wf_activity_attributes.name%type
66: ,p_exists out nocopy boolean
67: ,p_subtype out nocopy wf_activity_attributes.subtype%type
68: ,p_type out nocopy wf_activity_attributes.type%type
69: ,p_format out nocopy wf_activity_attributes.format%type
70: ,p_date_value out nocopy wf_activity_attr_values.date_value%type
71: ,p_number_value out nocopy wf_activity_attr_values.number_value%type
64: ,p_actid in wf_activity_attr_values.process_activity_id%type
65: ,p_name in wf_activity_attributes.name%type
66: ,p_exists out nocopy boolean
67: ,p_subtype out nocopy wf_activity_attributes.subtype%type
68: ,p_type out nocopy wf_activity_attributes.type%type
69: ,p_format out nocopy wf_activity_attributes.format%type
70: ,p_date_value out nocopy wf_activity_attr_values.date_value%type
71: ,p_number_value out nocopy wf_activity_attr_values.number_value%type
72: ,p_text_value out nocopy wf_activity_attr_values.text_value%type) is
65: ,p_name in wf_activity_attributes.name%type
66: ,p_exists out nocopy boolean
67: ,p_subtype out nocopy wf_activity_attributes.subtype%type
68: ,p_type out nocopy wf_activity_attributes.type%type
69: ,p_format out nocopy wf_activity_attributes.format%type
70: ,p_date_value out nocopy wf_activity_attr_values.date_value%type
71: ,p_number_value out nocopy wf_activity_attr_values.number_value%type
72: ,p_text_value out nocopy wf_activity_attr_values.text_value%type) is
73: -- --------------------------------------------------------------------------
72: ,p_text_value out nocopy wf_activity_attr_values.text_value%type) is
73: -- --------------------------------------------------------------------------
74: -- declare local variables
75: -- --------------------------------------------------------------------------
76: l_type wf_activity_attributes.type%type;
77: l_name wf_activity_attributes.name%type := upper(p_name);
78: --
79: begin
80: -- initialise the OUT parameters
73: -- --------------------------------------------------------------------------
74: -- declare local variables
75: -- --------------------------------------------------------------------------
76: l_type wf_activity_attributes.type%type;
77: l_name wf_activity_attributes.name%type := upper(p_name);
78: --
79: begin
80: -- initialise the OUT parameters
81: p_exists := true;
137: function get_web_page_code
138: (p_item_type in wf_items.item_type%type
139: ,p_item_key in wf_items.item_key%type
140: ,p_actid in wf_activity_attr_values.process_activity_id%type
141: ,p_web_page_section_code in wf_activity_attributes.name%type)
142: return varchar2 is
143: --
144: l_exists boolean;
145: l_subtype wf_activity_attributes.subtype%type;
141: ,p_web_page_section_code in wf_activity_attributes.name%type)
142: return varchar2 is
143: --
144: l_exists boolean;
145: l_subtype wf_activity_attributes.subtype%type;
146: l_type wf_activity_attributes.type%type;
147: l_format wf_activity_attributes.format%type;
148: l_date_value wf_activity_attr_values.date_value%type;
149: l_number_value wf_activity_attr_values.number_value%type;
142: return varchar2 is
143: --
144: l_exists boolean;
145: l_subtype wf_activity_attributes.subtype%type;
146: l_type wf_activity_attributes.type%type;
147: l_format wf_activity_attributes.format%type;
148: l_date_value wf_activity_attr_values.date_value%type;
149: l_number_value wf_activity_attr_values.number_value%type;
150: l_text_value wf_activity_attr_values.text_value%type;
143: --
144: l_exists boolean;
145: l_subtype wf_activity_attributes.subtype%type;
146: l_type wf_activity_attributes.type%type;
147: l_format wf_activity_attributes.format%type;
148: l_date_value wf_activity_attr_values.date_value%type;
149: l_number_value wf_activity_attr_values.number_value%type;
150: l_text_value wf_activity_attr_values.text_value%type;
151: --
178: function check_web_page_code
179: (p_item_type in wf_items.item_type%type
180: ,p_item_key in wf_items.item_key%type
181: ,p_actid in wf_activity_attr_values.process_activity_id%type
182: ,p_web_page_section_code in wf_activity_attributes.name%type)
183: return boolean is
184: --
185: l_exists boolean;
186: l_subtype wf_activity_attributes.subtype%type;
182: ,p_web_page_section_code in wf_activity_attributes.name%type)
183: return boolean is
184: --
185: l_exists boolean;
186: l_subtype wf_activity_attributes.subtype%type;
187: l_type wf_activity_attributes.type%type;
188: l_format wf_activity_attributes.format%type;
189: l_date_value wf_activity_attr_values.date_value%type;
190: l_number_value wf_activity_attr_values.number_value%type;
183: return boolean is
184: --
185: l_exists boolean;
186: l_subtype wf_activity_attributes.subtype%type;
187: l_type wf_activity_attributes.type%type;
188: l_format wf_activity_attributes.format%type;
189: l_date_value wf_activity_attr_values.date_value%type;
190: l_number_value wf_activity_attr_values.number_value%type;
191: l_text_value wf_activity_attr_values.text_value%type;
184: --
185: l_exists boolean;
186: l_subtype wf_activity_attributes.subtype%type;
187: l_type wf_activity_attributes.type%type;
188: l_format wf_activity_attributes.format%type;
189: l_date_value wf_activity_attr_values.date_value%type;
190: l_number_value wf_activity_attr_values.number_value%type;
191: l_text_value wf_activity_attr_values.text_value%type;
192: --