DBA Data[Home] [Help]

APPS.PAY_PUT_INS dependencies on PAY_PUT_SHD

Line 124: (p_rec in out nocopy pay_put_shd.g_rec_type

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

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

Line 158: pay_put_shd.g_api_dml := false; -- Unset the api dml status

154: ,p_rec.user_row_title
155: ,p_rec.object_version_number
156: );
157: --
158: pay_put_shd.g_api_dml := false; -- Unset the api dml status
159: --
160: hr_utility.set_location(' Leaving:'||l_proc, 10);
161: Exception
162: When hr_api.check_integrity_violated Then

Line 164: pay_put_shd.g_api_dml := false; -- Unset the api dml status

160: hr_utility.set_location(' Leaving:'||l_proc, 10);
161: Exception
162: When hr_api.check_integrity_violated Then
163: -- A check constraint has been violated
164: pay_put_shd.g_api_dml := false; -- Unset the api dml status
165: pay_put_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When hr_api.parent_integrity_violated Then
168: -- Parent integrity has been violated

Line 165: pay_put_shd.constraint_error

161: Exception
162: When hr_api.check_integrity_violated Then
163: -- A check constraint has been violated
164: pay_put_shd.g_api_dml := false; -- Unset the api dml status
165: pay_put_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When hr_api.parent_integrity_violated Then
168: -- Parent integrity has been violated
169: pay_put_shd.g_api_dml := false; -- Unset the api dml status

Line 169: pay_put_shd.g_api_dml := false; -- Unset the api dml status

165: pay_put_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When hr_api.parent_integrity_violated Then
168: -- Parent integrity has been violated
169: pay_put_shd.g_api_dml := false; -- Unset the api dml status
170: pay_put_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When hr_api.unique_integrity_violated Then
173: -- Unique integrity has been violated

Line 170: pay_put_shd.constraint_error

166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When hr_api.parent_integrity_violated Then
168: -- Parent integrity has been violated
169: pay_put_shd.g_api_dml := false; -- Unset the api dml status
170: pay_put_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When hr_api.unique_integrity_violated Then
173: -- Unique integrity has been violated
174: pay_put_shd.g_api_dml := false; -- Unset the api dml status

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

170: pay_put_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When hr_api.unique_integrity_violated Then
173: -- Unique integrity has been violated
174: pay_put_shd.g_api_dml := false; -- Unset the api dml status
175: pay_put_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When Others Then
178: pay_put_shd.g_api_dml := false; -- Unset the api dml status

Line 175: pay_put_shd.constraint_error

171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When hr_api.unique_integrity_violated Then
173: -- Unique integrity has been violated
174: pay_put_shd.g_api_dml := false; -- Unset the api dml status
175: pay_put_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When Others Then
178: pay_put_shd.g_api_dml := false; -- Unset the api dml status
179: Raise;

Line 178: pay_put_shd.g_api_dml := false; -- Unset the api dml status

174: pay_put_shd.g_api_dml := false; -- Unset the api dml status
175: pay_put_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When Others Then
178: pay_put_shd.g_api_dml := false; -- Unset the api dml status
179: Raise;
180: End insert_dml;
181: --
182: -- ----------------------------------------------------------------------------

Line 220: (p_rec in out nocopy pay_put_shd.g_rec_type

216: --
217: -- {End Of Comments}
218: -- ----------------------------------------------------------------------------
219: Procedure pre_insert
220: (p_rec in out nocopy pay_put_shd.g_rec_type
221: ) is
222: --
223: Cursor C_Sel1 is select pay_user_tables_s.nextval from sys.dual;
224: --

Line 308: ,p_rec in pay_put_shd.g_rec_type

304: -- {End Of Comments}
305: -- ----------------------------------------------------------------------------
306: Procedure post_insert
307: (p_effective_date in date
308: ,p_rec in pay_put_shd.g_rec_type
309: ) is
310: --
311: l_proc varchar2(72) := g_package||'post_insert';
312: --

Line 362: ,p_rec in out nocopy pay_put_shd.g_rec_type

358: -- |---------------------------------< ins >----------------------------------|
359: -- ----------------------------------------------------------------------------
360: Procedure ins
361: (p_effective_date in date
362: ,p_rec in out nocopy pay_put_shd.g_rec_type
363: ) is
364: --
365: l_proc varchar2(72) := g_package||'ins';
366: --

Line 416: l_rec pay_put_shd.g_rec_type;

412: ,p_user_table_id out nocopy number
413: ,p_object_version_number out nocopy number
414: ) is
415: --
416: l_rec pay_put_shd.g_rec_type;
417: l_proc varchar2(72) := g_package||'ins';
418: --
419: Begin
420: hr_utility.set_location('Entering:'||l_proc, 5);

Line 426: pay_put_shd.convert_args

422: -- Call conversion function to turn arguments into the
423: -- p_rec structure.
424: --
425: l_rec :=
426: pay_put_shd.convert_args
427: (null
428: ,p_business_group_id
429: ,p_legislation_code
430: ,p_range_or_match