DBA Data[Home] [Help]

APPS.PAY_AMP_UPD dependencies on PAY_AMP_SHD

Line 55: (p_rec in out nocopy pay_amp_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pay_amp_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72);
59: --

Line 68: pay_amp_shd.g_api_dml := true; -- Set the api dml status

64: --
65: -- Increment the object version
66: p_rec.object_version_number := p_rec.object_version_number + 1;
67: --
68: pay_amp_shd.g_api_dml := true; -- Set the api dml status
69: --
70: -- Update the pay_au_module_parameters Row
71: --
72: update pay_au_module_parameters

Line 91: pay_amp_shd.g_api_dml := false; -- Unset the api dml status

87: ,constant_value = p_rec.constant_value
88: ,object_version_number = p_rec.object_version_number
89: where module_parameter_id = p_rec.module_parameter_id;
90: --
91: pay_amp_shd.g_api_dml := false; -- Unset the api dml status
92: --
93: hr_utility.set_location(' Leaving:'||l_proc, 10);
94: --
95: Exception

Line 98: pay_amp_shd.g_api_dml := false; -- Unset the api dml status

94: --
95: Exception
96: When hr_api.check_integrity_violated Then
97: -- A check constraint has been violated
98: pay_amp_shd.g_api_dml := false; -- Unset the api dml status
99: pay_amp_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated

Line 99: pay_amp_shd.constraint_error

95: Exception
96: When hr_api.check_integrity_violated Then
97: -- A check constraint has been violated
98: pay_amp_shd.g_api_dml := false; -- Unset the api dml status
99: pay_amp_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: pay_amp_shd.g_api_dml := false; -- Unset the api dml status

Line 103: pay_amp_shd.g_api_dml := false; -- Unset the api dml status

99: pay_amp_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: pay_amp_shd.g_api_dml := false; -- Unset the api dml status
104: pay_amp_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated

Line 104: pay_amp_shd.constraint_error

100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: pay_amp_shd.g_api_dml := false; -- Unset the api dml status
104: pay_amp_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: pay_amp_shd.g_api_dml := false; -- Unset the api dml status

Line 108: pay_amp_shd.g_api_dml := false; -- Unset the api dml status

104: pay_amp_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: pay_amp_shd.g_api_dml := false; -- Unset the api dml status
109: pay_amp_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: pay_amp_shd.g_api_dml := false; -- Unset the api dml status

Line 109: pay_amp_shd.constraint_error

105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: pay_amp_shd.g_api_dml := false; -- Unset the api dml status
109: pay_amp_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: pay_amp_shd.g_api_dml := false; -- Unset the api dml status
113: Raise;

Line 112: pay_amp_shd.g_api_dml := false; -- Unset the api dml status

108: pay_amp_shd.g_api_dml := false; -- Unset the api dml status
109: pay_amp_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: pay_amp_shd.g_api_dml := false; -- Unset the api dml status
113: Raise;
114: End update_dml;
115: --
116: -- ----------------------------------------------------------------------------

