eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PUC_INS dependencies on PAY_PUC_SHD

Line 124: (p_rec in out nocopy pay_puc_shd.g_rec_type

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

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

Line 156: pay_puc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 162: pay_puc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 163: pay_puc_shd.constraint_error

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

Line 167: pay_puc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 168: pay_puc_shd.constraint_error

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

Line 172: pay_puc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 173: pay_puc_shd.constraint_error

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

Line 176: pay_puc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 218: (p_rec in out nocopy pay_puc_shd.g_rec_type

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

Line 305: (p_rec in pay_puc_shd.g_rec_type

301: --
302: -- {End Of Comments}
303: -- ----------------------------------------------------------------------------
304: Procedure post_insert
305: (p_rec in pay_puc_shd.g_rec_type
306: ) is
307: --
308: l_proc varchar2(72) := g_package||'post_insert';
309: --

Line 354: (p_rec in out nocopy pay_puc_shd.g_rec_type

350: -- ----------------------------------------------------------------------------
351: -- |---------------------------------< ins >----------------------------------|
352: -- ----------------------------------------------------------------------------
353: Procedure ins
354: (p_rec in out nocopy pay_puc_shd.g_rec_type
355: ) is
356: --
357: l_proc varchar2(72) := g_package||'ins';
358: --

Line 404: l_rec pay_puc_shd.g_rec_type;

400: ,p_user_column_id out nocopy number
401: ,p_object_version_number out nocopy number
402: ) is
403: --
404: l_rec pay_puc_shd.g_rec_type;
405: l_proc varchar2(72) := g_package||'ins';
406: --
407: Begin
408: hr_utility.set_location('Entering:'||l_proc, 5);

Line 414: pay_puc_shd.convert_args

410: -- Call conversion function to turn arguments into the
411: -- p_rec structure.
412: --
413: l_rec :=
414: pay_puc_shd.convert_args
415: (null
416: ,p_business_group_id
417: ,p_legislation_code
418: ,p_user_table_id