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.HR_AVM_UPD dependencies on HR_AVM_SHD

Line 55: (p_rec in out nocopy hr_avm_shd.g_rec_type

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

Line 88: hr_avm_shd.constraint_error

84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: --
88: hr_avm_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: --

Line 93: hr_avm_shd.constraint_error

89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: --
93: hr_avm_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --

Line 98: hr_avm_shd.constraint_error

94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --
98: hr_avm_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: --
102: Raise;

Line 138: (p_rec in hr_avm_shd.g_rec_type

134: --
135: -- {End Of Comments}
136: -- ----------------------------------------------------------------------------
137: Procedure pre_update
138: (p_rec in hr_avm_shd.g_rec_type
139: ) is
140: --
141: l_proc varchar2(72) := g_package||'pre_update';
142: --

Line 182: (p_rec in hr_avm_shd.g_rec_type

178: --
179: -- {End Of Comments}
180: -- ----------------------------------------------------------------------------
181: Procedure post_update
182: (p_rec in hr_avm_shd.g_rec_type
183: ) is
184: --
185: l_proc varchar2(72) := g_package||'post_update';
186: --

Line 205: => hr_avm_shd.g_old_rec.ath_dsn

201: => p_rec.object_version_number
202: ,p_ath_variablemap_id
203: => p_rec.ath_variablemap_id
204: ,p_ath_dsn_o
205: => hr_avm_shd.g_old_rec.ath_dsn
206: ,p_ath_tablename_o
207: => hr_avm_shd.g_old_rec.ath_tablename
208: ,p_ath_columnname_o
209: => hr_avm_shd.g_old_rec.ath_columnname

Line 207: => hr_avm_shd.g_old_rec.ath_tablename

203: => p_rec.ath_variablemap_id
204: ,p_ath_dsn_o
205: => hr_avm_shd.g_old_rec.ath_dsn
206: ,p_ath_tablename_o
207: => hr_avm_shd.g_old_rec.ath_tablename
208: ,p_ath_columnname_o
209: => hr_avm_shd.g_old_rec.ath_columnname
210: ,p_ath_varname_o
211: => hr_avm_shd.g_old_rec.ath_varname

Line 209: => hr_avm_shd.g_old_rec.ath_columnname

205: => hr_avm_shd.g_old_rec.ath_dsn
206: ,p_ath_tablename_o
207: => hr_avm_shd.g_old_rec.ath_tablename
208: ,p_ath_columnname_o
209: => hr_avm_shd.g_old_rec.ath_columnname
210: ,p_ath_varname_o
211: => hr_avm_shd.g_old_rec.ath_varname
212: ,p_object_version_number_o
213: => hr_avm_shd.g_old_rec.object_version_number

Line 211: => hr_avm_shd.g_old_rec.ath_varname

207: => hr_avm_shd.g_old_rec.ath_tablename
208: ,p_ath_columnname_o
209: => hr_avm_shd.g_old_rec.ath_columnname
210: ,p_ath_varname_o
211: => hr_avm_shd.g_old_rec.ath_varname
212: ,p_object_version_number_o
213: => hr_avm_shd.g_old_rec.object_version_number
214: );
215: --

Line 213: => hr_avm_shd.g_old_rec.object_version_number

209: => hr_avm_shd.g_old_rec.ath_columnname
210: ,p_ath_varname_o
211: => hr_avm_shd.g_old_rec.ath_varname
212: ,p_object_version_number_o
213: => hr_avm_shd.g_old_rec.object_version_number
214: );
215: --
216: exception
217: --

Line 273: (p_rec in out nocopy hr_avm_shd.g_rec_type

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

Line 285: hr_avm_shd.g_old_rec.ath_dsn;

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

Line 289: hr_avm_shd.g_old_rec.ath_tablename;

285: hr_avm_shd.g_old_rec.ath_dsn;
286: End If;
287: If (p_rec.ath_tablename = hr_api.g_varchar2) then
288: p_rec.ath_tablename :=
289: hr_avm_shd.g_old_rec.ath_tablename;
290: End If;
291: If (p_rec.ath_columnname = hr_api.g_varchar2) then
292: p_rec.ath_columnname :=
293: hr_avm_shd.g_old_rec.ath_columnname;

Line 293: hr_avm_shd.g_old_rec.ath_columnname;

289: hr_avm_shd.g_old_rec.ath_tablename;
290: End If;
291: If (p_rec.ath_columnname = hr_api.g_varchar2) then
292: p_rec.ath_columnname :=
293: hr_avm_shd.g_old_rec.ath_columnname;
294: End If;
295: If (p_rec.ath_varname = hr_api.g_varchar2) then
296: p_rec.ath_varname :=
297: hr_avm_shd.g_old_rec.ath_varname;

Line 297: hr_avm_shd.g_old_rec.ath_varname;

293: hr_avm_shd.g_old_rec.ath_columnname;
294: End If;
295: If (p_rec.ath_varname = hr_api.g_varchar2) then
296: p_rec.ath_varname :=
297: hr_avm_shd.g_old_rec.ath_varname;
298: End If;
299: --
300: End convert_defs;
301: --

Line 306: (p_rec in out nocopy hr_avm_shd.g_rec_type

302: -- ----------------------------------------------------------------------------
303: -- |---------------------------------< upd >----------------------------------|
304: -- ----------------------------------------------------------------------------
305: Procedure upd
306: (p_rec in out nocopy hr_avm_shd.g_rec_type
307: ) is
308: --
309: l_proc varchar2(72) := g_package||'upd';
310: --

Line 316: hr_avm_shd.lck

312: hr_utility.set_location('Entering:'||l_proc, 5);
313: --
314: -- We must lock the row which we need to update.
315: --
316: hr_avm_shd.lck
317: (p_rec.ath_variablemap_id
318: ,p_rec.object_version_number
319: );
320: --

Line 365: l_rec hr_avm_shd.g_rec_type;

361: ,p_ath_columnname in varchar2 default hr_api.g_varchar2
362: ,p_ath_varname in varchar2 default hr_api.g_varchar2
363: ) is
364: --
365: l_rec hr_avm_shd.g_rec_type;
366: l_proc varchar2(72) := g_package||'upd';
367: --
368: Begin
369: hr_utility.set_location('Entering:'||l_proc, 5);

Line 375: hr_avm_shd.convert_args

371: -- Call conversion function to turn arguments into the
372: -- l_rec structure.
373: --
374: l_rec :=
375: hr_avm_shd.convert_args
376: (p_ath_variablemap_id
377: ,p_ath_dsn
378: ,p_ath_tablename
379: ,p_ath_columnname