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_PUT_UPD dependencies on PAY_PUT_SHD

Line 55: (p_rec in out nocopy pay_put_shd.g_rec_type

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

Line 66: pay_put_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_put_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the pay_user_tables Row
69: --
70: update pay_user_tables

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

73: ,user_row_title = p_rec.user_row_title
74: ,object_version_number = p_rec.object_version_number
75: where user_table_id = p_rec.user_table_id;
76: --
77: pay_put_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_put_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_put_shd.g_api_dml := false; -- Unset the api dml status
85: pay_put_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_put_shd.constraint_error

81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
84: pay_put_shd.g_api_dml := false; -- Unset the api dml status
85: pay_put_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_put_shd.g_api_dml := false; -- Unset the api dml status

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

85: pay_put_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_put_shd.g_api_dml := false; -- Unset the api dml status
90: pay_put_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_put_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_put_shd.g_api_dml := false; -- Unset the api dml status
90: pay_put_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_put_shd.g_api_dml := false; -- Unset the api dml status

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

90: pay_put_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_put_shd.g_api_dml := false; -- Unset the api dml status
95: pay_put_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When Others Then
98: pay_put_shd.g_api_dml := false; -- Unset the api dml status

Line 95: pay_put_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_put_shd.g_api_dml := false; -- Unset the api dml status
95: pay_put_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When Others Then
98: pay_put_shd.g_api_dml := false; -- Unset the api dml status
99: Raise;

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

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

Line 135: (p_rec in pay_put_shd.g_rec_type

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

Line 180: ,p_rec in pay_put_shd.g_rec_type

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

Line 195: => pay_put_shd.g_old_rec.business_group_id

191: => p_effective_date
192: ,p_user_table_id
193: => p_rec.user_table_id
194: ,p_business_group_id_o
195: => pay_put_shd.g_old_rec.business_group_id
196: ,p_legislation_code_o
197: => pay_put_shd.g_old_rec.legislation_code
198: ,p_range_or_match_o
199: => pay_put_shd.g_old_rec.range_or_match

Line 197: => pay_put_shd.g_old_rec.legislation_code

193: => p_rec.user_table_id
194: ,p_business_group_id_o
195: => pay_put_shd.g_old_rec.business_group_id
196: ,p_legislation_code_o
197: => pay_put_shd.g_old_rec.legislation_code
198: ,p_range_or_match_o
199: => pay_put_shd.g_old_rec.range_or_match
200: ,p_user_key_units_o
201: => pay_put_shd.g_old_rec.user_key_units

Line 199: => pay_put_shd.g_old_rec.range_or_match

195: => pay_put_shd.g_old_rec.business_group_id
196: ,p_legislation_code_o
197: => pay_put_shd.g_old_rec.legislation_code
198: ,p_range_or_match_o
199: => pay_put_shd.g_old_rec.range_or_match
200: ,p_user_key_units_o
201: => pay_put_shd.g_old_rec.user_key_units
202: ,p_user_table_name
203: => p_rec.user_table_name

Line 201: => pay_put_shd.g_old_rec.user_key_units

197: => pay_put_shd.g_old_rec.legislation_code
198: ,p_range_or_match_o
199: => pay_put_shd.g_old_rec.range_or_match
200: ,p_user_key_units_o
201: => pay_put_shd.g_old_rec.user_key_units
202: ,p_user_table_name
203: => p_rec.user_table_name
204: ,p_user_table_name_o
205: => pay_put_shd.g_old_rec.user_table_name

Line 205: => pay_put_shd.g_old_rec.user_table_name

201: => pay_put_shd.g_old_rec.user_key_units
202: ,p_user_table_name
203: => p_rec.user_table_name
204: ,p_user_table_name_o
205: => pay_put_shd.g_old_rec.user_table_name
206: ,p_user_row_title
207: => p_rec.user_row_title
208: ,p_user_row_title_o
209: => pay_put_shd.g_old_rec.user_row_title

Line 209: => pay_put_shd.g_old_rec.user_row_title

205: => pay_put_shd.g_old_rec.user_table_name
206: ,p_user_row_title
207: => p_rec.user_row_title
208: ,p_user_row_title_o
209: => pay_put_shd.g_old_rec.user_row_title
210: ,p_object_version_number
211: => p_rec.object_version_number
212: ,p_object_version_number_o
213: => pay_put_shd.g_old_rec.object_version_number

Line 213: => pay_put_shd.g_old_rec.object_version_number

209: => pay_put_shd.g_old_rec.user_row_title
210: ,p_object_version_number
211: => p_rec.object_version_number
212: ,p_object_version_number_o
213: => pay_put_shd.g_old_rec.object_version_number
214: );
215: --
216: exception
217: --

Line 273: (p_rec in out nocopy pay_put_shd.g_rec_type

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

Line 285: pay_put_shd.g_old_rec.business_group_id;

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

Line 289: pay_put_shd.g_old_rec.legislation_code;

285: pay_put_shd.g_old_rec.business_group_id;
286: End If;
287: If (p_rec.legislation_code = hr_api.g_varchar2) then
288: p_rec.legislation_code :=
289: pay_put_shd.g_old_rec.legislation_code;
290: End If;
291: If (p_rec.range_or_match = hr_api.g_varchar2) then
292: p_rec.range_or_match :=
293: pay_put_shd.g_old_rec.range_or_match;

Line 293: pay_put_shd.g_old_rec.range_or_match;

289: pay_put_shd.g_old_rec.legislation_code;
290: End If;
291: If (p_rec.range_or_match = hr_api.g_varchar2) then
292: p_rec.range_or_match :=
293: pay_put_shd.g_old_rec.range_or_match;
294: End If;
295: If (p_rec.user_key_units = hr_api.g_varchar2) then
296: p_rec.user_key_units :=
297: pay_put_shd.g_old_rec.user_key_units;

Line 297: pay_put_shd.g_old_rec.user_key_units;

293: pay_put_shd.g_old_rec.range_or_match;
294: End If;
295: If (p_rec.user_key_units = hr_api.g_varchar2) then
296: p_rec.user_key_units :=
297: pay_put_shd.g_old_rec.user_key_units;
298: End If;
299: If (p_rec.user_table_name = hr_api.g_varchar2) then
300: p_rec.user_table_name :=
301: pay_put_shd.g_old_rec.user_table_name;

Line 301: pay_put_shd.g_old_rec.user_table_name;

297: pay_put_shd.g_old_rec.user_key_units;
298: End If;
299: If (p_rec.user_table_name = hr_api.g_varchar2) then
300: p_rec.user_table_name :=
301: pay_put_shd.g_old_rec.user_table_name;
302: End If;
303: If (p_rec.user_row_title = hr_api.g_varchar2) then
304: p_rec.user_row_title :=
305: pay_put_shd.g_old_rec.user_row_title;

Line 305: pay_put_shd.g_old_rec.user_row_title;

301: pay_put_shd.g_old_rec.user_table_name;
302: End If;
303: If (p_rec.user_row_title = hr_api.g_varchar2) then
304: p_rec.user_row_title :=
305: pay_put_shd.g_old_rec.user_row_title;
306: End If;
307: --
308: End convert_defs;
309: --

Line 315: ,p_rec in out nocopy pay_put_shd.g_rec_type

311: -- |---------------------------------< upd >----------------------------------|
312: -- ----------------------------------------------------------------------------
313: Procedure upd
314: (p_effective_date in date
315: ,p_rec in out nocopy pay_put_shd.g_rec_type
316: ) is
317: --
318: l_proc varchar2(72) := g_package||'upd';
319: --

Line 325: pay_put_shd.lck

321: hr_utility.set_location('Entering:'||l_proc, 5);
322: --
323: -- We must lock the row which we need to update.
324: --
325: pay_put_shd.lck
326: (p_rec.user_table_id
327: ,p_rec.object_version_number
328: );
329: --

Line 375: l_rec pay_put_shd.g_rec_type;

371: ,p_user_table_name in varchar2 default hr_api.g_varchar2
372: ,p_user_row_title in varchar2 default hr_api.g_varchar2
373: ) is
374: --
375: l_rec pay_put_shd.g_rec_type;
376: l_proc varchar2(72) := g_package||'upd';
377: --
378: Begin
379: hr_utility.set_location('Entering:'||l_proc, 5);

Line 385: pay_put_shd.convert_args

381: -- Call conversion function to turn arguments into the
382: -- l_rec structure.
383: --
384: l_rec :=
385: pay_put_shd.convert_args
386: (p_user_table_id
387: ,hr_api.g_number
388: ,hr_api.g_varchar2
389: ,hr_api.g_varchar2