APPS.PAY_AMO_INS dependencies on PAY_AMO_SHD

Line 126: (p_rec in out nocopy pay_amo_shd.g_rec_type

122: --
123: -- {End Of Comments}
124: -- ----------------------------------------------------------------------------
125: Procedure insert_dml
126: (p_rec in out nocopy pay_amo_shd.g_rec_type
127: ) is
128: --
129: l_proc varchar2(72);
130: --

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

133: --
134: hr_utility.set_location('Entering:'||l_proc, 5);
135: p_rec.object_version_number := 1; -- Initialise the object version
136: --
137: pay_amo_shd.g_api_dml := true; -- Set the api dml status
138: --
139: -- Insert the row into: pay_au_modules
140: --
141: insert into pay_au_modules

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

164: ,p_rec.formula_name
165: ,p_rec.object_version_number
166: );
167: --
168: pay_amo_shd.g_api_dml := false; -- Unset the api dml status
169: --
170: hr_utility.set_location(' Leaving:'||l_proc, 10);
171: Exception
172: When hr_api.check_integrity_violated Then

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

170: hr_utility.set_location(' Leaving:'||l_proc, 10);
171: Exception
172: When hr_api.check_integrity_violated Then
173: -- A check constraint has been violated
174: pay_amo_shd.g_api_dml := false; -- Unset the api dml status
175: pay_amo_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When hr_api.parent_integrity_violated Then
178: -- Parent integrity has been violated

Line 175: pay_amo_shd.constraint_error

171: Exception
172: When hr_api.check_integrity_violated Then
173: -- A check constraint has been violated
174: pay_amo_shd.g_api_dml := false; -- Unset the api dml status
175: pay_amo_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When hr_api.parent_integrity_violated Then
178: -- Parent integrity has been violated
179: pay_amo_shd.g_api_dml := false; -- Unset the api dml status

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

175: pay_amo_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When hr_api.parent_integrity_violated Then
178: -- Parent integrity has been violated
179: pay_amo_shd.g_api_dml := false; -- Unset the api dml status
180: pay_amo_shd.constraint_error
181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
182: When hr_api.unique_integrity_violated Then
183: -- Unique integrity has been violated

Line 180: pay_amo_shd.constraint_error

176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When hr_api.parent_integrity_violated Then
178: -- Parent integrity has been violated
179: pay_amo_shd.g_api_dml := false; -- Unset the api dml status
180: pay_amo_shd.constraint_error
181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
182: When hr_api.unique_integrity_violated Then
183: -- Unique integrity has been violated
184: pay_amo_shd.g_api_dml := false; -- Unset the api dml status

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

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

Line 185: pay_amo_shd.constraint_error

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

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

184: pay_amo_shd.g_api_dml := false; -- Unset the api dml status
185: pay_amo_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When Others Then
188: pay_amo_shd.g_api_dml := false; -- Unset the api dml status
189: Raise;
190: End insert_dml;
191: --
192: -- ----------------------------------------------------------------------------

Line 230: (p_rec in out nocopy pay_amo_shd.g_rec_type

226: --
227: -- {End Of Comments}
228: -- ----------------------------------------------------------------------------
229: Procedure pre_insert
230: (p_rec in out nocopy pay_amo_shd.g_rec_type
231: ) is
232: --
233: Cursor C_Sel1 is select pay_au_modules_s.nextval from sys.dual;
234: --

Line 319: (p_rec in pay_amo_shd.g_rec_type

315: --
316: -- {End Of Comments}
317: -- ----------------------------------------------------------------------------
318: Procedure post_insert
319: (p_rec in pay_amo_shd.g_rec_type
320: ) is
321: --
322: l_proc varchar2(72);
323: --

Line 345: (p_rec in out nocopy pay_amo_shd.g_rec_type

341: -- ----------------------------------------------------------------------------
342: -- |---------------------------------< ins >----------------------------------|
343: -- ----------------------------------------------------------------------------
344: Procedure ins
345: (p_rec in out nocopy pay_amo_shd.g_rec_type
346: ) is
347: --
348: l_proc varchar2(72);
349: --

Line 401: l_rec pay_amo_shd.g_rec_type;

397: ,p_module_id out nocopy number
398: ,p_object_version_number out nocopy number
399: ) is
400: --
401: l_rec pay_amo_shd.g_rec_type;
402: l_proc varchar2(72);
403: --
404: Begin
405: l_proc := g_package||'ins';

Line 413: pay_amo_shd.convert_args

409: -- Call conversion function to turn arguments into the
410: -- p_rec structure.
411: --
412: l_rec :=
413: pay_amo_shd.convert_args
414: (null
415: ,p_name
416: ,p_enabled_flag
417: ,p_module_type_id