DBA Data[Home] [Help]

APPS.HR_MEE_WORKFLOW_SERVICE dependencies on WF_ITEMS

Line 11: (p_item_type in wf_items.item_type%type

7: -- ----------------------------------------------------------------------------
8: -- |------------------------< get_activity_name >-----------------------------|
9: -- ----------------------------------------------------------------------------
10: procedure get_activity_name
11: (p_item_type in wf_items.item_type%type
12: ,p_item_key in wf_items.item_key%type
13: ,p_actid in number
14: ,p_activity_name out nocopy varchar2
15: ,p_activity_display_name out nocopy varchar2) is

Line 12: ,p_item_key in wf_items.item_key%type

8: -- |------------------------< get_activity_name >-----------------------------|
9: -- ----------------------------------------------------------------------------
10: procedure get_activity_name
11: (p_item_type in wf_items.item_type%type
12: ,p_item_key in wf_items.item_key%type
13: ,p_actid in number
14: ,p_activity_name out nocopy varchar2
15: ,p_activity_display_name out nocopy varchar2) is
16: --

Line 62: (p_item_type in wf_items.item_type%type

58: -- ----------------------------------------------------------------------------
59: -- |-------------------------< get_act_attr_expanded_info >------------------|
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

Line 63: ,p_item_key in wf_items.item_key%type

59: -- |-------------------------< get_act_attr_expanded_info >------------------|
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

Line 138: (p_item_type in wf_items.item_type%type

134: -- ----------------------------------------------------------------------------
135: -- |-----------------------------< get_web_page_code >------------------------|
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

Line 139: ,p_item_key in wf_items.item_key%type

135: -- |-----------------------------< get_web_page_code >------------------------|
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: --

Line 179: (p_item_type in wf_items.item_type%type

175: -- ----------------------------------------------------------------------------
176: -- |-------------------------< check_web_page_code >--------------------------|
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

Line 180: ,p_item_key in wf_items.item_key%type

176: -- |-------------------------< check_web_page_code >--------------------------|
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: --

Line 218: p_item_type IN wf_items.item_type%type

214: end check_web_page_code;
215: --
216: -- --- Function to return Assignment_id and Effective date
217: PROCEDURE get_assignment_details(
218: p_item_type IN wf_items.item_type%type
219: ,p_item_key IN wf_items.item_key%type
220: ,p_assignment_id OUT NOCOPY NUMBER
221: ,p_effective_date OUT NOCOPY DATE)
222: IS

Line 219: ,p_item_key IN wf_items.item_key%type

215: --
216: -- --- Function to return Assignment_id and Effective date
217: PROCEDURE get_assignment_details(
218: p_item_type IN wf_items.item_type%type
219: ,p_item_key IN wf_items.item_key%type
220: ,p_assignment_id OUT NOCOPY NUMBER
221: ,p_effective_date OUT NOCOPY DATE)
222: IS
223: l_effective_date date;