DBA Data[Home] [Help]

APPS.PAY_APR_UPD dependencies on PAY_APR_SHD

Line 55: (p_rec in out nocopy pay_apr_shd.g_rec_type

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

Line 68: pay_apr_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_apr_shd.g_api_dml := true; -- Set the api dml status
69: --
70: -- Update the pay_au_processes Row
71: --
72: update pay_au_processes

Line 85: pay_apr_shd.g_api_dml := false; -- Unset the api dml status

81: ,accrual_category = p_rec.accrual_category
82: ,object_version_number = p_rec.object_version_number
83: where process_id = p_rec.process_id;
84: --
85: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
86: --
87: hr_utility.set_location(' Leaving:'||l_proc, 10);
88: --
89: Exception

Line 92: pay_apr_shd.g_api_dml := false; -- Unset the api dml status

88: --
89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
93: pay_apr_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated

Line 93: pay_apr_shd.constraint_error

89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
93: pay_apr_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: pay_apr_shd.g_api_dml := false; -- Unset the api dml status

Line 97: pay_apr_shd.g_api_dml := false; -- Unset the api dml status

93: pay_apr_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
98: pay_apr_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated

Line 98: pay_apr_shd.constraint_error

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

Line 102: pay_apr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 103: pay_apr_shd.constraint_error

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

Line 106: pay_apr_shd.g_api_dml := false; -- Unset the api dml status

102: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
103: pay_apr_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
107: Raise;
108: End update_dml;
109: --
110: -- ----------------------------------------------------------------------------

Line 143: (p_rec in pay_apr_shd.g_rec_type

139: --
140: -- {End Of Comments}
141: -- ----------------------------------------------------------------------------
142: Procedure pre_update
143: (p_rec in pay_apr_shd.g_rec_type
144: ) is
145: --
146: l_proc varchar2(72);
147: --

Line 189: (p_rec in pay_apr_shd.g_rec_type

185: --
186: -- {End Of Comments}
187: -- ----------------------------------------------------------------------------
188: Procedure post_update
189: (p_rec in pay_apr_shd.g_rec_type
190: ) is
191: --
192: l_proc varchar2(72);
193: --

Line 246: (p_rec in out nocopy pay_apr_shd.g_rec_type

242: --
243: -- {End Of Comments}
244: -- ----------------------------------------------------------------------------
245: Procedure convert_defs
246: (p_rec in out nocopy pay_apr_shd.g_rec_type
247: ) is
248: --
249: Begin
250: --

Line 258: pay_apr_shd.g_old_rec.short_name;

254: -- is being used then we must set to the 'current' argument value.
255: --
256: If (p_rec.short_name = hr_api.g_varchar2) then
257: p_rec.short_name :=
258: pay_apr_shd.g_old_rec.short_name;
259: End If;
260: If (p_rec.name = hr_api.g_varchar2) then
261: p_rec.name :=
262: pay_apr_shd.g_old_rec.name;

Line 262: pay_apr_shd.g_old_rec.name;

258: pay_apr_shd.g_old_rec.short_name;
259: End If;
260: If (p_rec.name = hr_api.g_varchar2) then
261: p_rec.name :=
262: pay_apr_shd.g_old_rec.name;
263: End If;
264: If (p_rec.enabled_flag = hr_api.g_varchar2) then
265: p_rec.enabled_flag :=
266: pay_apr_shd.g_old_rec.enabled_flag;

Line 266: pay_apr_shd.g_old_rec.enabled_flag;

262: pay_apr_shd.g_old_rec.name;
263: End If;
264: If (p_rec.enabled_flag = hr_api.g_varchar2) then
265: p_rec.enabled_flag :=
266: pay_apr_shd.g_old_rec.enabled_flag;
267: End If;
268: If (p_rec.business_group_id = hr_api.g_number) then
269: p_rec.business_group_id :=
270: pay_apr_shd.g_old_rec.business_group_id;

Line 270: pay_apr_shd.g_old_rec.business_group_id;

266: pay_apr_shd.g_old_rec.enabled_flag;
267: End If;
268: If (p_rec.business_group_id = hr_api.g_number) then
269: p_rec.business_group_id :=
270: pay_apr_shd.g_old_rec.business_group_id;
271: End If;
272: If (p_rec.legislation_code = hr_api.g_varchar2) then
273: p_rec.legislation_code :=
274: pay_apr_shd.g_old_rec.legislation_code;

Line 274: pay_apr_shd.g_old_rec.legislation_code;

270: pay_apr_shd.g_old_rec.business_group_id;
271: End If;
272: If (p_rec.legislation_code = hr_api.g_varchar2) then
273: p_rec.legislation_code :=
274: pay_apr_shd.g_old_rec.legislation_code;
275: End If;
276: If (p_rec.description = hr_api.g_varchar2) then
277: p_rec.description :=
278: pay_apr_shd.g_old_rec.description;

Line 278: pay_apr_shd.g_old_rec.description;

274: pay_apr_shd.g_old_rec.legislation_code;
275: End If;
276: If (p_rec.description = hr_api.g_varchar2) then
277: p_rec.description :=
278: pay_apr_shd.g_old_rec.description;
279: End If;
280: If (p_rec.accrual_category = hr_api.g_varchar2) then
281: p_rec.accrual_category :=
282: pay_apr_shd.g_old_rec.accrual_category;

Line 282: pay_apr_shd.g_old_rec.accrual_category;

278: pay_apr_shd.g_old_rec.description;
279: End If;
280: If (p_rec.accrual_category = hr_api.g_varchar2) then
281: p_rec.accrual_category :=
282: pay_apr_shd.g_old_rec.accrual_category;
283: End If;
284: --
285: End convert_defs;
286: --

Line 291: (p_rec in out nocopy pay_apr_shd.g_rec_type

287: -- ----------------------------------------------------------------------------
288: -- |---------------------------------< upd >----------------------------------|
289: -- ----------------------------------------------------------------------------
290: Procedure upd
291: (p_rec in out nocopy pay_apr_shd.g_rec_type
292: ) is
293: --
294: l_proc varchar2(72);
295: --

Line 303: pay_apr_shd.lck

299: hr_utility.set_location('Entering:'||l_proc, 5);
300: --
301: -- We must lock the row which we need to update.
302: --
303: pay_apr_shd.lck
304: (p_rec.process_id
305: ,p_rec.object_version_number
306: );
307: --

Line 355: l_rec pay_apr_shd.g_rec_type;

351: ,p_description in varchar2
352: ,p_accrual_category in varchar2
353: ) is
354: --
355: l_rec pay_apr_shd.g_rec_type;
356: l_proc varchar2(72);
357: --
358: Begin
359: l_proc := g_package||'upd';

Line 367: pay_apr_shd.convert_args

363: -- Call conversion function to turn arguments into the
364: -- l_rec structure.
365: --
366: l_rec :=
367: pay_apr_shd.convert_args
368: (p_process_id
369: ,p_short_name
370: ,p_name
371: ,p_enabled_flag