DBA Data[Home] [Help]

APPS.PQH_SPECIAL_ATTRIBUTES_API dependencies on HR_API

Line 62: when hr_api.cannot_find_prog_unit then

58: ,p_context => p_context
59: ,p_effective_date => trunc(p_effective_date)
60: );
61: exception
62: when hr_api.cannot_find_prog_unit then
63: hr_api.cannot_find_prog_unit_error
64: (
65: p_module_name => 'create_special_attribute'
66: ,p_hook_type => 'BP'

Line 63: hr_api.cannot_find_prog_unit_error

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

Line 107: when hr_api.cannot_find_prog_unit then

103: ,p_context => p_context
104: ,p_effective_date => trunc(p_effective_date)
105: );
106: exception
107: when hr_api.cannot_find_prog_unit then
108: hr_api.cannot_find_prog_unit_error
109: (p_module_name => 'create_special_attribute'
110: ,p_hook_type => 'AP'
111: );

Line 108: hr_api.cannot_find_prog_unit_error

104: ,p_effective_date => trunc(p_effective_date)
105: );
106: exception
107: when hr_api.cannot_find_prog_unit then
108: hr_api.cannot_find_prog_unit_error
109: (p_module_name => 'create_special_attribute'
110: ,p_hook_type => 'AP'
111: );
112: --

Line 122: raise hr_api.validate_enabled;

118: --
119: -- When in validation only mode raise the Validate_Enabled exception
120: --
121: if p_validate then
122: raise hr_api.validate_enabled;
123: end if;
124: --
125: -- Set all output arguments
126: --

Line 134: when hr_api.validate_enabled then

130: hr_utility.set_location(' Leaving:'||l_proc, 70);
131: --
132: exception
133: --
134: when hr_api.validate_enabled then
135: --
136: -- As the Validate_Enabled exception has been raised
137: -- we must rollback to the savepoint
138: --

Line 166: ,p_txn_category_attribute_id in number default hr_api.g_number

162: --
163: procedure update_special_attribute
164: (p_validate in boolean default false
165: ,p_special_attribute_id in number
166: ,p_txn_category_attribute_id in number default hr_api.g_number
167: ,p_attribute_type_cd in varchar2 default hr_api.g_varchar2
168: ,p_key_attribute_type in varchar2 default hr_api.g_varchar2
169: ,p_enable_flag in varchar2 default hr_api.g_varchar2
170: ,p_flex_code in varchar2 default hr_api.g_varchar2

Line 167: ,p_attribute_type_cd in varchar2 default hr_api.g_varchar2

163: procedure update_special_attribute
164: (p_validate in boolean default false
165: ,p_special_attribute_id in number
166: ,p_txn_category_attribute_id in number default hr_api.g_number
167: ,p_attribute_type_cd in varchar2 default hr_api.g_varchar2
168: ,p_key_attribute_type in varchar2 default hr_api.g_varchar2
169: ,p_enable_flag in varchar2 default hr_api.g_varchar2
170: ,p_flex_code in varchar2 default hr_api.g_varchar2
171: ,p_object_version_number in out nocopy number

Line 168: ,p_key_attribute_type in varchar2 default hr_api.g_varchar2

164: (p_validate in boolean default false
165: ,p_special_attribute_id in number
166: ,p_txn_category_attribute_id in number default hr_api.g_number
167: ,p_attribute_type_cd in varchar2 default hr_api.g_varchar2
168: ,p_key_attribute_type in varchar2 default hr_api.g_varchar2
169: ,p_enable_flag in varchar2 default hr_api.g_varchar2
170: ,p_flex_code in varchar2 default hr_api.g_varchar2
171: ,p_object_version_number in out nocopy number
172: ,p_ddf_column_name in varchar2 default hr_api.g_varchar2

Line 169: ,p_enable_flag in varchar2 default hr_api.g_varchar2

165: ,p_special_attribute_id in number
166: ,p_txn_category_attribute_id in number default hr_api.g_number
167: ,p_attribute_type_cd in varchar2 default hr_api.g_varchar2
168: ,p_key_attribute_type in varchar2 default hr_api.g_varchar2
169: ,p_enable_flag in varchar2 default hr_api.g_varchar2
170: ,p_flex_code in varchar2 default hr_api.g_varchar2
171: ,p_object_version_number in out nocopy number
172: ,p_ddf_column_name in varchar2 default hr_api.g_varchar2
173: ,p_ddf_value_column_name in varchar2 default hr_api.g_varchar2

Line 170: ,p_flex_code in varchar2 default hr_api.g_varchar2

166: ,p_txn_category_attribute_id in number default hr_api.g_number
167: ,p_attribute_type_cd in varchar2 default hr_api.g_varchar2
168: ,p_key_attribute_type in varchar2 default hr_api.g_varchar2
169: ,p_enable_flag in varchar2 default hr_api.g_varchar2
170: ,p_flex_code in varchar2 default hr_api.g_varchar2
171: ,p_object_version_number in out nocopy number
172: ,p_ddf_column_name in varchar2 default hr_api.g_varchar2
173: ,p_ddf_value_column_name in varchar2 default hr_api.g_varchar2
174: ,p_context in varchar2 default hr_api.g_varchar2

Line 172: ,p_ddf_column_name in varchar2 default hr_api.g_varchar2

168: ,p_key_attribute_type in varchar2 default hr_api.g_varchar2
169: ,p_enable_flag in varchar2 default hr_api.g_varchar2
170: ,p_flex_code in varchar2 default hr_api.g_varchar2
171: ,p_object_version_number in out nocopy number
172: ,p_ddf_column_name in varchar2 default hr_api.g_varchar2
173: ,p_ddf_value_column_name in varchar2 default hr_api.g_varchar2
174: ,p_context in varchar2 default hr_api.g_varchar2
175: ,p_effective_date in date
176: ) is

Line 173: ,p_ddf_value_column_name in varchar2 default hr_api.g_varchar2

169: ,p_enable_flag in varchar2 default hr_api.g_varchar2
170: ,p_flex_code in varchar2 default hr_api.g_varchar2
171: ,p_object_version_number in out nocopy number
172: ,p_ddf_column_name in varchar2 default hr_api.g_varchar2
173: ,p_ddf_value_column_name in varchar2 default hr_api.g_varchar2
174: ,p_context in varchar2 default hr_api.g_varchar2
175: ,p_effective_date in date
176: ) is
177: --

Line 174: ,p_context in varchar2 default hr_api.g_varchar2

170: ,p_flex_code in varchar2 default hr_api.g_varchar2
171: ,p_object_version_number in out nocopy number
172: ,p_ddf_column_name in varchar2 default hr_api.g_varchar2
173: ,p_ddf_value_column_name in varchar2 default hr_api.g_varchar2
174: ,p_context in varchar2 default hr_api.g_varchar2
175: ,p_effective_date in date
176: ) is
177: --
178: -- Declare cursors and local variables

