APPS.PAY_AMO_DEL dependencies on PAY_AMO_SHD

Line 86: (p_rec in pay_amo_shd.g_rec_type

82: --
83: -- {End Of Comments}
84: -- ----------------------------------------------------------------------------
85: Procedure delete_dml
86: (p_rec in pay_amo_shd.g_rec_type
87: ) is
88: --
89: l_proc varchar2(72);
90: --

Line 96: pay_amo_shd.g_api_dml := true; -- Set the api dml status

92: l_proc := g_package||'delete_dml';
93: --
94: hr_utility.set_location('Entering:'||l_proc, 5);
95: --
96: pay_amo_shd.g_api_dml := true; -- Set the api dml status
97: --
98: -- Delete the pay_au_modules row.
99: --
100: delete from pay_au_modules

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

99: --
100: delete from pay_au_modules
101: where module_id = p_rec.module_id;
102: --
103: pay_amo_shd.g_api_dml := false; -- Unset the api dml status
104: --
105: hr_utility.set_location(' Leaving:'||l_proc, 10);
106: --
107: Exception

Line 110: pay_amo_shd.g_api_dml := false; -- Unset the api dml status

106: --
107: Exception
108: When hr_api.child_integrity_violated then
109: -- Child integrity has been violated
110: pay_amo_shd.g_api_dml := false; -- Unset the api dml status
111: pay_amo_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When Others Then
114: pay_amo_shd.g_api_dml := false; -- Unset the api dml status

Line 111: pay_amo_shd.constraint_error

107: Exception
108: When hr_api.child_integrity_violated then
109: -- Child integrity has been violated
110: pay_amo_shd.g_api_dml := false; -- Unset the api dml status
111: pay_amo_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When Others Then
114: pay_amo_shd.g_api_dml := false; -- Unset the api dml status
115: Raise;

Line 114: pay_amo_shd.g_api_dml := false; -- Unset the api dml status

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

Line 150: Procedure pre_delete(p_rec in pay_amo_shd.g_rec_type) is

146: -- Internal Row Handler Use Only.
147: --
148: -- {End Of Comments}
149: -- ----------------------------------------------------------------------------
150: Procedure pre_delete(p_rec in pay_amo_shd.g_rec_type) is
151: --
152: l_proc varchar2(72);
153: --
154: Begin

Line 194: Procedure post_delete(p_rec in pay_amo_shd.g_rec_type) is

190: -- Internal Row Handler Use Only.
191: --
192: -- {End Of Comments}
193: -- -----------------------------------------------------------------------------
194: Procedure post_delete(p_rec in pay_amo_shd.g_rec_type) is
195: --
196: l_proc varchar2(72);
197: --
198: Begin

Line 218: (p_rec in pay_amo_shd.g_rec_type

214: -- ----------------------------------------------------------------------------
215: -- |---------------------------------< del >----------------------------------|
216: -- ----------------------------------------------------------------------------
217: Procedure del
218: (p_rec in pay_amo_shd.g_rec_type
219: ) is
220: --
221: l_proc varchar2(72);
222: --

Line 230: pay_amo_shd.lck

226: hr_utility.set_location('Entering:'||l_proc, 5);
227: --
228: -- We must lock the row which we need to delete.
229: --
230: pay_amo_shd.lck
231: (p_rec.module_id
232: ,p_rec.object_version_number
233: );
234: --

Line 267: l_rec pay_amo_shd.g_rec_type;

263: (p_module_id in number
264: ,p_object_version_number in number
265: ) is
266: --
267: l_rec pay_amo_shd.g_rec_type;
268: l_proc varchar2(72);
269: --
270: Begin
271: l_proc := g_package||'del';