APPS.PAY_MGR_DEL dependencies on PAY_MGR_SHD

Line 51: Procedure delete_dml(p_rec in pay_mgr_shd.g_rec_type) is

47: -- Internal Development Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in pay_mgr_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 58: pay_mgr_shd.g_api_dml := true; -- Set the api dml status

54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: pay_mgr_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the pay_magnetic_records row.
61: --
62: delete from pay_magnetic_records

Line 66: pay_mgr_shd.g_api_dml := false; -- Unset the api dml status

62: delete from pay_magnetic_records
63: where magnetic_block_id = p_rec.magnetic_block_id
64: and sequence = p_rec.sequence;
65: --
66: pay_mgr_shd.g_api_dml := false; -- Unset the api dml status
67: --
68: hr_utility.set_location(' Leaving:'||l_proc, 10);
69: --
70: Exception

Line 73: pay_mgr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 74: pay_mgr_shd.constraint_error

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

Line 77: pay_mgr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 113: Procedure pre_delete(p_rec in pay_mgr_shd.g_rec_type) is

109: -- Internal Development Use Only.
110: --
111: -- {End Of Comments}
112: -- ----------------------------------------------------------------------------
113: Procedure pre_delete(p_rec in pay_mgr_shd.g_rec_type) is
114: --
115: l_proc varchar2(72) := g_package||'pre_delete';
116: --
117: Begin

Line 155: Procedure post_delete(p_rec in pay_mgr_shd.g_rec_type) is

151: -- Internal Development Use Only.
152: --
153: -- {End Of Comments}
154: -- ----------------------------------------------------------------------------
155: Procedure post_delete(p_rec in pay_mgr_shd.g_rec_type) is
156: --
157: l_proc varchar2(72) := g_package||'post_delete';
158: --
159: Begin

Line 170: p_rec in pay_mgr_shd.g_rec_type,

166: -- |---------------------------------< del >----------------------------------|
167: -- ----------------------------------------------------------------------------
168: Procedure del
169: (
170: p_rec in pay_mgr_shd.g_rec_type,
171: p_validate in boolean default false
172: ) is
173: --
174: l_proc varchar2(72) := g_package||'del';

Line 190: pay_mgr_shd.lck

186: End If;
187: --
188: -- We must lock the row which we need to delete.
189: --
190: pay_mgr_shd.lck
191: (
192: p_rec.magnetic_block_id,
193: p_rec.sequence
194: );

Line 238: l_rec pay_mgr_shd.g_rec_type;

234: p_sequence in number,
235: p_validate in boolean default false
236: ) is
237: --
238: l_rec pay_mgr_shd.g_rec_type;
239: l_proc varchar2(72) := g_package||'del';
240: --
241: Begin
242: hr_utility.set_location('Entering:'||l_proc, 5);