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.PQH_WORKSHEETS_API dependencies on HR_API

Line 68: when hr_api.cannot_find_prog_unit then

64: ,p_effective_date => trunc(p_effective_date)
65: ,p_wf_transaction_category_id => p_wf_transaction_category_id
66: );
67: exception
68: when hr_api.cannot_find_prog_unit then
69: hr_api.cannot_find_prog_unit_error
70: (
71: p_module_name => 'CREATE_WORKSHEET'
72: ,p_hook_type => 'BP'

Line 69: hr_api.cannot_find_prog_unit_error

65: ,p_wf_transaction_category_id => p_wf_transaction_category_id
66: );
67: exception
68: when hr_api.cannot_find_prog_unit then
69: hr_api.cannot_find_prog_unit_error
70: (
71: p_module_name => 'CREATE_WORKSHEET'
72: ,p_hook_type => 'BP'
73: );

Line 119: when hr_api.cannot_find_prog_unit then

115: ,p_effective_date => trunc(p_effective_date)
116: ,p_wf_transaction_category_id => p_wf_transaction_category_id
117: );
118: exception
119: when hr_api.cannot_find_prog_unit then
120: hr_api.cannot_find_prog_unit_error
121: (p_module_name => 'CREATE_WORKSHEET'
122: ,p_hook_type => 'AP'
123: );

Line 120: hr_api.cannot_find_prog_unit_error

116: ,p_wf_transaction_category_id => p_wf_transaction_category_id
117: );
118: exception
119: when hr_api.cannot_find_prog_unit then
120: hr_api.cannot_find_prog_unit_error
121: (p_module_name => 'CREATE_WORKSHEET'
122: ,p_hook_type => 'AP'
123: );
124: --

Line 134: raise hr_api.validate_enabled;

130: --
131: -- When in validation only mode raise the Validate_Enabled exception
132: --
133: if p_validate then
134: raise hr_api.validate_enabled;
135: end if;
136: --
137: -- Set all output arguments
138: --

Line 146: when hr_api.validate_enabled then

142: hr_utility.set_location(' Leaving:'||l_proc, 70);
143: --
144: exception
145: --
146: when hr_api.validate_enabled then
147: --
148: -- As the Validate_Enabled exception has been raised
149: -- we must rollback to the savepoint
150: --

Line 178: ,p_budget_id in number default hr_api.g_number

