APPS.PAY_PEU_INS dependencies on PAY_PEU_SHD

Line 54: (p_rec in out nocopy pay_peu_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy pay_peu_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --

Line 63: pay_peu_shd.g_api_dml := true; -- Set the api dml status

59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: p_rec.object_version_number := 1; -- Initialise the object version
62: --
63: pay_peu_shd.g_api_dml := true; -- Set the api dml status
64: --
65: -- Insert the row into: pay_event_updates
66: --
67: insert into pay_event_updates

Line 90: pay_peu_shd.g_api_dml := false; -- Unset the api dml status

86: ,p_rec.event_type
87: ,p_rec.object_version_number
88: );
89: --
90: pay_peu_shd.g_api_dml := false; -- Unset the api dml status
91: --
92: hr_utility.set_location(' Leaving:'||l_proc, 10);
93: Exception
94: When hr_api.check_integrity_violated Then

Line 96: pay_peu_shd.g_api_dml := false; -- Unset the api dml status

92: hr_utility.set_location(' Leaving:'||l_proc, 10);
93: Exception
94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: pay_peu_shd.g_api_dml := false; -- Unset the api dml status
97: pay_peu_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated

Line 97: pay_peu_shd.constraint_error

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

Line 101: pay_peu_shd.g_api_dml := false; -- Unset the api dml status

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

Line 102: pay_peu_shd.constraint_error

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

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

102: pay_peu_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: pay_peu_shd.g_api_dml := false; -- Unset the api dml status
107: pay_peu_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then
110: pay_peu_shd.g_api_dml := false; -- Unset the api dml status

Line 107: pay_peu_shd.constraint_error

103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: pay_peu_shd.g_api_dml := false; -- Unset the api dml status
107: pay_peu_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then
110: pay_peu_shd.g_api_dml := false; -- Unset the api dml status
111: Raise;

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

106: pay_peu_shd.g_api_dml := false; -- Unset the api dml status
107: pay_peu_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then
110: pay_peu_shd.g_api_dml := false; -- Unset the api dml status
111: Raise;
112: End insert_dml;
113: --
114: -- ----------------------------------------------------------------------------

Line 152: (p_rec in out nocopy pay_peu_shd.g_rec_type

148: --
149: -- {End Of Comments}
150: -- ----------------------------------------------------------------------------
151: Procedure pre_insert
152: (p_rec in out nocopy pay_peu_shd.g_rec_type
153: ) is
154: --
155: l_proc varchar2(72) := g_package||'pre_insert';
156: --

Line 206: ,p_rec in pay_peu_shd.g_rec_type

202: -- {End Of Comments}
203: -- ----------------------------------------------------------------------------
204: Procedure post_insert
205: (p_effective_date in date
206: ,p_rec in pay_peu_shd.g_rec_type
207: ) is
208: --
209: l_proc varchar2(72) := g_package||'post_insert';
210: --

Line 255: ,p_rec in out nocopy pay_peu_shd.g_rec_type

251: -- |---------------------------------< ins >----------------------------------|
252: -- ----------------------------------------------------------------------------
253: Procedure ins
254: (p_effective_date in date
255: ,p_rec in out nocopy pay_peu_shd.g_rec_type
256: ) is
257: --
258: l_proc varchar2(72) := g_package||'ins';
259: --

Line 304: l_rec pay_peu_shd.g_rec_type;

300: ,p_event_update_id out nocopy number
301: ,p_object_version_number out nocopy number
302: ) is
303: --
304: l_rec pay_peu_shd.g_rec_type;
305: l_proc varchar2(72) := g_package||'ins';
306: --
307: Begin
308: hr_utility.set_location('Entering:'||l_proc, 5);

Line 314: pay_peu_shd.convert_args

310: -- Call conversion function to turn arguments into the
311: -- p_rec structure.
312: --
313: l_rec :=
314: pay_peu_shd.convert_args
315: (null
316: ,p_table_name
317: ,p_column_name
318: ,p_dated_table_id