DBA Data[Home] [Help]

APPS.HR_MEE_WORKFLOW_SERVICE dependencies on WF_ACTIVITY_ATTR_VALUES

Line 64: ,p_actid in wf_activity_attr_values.process_activity_id%type

60: -- ----------------------------------------------------------------------------
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

Line 70: ,p_date_value out nocopy wf_activity_attr_values.date_value%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: -- --------------------------------------------------------------------------
74: -- declare local variables

Line 71: ,p_number_value out nocopy wf_activity_attr_values.number_value%type

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: -- --------------------------------------------------------------------------
74: -- declare local variables
75: -- --------------------------------------------------------------------------

Line 72: ,p_text_value out nocopy wf_activity_attr_values.text_value%type) is

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: -- --------------------------------------------------------------------------
74: -- declare local variables
75: -- --------------------------------------------------------------------------
76: l_type wf_activity_attributes.type%type;

Line 140: ,p_actid in wf_activity_attr_values.process_activity_id%type

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

Line 148: l_date_value wf_activity_attr_values.date_value%type;

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: --
152: begin

Line 149: l_number_value wf_activity_attr_values.number_value%type;

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: --
152: begin
153: -- get the p_web_page_section_code activity attribute details

Line 150: l_text_value wf_activity_attr_values.text_value%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: --
152: begin
153: -- get the p_web_page_section_code activity attribute details
154: get_act_attr_expanded_info

Line 181: ,p_actid in wf_activity_attr_values.process_activity_id%type

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

Line 189: l_date_value wf_activity_attr_values.date_value%type;

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: --
193: begin

Line 190: l_number_value wf_activity_attr_values.number_value%type;

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: --
193: begin
194: -- check to see if the specified p_web_page_section_code activity

Line 191: l_text_value wf_activity_attr_values.text_value%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: --
193: begin
194: -- check to see if the specified p_web_page_section_code activity
195: -- attribute exists