174: --
175: procedure update_WORKSHEET
176: (p_validate in boolean default false
177: ,p_worksheet_id in number
178: ,p_budget_id in number default hr_api.g_number
179: ,p_worksheet_name in varchar2 default hr_api.g_varchar2
180: ,p_version_number in number default hr_api.g_number
181: ,p_action_date in date default hr_api.g_date
182: ,p_date_from in date default hr_api.g_date

Line 179: ,p_worksheet_name in varchar2 default hr_api.g_varchar2

175: procedure update_WORKSHEET
176: (p_validate in boolean default false
177: ,p_worksheet_id in number
178: ,p_budget_id in number default hr_api.g_number
179: ,p_worksheet_name in varchar2 default hr_api.g_varchar2
180: ,p_version_number in number default hr_api.g_number
181: ,p_action_date in date default hr_api.g_date
182: ,p_date_from in date default hr_api.g_date
183: ,p_date_to in date default hr_api.g_date

Line 180: ,p_version_number in number default hr_api.g_number

176: (p_validate in boolean default false
177: ,p_worksheet_id in number
178: ,p_budget_id in number default hr_api.g_number
179: ,p_worksheet_name in varchar2 default hr_api.g_varchar2
180: ,p_version_number in number default hr_api.g_number
181: ,p_action_date in date default hr_api.g_date
182: ,p_date_from in date default hr_api.g_date
183: ,p_date_to in date default hr_api.g_date
184: ,p_worksheet_mode_cd in varchar2 default hr_api.g_varchar2

Line 181: ,p_action_date in date default hr_api.g_date

177: ,p_worksheet_id in number
178: ,p_budget_id in number default hr_api.g_number
179: ,p_worksheet_name in varchar2 default hr_api.g_varchar2
180: ,p_version_number in number default hr_api.g_number
181: ,p_action_date in date default hr_api.g_date
182: ,p_date_from in date default hr_api.g_date
183: ,p_date_to in date default hr_api.g_date
184: ,p_worksheet_mode_cd in varchar2 default hr_api.g_varchar2
185: ,p_transaction_status in varchar2 default hr_api.g_varchar2

Line 182: ,p_date_from in date default hr_api.g_date

178: ,p_budget_id in number default hr_api.g_number
179: ,p_worksheet_name in varchar2 default hr_api.g_varchar2
180: ,p_version_number in number default hr_api.g_number
181: ,p_action_date in date default hr_api.g_date
182: ,p_date_from in date default hr_api.g_date
183: ,p_date_to in date default hr_api.g_date
184: ,p_worksheet_mode_cd in varchar2 default hr_api.g_varchar2
185: ,p_transaction_status in varchar2 default hr_api.g_varchar2
186: ,p_object_version_number in out nocopy number

Line 183: ,p_date_to in date default hr_api.g_date

179: ,p_worksheet_name in varchar2 default hr_api.g_varchar2
180: ,p_version_number in number default hr_api.g_number
181: ,p_action_date in date default hr_api.g_date
182: ,p_date_from in date default hr_api.g_date
183: ,p_date_to in date default hr_api.g_date
184: ,p_worksheet_mode_cd in varchar2 default hr_api.g_varchar2
185: ,p_transaction_status in varchar2 default hr_api.g_varchar2
186: ,p_object_version_number in out nocopy number
187: ,p_budget_version_id in number default hr_api.g_number

Line 184: ,p_worksheet_mode_cd in varchar2 default hr_api.g_varchar2

180: ,p_version_number in number default hr_api.g_number
181: ,p_action_date in date default hr_api.g_date
182: ,p_date_from in date default hr_api.g_date
183: ,p_date_to in date default hr_api.g_date
184: ,p_worksheet_mode_cd in varchar2 default hr_api.g_varchar2
185: ,p_transaction_status in varchar2 default hr_api.g_varchar2
186: ,p_object_version_number in out nocopy number
187: ,p_budget_version_id in number default hr_api.g_number
188: ,p_propagation_method in varchar2 default hr_api.g_varchar2

Line 185: ,p_transaction_status in varchar2 default hr_api.g_varchar2

181: ,p_action_date in date default hr_api.g_date
182: ,p_date_from in date default hr_api.g_date
183: ,p_date_to in date default hr_api.g_date
184: ,p_worksheet_mode_cd in varchar2 default hr_api.g_varchar2
185: ,p_transaction_status in varchar2 default hr_api.g_varchar2
186: ,p_object_version_number in out nocopy number
187: ,p_budget_version_id in number default hr_api.g_number
188: ,p_propagation_method in varchar2 default hr_api.g_varchar2
189: ,p_effective_date in date

Line 187: ,p_budget_version_id in number default hr_api.g_number

183: ,p_date_to in date default hr_api.g_date
184: ,p_worksheet_mode_cd in varchar2 default hr_api.g_varchar2
185: ,p_transaction_status in varchar2 default hr_api.g_varchar2
186: ,p_object_version_number in out nocopy number
187: ,p_budget_version_id in number default hr_api.g_number
188: ,p_propagation_method in varchar2 default hr_api.g_varchar2
189: ,p_effective_date in date
190: ,p_wf_transaction_category_id in number default hr_api.g_number
191: ) is

Line 188: ,p_propagation_method in varchar2 default hr_api.g_varchar2

184: ,p_worksheet_mode_cd in varchar2 default hr_api.g_varchar2
185: ,p_transaction_status in varchar2 default hr_api.g_varchar2
186: ,p_object_version_number in out nocopy number
187: ,p_budget_version_id in number default hr_api.g_number
188: ,p_propagation_method in varchar2 default hr_api.g_varchar2
189: ,p_effective_date in date
190: ,p_wf_transaction_category_id in number default hr_api.g_number
191: ) is
192: --

Line 190: ,p_wf_transaction_category_id in number default hr_api.g_number

186: ,p_object_version_number in out nocopy number
187: ,p_budget_version_id in number default hr_api.g_number
188: ,p_propagation_method in varchar2 default hr_api.g_varchar2
189: ,p_effective_date in date
190: ,p_wf_transaction_category_id in number default hr_api.g_number
191: ) is
192: --
193: -- Declare cursors and local variables
194: --

Line 234: when hr_api.cannot_find_prog_unit then

