APPS.PAY_TDF_INS dependencies on PAY_TDF_SHD

Line 124: (p_rec in out nocopy pay_tdf_shd.g_rec_type

120: --
121: -- {End Of Comments}
122: -- ----------------------------------------------------------------------------
123: Procedure insert_dml
124: (p_rec in out nocopy pay_tdf_shd.g_rec_type
125: ) is
126: --
127: l_proc varchar2(72) := g_package||'insert_dml';
128: --

Line 133: pay_tdf_shd.g_api_dml := true; -- Set the api dml status

129: Begin
130: hr_utility.set_location('Entering:'||l_proc, 5);
131: p_rec.object_version_number := 1; -- Initialise the object version
132: --
133: pay_tdf_shd.g_api_dml := true; -- Set the api dml status
134: --
135: -- Insert the row into: pay_time_definitions
136: --
137: insert into pay_time_definitions

Line 174: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status

170: ,p_rec.creator_type
171: ,p_rec.object_version_number
172: );
173: --
174: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
175: --
176: hr_utility.set_location(' Leaving:'||l_proc, 10);
177: Exception
178: When hr_api.check_integrity_violated Then

Line 180: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status

176: hr_utility.set_location(' Leaving:'||l_proc, 10);
177: Exception
178: When hr_api.check_integrity_violated Then
179: -- A check constraint has been violated
180: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
181: pay_tdf_shd.constraint_error
182: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
183: When hr_api.parent_integrity_violated Then
184: -- Parent integrity has been violated

Line 181: pay_tdf_shd.constraint_error

177: Exception
178: When hr_api.check_integrity_violated Then
179: -- A check constraint has been violated
180: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
181: pay_tdf_shd.constraint_error
182: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
183: When hr_api.parent_integrity_violated Then
184: -- Parent integrity has been violated
185: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status

Line 185: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status

181: pay_tdf_shd.constraint_error
182: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
183: When hr_api.parent_integrity_violated Then
184: -- Parent integrity has been violated
185: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
186: pay_tdf_shd.constraint_error
187: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
188: When hr_api.unique_integrity_violated Then
189: -- Unique integrity has been violated

Line 186: pay_tdf_shd.constraint_error

182: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
183: When hr_api.parent_integrity_violated Then
184: -- Parent integrity has been violated
185: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
186: pay_tdf_shd.constraint_error
187: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
188: When hr_api.unique_integrity_violated Then
189: -- Unique integrity has been violated
190: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status

Line 190: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status

186: pay_tdf_shd.constraint_error
187: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
188: When hr_api.unique_integrity_violated Then
189: -- Unique integrity has been violated
190: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
191: pay_tdf_shd.constraint_error
192: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
193: When Others Then
194: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status

Line 191: pay_tdf_shd.constraint_error

187: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
188: When hr_api.unique_integrity_violated Then
189: -- Unique integrity has been violated
190: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
191: pay_tdf_shd.constraint_error
192: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
193: When Others Then
194: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
195: Raise;

Line 194: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status

190: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
191: pay_tdf_shd.constraint_error
192: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
193: When Others Then
194: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
195: Raise;
196: End insert_dml;
197: --
198: -- ----------------------------------------------------------------------------

Line 236: (p_rec in out nocopy pay_tdf_shd.g_rec_type

232: --
233: -- {End Of Comments}
234: -- ----------------------------------------------------------------------------
235: Procedure pre_insert
236: (p_rec in out nocopy pay_tdf_shd.g_rec_type
237: ) is
238: --
239: Cursor C_Sel1 is select pay_time_definitions_s.nextval from sys.dual;
240: --

Line 324: ,p_rec in pay_tdf_shd.g_rec_type

320: -- {End Of Comments}
321: -- ----------------------------------------------------------------------------
322: Procedure post_insert
323: (p_effective_date in date
324: ,p_rec in pay_tdf_shd.g_rec_type
325: ) is
326: --
327: l_proc varchar2(72) := g_package||'post_insert';
328: --

Line 393: ,p_rec in out nocopy pay_tdf_shd.g_rec_type

389: -- |---------------------------------< ins >----------------------------------|
390: -- ----------------------------------------------------------------------------
391: Procedure ins
392: (p_effective_date in date
393: ,p_rec in out nocopy pay_tdf_shd.g_rec_type
394: ) is
395: --
396: l_proc varchar2(72) := g_package||'ins';
397: --

Line 455: l_rec pay_tdf_shd.g_rec_type;

451: ,p_time_definition_id out nocopy number
452: ,p_object_version_number out nocopy number
453: ) is
454: --
455: l_rec pay_tdf_shd.g_rec_type;
456: l_proc varchar2(72) := g_package||'ins';
457: --
458: Begin
459: hr_utility.set_location('Entering:'||l_proc, 5);

Line 465: pay_tdf_shd.convert_args

461: -- Call conversion function to turn arguments into the
462: -- p_rec structure.
463: --
464: l_rec :=
465: pay_tdf_shd.convert_args
466: (null
467: ,p_short_name
468: ,p_definition_name
469: ,p_period_type