Line 149: (p_rec in pay_amp_shd.g_rec_type

145: --
146: -- {End Of Comments}
147: -- ----------------------------------------------------------------------------
148: Procedure pre_update
149: (p_rec in pay_amp_shd.g_rec_type
150: ) is
151: --
152: l_proc varchar2(72);
153: --

Line 195: (p_rec in pay_amp_shd.g_rec_type

191: --
192: -- {End Of Comments}
193: -- ----------------------------------------------------------------------------
194: Procedure post_update
195: (p_rec in pay_amp_shd.g_rec_type
196: ) is
197: --
198: l_proc varchar2(72);
199: --

Line 252: (p_rec in out nocopy pay_amp_shd.g_rec_type

248: --
249: -- {End Of Comments}
250: -- ----------------------------------------------------------------------------
251: Procedure convert_defs
252: (p_rec in out nocopy pay_amp_shd.g_rec_type
253: ) is
254: --
255: Begin
256: --

Line 264: pay_amp_shd.g_old_rec.module_id;

260: -- is being used then we must set to the 'current' argument value.
261: --
262: If (p_rec.module_id = hr_api.g_number) then
263: p_rec.module_id :=
264: pay_amp_shd.g_old_rec.module_id;
265: End If;
266: If (p_rec.internal_name = hr_api.g_varchar2) then
267: p_rec.internal_name :=
268: pay_amp_shd.g_old_rec.internal_name;

Line 268: pay_amp_shd.g_old_rec.internal_name;

264: pay_amp_shd.g_old_rec.module_id;
265: End If;
266: If (p_rec.internal_name = hr_api.g_varchar2) then
267: p_rec.internal_name :=
268: pay_amp_shd.g_old_rec.internal_name;
269: End If;
270: If (p_rec.data_type = hr_api.g_varchar2) then
271: p_rec.data_type :=
272: pay_amp_shd.g_old_rec.data_type;

Line 272: pay_amp_shd.g_old_rec.data_type;

268: pay_amp_shd.g_old_rec.internal_name;
269: End If;
270: If (p_rec.data_type = hr_api.g_varchar2) then
271: p_rec.data_type :=
272: pay_amp_shd.g_old_rec.data_type;
273: End If;
274: If (p_rec.input_flag = hr_api.g_varchar2) then
275: p_rec.input_flag :=
276: pay_amp_shd.g_old_rec.input_flag;

Line 276: pay_amp_shd.g_old_rec.input_flag;

272: pay_amp_shd.g_old_rec.data_type;
273: End If;
274: If (p_rec.input_flag = hr_api.g_varchar2) then
275: p_rec.input_flag :=
276: pay_amp_shd.g_old_rec.input_flag;
277: End If;
278: If (p_rec.context_flag = hr_api.g_varchar2) then
279: p_rec.context_flag :=
280: pay_amp_shd.g_old_rec.context_flag;

Line 280: pay_amp_shd.g_old_rec.context_flag;

276: pay_amp_shd.g_old_rec.input_flag;
277: End If;
278: If (p_rec.context_flag = hr_api.g_varchar2) then
279: p_rec.context_flag :=
280: pay_amp_shd.g_old_rec.context_flag;
281: End If;
282: If (p_rec.output_flag = hr_api.g_varchar2) then
283: p_rec.output_flag :=
284: pay_amp_shd.g_old_rec.output_flag;

Line 284: pay_amp_shd.g_old_rec.output_flag;

280: pay_amp_shd.g_old_rec.context_flag;
281: End If;
282: If (p_rec.output_flag = hr_api.g_varchar2) then
283: p_rec.output_flag :=
284: pay_amp_shd.g_old_rec.output_flag;
285: End If;
286: If (p_rec.result_flag = hr_api.g_varchar2) then
287: p_rec.result_flag :=
288: pay_amp_shd.g_old_rec.result_flag;

Line 288: pay_amp_shd.g_old_rec.result_flag;

284: pay_amp_shd.g_old_rec.output_flag;
285: End If;
286: If (p_rec.result_flag = hr_api.g_varchar2) then
287: p_rec.result_flag :=
288: pay_amp_shd.g_old_rec.result_flag;
289: End If;
290: If (p_rec.error_message_flag = hr_api.g_varchar2) then
291: p_rec.error_message_flag :=
292: pay_amp_shd.g_old_rec.error_message_flag;

Line 292: pay_amp_shd.g_old_rec.error_message_flag;

288: pay_amp_shd.g_old_rec.result_flag;
289: End If;
290: If (p_rec.error_message_flag = hr_api.g_varchar2) then
291: p_rec.error_message_flag :=
292: pay_amp_shd.g_old_rec.error_message_flag;
293: End If;
294: If (p_rec.function_return_flag = hr_api.g_varchar2) then
295: p_rec.function_return_flag :=
296: pay_amp_shd.g_old_rec.function_return_flag;

Line 296: pay_amp_shd.g_old_rec.function_return_flag;

292: pay_amp_shd.g_old_rec.error_message_flag;
293: End If;
294: If (p_rec.function_return_flag = hr_api.g_varchar2) then
295: p_rec.function_return_flag :=
296: pay_amp_shd.g_old_rec.function_return_flag;
297: End If;
298: If (p_rec.enabled_flag = hr_api.g_varchar2) then
299: p_rec.enabled_flag :=
300: pay_amp_shd.g_old_rec.enabled_flag;

Line 300: pay_amp_shd.g_old_rec.enabled_flag;

296: pay_amp_shd.g_old_rec.function_return_flag;
297: End If;
298: If (p_rec.enabled_flag = hr_api.g_varchar2) then
299: p_rec.enabled_flag :=
300: pay_amp_shd.g_old_rec.enabled_flag;
301: End If;
302: If (p_rec.external_name = hr_api.g_varchar2) then
303: p_rec.external_name :=
304: pay_amp_shd.g_old_rec.external_name;

Line 304: pay_amp_shd.g_old_rec.external_name;

300: pay_amp_shd.g_old_rec.enabled_flag;
301: End If;
302: If (p_rec.external_name = hr_api.g_varchar2) then
303: p_rec.external_name :=
304: pay_amp_shd.g_old_rec.external_name;
305: End If;
306: If (p_rec.database_item_name = hr_api.g_varchar2) then
307: p_rec.database_item_name :=
308: pay_amp_shd.g_old_rec.database_item_name;

Line 308: pay_amp_shd.g_old_rec.database_item_name;

304: pay_amp_shd.g_old_rec.external_name;
305: End If;
306: If (p_rec.database_item_name = hr_api.g_varchar2) then
307: p_rec.database_item_name :=
308: pay_amp_shd.g_old_rec.database_item_name;
309: End If;
310: If (p_rec.constant_value = hr_api.g_varchar2) then
311: p_rec.constant_value :=
312: pay_amp_shd.g_old_rec.constant_value;

Line 312: pay_amp_shd.g_old_rec.constant_value;

308: pay_amp_shd.g_old_rec.database_item_name;
309: End If;
310: If (p_rec.constant_value = hr_api.g_varchar2) then
311: p_rec.constant_value :=
312: pay_amp_shd.g_old_rec.constant_value;
313: End If;
314: --
315: End convert_defs;
316: --

Line 321: (p_rec in out nocopy pay_amp_shd.g_rec_type

317: -- ----------------------------------------------------------------------------
318: -- |---------------------------------< upd >----------------------------------|
319: -- ----------------------------------------------------------------------------
320: Procedure upd
321: (p_rec in out nocopy pay_amp_shd.g_rec_type
322: ) is
323: --
324: l_proc varchar2(72);
325: --

Line 333: pay_amp_shd.lck

329: hr_utility.set_location('Entering:'||l_proc, 5);
330: --
331: -- We must lock the row which we need to update.
332: --
333: pay_amp_shd.lck
334: (p_rec.module_parameter_id
335: ,p_rec.object_version_number
336: );
337: --

Line 391: l_rec pay_amp_shd.g_rec_type;

387: ,p_database_item_name in varchar2
388: ,p_constant_value in varchar2
389: ) is
390: --
391: l_rec pay_amp_shd.g_rec_type;
392: l_proc varchar2(72);
393: --
394: Begin
395: l_proc := g_package||'upd';

Line 403: pay_amp_shd.convert_args

399: -- Call conversion function to turn arguments into the
400: -- l_rec structure.
401: --
402: l_rec :=
403: pay_amp_shd.convert_args
404: (p_module_parameter_id
405: ,p_module_id
406: ,p_internal_name
407: ,p_data_type