APPS.PQH_SAT_UPD dependencies on HR_API

Line 83: When hr_api.check_integrity_violated Then

79: --
80: hr_utility.set_location(' Leaving:'||l_proc, 10);
81: --
82: Exception
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
85: pqh_sat_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then

Line 86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

82: Exception
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
85: pqh_sat_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: pqh_sat_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 87: When hr_api.parent_integrity_violated Then

83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
85: pqh_sat_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: pqh_sat_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then

Line 90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: pqh_sat_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: pqh_sat_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 91: When hr_api.unique_integrity_violated Then

87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: pqh_sat_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: pqh_sat_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When Others Then

Line 94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: pqh_sat_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When Others Then
96: Raise;
97: End update_dml;
98: --

Line 212: when hr_api.cannot_find_prog_unit then

208: );
209: --
210: exception
211: --
212: when hr_api.cannot_find_prog_unit then
213: --
214: hr_api.cannot_find_prog_unit_error
215: (p_module_name => 'pqh_special_attributes'
216: ,p_hook_type => 'AU');

Line 214: hr_api.cannot_find_prog_unit_error

210: exception
211: --
212: when hr_api.cannot_find_prog_unit then
213: --
214: hr_api.cannot_find_prog_unit_error
215: (p_module_name => 'pqh_special_attributes'
216: ,p_hook_type => 'AU');
217: --
218: end;

Line 282: If (p_rec.txn_category_attribute_id = hr_api.g_number) then

278: -- p_rec plsql record structure
279: -- to see if a system default is being used. If a system default
280: -- is being used then we must set to the 'current' argument value.
281: --
282: If (p_rec.txn_category_attribute_id = hr_api.g_number) then
283: p_rec.txn_category_attribute_id :=
284: pqh_sat_shd.g_old_rec.txn_category_attribute_id;
285: End If;
286: If (p_rec.attribute_type_cd = hr_api.g_varchar2) then

Line 286: If (p_rec.attribute_type_cd = hr_api.g_varchar2) then

282: If (p_rec.txn_category_attribute_id = hr_api.g_number) then
283: p_rec.txn_category_attribute_id :=
284: pqh_sat_shd.g_old_rec.txn_category_attribute_id;
285: End If;
286: If (p_rec.attribute_type_cd = hr_api.g_varchar2) then
287: p_rec.attribute_type_cd :=
288: pqh_sat_shd.g_old_rec.attribute_type_cd;
289: End If;
290: If (p_rec.key_attribute_type = hr_api.g_varchar2) then

Line 290: If (p_rec.key_attribute_type = hr_api.g_varchar2) then

286: If (p_rec.attribute_type_cd = hr_api.g_varchar2) then
287: p_rec.attribute_type_cd :=
288: pqh_sat_shd.g_old_rec.attribute_type_cd;
289: End If;
290: If (p_rec.key_attribute_type = hr_api.g_varchar2) then
291: p_rec.key_attribute_type :=
292: pqh_sat_shd.g_old_rec.key_attribute_type;
293: End If;
294: If (p_rec.enable_flag = hr_api.g_varchar2) then

Line 294: If (p_rec.enable_flag = hr_api.g_varchar2) then

290: If (p_rec.key_attribute_type = hr_api.g_varchar2) then
291: p_rec.key_attribute_type :=
292: pqh_sat_shd.g_old_rec.key_attribute_type;
293: End If;
294: If (p_rec.enable_flag = hr_api.g_varchar2) then
295: p_rec.enable_flag :=
296: pqh_sat_shd.g_old_rec.enable_flag;
297: End If;
298: If (p_rec.flex_code = hr_api.g_varchar2) then

Line 298: If (p_rec.flex_code = hr_api.g_varchar2) then

294: If (p_rec.enable_flag = hr_api.g_varchar2) then
295: p_rec.enable_flag :=
296: pqh_sat_shd.g_old_rec.enable_flag;
297: End If;
298: If (p_rec.flex_code = hr_api.g_varchar2) then
299: p_rec.flex_code :=
300: pqh_sat_shd.g_old_rec.flex_code;
301: End If;
302: If (p_rec.ddf_column_name = hr_api.g_varchar2) then

Line 302: If (p_rec.ddf_column_name = hr_api.g_varchar2) then

298: If (p_rec.flex_code = hr_api.g_varchar2) then
299: p_rec.flex_code :=
300: pqh_sat_shd.g_old_rec.flex_code;
301: End If;
302: If (p_rec.ddf_column_name = hr_api.g_varchar2) then
303: p_rec.ddf_column_name :=
304: pqh_sat_shd.g_old_rec.ddf_column_name;
305: End If;
306: If (p_rec.ddf_value_column_name = hr_api.g_varchar2) then

Line 306: If (p_rec.ddf_value_column_name = hr_api.g_varchar2) then

302: If (p_rec.ddf_column_name = hr_api.g_varchar2) then
303: p_rec.ddf_column_name :=
304: pqh_sat_shd.g_old_rec.ddf_column_name;
305: End If;
306: If (p_rec.ddf_value_column_name = hr_api.g_varchar2) then
307: p_rec.ddf_value_column_name :=
308: pqh_sat_shd.g_old_rec.ddf_value_column_name;
309: End If;
310: If (p_rec.context = hr_api.g_varchar2) then

