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.PQH_LCD_UPD dependencies on PQH_LCD_SHD

Line 55: (p_rec in out nocopy pqh_lcd_shd.g_rec_type

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

Line 88: pqh_lcd_shd.constraint_error

84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: --
88: pqh_lcd_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: pqh_lcd_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: pqh_lcd_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: pqh_lcd_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: pqh_lcd_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 pqh_lcd_shd.g_rec_type

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

Line 182: (p_rec in pqh_lcd_shd.g_rec_type

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

Line 205: => pqh_lcd_shd.g_old_rec.level_number_id

201: => p_rec.gradual_value_number
202: ,p_object_version_number
203: => p_rec.object_version_number
204: ,p_level_number_id_o
205: => pqh_lcd_shd.g_old_rec.level_number_id
206: ,p_level_code_o
207: => pqh_lcd_shd.g_old_rec.level_code
208: ,p_description_o
209: => pqh_lcd_shd.g_old_rec.description

Line 207: => pqh_lcd_shd.g_old_rec.level_code

203: => p_rec.object_version_number
204: ,p_level_number_id_o
205: => pqh_lcd_shd.g_old_rec.level_number_id
206: ,p_level_code_o
207: => pqh_lcd_shd.g_old_rec.level_code
208: ,p_description_o
209: => pqh_lcd_shd.g_old_rec.description
210: ,p_gradual_value_number_o
211: => pqh_lcd_shd.g_old_rec.gradual_value_number

Line 209: => pqh_lcd_shd.g_old_rec.description

205: => pqh_lcd_shd.g_old_rec.level_number_id
206: ,p_level_code_o
207: => pqh_lcd_shd.g_old_rec.level_code
208: ,p_description_o
209: => pqh_lcd_shd.g_old_rec.description
210: ,p_gradual_value_number_o
211: => pqh_lcd_shd.g_old_rec.gradual_value_number
212: ,p_object_version_number_o
213: => pqh_lcd_shd.g_old_rec.object_version_number

Line 211: => pqh_lcd_shd.g_old_rec.gradual_value_number

207: => pqh_lcd_shd.g_old_rec.level_code
208: ,p_description_o
209: => pqh_lcd_shd.g_old_rec.description
210: ,p_gradual_value_number_o
211: => pqh_lcd_shd.g_old_rec.gradual_value_number
212: ,p_object_version_number_o
213: => pqh_lcd_shd.g_old_rec.object_version_number
214: );
215: --

Line 213: => pqh_lcd_shd.g_old_rec.object_version_number

209: => pqh_lcd_shd.g_old_rec.description
210: ,p_gradual_value_number_o
211: => pqh_lcd_shd.g_old_rec.gradual_value_number
212: ,p_object_version_number_o
213: => pqh_lcd_shd.g_old_rec.object_version_number
214: );
215: --
216: exception
217: --

Line 273: (p_rec in out nocopy pqh_lcd_shd.g_rec_type

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

Line 285: pqh_lcd_shd.g_old_rec.level_number_id;

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

Line 289: pqh_lcd_shd.g_old_rec.level_code;

285: pqh_lcd_shd.g_old_rec.level_number_id;
286: End If;
287: If (p_rec.level_code = hr_api.g_varchar2) then
288: p_rec.level_code :=
289: pqh_lcd_shd.g_old_rec.level_code;
290: End If;
291: If (p_rec.description = hr_api.g_varchar2) then
292: p_rec.description :=
293: pqh_lcd_shd.g_old_rec.description;

Line 293: pqh_lcd_shd.g_old_rec.description;

289: pqh_lcd_shd.g_old_rec.level_code;
290: End If;
291: If (p_rec.description = hr_api.g_varchar2) then
292: p_rec.description :=
293: pqh_lcd_shd.g_old_rec.description;
294: End If;
295: If (p_rec.gradual_value_number = hr_api.g_number) then
296: p_rec.gradual_value_number :=
297: pqh_lcd_shd.g_old_rec.gradual_value_number;

Line 297: pqh_lcd_shd.g_old_rec.gradual_value_number;

293: pqh_lcd_shd.g_old_rec.description;
294: End If;
295: If (p_rec.gradual_value_number = hr_api.g_number) then
296: p_rec.gradual_value_number :=
297: pqh_lcd_shd.g_old_rec.gradual_value_number;
298: End If;
299: --
300: End convert_defs;
301: --

Line 306: (p_rec in out nocopy pqh_lcd_shd.g_rec_type

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

Line 316: pqh_lcd_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: pqh_lcd_shd.lck
317: (p_rec.level_code_id
318: ,p_rec.object_version_number
319: );
320: --

Line 365: l_rec pqh_lcd_shd.g_rec_type;

361: ,p_description in varchar2 default hr_api.g_varchar2
362: ,p_gradual_value_number in number default hr_api.g_number
363: ) is
364: --
365: l_rec pqh_lcd_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: pqh_lcd_shd.convert_args

371: -- Call conversion function to turn arguments into the
372: -- l_rec structure.
373: --
374: l_rec :=
375: pqh_lcd_shd.convert_args
376: (p_level_code_id
377: ,p_level_number_id
378: ,p_level_code
379: ,p_description