eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_WORKFLOW_SERVICE dependencies on WF_ITEMS

Line 21: TYPE active_wf_items_rec IS RECORD (

17: g_invalid_responsibility EXCEPTION;
18: TYPE g_varchar2_tab_type IS TABLE OF varchar2(2000) INDEX BY BINARY_INTEGER;
19: g_varchar2_tab_default g_varchar2_tab_type;
20: --
21: TYPE active_wf_items_rec IS RECORD (
22: active_item_key wf_items.item_key%type,
23: activity_result_code wf_item_activity_statuses_v.activity_result_code%type,
24: activity_id wf_item_activity_statuses_v.activity_id%type
25: );

Line 22: active_item_key wf_items.item_key%type,

18: TYPE g_varchar2_tab_type IS TABLE OF varchar2(2000) INDEX BY BINARY_INTEGER;
19: g_varchar2_tab_default g_varchar2_tab_type;
20: --
21: TYPE active_wf_items_rec IS RECORD (
22: active_item_key wf_items.item_key%type,
23: activity_result_code wf_item_activity_statuses_v.activity_result_code%type,
24: activity_id wf_item_activity_statuses_v.activity_id%type
25: );
26: --

Line 27: TYPE active_wf_items_list IS TABLE OF active_wf_items_rec INDEX BY BINARY_INTEGER;

23: activity_result_code wf_item_activity_statuses_v.activity_result_code%type,
24: activity_id wf_item_activity_statuses_v.activity_id%type
25: );
26: --
27: TYPE active_wf_items_list IS TABLE OF active_wf_items_rec INDEX BY BINARY_INTEGER;
28: --
29: TYPE active_wf_trans_items_rec IS RECORD (
30: active_item_key wf_items.item_key%type
31: ,activity_id wf_item_activity_statuses_v.activity_id%type

Line 30: active_item_key wf_items.item_key%type

26: --
27: TYPE active_wf_items_list IS TABLE OF active_wf_items_rec INDEX BY BINARY_INTEGER;
28: --
29: TYPE active_wf_trans_items_rec IS RECORD (
30: active_item_key wf_items.item_key%type
31: ,activity_id wf_item_activity_statuses_v.activity_id%type
32: ,trans_step_id hr_api_transaction_steps.transaction_step_id %type
33: ,activity_result_code
34: wf_item_activity_statuses_v.activity_result_code%type

Line 60: (p_item_type in wf_items.item_type%type

56: -- ----------------------------------------------------------------------------
57: -- |------------------------< create_hr_directory_services >------------------|
58: -- ----------------------------------------------------------------------------
59: procedure create_hr_directory_services
60: (p_item_type in wf_items.item_type%type
61: ,p_item_key in wf_items.item_key%type
62: ,p_service_name in varchar2
63: ,p_service_person_id in per_all_people_f.person_id%type);
64: --

Line 61: ,p_item_key in wf_items.item_key%type

57: -- |------------------------< create_hr_directory_services >------------------|
58: -- ----------------------------------------------------------------------------
59: procedure create_hr_directory_services
60: (p_item_type in wf_items.item_type%type
61: ,p_item_key in wf_items.item_key%type
62: ,p_service_name in varchar2
63: ,p_service_person_id in per_all_people_f.person_id%type);
64: --
65: -- ----------------------------------------------------------------------------

Line 69: (p_item_type in wf_items.item_type%type

65: -- ----------------------------------------------------------------------------
66: -- |-------------------------< get_item_attr_expanded_info >------------------|
67: -- ----------------------------------------------------------------------------
68: procedure get_item_attr_expanded_info
69: (p_item_type in wf_items.item_type%type
70: ,p_item_key in wf_items.item_key%type
71: ,p_name in wf_item_attributes.name%type
72: ,p_exists out nocopy boolean
73: ,p_subtype out nocopy wf_item_attributes.subtype%type

Line 70: ,p_item_key in wf_items.item_key%type

66: -- |-------------------------< get_item_attr_expanded_info >------------------|
67: -- ----------------------------------------------------------------------------
68: procedure get_item_attr_expanded_info
69: (p_item_type in wf_items.item_type%type
70: ,p_item_key in wf_items.item_key%type
71: ,p_name in wf_item_attributes.name%type
72: ,p_exists out nocopy boolean
73: ,p_subtype out nocopy wf_item_attributes.subtype%type
74: ,p_type out nocopy wf_item_attributes.type%type

Line 83: (p_item_type in wf_items.item_type%type

79: -- ----------------------------------------------------------------------------
80: -- |-------------------------< get_act_attr_expanded_info >------------------|
81: -- ----------------------------------------------------------------------------
82: procedure get_act_attr_expanded_info
83: (p_item_type in wf_items.item_type%type
84: ,p_item_key in wf_items.item_key%type
85: ,p_actid in wf_activity_attr_values.process_activity_id%type
86: ,p_name in wf_activity_attributes.name%type
87: ,p_exists out nocopy boolean

Line 84: ,p_item_key in wf_items.item_key%type

80: -- |-------------------------< get_act_attr_expanded_info >------------------|
81: -- ----------------------------------------------------------------------------
82: procedure get_act_attr_expanded_info
83: (p_item_type in wf_items.item_type%type
84: ,p_item_key in wf_items.item_key%type
85: ,p_actid in wf_activity_attr_values.process_activity_id%type
86: ,p_name in wf_activity_attributes.name%type
87: ,p_exists out nocopy boolean
88: ,p_subtype out nocopy wf_activity_attributes.subtype%type

Line 98: (p_item_type in wf_items.item_type%type

94: -- ----------------------------------------------------------------------------
95: -- |-------------------------< check_activity_type_attrs >--------------------|
96: -- ----------------------------------------------------------------------------
97: procedure check_activity_type_attrs
98: (p_item_type in wf_items.item_type%type
99: ,p_item_key in wf_items.item_key%type
100: ,p_actid in wf_activity_attr_values.process_activity_id%type);
101: -- ----------------------------------------------------------------------------
102: -- |-------------------------------< hr_web_page >----------------------------|

Line 99: ,p_item_key in wf_items.item_key%type

95: -- |-------------------------< check_activity_type_attrs >--------------------|
96: -- ----------------------------------------------------------------------------
97: procedure check_activity_type_attrs
98: (p_item_type in wf_items.item_type%type
99: ,p_item_key in wf_items.item_key%type
100: ,p_actid in wf_activity_attr_values.process_activity_id%type);
101: -- ----------------------------------------------------------------------------
102: -- |-------------------------------< hr_web_page >----------------------------|
103: -- ----------------------------------------------------------------------------

Line 114: (p_item_type in wf_items.item_type%type

110: -- ----------------------------------------------------------------------------
111: -- |-------------------------< check_hr_window_title >------------------------|
112: -- ----------------------------------------------------------------------------
113: function check_hr_window_title
114: (p_item_type in wf_items.item_type%type
115: ,p_item_key in wf_items.item_key%type
116: ,p_actid in wf_activity_attr_values.process_activity_id%type)
117: return boolean;
118: -- ----------------------------------------------------------------------------

Line 115: ,p_item_key in wf_items.item_key%type

111: -- |-------------------------< check_hr_window_title >------------------------|
112: -- ----------------------------------------------------------------------------
113: function check_hr_window_title
114: (p_item_type in wf_items.item_type%type
115: ,p_item_key in wf_items.item_key%type
116: ,p_actid in wf_activity_attr_values.process_activity_id%type)
117: return boolean;
118: -- ----------------------------------------------------------------------------
119: -- |---------------------------< get_hr_window_title >------------------------|

Line 122: (p_item_type in wf_items.item_type%type

118: -- ----------------------------------------------------------------------------
119: -- |---------------------------< get_hr_window_title >------------------------|
120: -- ----------------------------------------------------------------------------
121: function get_hr_window_title
122: (p_item_type in wf_items.item_type%type
123: ,p_item_key in wf_items.item_key%type
124: ,p_actid in wf_activity_attr_values.process_activity_id%type)
125: return varchar2;
126: -- ----------------------------------------------------------------------------

Line 123: ,p_item_key in wf_items.item_key%type

119: -- |---------------------------< get_hr_window_title >------------------------|
120: -- ----------------------------------------------------------------------------
121: function get_hr_window_title
122: (p_item_type in wf_items.item_type%type
123: ,p_item_key in wf_items.item_key%type
124: ,p_actid in wf_activity_attr_values.process_activity_id%type)
125: return varchar2;
126: -- ----------------------------------------------------------------------------
127: -- |-------------------------< check_web_page_code >--------------------------|

Line 130: (p_item_type in wf_items.item_type%type

126: -- ----------------------------------------------------------------------------
127: -- |-------------------------< check_web_page_code >--------------------------|
128: -- ----------------------------------------------------------------------------
129: function check_web_page_code
130: (p_item_type in wf_items.item_type%type
131: ,p_item_key in wf_items.item_key%type
132: ,p_actid in wf_activity_attr_values.process_activity_id%type
133: ,p_web_page_section_code in wf_activity_attributes.name%type)
134: return boolean;

Line 131: ,p_item_key in wf_items.item_key%type

127: -- |-------------------------< check_web_page_code >--------------------------|
128: -- ----------------------------------------------------------------------------
129: function check_web_page_code
130: (p_item_type in wf_items.item_type%type
131: ,p_item_key in wf_items.item_key%type
132: ,p_actid in wf_activity_attr_values.process_activity_id%type
133: ,p_web_page_section_code in wf_activity_attributes.name%type)
134: return boolean;
135: -- ----------------------------------------------------------------------------

Line 139: (p_item_type in wf_items.item_type%type

135: -- ----------------------------------------------------------------------------
136: -- |-----------------------------< get_web_page_code >------------------------|
137: -- ----------------------------------------------------------------------------
138: function get_web_page_code
139: (p_item_type in wf_items.item_type%type
140: ,p_item_key in wf_items.item_key%type
141: ,p_actid in wf_activity_attr_values.process_activity_id%type
142: ,p_web_page_section_code in wf_activity_attributes.name%type)
143: return varchar2;

Line 140: ,p_item_key in wf_items.item_key%type

136: -- |-----------------------------< get_web_page_code >------------------------|
137: -- ----------------------------------------------------------------------------
138: function get_web_page_code
139: (p_item_type in wf_items.item_type%type
140: ,p_item_key in wf_items.item_key%type
141: ,p_actid in wf_activity_attr_values.process_activity_id%type
142: ,p_web_page_section_code in wf_activity_attributes.name%type)
143: return varchar2;
144: -- ----------------------------------------------------------------------------

Line 148: (p_item_type in wf_items.item_type%type

144: -- ----------------------------------------------------------------------------
145: -- |-------------------------< check_activity_reentry >-----------------------|
146: -- ----------------------------------------------------------------------------
147: function check_activity_reentry
148: (p_item_type in wf_items.item_type%type
149: ,p_item_key in wf_items.item_key%type
150: ,p_actid in wf_activity_attr_values.process_activity_id%type)
151: return boolean;
152: -- ----------------------------------------------------------------------------

Line 149: ,p_item_key in wf_items.item_key%type

145: -- |-------------------------< check_activity_reentry >-----------------------|
146: -- ----------------------------------------------------------------------------
147: function check_activity_reentry
148: (p_item_type in wf_items.item_type%type
149: ,p_item_key in wf_items.item_key%type
150: ,p_actid in wf_activity_attr_values.process_activity_id%type)
151: return boolean;
152: -- ----------------------------------------------------------------------------
153: -- |-------------------------< get_activity_reentry_value >-------------------|

Line 156: (p_item_type in wf_items.item_type%type

152: -- ----------------------------------------------------------------------------
153: -- |-------------------------< get_activity_reentry_value >-------------------|
154: -- ----------------------------------------------------------------------------
155: function get_activity_reentry_value
156: (p_item_type in wf_items.item_type%type
157: ,p_item_key in wf_items.item_key%type
158: ,p_actid in wf_activity_attr_values.process_activity_id%type)
159: return wf_item_activity_statuses_v.activity_result_code%type;
160: -- ----------------------------------------------------------------------------

Line 157: ,p_item_key in wf_items.item_key%type

153: -- |-------------------------< get_activity_reentry_value >-------------------|
154: -- ----------------------------------------------------------------------------
155: function get_activity_reentry_value
156: (p_item_type in wf_items.item_type%type
157: ,p_item_key in wf_items.item_key%type
158: ,p_actid in wf_activity_attr_values.process_activity_id%type)
159: return wf_item_activity_statuses_v.activity_result_code%type;
160: -- ----------------------------------------------------------------------------
161: -- |------------------------------< create_process >--------------------------|

Line 168: ,p_item_type in wf_items.item_type%type

164: -- and p_called_from as parameters.
165: -- ----------------------------------------------------------------------------
166: procedure create_process
167: (p_process_name in wf_process_activities.process_name%type
168: ,p_item_type in wf_items.item_type%type
169: ,p_person_id in varchar2 default null
170: ,p_called_from in varchar2 default null
171: ,p_item_attribute in g_varchar2_tab_type
172: default g_varchar2_tab_default

Line 181: (p_item_type in wf_items.item_type%type

177: -- ----------------------------------------------------------------------------
178: -- |---------------------------< continue_process >---------------------------|
179: -- ----------------------------------------------------------------------------
180: procedure continue_process
181: (p_item_type in wf_items.item_type%type
182: ,p_item_key in wf_items.item_key%type);
183: -- ----------------------------------------------------------------------------
184: -- |------------------------< transition_activity >---------------------------|
185: -- ----------------------------------------------------------------------------

Line 182: ,p_item_key in wf_items.item_key%type);

178: -- |---------------------------< continue_process >---------------------------|
179: -- ----------------------------------------------------------------------------
180: procedure continue_process
181: (p_item_type in wf_items.item_type%type
182: ,p_item_key in wf_items.item_key%type);
183: -- ----------------------------------------------------------------------------
184: -- |------------------------< transition_activity >---------------------------|
185: -- ----------------------------------------------------------------------------
186: procedure transition_activity

Line 187: (p_item_type in wf_items.item_type%type

183: -- ----------------------------------------------------------------------------
184: -- |------------------------< transition_activity >---------------------------|
185: -- ----------------------------------------------------------------------------
186: procedure transition_activity
187: (p_item_type in wf_items.item_type%type
188: ,p_item_key in wf_items.item_key%type
189: ,p_actid in wf_activity_attr_values.process_activity_id%type
190: ,p_result_code in wf_item_activity_statuses_v.activity_result_code%type);
191: -- ----------------------------------------------------------------------------

Line 188: ,p_item_key in wf_items.item_key%type

184: -- |------------------------< transition_activity >---------------------------|
185: -- ----------------------------------------------------------------------------
186: procedure transition_activity
187: (p_item_type in wf_items.item_type%type
188: ,p_item_key in wf_items.item_key%type
189: ,p_actid in wf_activity_attr_values.process_activity_id%type
190: ,p_result_code in wf_item_activity_statuses_v.activity_result_code%type);
191: -- ----------------------------------------------------------------------------
192: -- |-------------------------< check_active_wf_items >-- ---------------------|

Line 192: -- |-------------------------< check_active_wf_items >-- ---------------------|

188: ,p_item_key in wf_items.item_key%type
189: ,p_actid in wf_activity_attr_values.process_activity_id%type
190: ,p_result_code in wf_item_activity_statuses_v.activity_result_code%type);
191: -- ----------------------------------------------------------------------------
192: -- |-------------------------< check_active_wf_items >-- ---------------------|
193: -- ----------------------------------------------------------------------------
194: -- Purpose: This function is overloaded. It will only return the pending
195: -- approval workflow items for a section of a page, ie. by
196: -- activity_result_code to a table.

Line 198: function check_active_wf_items

194: -- Purpose: This function is overloaded. It will only return the pending
195: -- approval workflow items for a section of a page, ie. by
196: -- activity_result_code to a table.
197: -- ----------------------------------------------------------------------------
198: function check_active_wf_items
199: (p_item_type in wf_items.item_type%type
200: ,p_process_name in wf_process_activities.process_name%type
201: ,p_current_person_id in per_people_f.person_id%type
202: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type

Line 199: (p_item_type in wf_items.item_type%type

195: -- approval workflow items for a section of a page, ie. by
196: -- activity_result_code to a table.
197: -- ----------------------------------------------------------------------------
198: function check_active_wf_items
199: (p_item_type in wf_items.item_type%type
200: ,p_process_name in wf_process_activities.process_name%type
201: ,p_current_person_id in per_people_f.person_id%type
202: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type
203: ,p_activity_result_code in varchar2

Line 205: return active_wf_items_list;

201: ,p_current_person_id in per_people_f.person_id%type
202: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type
203: ,p_activity_result_code in varchar2
204: )
205: return active_wf_items_list;
206: --
207: --
208: function check_active_wf_items
209: (p_item_type in wf_items.item_type%type

Line 208: function check_active_wf_items

204: )
205: return active_wf_items_list;
206: --
207: --
208: function check_active_wf_items
209: (p_item_type in wf_items.item_type%type
210: ,p_process_name in wf_process_activities.process_name%type
211: ,p_current_person_id in per_people_f.person_id%type
212: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type

Line 209: (p_item_type in wf_items.item_type%type

205: return active_wf_items_list;
206: --
207: --
208: function check_active_wf_items
209: (p_item_type in wf_items.item_type%type
210: ,p_process_name in wf_process_activities.process_name%type
211: ,p_current_person_id in per_people_f.person_id%type
212: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type
213: )

Line 214: return active_wf_items_list;

210: ,p_process_name in wf_process_activities.process_name%type
211: ,p_current_person_id in per_people_f.person_id%type
212: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type
213: )
214: return active_wf_items_list;
215: --
216: -- ----------------------------------------------------------------------------
217: -- |---------------------------< get_active_wf_items >-------------------------|
218: -- ----------------------------------------------------------------------------

Line 217: -- |---------------------------< get_active_wf_items >-------------------------|

213: )
214: return active_wf_items_list;
215: --
216: -- ----------------------------------------------------------------------------
217: -- |---------------------------< get_active_wf_items >-------------------------|
218: -- ----------------------------------------------------------------------------
219: -- Purpose: This function will return all the pending approval workflow items
220: -- for a page for a given item_type, item_key and the api_name. If a
221: -- page has many sections, the caller can pass the result code to

Line 232: FUNCTION get_active_wf_items

228: -- a value of either "PRIMARY" or "SECONDARY" in the parameter
229: -- p_address_context because Primary Address and Secondary Address
230: -- share the same api name, which is hr_process_address_ss.
231: -- ----------------------------------------------------------------------------
232: FUNCTION get_active_wf_items
233: (p_item_type in wf_items.item_type%type
234: ,p_process_name in wf_process_activities.process_name%type
235: ,p_current_person_id in per_people_f.person_id%type
236: ,p_api_name in hr_api_transaction_steps.api_name%type

Line 233: (p_item_type in wf_items.item_type%type

229: -- p_address_context because Primary Address and Secondary Address
230: -- share the same api name, which is hr_process_address_ss.
231: -- ----------------------------------------------------------------------------
232: FUNCTION get_active_wf_items
233: (p_item_type in wf_items.item_type%type
234: ,p_process_name in wf_process_activities.process_name%type
235: ,p_current_person_id in per_people_f.person_id%type
236: ,p_api_name in hr_api_transaction_steps.api_name%type
237: ,p_activity_result_code in varchar2 default null

Line 252: ,p_item_type in wf_items.item_type%type

248: ,resultout out nocopy varchar2);
249: --
250: /*procedure start_cleanup_process
251: (p_process_name in wf_process_activities.process_name%type
252: ,p_item_type in wf_items.item_type%type
253: );
254: */
255:
256: procedure start_cleanup_process(

Line 257: p_item_type in wf_items.item_type%type

253: );
254: */
255:
256: procedure start_cleanup_process(
257: p_item_type in wf_items.item_type%type
258: ,p_transaction_age in wf_item_attribute_values.number_value%type
259: ,p_process_name in wf_process_activities.process_name%type default 'HR_BACKGROUND_CLEANUP_PRC',
260: p_transaction_status in varchar2 default 'ALL'
261: ) ;

Line 300: return wf_items.item_type%type;

296: transaction_status in varchar2 default 'ALL');
297:
298: --
299: function getItemType(p_transaction_id in hr_api_transactions.transaction_id%type)
300: return wf_items.item_type%type;
301:
302: function getItemKey(p_transaction_id in hr_api_transactions.transaction_id%type)
303: return wf_items.item_key%type;
304:

Line 303: return wf_items.item_key%type;

299: function getItemType(p_transaction_id in hr_api_transactions.transaction_id%type)
300: return wf_items.item_type%type;
301:
302: function getItemKey(p_transaction_id in hr_api_transactions.transaction_id%type)
303: return wf_items.item_key%type;
304:
305: function item_attribute_exists
306: (p_item_type in wf_items.item_type%type
307: ,p_item_key in wf_items.item_key%type

Line 306: (p_item_type in wf_items.item_type%type

302: function getItemKey(p_transaction_id in hr_api_transactions.transaction_id%type)
303: return wf_items.item_key%type;
304:
305: function item_attribute_exists
306: (p_item_type in wf_items.item_type%type
307: ,p_item_key in wf_items.item_key%type
308: ,p_name in wf_item_attribute_values.name%type)
309: return boolean;
310:

Line 307: ,p_item_key in wf_items.item_key%type

303: return wf_items.item_key%type;
304:
305: function item_attribute_exists
306: (p_item_type in wf_items.item_type%type
307: ,p_item_key in wf_items.item_key%type
308: ,p_name in wf_item_attribute_values.name%type)
309: return boolean;
310:
311: END hr_workflow_service;