Line 310: If (p_rec.context = hr_api.g_varchar2) then

306: If (p_rec.ddf_value_column_name = hr_api.g_varchar2) then
307: p_rec.ddf_value_column_name :=
308: pqh_sat_shd.g_old_rec.ddf_value_column_name;
309: End If;
310: If (p_rec.context = hr_api.g_varchar2) then
311: p_rec.context :=
312: pqh_sat_shd.g_old_rec.context;
313: End If;
314: --

Line 372: p_txn_category_attribute_id in number default hr_api.g_number,

368: Procedure upd
369: (
370: p_effective_date in date,
371: p_special_attribute_id in number,
372: p_txn_category_attribute_id in number default hr_api.g_number,
373: p_attribute_type_cd in varchar2 default hr_api.g_varchar2,
374: p_key_attribute_type in varchar2 default hr_api.g_varchar2,
375: p_enable_flag in varchar2 default hr_api.g_varchar2,
376: p_flex_code in varchar2 default hr_api.g_varchar2,

Line 373: p_attribute_type_cd in varchar2 default hr_api.g_varchar2,

369: (
370: p_effective_date in date,
371: p_special_attribute_id in number,
372: p_txn_category_attribute_id in number default hr_api.g_number,
373: p_attribute_type_cd in varchar2 default hr_api.g_varchar2,
374: p_key_attribute_type in varchar2 default hr_api.g_varchar2,
375: p_enable_flag in varchar2 default hr_api.g_varchar2,
376: p_flex_code in varchar2 default hr_api.g_varchar2,
377: p_object_version_number in out nocopy number,

Line 374: p_key_attribute_type in varchar2 default hr_api.g_varchar2,

370: p_effective_date in date,
371: p_special_attribute_id in number,
372: p_txn_category_attribute_id in number default hr_api.g_number,
373: p_attribute_type_cd in varchar2 default hr_api.g_varchar2,
374: p_key_attribute_type in varchar2 default hr_api.g_varchar2,
375: p_enable_flag in varchar2 default hr_api.g_varchar2,
376: p_flex_code in varchar2 default hr_api.g_varchar2,
377: p_object_version_number in out nocopy number,
378: p_ddf_column_name in varchar2 default hr_api.g_varchar2,

Line 375: p_enable_flag in varchar2 default hr_api.g_varchar2,

371: p_special_attribute_id in number,
372: p_txn_category_attribute_id in number default hr_api.g_number,
373: p_attribute_type_cd in varchar2 default hr_api.g_varchar2,
374: p_key_attribute_type in varchar2 default hr_api.g_varchar2,
375: p_enable_flag in varchar2 default hr_api.g_varchar2,
376: p_flex_code in varchar2 default hr_api.g_varchar2,
377: p_object_version_number in out nocopy number,
378: p_ddf_column_name in varchar2 default hr_api.g_varchar2,
379: p_ddf_value_column_name in varchar2 default hr_api.g_varchar2,

Line 376: p_flex_code in varchar2 default hr_api.g_varchar2,

372: p_txn_category_attribute_id in number default hr_api.g_number,
373: p_attribute_type_cd in varchar2 default hr_api.g_varchar2,
374: p_key_attribute_type in varchar2 default hr_api.g_varchar2,
375: p_enable_flag in varchar2 default hr_api.g_varchar2,
376: p_flex_code in varchar2 default hr_api.g_varchar2,
377: p_object_version_number in out nocopy number,
378: p_ddf_column_name in varchar2 default hr_api.g_varchar2,
379: p_ddf_value_column_name in varchar2 default hr_api.g_varchar2,
380: p_context in varchar2 default hr_api.g_varchar2

Line 378: p_ddf_column_name in varchar2 default hr_api.g_varchar2,

374: p_key_attribute_type in varchar2 default hr_api.g_varchar2,
375: p_enable_flag in varchar2 default hr_api.g_varchar2,
376: p_flex_code in varchar2 default hr_api.g_varchar2,
377: p_object_version_number in out nocopy number,
378: p_ddf_column_name in varchar2 default hr_api.g_varchar2,
379: p_ddf_value_column_name in varchar2 default hr_api.g_varchar2,
380: p_context in varchar2 default hr_api.g_varchar2
381: ) is
382: --

Line 379: p_ddf_value_column_name in varchar2 default hr_api.g_varchar2,

375: p_enable_flag in varchar2 default hr_api.g_varchar2,
376: p_flex_code in varchar2 default hr_api.g_varchar2,
377: p_object_version_number in out nocopy number,
378: p_ddf_column_name in varchar2 default hr_api.g_varchar2,
379: p_ddf_value_column_name in varchar2 default hr_api.g_varchar2,
380: p_context in varchar2 default hr_api.g_varchar2
381: ) is
382: --
383: l_rec pqh_sat_shd.g_rec_type;

Line 380: p_context in varchar2 default hr_api.g_varchar2

376: p_flex_code in varchar2 default hr_api.g_varchar2,
377: p_object_version_number in out nocopy number,
378: p_ddf_column_name in varchar2 default hr_api.g_varchar2,
379: p_ddf_value_column_name in varchar2 default hr_api.g_varchar2,
380: p_context in varchar2 default hr_api.g_varchar2
381: ) is
382: --
383: l_rec pqh_sat_shd.g_rec_type;
384: l_proc varchar2(72) := g_package||'upd';