DBA Data[Home] [Help]

APPS.PAY_DATED_TABLES_API dependencies on HR_API

Line 63: when hr_api.cannot_find_prog_unit then

59: ,p_dyn_trigger_package_name => p_dyn_trigger_package_name
60: ,p_dyn_trig_pkg_generated => p_dyn_trig_pkg_generated
61: );
62: exception
63: when hr_api.cannot_find_prog_unit then
64: hr_api.cannot_find_prog_unit_error
65: (p_module_name => 'CREATE_DATED_TABLE',
66: p_hook_type => 'BP'
67: );

Line 64: hr_api.cannot_find_prog_unit_error

60: ,p_dyn_trig_pkg_generated => p_dyn_trig_pkg_generated
61: );
62: exception
63: when hr_api.cannot_find_prog_unit then
64: hr_api.cannot_find_prog_unit_error
65: (p_module_name => 'CREATE_DATED_TABLE',
66: p_hook_type => 'BP'
67: );
68: end;

Line 103: when hr_api.cannot_find_prog_unit then

99: ,p_dyn_trigger_package_name => p_dyn_trigger_package_name
100: ,p_dyn_trig_pkg_generated => p_dyn_trig_pkg_generated
101: );
102: exception
103: when hr_api.cannot_find_prog_unit then
104: hr_api.cannot_find_prog_unit_error
105: (p_module_name => 'CREATE_DATED_TABLE',
106: p_hook_type => 'AP'
107: );

Line 104: hr_api.cannot_find_prog_unit_error

100: ,p_dyn_trig_pkg_generated => p_dyn_trig_pkg_generated
101: );
102: exception
103: when hr_api.cannot_find_prog_unit then
104: hr_api.cannot_find_prog_unit_error
105: (p_module_name => 'CREATE_DATED_TABLE',
106: p_hook_type => 'AP'
107: );
108: end;

Line 111: Raise HR_Api.Validate_Enabled;

107: );
108: end;
109: --
110: If p_validate then
111: Raise HR_Api.Validate_Enabled;
112: End If;
113: --
114: exception
115: --

Line 116: when HR_Api.Validate_Enabled then

112: End If;
113: --
114: exception
115: --
116: when HR_Api.Validate_Enabled then
117: --
118: -- A validation or unexpected error has occured
119: --
120: ROLLBACK TO create_dated_table;

Line 144: ,p_table_name in varchar2 default hr_api.g_varchar2