Line 216: when hr_api.cannot_find_prog_unit then

212: ,p_context => p_context
213: ,p_effective_date => trunc(p_effective_date)
214: );
215: exception
216: when hr_api.cannot_find_prog_unit then
217: hr_api.cannot_find_prog_unit_error
218: (p_module_name => 'update_special_attribute'
219: ,p_hook_type => 'BP'
220: );

Line 217: hr_api.cannot_find_prog_unit_error

213: ,p_effective_date => trunc(p_effective_date)
214: );
215: exception
216: when hr_api.cannot_find_prog_unit then
217: hr_api.cannot_find_prog_unit_error
218: (p_module_name => 'update_special_attribute'
219: ,p_hook_type => 'BP'
220: );
221: --

Line 260: when hr_api.cannot_find_prog_unit then

256: ,p_context => p_context
257: ,p_effective_date => trunc(p_effective_date)
258: );
259: exception
260: when hr_api.cannot_find_prog_unit then
261: hr_api.cannot_find_prog_unit_error
262: (p_module_name => 'update_special_attribute'
263: ,p_hook_type => 'AP'
264: );

Line 261: hr_api.cannot_find_prog_unit_error

257: ,p_effective_date => trunc(p_effective_date)
258: );
259: exception
260: when hr_api.cannot_find_prog_unit then
261: hr_api.cannot_find_prog_unit_error
262: (p_module_name => 'update_special_attribute'
263: ,p_hook_type => 'AP'
264: );
265: --

Line 275: raise hr_api.validate_enabled;

271: --
272: -- When in validation only mode raise the Validate_Enabled exception
273: --
274: if p_validate then
275: raise hr_api.validate_enabled;
276: end if;
277: --
278: -- Set all output arguments
279: --

Line 286: when hr_api.validate_enabled then

282: hr_utility.set_location(' Leaving:'||l_proc, 70);
283: --
284: exception
285: --
286: when hr_api.validate_enabled then
287: --
288: -- As the Validate_Enabled exception has been raised
289: -- we must rollback to the savepoint
290: --

Line 350: when hr_api.cannot_find_prog_unit then

346: ,p_object_version_number => p_object_version_number
347: ,p_effective_date => trunc(p_effective_date)
348: );
349: exception
350: when hr_api.cannot_find_prog_unit then
351: hr_api.cannot_find_prog_unit_error
352: (p_module_name => 'delete_special_attribute'
353: ,p_hook_type => 'BP'
354: );

Line 351: hr_api.cannot_find_prog_unit_error

347: ,p_effective_date => trunc(p_effective_date)
348: );
349: exception
350: when hr_api.cannot_find_prog_unit then
351: hr_api.cannot_find_prog_unit_error
352: (p_module_name => 'delete_special_attribute'
353: ,p_hook_type => 'BP'
354: );
355: --

Line 378: when hr_api.cannot_find_prog_unit then

374: ,p_object_version_number => l_object_version_number
375: ,p_effective_date => trunc(p_effective_date)
376: );
377: exception
378: when hr_api.cannot_find_prog_unit then
379: hr_api.cannot_find_prog_unit_error
380: (p_module_name => 'delete_special_attribute'
381: ,p_hook_type => 'AP'
382: );

Line 379: hr_api.cannot_find_prog_unit_error

375: ,p_effective_date => trunc(p_effective_date)
376: );
377: exception
378: when hr_api.cannot_find_prog_unit then
379: hr_api.cannot_find_prog_unit_error
380: (p_module_name => 'delete_special_attribute'
381: ,p_hook_type => 'AP'
382: );
383: --

Line 393: raise hr_api.validate_enabled;

389: --
390: -- When in validation only mode raise the Validate_Enabled exception
391: --
392: if p_validate then
393: raise hr_api.validate_enabled;
394: end if;
395: --
396: hr_utility.set_location(' Leaving:'||l_proc, 70);
397: --

Line 400: when hr_api.validate_enabled then

396: hr_utility.set_location(' Leaving:'||l_proc, 70);
397: --
398: exception
399: --
400: when hr_api.validate_enabled then
401: --
402: -- As the Validate_Enabled exception has been raised
403: -- we must rollback to the savepoint
404: --