APPS.PAY_BLT_INS dependencies on PAY_BLT_SHD

Line 124: (p_rec in out nocopy pay_blt_shd.g_rec_type

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

Line 133: pay_blt_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_blt_shd.g_api_dml := true; -- Set the api dml status
134: --
135: -- Insert the row into: pay_balance_types
136: --
137: insert into pay_balance_types

Line 216: pay_blt_shd.g_api_dml := false; -- Unset the api dml status

212: ,p_rec.base_balance_type_id
213: ,p_rec.input_value_id
214: );
215: --
216: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
217: --
218: hr_utility.set_location(' Leaving:'||l_proc, 10);
219: Exception
220: When hr_api.check_integrity_violated Then

Line 222: pay_blt_shd.g_api_dml := false; -- Unset the api dml status

218: hr_utility.set_location(' Leaving:'||l_proc, 10);
219: Exception
220: When hr_api.check_integrity_violated Then
221: -- A check constraint has been violated
222: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
223: pay_blt_shd.constraint_error
224: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
225: When hr_api.parent_integrity_violated Then
226: -- Parent integrity has been violated

Line 223: pay_blt_shd.constraint_error

219: Exception
220: When hr_api.check_integrity_violated Then
221: -- A check constraint has been violated
222: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
223: pay_blt_shd.constraint_error
224: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
225: When hr_api.parent_integrity_violated Then
226: -- Parent integrity has been violated
227: pay_blt_shd.g_api_dml := false; -- Unset the api dml status

Line 227: pay_blt_shd.g_api_dml := false; -- Unset the api dml status

223: pay_blt_shd.constraint_error
224: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
225: When hr_api.parent_integrity_violated Then
226: -- Parent integrity has been violated
227: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
228: pay_blt_shd.constraint_error
229: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
230: When hr_api.unique_integrity_violated Then
231: -- Unique integrity has been violated

Line 228: pay_blt_shd.constraint_error

224: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
225: When hr_api.parent_integrity_violated Then
226: -- Parent integrity has been violated
227: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
228: pay_blt_shd.constraint_error
229: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
230: When hr_api.unique_integrity_violated Then
231: -- Unique integrity has been violated
232: pay_blt_shd.g_api_dml := false; -- Unset the api dml status

Line 232: pay_blt_shd.g_api_dml := false; -- Unset the api dml status

228: pay_blt_shd.constraint_error
229: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
230: When hr_api.unique_integrity_violated Then
231: -- Unique integrity has been violated
232: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
233: pay_blt_shd.constraint_error
234: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
235: When Others Then
236: pay_blt_shd.g_api_dml := false; -- Unset the api dml status

Line 233: pay_blt_shd.constraint_error

229: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
230: When hr_api.unique_integrity_violated Then
231: -- Unique integrity has been violated
232: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
233: pay_blt_shd.constraint_error
234: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
235: When Others Then
236: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
237: Raise;

Line 236: pay_blt_shd.g_api_dml := false; -- Unset the api dml status

232: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
233: pay_blt_shd.constraint_error
234: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
235: When Others Then
236: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
237: Raise;
238: End insert_dml;
239: --
240: -- ----------------------------------------------------------------------------

Line 278: (p_rec in out nocopy pay_blt_shd.g_rec_type

274: --
275: -- {End Of Comments}
276: -- ----------------------------------------------------------------------------
277: Procedure pre_insert
278: (p_rec in out nocopy pay_blt_shd.g_rec_type
279: ) is
280: --
281: Cursor C_Sel1 is select pay_balance_types_s.nextval from sys.dual;
282: --

Line 366: ,p_rec in pay_blt_shd.g_rec_type

362: -- {End Of Comments}
363: -- ----------------------------------------------------------------------------
364: Procedure post_insert
365: (p_effective_date in date
366: ,p_rec in pay_blt_shd.g_rec_type
367: ) is
368: --
369: l_proc varchar2(72) := g_package||'post_insert';
370: --

Line 477: ,p_rec in out nocopy pay_blt_shd.g_rec_type

473: -- |---------------------------------< ins >----------------------------------|
474: -- ----------------------------------------------------------------------------
475: Procedure ins
476: (p_effective_date in date
477: ,p_rec in out nocopy pay_blt_shd.g_rec_type
478: ) is
479: --
480: l_proc varchar2(72) := g_package||'ins';
481: --

Line 573: l_rec pay_blt_shd.g_rec_type;

569: ,p_balance_type_id out nocopy number
570: ,p_object_version_number out nocopy number
571: ) is
572: --
573: l_rec pay_blt_shd.g_rec_type;
574: l_proc varchar2(72) := g_package||'ins';
575: l_balance_name_warning number;
576: --
577: Begin

Line 584: pay_blt_shd.convert_args

580: -- Call conversion function to turn arguments into the
581: -- p_rec structure.
582: --
583: l_rec :=
584: pay_blt_shd.convert_args
585: (null
586: ,p_business_group_id
587: ,p_legislation_code
588: ,p_currency_code