APPS.HR_TRV_UPD dependencies on HR_API

Line 64: -- Update the hr_api_transaction_values Row

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,

Line 66: update hr_api_transaction_values

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,

Line 85: When hr_api.check_integrity_violated Then

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));

Line 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

Line 90: When hr_api.parent_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
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 95: When hr_api.unique_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
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 246: If (p_rec.transaction_step_id = hr_api.g_number) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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: --

Line 341: Raise HR_Api.Validate_Enabled;

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

Line 346: When HR_Api.Validate_Enabled Then

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: --

Line 360: p_transaction_step_id in number default hr_api.g_number,

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,

Line 361: p_datatype in varchar2 default hr_api.g_varchar2,

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,

Line 362: p_name in varchar2 default hr_api.g_varchar2,

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,

Line 363: p_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,

Line 364: p_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,

Line 365: p_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

Line 366: p_original_varchar2_value 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
370: ) is

Line 367: p_original_number_value in number default hr_api.g_number,

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: --

Line 368: p_original_date_value in date default hr_api.g_date,

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;