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_UPD dependencies on PAY_PUC_SHD

Line 55: (p_rec in out nocopy pay_puc_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pay_puc_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 66: pay_puc_shd.g_api_dml := true; -- Set the api dml status

62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: pay_puc_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the pay_user_columns Row
69: --
70: update pay_user_columns

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

73: ,user_column_name = p_rec.user_column_name
74: ,object_version_number = p_rec.object_version_number
75: where user_column_id = p_rec.user_column_id;
76: --
77: pay_puc_shd.g_api_dml := false; -- Unset the api dml status
78: --
79: hr_utility.set_location(' Leaving:'||l_proc, 10);
80: --
81: Exception

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

80: --
81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
84: pay_puc_shd.g_api_dml := false; -- Unset the api dml status
85: pay_puc_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated

Line 85: pay_puc_shd.constraint_error

81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
84: pay_puc_shd.g_api_dml := false; -- Unset the api dml status
85: pay_puc_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: pay_puc_shd.g_api_dml := false; -- Unset the api dml status

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

85: pay_puc_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: pay_puc_shd.g_api_dml := false; -- Unset the api dml status
90: pay_puc_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.unique_integrity_violated Then
93: -- Unique integrity has been violated

Line 90: pay_puc_shd.constraint_error

86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: pay_puc_shd.g_api_dml := false; -- Unset the api dml status
90: pay_puc_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.unique_integrity_violated Then
93: -- Unique integrity has been violated
94: pay_puc_shd.g_api_dml := false; -- Unset the api dml status

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

90: pay_puc_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.unique_integrity_violated Then
93: -- Unique integrity has been violated
94: pay_puc_shd.g_api_dml := false; -- Unset the api dml status
95: pay_puc_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When Others Then
98: pay_puc_shd.g_api_dml := false; -- Unset the api dml status

Line 95: pay_puc_shd.constraint_error

91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.unique_integrity_violated Then
93: -- Unique integrity has been violated
94: pay_puc_shd.g_api_dml := false; -- Unset the api dml status
95: pay_puc_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When Others Then
98: pay_puc_shd.g_api_dml := false; -- Unset the api dml status
99: Raise;

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

94: pay_puc_shd.g_api_dml := false; -- Unset the api dml status
95: pay_puc_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When Others Then
98: pay_puc_shd.g_api_dml := false; -- Unset the api dml status
99: Raise;
100: End update_dml;
101: --
102: -- ----------------------------------------------------------------------------

Line 135: (p_rec in pay_puc_shd.g_rec_type

131: --
132: -- {End Of Comments}
133: -- ----------------------------------------------------------------------------
134: Procedure pre_update
135: (p_rec in pay_puc_shd.g_rec_type
136: ) is
137: --
138: l_proc varchar2(72) := g_package||'pre_update';
139: --

Line 179: (p_rec in pay_puc_shd.g_rec_type

175: --
176: -- {End Of Comments}
177: -- ----------------------------------------------------------------------------
178: Procedure post_update
179: (p_rec in pay_puc_shd.g_rec_type
180: ,p_formula_warning in boolean
181: ) is
182: --
183: l_proc varchar2(72) := g_package||'post_update';

Line 201: => pay_puc_shd.g_old_rec.business_group_id

197: => p_rec.object_version_number
198: ,p_formula_warning
199: => p_formula_warning
200: ,p_business_group_id_o
201: => pay_puc_shd.g_old_rec.business_group_id
202: ,p_legislation_code_o
203: => pay_puc_shd.g_old_rec.legislation_code
204: ,p_user_table_id_o
205: => pay_puc_shd.g_old_rec.user_table_id

Line 203: => pay_puc_shd.g_old_rec.legislation_code

199: => p_formula_warning
200: ,p_business_group_id_o
201: => pay_puc_shd.g_old_rec.business_group_id
202: ,p_legislation_code_o
203: => pay_puc_shd.g_old_rec.legislation_code
204: ,p_user_table_id_o
205: => pay_puc_shd.g_old_rec.user_table_id
206: ,p_formula_id_o
207: => pay_puc_shd.g_old_rec.formula_id

Line 205: => pay_puc_shd.g_old_rec.user_table_id

201: => pay_puc_shd.g_old_rec.business_group_id
202: ,p_legislation_code_o
203: => pay_puc_shd.g_old_rec.legislation_code
204: ,p_user_table_id_o
205: => pay_puc_shd.g_old_rec.user_table_id
206: ,p_formula_id_o
207: => pay_puc_shd.g_old_rec.formula_id
208: ,p_user_column_name_o
209: => pay_puc_shd.g_old_rec.user_column_name

Line 207: => pay_puc_shd.g_old_rec.formula_id

203: => pay_puc_shd.g_old_rec.legislation_code
204: ,p_user_table_id_o
205: => pay_puc_shd.g_old_rec.user_table_id
206: ,p_formula_id_o
207: => pay_puc_shd.g_old_rec.formula_id
208: ,p_user_column_name_o
209: => pay_puc_shd.g_old_rec.user_column_name
210: ,p_object_version_number_o
211: => pay_puc_shd.g_old_rec.object_version_number

Line 209: => pay_puc_shd.g_old_rec.user_column_name

205: => pay_puc_shd.g_old_rec.user_table_id
206: ,p_formula_id_o
207: => pay_puc_shd.g_old_rec.formula_id
208: ,p_user_column_name_o
209: => pay_puc_shd.g_old_rec.user_column_name
210: ,p_object_version_number_o
211: => pay_puc_shd.g_old_rec.object_version_number
212: );
213: --

Line 211: => pay_puc_shd.g_old_rec.object_version_number

207: => pay_puc_shd.g_old_rec.formula_id
208: ,p_user_column_name_o
209: => pay_puc_shd.g_old_rec.user_column_name
210: ,p_object_version_number_o
211: => pay_puc_shd.g_old_rec.object_version_number
212: );
213: --
214: exception
215: --

Line 271: (p_rec in out nocopy pay_puc_shd.g_rec_type

267: --
268: -- {End Of Comments}
269: -- ----------------------------------------------------------------------------
270: Procedure convert_defs
271: (p_rec in out nocopy pay_puc_shd.g_rec_type
272: ) is
273: --
274: Begin
275: --

Line 283: pay_puc_shd.g_old_rec.business_group_id;

279: -- is being used then we must set to the 'current' argument value.
280: --
281: If (p_rec.business_group_id = hr_api.g_number) then
282: p_rec.business_group_id :=
283: pay_puc_shd.g_old_rec.business_group_id;
284: End If;
285: If (p_rec.legislation_code = hr_api.g_varchar2) then
286: p_rec.legislation_code :=
287: pay_puc_shd.g_old_rec.legislation_code;

Line 287: pay_puc_shd.g_old_rec.legislation_code;

283: pay_puc_shd.g_old_rec.business_group_id;
284: End If;
285: If (p_rec.legislation_code = hr_api.g_varchar2) then
286: p_rec.legislation_code :=
287: pay_puc_shd.g_old_rec.legislation_code;
288: End If;
289: If (p_rec.user_table_id = hr_api.g_number) then
290: p_rec.user_table_id :=
291: pay_puc_shd.g_old_rec.user_table_id;

Line 291: pay_puc_shd.g_old_rec.user_table_id;

287: pay_puc_shd.g_old_rec.legislation_code;
288: End If;
289: If (p_rec.user_table_id = hr_api.g_number) then
290: p_rec.user_table_id :=
291: pay_puc_shd.g_old_rec.user_table_id;
292: End If;
293: If (p_rec.formula_id = hr_api.g_number) then
294: p_rec.formula_id :=
295: pay_puc_shd.g_old_rec.formula_id;

Line 295: pay_puc_shd.g_old_rec.formula_id;

291: pay_puc_shd.g_old_rec.user_table_id;
292: End If;
293: If (p_rec.formula_id = hr_api.g_number) then
294: p_rec.formula_id :=
295: pay_puc_shd.g_old_rec.formula_id;
296: End If;
297: If (p_rec.user_column_name = hr_api.g_varchar2) then
298: p_rec.user_column_name :=
299: pay_puc_shd.g_old_rec.user_column_name;

Line 299: pay_puc_shd.g_old_rec.user_column_name;

295: pay_puc_shd.g_old_rec.formula_id;
296: End If;
297: If (p_rec.user_column_name = hr_api.g_varchar2) then
298: p_rec.user_column_name :=
299: pay_puc_shd.g_old_rec.user_column_name;
300: End If;
301: --
302: End convert_defs;
303: --

Line 308: (p_rec in out nocopy pay_puc_shd.g_rec_type

304: -- ----------------------------------------------------------------------------
305: -- |---------------------------------< upd >----------------------------------|
306: -- ----------------------------------------------------------------------------
307: Procedure upd
308: (p_rec in out nocopy pay_puc_shd.g_rec_type
309: ,p_formula_warning out nocopy boolean
310: ) is
311: --
312: l_proc varchar2(72) := g_package||'upd';

Line 320: pay_puc_shd.lck

316: hr_utility.set_location('Entering:'||l_proc, 5);
317: --
318: -- We must lock the row which we need to update.
319: --
320: pay_puc_shd.lck
321: (p_rec.user_column_id
322: ,p_rec.object_version_number
323: );
324: --

Line 372: l_rec pay_puc_shd.g_rec_type;

368: ,p_formula_id in number default hr_api.g_number
369: ,p_formula_warning out nocopy boolean
370: ) is
371: --
372: l_rec pay_puc_shd.g_rec_type;
373: l_proc varchar2(72) := g_package||'upd';
374: --
375: Begin
376: hr_utility.set_location('Entering:'||l_proc, 5);

Line 382: pay_puc_shd.convert_args

378: -- Call conversion function to turn arguments into the
379: -- l_rec structure.
380: --
381: l_rec :=
382: pay_puc_shd.convert_args
383: (p_user_column_id
384: ,hr_api.g_number
385: ,hr_api.g_varchar2
386: ,hr_api.g_number