DBA Data[Home] [Help]

APPS.HR_MEE_WORKFLOW_SERVICE dependencies on WF_ACTIVITY_ATTRIBUTES

Line 65: ,p_name in wf_activity_attributes.name%type

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

Line 67: ,p_subtype out nocopy wf_activity_attributes.subtype%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

Line 68: ,p_type out nocopy wf_activity_attributes.type%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

Line 69: ,p_format out nocopy wf_activity_attributes.format%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
73: -- --------------------------------------------------------------------------

Line 76: l_type wf_activity_attributes.type%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;
77: l_name wf_activity_attributes.name%type := upper(p_name);
78: --
79: begin
80: -- initialise the OUT parameters

Line 77: l_name wf_activity_attributes.name%type := upper(p_name);

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;

Line 141: ,p_web_page_section_code in wf_activity_attributes.name%type)

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;

Line 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;

Line 146: l_type wf_activity_attributes.type%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;

Line 147: l_format wf_activity_attributes.format%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: --

Line 182: ,p_web_page_section_code in wf_activity_attributes.name%type)

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;

Line 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;

Line 187: l_type wf_activity_attributes.type%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;

Line 188: l_format wf_activity_attributes.format%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: --