DBA Data[Home] [Help]

APPS.PAY_ETM_DEL dependencies on HR_UTILITY

Line 50: hr_utility.set_location('Entering:'||l_proc, 5);

46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: --
52: -- Delete the pay_element_templates row.
53: --
54: delete from pay_element_templates

Line 57: hr_utility.set_location(' Leaving:'||l_proc, 10);

53: --
54: delete from pay_element_templates
55: where template_id = p_rec.template_id;
56: --
57: hr_utility.set_location(' Leaving:'||l_proc, 10);
58: --
59: Exception
60: When hr_api.child_integrity_violated then
61: -- Child integrity has been violated

Line 105: hr_utility.set_location('Entering:'||l_proc, 5);

101: --
102: l_proc varchar2(72) := g_package||'pre_delete';
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: hr_utility.set_location(' Leaving:'||l_proc, 10);
108: End pre_delete;
109: --

Line 107: hr_utility.set_location(' Leaving:'||l_proc, 10);

103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: hr_utility.set_location(' Leaving:'||l_proc, 10);
108: End pre_delete;
109: --
110: -- ----------------------------------------------------------------------------
111: -- |-----------------------------< post_delete >------------------------------|

Line 147: hr_utility.set_location('Entering:'||l_proc, 5);

143: --
144: l_proc varchar2(72) := g_package||'post_delete';
145: --
146: Begin
147: hr_utility.set_location('Entering:'||l_proc, 5);
148: --
149: hr_utility.set_location(' Leaving:'||l_proc, 10);
150: End post_delete;
151: --

Line 149: hr_utility.set_location(' Leaving:'||l_proc, 10);

145: --
146: Begin
147: hr_utility.set_location('Entering:'||l_proc, 5);
148: --
149: hr_utility.set_location(' Leaving:'||l_proc, 10);
150: End post_delete;
151: --
152: -- ----------------------------------------------------------------------------
153: -- |---------------------------------< del >----------------------------------|

Line 163: hr_utility.set_location('Entering:'||l_proc, 5);

159: --
160: l_proc varchar2(72) := g_package||'del';
161: --
162: Begin
163: hr_utility.set_location('Entering:'||l_proc, 5);
164: --
165: -- We must lock the row which we need to delete.
166: --
167: pay_etm_shd.lck

Line 203: hr_utility.set_location('Entering:'||l_proc, 5);

199: l_rec pay_etm_shd.g_rec_type;
200: l_proc varchar2(72) := g_package||'del';
201: --
202: Begin
203: hr_utility.set_location('Entering:'||l_proc, 5);
204: --
205: -- As the delete procedure accepts a plsql record structure we do need to
206: -- convert the arguments into the record structure.
207: -- We don't need to call the supplied conversion argument routine as we

Line 219: hr_utility.set_location(' Leaving:'||l_proc, 10);

215: -- business process
216: --
217: del(l_rec);
218: --
219: hr_utility.set_location(' Leaving:'||l_proc, 10);
220: End del;
221: --
222: end pay_etm_del;