140: procedure update_dated_table
141: (p_validate in boolean default false
142: ,p_dated_table_id in number
143: ,p_object_version_number in out nocopy number
144: ,p_table_name in varchar2 default hr_api.g_varchar2
145: ,p_application_id in number default hr_api.g_number
146: ,p_surrogate_key_name in varchar2 default hr_api.g_varchar2
147: ,p_start_date_name in varchar2 default hr_api.g_varchar2
148: ,p_end_date_name in varchar2 default hr_api.g_varchar2

Line 145: ,p_application_id in number default hr_api.g_number

141: (p_validate in boolean default false
142: ,p_dated_table_id in number
143: ,p_object_version_number in out nocopy number
144: ,p_table_name in varchar2 default hr_api.g_varchar2
145: ,p_application_id in number default hr_api.g_number
146: ,p_surrogate_key_name in varchar2 default hr_api.g_varchar2
147: ,p_start_date_name in varchar2 default hr_api.g_varchar2
148: ,p_end_date_name in varchar2 default hr_api.g_varchar2
149: ,p_business_group_id in number default hr_api.g_number

Line 146: ,p_surrogate_key_name in varchar2 default hr_api.g_varchar2

142: ,p_dated_table_id in number
143: ,p_object_version_number in out nocopy number
144: ,p_table_name in varchar2 default hr_api.g_varchar2
145: ,p_application_id in number default hr_api.g_number
146: ,p_surrogate_key_name in varchar2 default hr_api.g_varchar2
147: ,p_start_date_name in varchar2 default hr_api.g_varchar2
148: ,p_end_date_name in varchar2 default hr_api.g_varchar2
149: ,p_business_group_id in number default hr_api.g_number
150: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 147: ,p_start_date_name in varchar2 default hr_api.g_varchar2

143: ,p_object_version_number in out nocopy number
144: ,p_table_name in varchar2 default hr_api.g_varchar2
145: ,p_application_id in number default hr_api.g_number
146: ,p_surrogate_key_name in varchar2 default hr_api.g_varchar2
147: ,p_start_date_name in varchar2 default hr_api.g_varchar2
148: ,p_end_date_name in varchar2 default hr_api.g_varchar2
149: ,p_business_group_id in number default hr_api.g_number
150: ,p_legislation_code in varchar2 default hr_api.g_varchar2
151: ,p_dyn_trigger_type in varchar2 default hr_api.g_varchar2

Line 148: ,p_end_date_name in varchar2 default hr_api.g_varchar2

144: ,p_table_name in varchar2 default hr_api.g_varchar2
145: ,p_application_id in number default hr_api.g_number
146: ,p_surrogate_key_name in varchar2 default hr_api.g_varchar2
147: ,p_start_date_name in varchar2 default hr_api.g_varchar2
148: ,p_end_date_name in varchar2 default hr_api.g_varchar2
149: ,p_business_group_id in number default hr_api.g_number
150: ,p_legislation_code in varchar2 default hr_api.g_varchar2
151: ,p_dyn_trigger_type in varchar2 default hr_api.g_varchar2
152: ,p_dyn_trigger_package_name in varchar2 default hr_api.g_varchar2

Line 149: ,p_business_group_id in number default hr_api.g_number

145: ,p_application_id in number default hr_api.g_number
146: ,p_surrogate_key_name in varchar2 default hr_api.g_varchar2
147: ,p_start_date_name in varchar2 default hr_api.g_varchar2
148: ,p_end_date_name in varchar2 default hr_api.g_varchar2
149: ,p_business_group_id in number default hr_api.g_number
150: ,p_legislation_code in varchar2 default hr_api.g_varchar2
151: ,p_dyn_trigger_type in varchar2 default hr_api.g_varchar2
152: ,p_dyn_trigger_package_name in varchar2 default hr_api.g_varchar2
153: ,p_dyn_trig_pkg_generated in varchar2 default hr_api.g_varchar2

Line 150: ,p_legislation_code in varchar2 default hr_api.g_varchar2

146: ,p_surrogate_key_name in varchar2 default hr_api.g_varchar2
147: ,p_start_date_name in varchar2 default hr_api.g_varchar2
148: ,p_end_date_name in varchar2 default hr_api.g_varchar2
149: ,p_business_group_id in number default hr_api.g_number
150: ,p_legislation_code in varchar2 default hr_api.g_varchar2
151: ,p_dyn_trigger_type in varchar2 default hr_api.g_varchar2
152: ,p_dyn_trigger_package_name in varchar2 default hr_api.g_varchar2
153: ,p_dyn_trig_pkg_generated in varchar2 default hr_api.g_varchar2
154: )is

Line 151: ,p_dyn_trigger_type in varchar2 default hr_api.g_varchar2

147: ,p_start_date_name in varchar2 default hr_api.g_varchar2
148: ,p_end_date_name in varchar2 default hr_api.g_varchar2
149: ,p_business_group_id in number default hr_api.g_number
150: ,p_legislation_code in varchar2 default hr_api.g_varchar2
151: ,p_dyn_trigger_type in varchar2 default hr_api.g_varchar2
152: ,p_dyn_trigger_package_name in varchar2 default hr_api.g_varchar2
153: ,p_dyn_trig_pkg_generated in varchar2 default hr_api.g_varchar2
154: )is
155: --

Line 152: ,p_dyn_trigger_package_name in varchar2 default hr_api.g_varchar2

148: ,p_end_date_name in varchar2 default hr_api.g_varchar2
149: ,p_business_group_id in number default hr_api.g_number
150: ,p_legislation_code in varchar2 default hr_api.g_varchar2
151: ,p_dyn_trigger_type in varchar2 default hr_api.g_varchar2
152: ,p_dyn_trigger_package_name in varchar2 default hr_api.g_varchar2
153: ,p_dyn_trig_pkg_generated in varchar2 default hr_api.g_varchar2
154: )is
155: --
156: -- Declare cursors and local variables

Line 153: ,p_dyn_trig_pkg_generated in varchar2 default hr_api.g_varchar2

