APPS.PAY_AMT_DEL dependencies on PAY_AMT_SHD

Line 52: (p_rec in pay_amt_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in pay_amt_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72);
56: --

Line 62: pay_amt_shd.g_api_dml := true; -- Set the api dml status

58: l_proc := g_package||'delete_dml';
59: --
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: --
62: pay_amt_shd.g_api_dml := true; -- Set the api dml status
63: --
64: -- Delete the pay_au_module_types row.
65: --
66: delete from pay_au_module_types

Line 69: pay_amt_shd.g_api_dml := false; -- Unset the api dml status

65: --
66: delete from pay_au_module_types
67: where module_type_id = p_rec.module_type_id;
68: --
69: pay_amt_shd.g_api_dml := false; -- Unset the api dml status
70: --
71: hr_utility.set_location(' Leaving:'||l_proc, 10);
72: --
73: Exception

Line 76: pay_amt_shd.g_api_dml := false; -- Unset the api dml status

72: --
73: Exception
74: When hr_api.child_integrity_violated then
75: -- Child integrity has been violated
76: pay_amt_shd.g_api_dml := false; -- Unset the api dml status
77: pay_amt_shd.constraint_error
78: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
79: When Others Then
80: pay_amt_shd.g_api_dml := false; -- Unset the api dml status

Line 77: pay_amt_shd.constraint_error

73: Exception
74: When hr_api.child_integrity_violated then
75: -- Child integrity has been violated
76: pay_amt_shd.g_api_dml := false; -- Unset the api dml status
77: pay_amt_shd.constraint_error
78: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
79: When Others Then
80: pay_amt_shd.g_api_dml := false; -- Unset the api dml status
81: Raise;

Line 80: pay_amt_shd.g_api_dml := false; -- Unset the api dml status

76: pay_amt_shd.g_api_dml := false; -- Unset the api dml status
77: pay_amt_shd.constraint_error
78: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
79: When Others Then
80: pay_amt_shd.g_api_dml := false; -- Unset the api dml status
81: Raise;
82: End delete_dml;
83: --
84: -- ----------------------------------------------------------------------------

Line 116: Procedure pre_delete(p_rec in pay_amt_shd.g_rec_type) is

112: -- Internal Row Handler Use Only.
113: --
114: -- {End Of Comments}
115: -- ----------------------------------------------------------------------------
116: Procedure pre_delete(p_rec in pay_amt_shd.g_rec_type) is
117: --
118: l_proc varchar2(72);
119: --
120: Begin

Line 160: Procedure post_delete(p_rec in pay_amt_shd.g_rec_type) is

156: -- Internal Row Handler Use Only.
157: --
158: -- {End Of Comments}
159: -- -----------------------------------------------------------------------------
160: Procedure post_delete(p_rec in pay_amt_shd.g_rec_type) is
161: --
162: l_proc varchar2(72);
163: --
164: Begin

Line 176: (p_rec in pay_amt_shd.g_rec_type

172: -- ----------------------------------------------------------------------------
173: -- |---------------------------------< del >----------------------------------|
174: -- ----------------------------------------------------------------------------
175: Procedure del
176: (p_rec in pay_amt_shd.g_rec_type
177: ) is
178: --
179: l_proc varchar2(72);
180: --

Line 188: pay_amt_shd.lck

184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: -- We must lock the row which we need to delete.
187: --
188: pay_amt_shd.lck
189: (p_rec.module_type_id
190: ,p_rec.object_version_number
191: );
192: --

Line 225: l_rec pay_amt_shd.g_rec_type;

221: (p_module_type_id in number
222: ,p_object_version_number in number
223: ) is
224: --
225: l_rec pay_amt_shd.g_rec_type;
226: l_proc varchar2(72);
227: --
228: Begin
229: l_proc := g_package||'del';