APPS.PAY_AMP_INS dependencies on PAY_AMP_SHD

Line 78: (p_rec in out nocopy pay_amp_shd.g_rec_type

74: --
75: -- {End Of Comments}
76: -- ----------------------------------------------------------------------------
77: Procedure insert_dml
78: (p_rec in out nocopy pay_amp_shd.g_rec_type
79: ) is
80: --
81: l_proc varchar2(72);
82: --

Line 89: pay_amp_shd.g_api_dml := true; -- Set the api dml status

85: --
86: hr_utility.set_location('Entering:'||l_proc, 5);
87: p_rec.object_version_number := 1; -- Initialise the object version
88: --
89: pay_amp_shd.g_api_dml := true; -- Set the api dml status
90: --
91: -- Insert the row into: pay_au_module_parameters
92: --
93: insert into pay_au_module_parameters

Line 128: pay_amp_shd.g_api_dml := false; -- Unset the api dml status

124: ,p_rec.constant_value
125: ,p_rec.object_version_number
126: );
127: --
128: pay_amp_shd.g_api_dml := false; -- Unset the api dml status
129: --
130: hr_utility.set_location(' Leaving:'||l_proc, 10);
131: Exception
132: When hr_api.check_integrity_violated Then

Line 134: pay_amp_shd.g_api_dml := false; -- Unset the api dml status

130: hr_utility.set_location(' Leaving:'||l_proc, 10);
131: Exception
132: When hr_api.check_integrity_violated Then
133: -- A check constraint has been violated
134: pay_amp_shd.g_api_dml := false; -- Unset the api dml status
135: pay_amp_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.parent_integrity_violated Then
138: -- Parent integrity has been violated

Line 135: pay_amp_shd.constraint_error

131: Exception
132: When hr_api.check_integrity_violated Then
133: -- A check constraint has been violated
134: pay_amp_shd.g_api_dml := false; -- Unset the api dml status
135: pay_amp_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.parent_integrity_violated Then
138: -- Parent integrity has been violated
139: pay_amp_shd.g_api_dml := false; -- Unset the api dml status

Line 139: pay_amp_shd.g_api_dml := false; -- Unset the api dml status

135: pay_amp_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.parent_integrity_violated Then
138: -- Parent integrity has been violated
139: pay_amp_shd.g_api_dml := false; -- Unset the api dml status
140: pay_amp_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated

Line 140: pay_amp_shd.constraint_error

136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.parent_integrity_violated Then
138: -- Parent integrity has been violated
139: pay_amp_shd.g_api_dml := false; -- Unset the api dml status
140: pay_amp_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
144: pay_amp_shd.g_api_dml := false; -- Unset the api dml status

Line 144: pay_amp_shd.g_api_dml := false; -- Unset the api dml status

140: pay_amp_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
144: pay_amp_shd.g_api_dml := false; -- Unset the api dml status
145: pay_amp_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When Others Then
148: pay_amp_shd.g_api_dml := false; -- Unset the api dml status

Line 145: pay_amp_shd.constraint_error

141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
144: pay_amp_shd.g_api_dml := false; -- Unset the api dml status
145: pay_amp_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When Others Then
148: pay_amp_shd.g_api_dml := false; -- Unset the api dml status
149: Raise;

Line 148: pay_amp_shd.g_api_dml := false; -- Unset the api dml status

144: pay_amp_shd.g_api_dml := false; -- Unset the api dml status
145: pay_amp_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When Others Then
148: pay_amp_shd.g_api_dml := false; -- Unset the api dml status
149: Raise;
150: End insert_dml;
151: --
152: -- ----------------------------------------------------------------------------

Line 190: (p_rec in out nocopy pay_amp_shd.g_rec_type

186: --
187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189: Procedure pre_insert
190: (p_rec in out nocopy pay_amp_shd.g_rec_type
191: ) is
192: --
193: Cursor C_Sel1 is select pay_au_module_parameters_s.nextval from sys.dual;
194: --

Line 279: (p_rec in pay_amp_shd.g_rec_type

275: --
276: -- {End Of Comments}
277: -- ----------------------------------------------------------------------------
278: Procedure post_insert
279: (p_rec in pay_amp_shd.g_rec_type
280: ) is
281: --
282: l_proc varchar2(72);
283: --

Line 296: (p_rec in out nocopy pay_amp_shd.g_rec_type

292: -- ----------------------------------------------------------------------------
293: -- |---------------------------------< ins >----------------------------------|
294: -- ----------------------------------------------------------------------------
295: Procedure ins
296: (p_rec in out nocopy pay_amp_shd.g_rec_type
297: ) is
298: --
299: l_proc varchar2(72);
300: --

Line 356: l_rec pay_amp_shd.g_rec_type;

352: ,p_module_parameter_id out nocopy number
353: ,p_object_version_number out nocopy number
354: ) is
355: --
356: l_rec pay_amp_shd.g_rec_type;
357: l_proc varchar2(72);
358: --
359: Begin
360: l_proc := g_package||'ins';

Line 368: pay_amp_shd.convert_args

364: -- Call conversion function to turn arguments into the
365: -- p_rec structure.
366: --
367: l_rec :=
368: pay_amp_shd.convert_args
369: (null
370: ,p_module_id
371: ,p_internal_name
372: ,p_data_type