149: ,p_business_group_id in number default hr_api.g_number
150: ,p_legislation_code in varchar2 default hr_api.g_varchar2
151: ,p_dyn_trigger_type in varchar2 default hr_api.g_varchar2
152: ,p_dyn_trigger_package_name in varchar2 default hr_api.g_varchar2
153: ,p_dyn_trig_pkg_generated in varchar2 default hr_api.g_varchar2
154: )is
155: --
156: -- Declare cursors and local variables
157: --

Line 190: when hr_api.cannot_find_prog_unit then

186: ,p_dyn_trigger_package_name => p_dyn_trigger_package_name
187: ,p_dyn_trig_pkg_generated => p_dyn_trig_pkg_generated
188: );
189: exception
190: when hr_api.cannot_find_prog_unit then
191: hr_api.cannot_find_prog_unit_error
192: (p_module_name => 'UPDATE_DATED_TABLE',
193: p_hook_type => 'BP'
194: );

Line 191: hr_api.cannot_find_prog_unit_error

187: ,p_dyn_trig_pkg_generated => p_dyn_trig_pkg_generated
188: );
189: exception
190: when hr_api.cannot_find_prog_unit then
191: hr_api.cannot_find_prog_unit_error
192: (p_module_name => 'UPDATE_DATED_TABLE',
193: p_hook_type => 'BP'
194: );
195: end;

Line 234: when hr_api.cannot_find_prog_unit then

230: ,p_dyn_trigger_package_name => p_dyn_trigger_package_name
231: ,p_dyn_trig_pkg_generated => p_dyn_trig_pkg_generated
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_DATED_TABLE',
237: p_hook_type => 'AP'
238: );

Line 235: hr_api.cannot_find_prog_unit_error

231: ,p_dyn_trig_pkg_generated => p_dyn_trig_pkg_generated
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_DATED_TABLE',
237: p_hook_type => 'AP'
238: );
239: end;

Line 244: Raise HR_Api.Validate_Enabled;

240: --
241: -- End of API User Hook for the after hook of update_DATED_TABLE.
242: --
243: If p_validate then
244: Raise HR_Api.Validate_Enabled;
245: End If;
246: --
247: exception
248: --

Line 249: when HR_Api.Validate_Enabled then

245: End If;
246: --
247: exception
248: --
249: when HR_Api.Validate_Enabled then
250: --
251: -- A validation or unexpected error has occured
252: --
253: ROLLBACK TO update_dated_table;

Line 302: when hr_api.cannot_find_prog_unit then

298: p_dated_table_id => p_dated_table_id
299: ,p_object_version_number => l_object_version_number
300: );
301: exception
302: when hr_api.cannot_find_prog_unit then
303: hr_api.cannot_find_prog_unit_error
304: (p_module_name => 'DELETE_DATED_TABLE',
305: p_hook_type => 'BP'
306: );

Line 303: hr_api.cannot_find_prog_unit_error

299: ,p_object_version_number => l_object_version_number
300: );
301: exception
302: when hr_api.cannot_find_prog_unit then
303: hr_api.cannot_find_prog_unit_error
304: (p_module_name => 'DELETE_DATED_TABLE',
305: p_hook_type => 'BP'
306: );
307: end;

Line 326: when hr_api.cannot_find_prog_unit then

322: p_dated_table_id => p_dated_table_id
323: ,p_object_version_number => l_object_version_number
324: );
325: exception
326: when hr_api.cannot_find_prog_unit then
327: hr_api.cannot_find_prog_unit_error
328: (p_module_name => 'DELETE_DATED_TABLE',
329: p_hook_type => 'AP'
330: );

Line 327: hr_api.cannot_find_prog_unit_error

323: ,p_object_version_number => l_object_version_number
324: );
325: exception
326: when hr_api.cannot_find_prog_unit then
327: hr_api.cannot_find_prog_unit_error
328: (p_module_name => 'DELETE_DATED_TABLE',
329: p_hook_type => 'AP'
330: );
331: end;

Line 335: Raise HR_Api.Validate_Enabled;

331: end;
332: --
333:
334: If p_validate then
335: Raise HR_Api.Validate_Enabled;
336: End If;
337: --
338: exception
339: when HR_Api.Validate_Enabled then

Line 339: when HR_Api.Validate_Enabled then

335: Raise HR_Api.Validate_Enabled;
336: End If;
337: --
338: exception
339: when HR_Api.Validate_Enabled then
340: --
341: -- A validation or unexpected error has occured
342: --
343: ROLLBACK TO delete_dated_table;