230: ,p_effective_date => trunc(p_effective_date)
231: ,p_wf_transaction_category_id => p_wf_transaction_category_id
232: );
233: exception
234: when hr_api.cannot_find_prog_unit then
235: hr_api.cannot_find_prog_unit_error
236: (p_module_name => 'UPDATE_WORKSHEET'
237: ,p_hook_type => 'BP'
238: );

Line 235: hr_api.cannot_find_prog_unit_error

231: ,p_wf_transaction_category_id => p_wf_transaction_category_id
232: );
233: exception
234: when hr_api.cannot_find_prog_unit then
235: hr_api.cannot_find_prog_unit_error
236: (p_module_name => 'UPDATE_WORKSHEET'
237: ,p_hook_type => 'BP'
238: );
239: --

Line 284: when hr_api.cannot_find_prog_unit then

280: ,p_effective_date => trunc(p_effective_date)
281: ,p_wf_transaction_category_id => p_wf_transaction_category_id
282: );
283: exception
284: when hr_api.cannot_find_prog_unit then
285: hr_api.cannot_find_prog_unit_error
286: (p_module_name => 'UPDATE_WORKSHEET'
287: ,p_hook_type => 'AP'
288: );

Line 285: hr_api.cannot_find_prog_unit_error

281: ,p_wf_transaction_category_id => p_wf_transaction_category_id
282: );
283: exception
284: when hr_api.cannot_find_prog_unit then
285: hr_api.cannot_find_prog_unit_error
286: (p_module_name => 'UPDATE_WORKSHEET'
287: ,p_hook_type => 'AP'
288: );
289: --

Line 299: raise hr_api.validate_enabled;

295: --
296: -- When in validation only mode raise the Validate_Enabled exception
297: --
298: if p_validate then
299: raise hr_api.validate_enabled;
300: end if;
301: --
302: -- Set all output arguments
303: --

Line 310: when hr_api.validate_enabled then

306: hr_utility.set_location(' Leaving:'||l_proc, 70);
307: --
308: exception
309: --
310: when hr_api.validate_enabled then
311: --
312: -- As the Validate_Enabled exception has been raised
313: -- we must rollback to the savepoint
314: --

Line 374: when hr_api.cannot_find_prog_unit then

370: ,p_object_version_number => p_object_version_number
371: ,p_effective_date => trunc(p_effective_date)
372: );
373: exception
374: when hr_api.cannot_find_prog_unit then
375: hr_api.cannot_find_prog_unit_error
376: (p_module_name => 'DELETE_WORKSHEET'
377: ,p_hook_type => 'BP'
378: );

Line 375: hr_api.cannot_find_prog_unit_error

371: ,p_effective_date => trunc(p_effective_date)
372: );
373: exception
374: when hr_api.cannot_find_prog_unit then
375: hr_api.cannot_find_prog_unit_error
376: (p_module_name => 'DELETE_WORKSHEET'
377: ,p_hook_type => 'BP'
378: );
379: --

Line 402: when hr_api.cannot_find_prog_unit then

398: ,p_object_version_number => l_object_version_number
399: ,p_effective_date => trunc(p_effective_date)
400: );
401: exception
402: when hr_api.cannot_find_prog_unit then
403: hr_api.cannot_find_prog_unit_error
404: (p_module_name => 'DELETE_WORKSHEET'
405: ,p_hook_type => 'AP'
406: );

Line 403: hr_api.cannot_find_prog_unit_error

399: ,p_effective_date => trunc(p_effective_date)
400: );
401: exception
402: when hr_api.cannot_find_prog_unit then
403: hr_api.cannot_find_prog_unit_error
404: (p_module_name => 'DELETE_WORKSHEET'
405: ,p_hook_type => 'AP'
406: );
407: --

Line 417: raise hr_api.validate_enabled;

413: --
414: -- When in validation only mode raise the Validate_Enabled exception
415: --
416: if p_validate then
417: raise hr_api.validate_enabled;
418: end if;
419: --
420: hr_utility.set_location(' Leaving:'||l_proc, 70);
421: --

Line 424: when hr_api.validate_enabled then

420: hr_utility.set_location(' Leaving:'||l_proc, 70);
421: --
422: exception
423: --
424: when hr_api.validate_enabled then
425: --
426: -- As the Validate_Enabled exception has been raised
427: -- we must rollback to the savepoint
428: --