47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure update_dml(p_rec in out nocopy pqh_sat_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'update_dml';
54: --
55: Begin
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
88: -- Parent integrity has been violated
89: pqh_sat_shd.constraint_error
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
92: -- Unique integrity has been violated
93: pqh_sat_shd.constraint_error
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
96: Raise;
97: End update_dml;
127: -- Internal Row Handler Use Only.
128: --
129: -- {End Of Comments}
130: -- ----------------------------------------------------------------------------
131: Procedure pre_update(p_rec in pqh_sat_shd.g_rec_type) is
132: --
133: l_proc varchar2(72) := g_package||'pre_update';
134: --
135: Begin
170: --
171: -- {End Of Comments}
172: -- ----------------------------------------------------------------------------
173: Procedure post_update(
174: p_effective_date in date,p_rec in pqh_sat_shd.g_rec_type) is
175: --
176: l_proc varchar2(72) := g_package||'post_update';
177: --
178: Begin
195: ,p_ddf_column_name =>p_rec.ddf_column_name
196: ,p_ddf_value_column_name =>p_rec.ddf_value_column_name
197: ,p_context =>p_rec.context
198: ,p_effective_date =>p_effective_date
199: ,p_txn_category_attribute_id_o =>pqh_sat_shd.g_old_rec.txn_category_attribute_id
200: ,p_attribute_type_cd_o =>pqh_sat_shd.g_old_rec.attribute_type_cd
201: ,p_key_attribute_type_o =>pqh_sat_shd.g_old_rec.key_attribute_type
202: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
203: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
196: ,p_ddf_value_column_name =>p_rec.ddf_value_column_name
197: ,p_context =>p_rec.context
198: ,p_effective_date =>p_effective_date
199: ,p_txn_category_attribute_id_o =>pqh_sat_shd.g_old_rec.txn_category_attribute_id
200: ,p_attribute_type_cd_o =>pqh_sat_shd.g_old_rec.attribute_type_cd
201: ,p_key_attribute_type_o =>pqh_sat_shd.g_old_rec.key_attribute_type
202: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
203: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
204: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number
197: ,p_context =>p_rec.context
198: ,p_effective_date =>p_effective_date
199: ,p_txn_category_attribute_id_o =>pqh_sat_shd.g_old_rec.txn_category_attribute_id
200: ,p_attribute_type_cd_o =>pqh_sat_shd.g_old_rec.attribute_type_cd
201: ,p_key_attribute_type_o =>pqh_sat_shd.g_old_rec.key_attribute_type
202: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
203: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
204: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number
205: ,p_ddf_column_name_o =>pqh_sat_shd.g_old_rec.ddf_column_name
198: ,p_effective_date =>p_effective_date
199: ,p_txn_category_attribute_id_o =>pqh_sat_shd.g_old_rec.txn_category_attribute_id
200: ,p_attribute_type_cd_o =>pqh_sat_shd.g_old_rec.attribute_type_cd
201: ,p_key_attribute_type_o =>pqh_sat_shd.g_old_rec.key_attribute_type
202: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
203: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
204: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number
205: ,p_ddf_column_name_o =>pqh_sat_shd.g_old_rec.ddf_column_name
206: ,p_ddf_value_column_name_o =>pqh_sat_shd.g_old_rec.ddf_value_column_name
199: ,p_txn_category_attribute_id_o =>pqh_sat_shd.g_old_rec.txn_category_attribute_id
200: ,p_attribute_type_cd_o =>pqh_sat_shd.g_old_rec.attribute_type_cd
201: ,p_key_attribute_type_o =>pqh_sat_shd.g_old_rec.key_attribute_type
202: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
203: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
204: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number
205: ,p_ddf_column_name_o =>pqh_sat_shd.g_old_rec.ddf_column_name
206: ,p_ddf_value_column_name_o =>pqh_sat_shd.g_old_rec.ddf_value_column_name
207: ,p_context_o =>pqh_sat_shd.g_old_rec.context
200: ,p_attribute_type_cd_o =>pqh_sat_shd.g_old_rec.attribute_type_cd
201: ,p_key_attribute_type_o =>pqh_sat_shd.g_old_rec.key_attribute_type
202: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
203: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
204: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number
205: ,p_ddf_column_name_o =>pqh_sat_shd.g_old_rec.ddf_column_name
206: ,p_ddf_value_column_name_o =>pqh_sat_shd.g_old_rec.ddf_value_column_name
207: ,p_context_o =>pqh_sat_shd.g_old_rec.context
208: );
201: ,p_key_attribute_type_o =>pqh_sat_shd.g_old_rec.key_attribute_type
202: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
203: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
204: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number
205: ,p_ddf_column_name_o =>pqh_sat_shd.g_old_rec.ddf_column_name
206: ,p_ddf_value_column_name_o =>pqh_sat_shd.g_old_rec.ddf_value_column_name
207: ,p_context_o =>pqh_sat_shd.g_old_rec.context
208: );
209: --
202: ,p_enable_flag_o =>pqh_sat_shd.g_old_rec.enable_flag
203: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
204: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number
205: ,p_ddf_column_name_o =>pqh_sat_shd.g_old_rec.ddf_column_name
206: ,p_ddf_value_column_name_o =>pqh_sat_shd.g_old_rec.ddf_value_column_name
207: ,p_context_o =>pqh_sat_shd.g_old_rec.context
208: );
209: --
210: exception
203: ,p_flex_code_o =>pqh_sat_shd.g_old_rec.flex_code
204: ,p_object_version_number_o =>pqh_sat_shd.g_old_rec.object_version_number
205: ,p_ddf_column_name_o =>pqh_sat_shd.g_old_rec.ddf_column_name
206: ,p_ddf_value_column_name_o =>pqh_sat_shd.g_old_rec.ddf_value_column_name
207: ,p_context_o =>pqh_sat_shd.g_old_rec.context
208: );
209: --
210: exception
211: --
265: -- Internal Row Handler Use Only.
266: --
267: -- {End Of Comments}
268: -- ----------------------------------------------------------------------------
269: Procedure convert_defs(p_rec in out nocopy pqh_sat_shd.g_rec_type) is
270: --
271: l_proc varchar2(72) := g_package||'convert_defs';
272: --
273: Begin
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
287: p_rec.attribute_type_cd :=
288: pqh_sat_shd.g_old_rec.attribute_type_cd;
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
291: p_rec.key_attribute_type :=
292: pqh_sat_shd.g_old_rec.key_attribute_type;
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
295: p_rec.enable_flag :=
296: pqh_sat_shd.g_old_rec.enable_flag;
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
299: p_rec.flex_code :=
300: pqh_sat_shd.g_old_rec.flex_code;
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
303: p_rec.ddf_column_name :=
304: pqh_sat_shd.g_old_rec.ddf_column_name;
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
307: p_rec.ddf_value_column_name :=
308: pqh_sat_shd.g_old_rec.ddf_value_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
311: p_rec.context :=
312: pqh_sat_shd.g_old_rec.context;
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: --
315: hr_utility.set_location(' Leaving:'||l_proc, 10);
316: --
321: -- ----------------------------------------------------------------------------
322: Procedure upd
323: (
324: p_effective_date in date,
325: p_rec in out nocopy pqh_sat_shd.g_rec_type
326: ) is
327: --
328: l_proc varchar2(72) := g_package||'upd';
329: --
331: hr_utility.set_location('Entering:'||l_proc, 5);
332: --
333: -- We must lock the row which we need to update.
334: --
335: pqh_sat_shd.lck
336: (
337: p_rec.special_attribute_id,
338: p_rec.object_version_number
339: );
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';
385: --
386: Begin
387: hr_utility.set_location('Entering:'||l_proc, 5);
389: -- Call conversion function to turn arguments into the
390: -- l_rec structure.
391: --
392: l_rec :=
393: pqh_sat_shd.convert_args
394: (
395: p_special_attribute_id,
396: p_txn_category_attribute_id,
397: p_attribute_type_cd,