60: --
61: --
62: hr_trv_shd.g_api_dml := true; -- Set the api dml status
63: --
64: -- Update the hr_api_transaction_values Row
65: --
66: update hr_api_transaction_values
67: set
68: transaction_value_id = p_rec.transaction_value_id,
62: hr_trv_shd.g_api_dml := true; -- Set the api dml status
63: --
64: -- Update the hr_api_transaction_values Row
65: --
66: update hr_api_transaction_values
67: set
68: transaction_value_id = p_rec.transaction_value_id,
69: transaction_step_id = p_rec.transaction_step_id,
70: datatype = p_rec.datatype,
81: --
82: hr_utility.set_location(' Leaving:'||l_proc, 10);
83: --
84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: hr_trv_shd.g_api_dml := false; -- Unset the api dml status
88: hr_trv_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: hr_trv_shd.g_api_dml := false; -- Unset the api dml status
88: hr_trv_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: hr_trv_shd.g_api_dml := false; -- Unset the api dml status
93: hr_trv_shd.constraint_error
86: -- A check constraint has been violated
87: hr_trv_shd.g_api_dml := false; -- Unset the api dml status
88: hr_trv_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: hr_trv_shd.g_api_dml := false; -- Unset the api dml status
93: hr_trv_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: hr_trv_shd.g_api_dml := false; -- Unset the api dml status
93: hr_trv_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: hr_trv_shd.g_api_dml := false; -- Unset the api dml status
98: hr_trv_shd.constraint_error
91: -- Parent integrity has been violated
92: hr_trv_shd.g_api_dml := false; -- Unset the api dml status
93: hr_trv_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: hr_trv_shd.g_api_dml := false; -- Unset the api dml status
98: hr_trv_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: hr_trv_shd.g_api_dml := false; -- Unset the api dml status
98: hr_trv_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: hr_trv_shd.g_api_dml := false; -- Unset the api dml status
102: Raise;
103: End update_dml;
242: -- p_rec plsql record structure
243: -- to see if a system default is being used. If a system default
244: -- is being used then we must set to the 'current' argument value.
245: --
246: If (p_rec.transaction_step_id = hr_api.g_number) then
247: p_rec.transaction_step_id :=
248: hr_trv_shd.g_old_rec.transaction_step_id;
249: End If;
250: If (p_rec.datatype = hr_api.g_varchar2) then
246: If (p_rec.transaction_step_id = hr_api.g_number) then
247: p_rec.transaction_step_id :=
248: hr_trv_shd.g_old_rec.transaction_step_id;
249: End If;
250: If (p_rec.datatype = hr_api.g_varchar2) then
251: p_rec.datatype :=
252: hr_trv_shd.g_old_rec.datatype;
253: End If;
254: If (p_rec.name = hr_api.g_varchar2) then
250: If (p_rec.datatype = hr_api.g_varchar2) then
251: p_rec.datatype :=
252: hr_trv_shd.g_old_rec.datatype;
253: End If;
254: If (p_rec.name = hr_api.g_varchar2) then
255: p_rec.name :=
256: hr_trv_shd.g_old_rec.name;
257: End If;
258: If (p_rec.varchar2_value = hr_api.g_varchar2) then
254: If (p_rec.name = hr_api.g_varchar2) then
255: p_rec.name :=
256: hr_trv_shd.g_old_rec.name;
257: End If;
258: If (p_rec.varchar2_value = hr_api.g_varchar2) then
259: p_rec.varchar2_value :=
260: hr_trv_shd.g_old_rec.varchar2_value;
261: End If;
262: If (p_rec.number_value = hr_api.g_number) then
258: If (p_rec.varchar2_value = hr_api.g_varchar2) then
259: p_rec.varchar2_value :=
260: hr_trv_shd.g_old_rec.varchar2_value;
261: End If;
262: If (p_rec.number_value = hr_api.g_number) then
263: p_rec.number_value :=
264: hr_trv_shd.g_old_rec.number_value;
265: End If;
266: If (p_rec.date_value = hr_api.g_date) then
262: If (p_rec.number_value = hr_api.g_number) then
263: p_rec.number_value :=
264: hr_trv_shd.g_old_rec.number_value;
265: End If;
266: If (p_rec.date_value = hr_api.g_date) then
267: p_rec.date_value :=
268: hr_trv_shd.g_old_rec.date_value;
269: End If;
270: If (p_rec.original_varchar2_value = hr_api.g_varchar2) then
266: If (p_rec.date_value = hr_api.g_date) then
267: p_rec.date_value :=
268: hr_trv_shd.g_old_rec.date_value;
269: End If;
270: If (p_rec.original_varchar2_value = hr_api.g_varchar2) then
271: p_rec.original_varchar2_value :=
272: hr_trv_shd.g_old_rec.original_varchar2_value;
273: End If;
274: If (p_rec.original_number_value = hr_api.g_number) then
270: If (p_rec.original_varchar2_value = hr_api.g_varchar2) then
271: p_rec.original_varchar2_value :=
272: hr_trv_shd.g_old_rec.original_varchar2_value;
273: End If;
274: If (p_rec.original_number_value = hr_api.g_number) then
275: p_rec.original_number_value :=
276: hr_trv_shd.g_old_rec.original_number_value;
277: End If;
278: If (p_rec.original_date_value = hr_api.g_date) then
274: If (p_rec.original_number_value = hr_api.g_number) then
275: p_rec.original_number_value :=
276: hr_trv_shd.g_old_rec.original_number_value;
277: End If;
278: If (p_rec.original_date_value = hr_api.g_date) then
279: p_rec.original_date_value :=
280: hr_trv_shd.g_old_rec.original_date_value;
281: End If;
282: --
337: --
338: -- If we are validating then raise the Validate_Enabled exception
339: --
340: If p_validate then
341: Raise HR_Api.Validate_Enabled;
342: End If;
343: --
344: hr_utility.set_location(' Leaving:'||l_proc, 10);
345: Exception
342: End If;
343: --
344: hr_utility.set_location(' Leaving:'||l_proc, 10);
345: Exception
346: When HR_Api.Validate_Enabled Then
347: --
348: -- As the Validate_Enabled exception has been raised
349: -- we must rollback to the savepoint
350: --
356: -- ----------------------------------------------------------------------------
357: Procedure upd
358: (
359: p_transaction_value_id in number,
360: p_transaction_step_id in number default hr_api.g_number,
361: p_datatype in varchar2 default hr_api.g_varchar2,
362: p_name in varchar2 default hr_api.g_varchar2,
363: p_varchar2_value in varchar2 default hr_api.g_varchar2,
364: p_number_value in number default hr_api.g_number,
357: Procedure upd
358: (
359: p_transaction_value_id in number,
360: p_transaction_step_id in number default hr_api.g_number,
361: p_datatype in varchar2 default hr_api.g_varchar2,
362: p_name in varchar2 default hr_api.g_varchar2,
363: p_varchar2_value in varchar2 default hr_api.g_varchar2,
364: p_number_value in number default hr_api.g_number,
365: p_date_value in date default hr_api.g_date,
358: (
359: p_transaction_value_id in number,
360: p_transaction_step_id in number default hr_api.g_number,
361: p_datatype in varchar2 default hr_api.g_varchar2,
362: p_name in varchar2 default hr_api.g_varchar2,
363: p_varchar2_value in varchar2 default hr_api.g_varchar2,
364: p_number_value in number default hr_api.g_number,
365: p_date_value in date default hr_api.g_date,
366: p_original_varchar2_value in varchar2 default hr_api.g_varchar2,
359: p_transaction_value_id in number,
360: p_transaction_step_id in number default hr_api.g_number,
361: p_datatype in varchar2 default hr_api.g_varchar2,
362: p_name in varchar2 default hr_api.g_varchar2,
363: p_varchar2_value in varchar2 default hr_api.g_varchar2,
364: p_number_value in number default hr_api.g_number,
365: p_date_value in date default hr_api.g_date,
366: p_original_varchar2_value in varchar2 default hr_api.g_varchar2,
367: p_original_number_value in number default hr_api.g_number,
360: p_transaction_step_id in number default hr_api.g_number,
361: p_datatype in varchar2 default hr_api.g_varchar2,
362: p_name in varchar2 default hr_api.g_varchar2,
363: p_varchar2_value in varchar2 default hr_api.g_varchar2,
364: p_number_value in number default hr_api.g_number,
365: p_date_value in date default hr_api.g_date,
366: p_original_varchar2_value in varchar2 default hr_api.g_varchar2,
367: p_original_number_value in number default hr_api.g_number,
368: p_original_date_value in date default hr_api.g_date,
361: p_datatype in varchar2 default hr_api.g_varchar2,
362: p_name in varchar2 default hr_api.g_varchar2,
363: p_varchar2_value in varchar2 default hr_api.g_varchar2,
364: p_number_value in number default hr_api.g_number,
365: p_date_value in date default hr_api.g_date,
366: p_original_varchar2_value in varchar2 default hr_api.g_varchar2,
367: p_original_number_value in number default hr_api.g_number,
368: p_original_date_value in date default hr_api.g_date,
369: p_validate in boolean default false
362: p_name in varchar2 default hr_api.g_varchar2,
363: p_varchar2_value in varchar2 default hr_api.g_varchar2,
364: p_number_value in number default hr_api.g_number,
365: p_date_value in date default hr_api.g_date,
366: p_original_varchar2_value in varchar2 default hr_api.g_varchar2,
367: p_original_number_value in number default hr_api.g_number,
368: p_original_date_value in date default hr_api.g_date,
369: p_validate in boolean default false
370: ) is
363: p_varchar2_value in varchar2 default hr_api.g_varchar2,
364: p_number_value in number default hr_api.g_number,
365: p_date_value in date default hr_api.g_date,
366: p_original_varchar2_value in varchar2 default hr_api.g_varchar2,
367: p_original_number_value in number default hr_api.g_number,
368: p_original_date_value in date default hr_api.g_date,
369: p_validate in boolean default false
370: ) is
371: --
364: p_number_value in number default hr_api.g_number,
365: p_date_value in date default hr_api.g_date,
366: p_original_varchar2_value in varchar2 default hr_api.g_varchar2,
367: p_original_number_value in number default hr_api.g_number,
368: p_original_date_value in date default hr_api.g_date,
369: p_validate in boolean default false
370: ) is
371: --
372: l_rec hr_trv_shd.g_rec_type;