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.PER_STB_UPD dependencies on PER_STB_SHD

Line 55: (p_rec in out nocopy per_stb_shd.g_rec_type

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

Line 91: per_stb_shd.constraint_error

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

Line 96: per_stb_shd.constraint_error

92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: --
96: per_stb_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: --

Line 101: per_stb_shd.constraint_error

97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: --
101: per_stb_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: --
105: Raise;

Line 141: (p_rec in per_stb_shd.g_rec_type

137: --
138: -- {End Of Comments}
139: -- ----------------------------------------------------------------------------
140: Procedure pre_update
141: (p_rec in per_stb_shd.g_rec_type
142: ) is
143: --
144: l_proc varchar2(72) := g_package||'pre_update';
145: --

Line 186: ,p_rec in per_stb_shd.g_rec_type

182: -- {End Of Comments}
183: -- ----------------------------------------------------------------------------
184: Procedure post_update
185: (p_effective_date in date
186: ,p_rec in per_stb_shd.g_rec_type
187: ) is
188: --
189: l_proc varchar2(72) := g_package||'post_update';
190: --

Line 206: ,p_workbench_item_code_o => per_stb_shd.g_old_rec.workbench_item_code

202: ,p_setup_task_last_modified_dat => p_rec.setup_task_last_modified_date
203: ,p_setup_task_type => p_rec.setup_task_type
204: ,p_setup_task_action => p_rec.setup_task_action
205: ,p_object_version_number => p_rec.object_version_number
206: ,p_workbench_item_code_o => per_stb_shd.g_old_rec.workbench_item_code
207: ,p_setup_task_sequence_o => per_stb_shd.g_old_rec.setup_task_sequence
208: ,p_setup_task_status_o => per_stb_shd.g_old_rec.setup_task_status
209: ,p_setup_task_creation_date_o => per_stb_shd.g_old_rec.setup_task_creation_date
210: ,p_setup_task_last_modified_d_o => per_stb_shd.g_old_rec.setup_task_last_modified_date

Line 207: ,p_setup_task_sequence_o => per_stb_shd.g_old_rec.setup_task_sequence

203: ,p_setup_task_type => p_rec.setup_task_type
204: ,p_setup_task_action => p_rec.setup_task_action
205: ,p_object_version_number => p_rec.object_version_number
206: ,p_workbench_item_code_o => per_stb_shd.g_old_rec.workbench_item_code
207: ,p_setup_task_sequence_o => per_stb_shd.g_old_rec.setup_task_sequence
208: ,p_setup_task_status_o => per_stb_shd.g_old_rec.setup_task_status
209: ,p_setup_task_creation_date_o => per_stb_shd.g_old_rec.setup_task_creation_date
210: ,p_setup_task_last_modified_d_o => per_stb_shd.g_old_rec.setup_task_last_modified_date
211: ,p_setup_task_type_o => per_stb_shd.g_old_rec.setup_task_type

Line 208: ,p_setup_task_status_o => per_stb_shd.g_old_rec.setup_task_status

204: ,p_setup_task_action => p_rec.setup_task_action
205: ,p_object_version_number => p_rec.object_version_number
206: ,p_workbench_item_code_o => per_stb_shd.g_old_rec.workbench_item_code
207: ,p_setup_task_sequence_o => per_stb_shd.g_old_rec.setup_task_sequence
208: ,p_setup_task_status_o => per_stb_shd.g_old_rec.setup_task_status
209: ,p_setup_task_creation_date_o => per_stb_shd.g_old_rec.setup_task_creation_date
210: ,p_setup_task_last_modified_d_o => per_stb_shd.g_old_rec.setup_task_last_modified_date
211: ,p_setup_task_type_o => per_stb_shd.g_old_rec.setup_task_type
212: ,p_setup_task_action_o => per_stb_shd.g_old_rec.setup_task_action

Line 209: ,p_setup_task_creation_date_o => per_stb_shd.g_old_rec.setup_task_creation_date

205: ,p_object_version_number => p_rec.object_version_number
206: ,p_workbench_item_code_o => per_stb_shd.g_old_rec.workbench_item_code
207: ,p_setup_task_sequence_o => per_stb_shd.g_old_rec.setup_task_sequence
208: ,p_setup_task_status_o => per_stb_shd.g_old_rec.setup_task_status
209: ,p_setup_task_creation_date_o => per_stb_shd.g_old_rec.setup_task_creation_date
210: ,p_setup_task_last_modified_d_o => per_stb_shd.g_old_rec.setup_task_last_modified_date
211: ,p_setup_task_type_o => per_stb_shd.g_old_rec.setup_task_type
212: ,p_setup_task_action_o => per_stb_shd.g_old_rec.setup_task_action
213: ,p_object_version_number_o => per_stb_shd.g_old_rec.object_version_number

Line 210: ,p_setup_task_last_modified_d_o => per_stb_shd.g_old_rec.setup_task_last_modified_date

206: ,p_workbench_item_code_o => per_stb_shd.g_old_rec.workbench_item_code
207: ,p_setup_task_sequence_o => per_stb_shd.g_old_rec.setup_task_sequence
208: ,p_setup_task_status_o => per_stb_shd.g_old_rec.setup_task_status
209: ,p_setup_task_creation_date_o => per_stb_shd.g_old_rec.setup_task_creation_date
210: ,p_setup_task_last_modified_d_o => per_stb_shd.g_old_rec.setup_task_last_modified_date
211: ,p_setup_task_type_o => per_stb_shd.g_old_rec.setup_task_type
212: ,p_setup_task_action_o => per_stb_shd.g_old_rec.setup_task_action
213: ,p_object_version_number_o => per_stb_shd.g_old_rec.object_version_number
214: );

Line 211: ,p_setup_task_type_o => per_stb_shd.g_old_rec.setup_task_type

207: ,p_setup_task_sequence_o => per_stb_shd.g_old_rec.setup_task_sequence
208: ,p_setup_task_status_o => per_stb_shd.g_old_rec.setup_task_status
209: ,p_setup_task_creation_date_o => per_stb_shd.g_old_rec.setup_task_creation_date
210: ,p_setup_task_last_modified_d_o => per_stb_shd.g_old_rec.setup_task_last_modified_date
211: ,p_setup_task_type_o => per_stb_shd.g_old_rec.setup_task_type
212: ,p_setup_task_action_o => per_stb_shd.g_old_rec.setup_task_action
213: ,p_object_version_number_o => per_stb_shd.g_old_rec.object_version_number
214: );
215: --

Line 212: ,p_setup_task_action_o => per_stb_shd.g_old_rec.setup_task_action

208: ,p_setup_task_status_o => per_stb_shd.g_old_rec.setup_task_status
209: ,p_setup_task_creation_date_o => per_stb_shd.g_old_rec.setup_task_creation_date
210: ,p_setup_task_last_modified_d_o => per_stb_shd.g_old_rec.setup_task_last_modified_date
211: ,p_setup_task_type_o => per_stb_shd.g_old_rec.setup_task_type
212: ,p_setup_task_action_o => per_stb_shd.g_old_rec.setup_task_action
213: ,p_object_version_number_o => per_stb_shd.g_old_rec.object_version_number
214: );
215: --
216: exception

Line 213: ,p_object_version_number_o => per_stb_shd.g_old_rec.object_version_number

209: ,p_setup_task_creation_date_o => per_stb_shd.g_old_rec.setup_task_creation_date
210: ,p_setup_task_last_modified_d_o => per_stb_shd.g_old_rec.setup_task_last_modified_date
211: ,p_setup_task_type_o => per_stb_shd.g_old_rec.setup_task_type
212: ,p_setup_task_action_o => per_stb_shd.g_old_rec.setup_task_action
213: ,p_object_version_number_o => per_stb_shd.g_old_rec.object_version_number
214: );
215: --
216: exception
217: --

Line 273: (p_rec in out nocopy per_stb_shd.g_rec_type

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

Line 285: per_stb_shd.g_old_rec.workbench_item_code;

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

Line 289: per_stb_shd.g_old_rec.setup_task_sequence;

285: per_stb_shd.g_old_rec.workbench_item_code;
286: End If;
287: If (p_rec.setup_task_sequence = hr_api.g_number) then
288: p_rec.setup_task_sequence :=
289: per_stb_shd.g_old_rec.setup_task_sequence;
290: End If;
291: If (p_rec.setup_task_status = hr_api.g_varchar2) then
292: p_rec.setup_task_status :=
293: per_stb_shd.g_old_rec.setup_task_status;

Line 293: per_stb_shd.g_old_rec.setup_task_status;

289: per_stb_shd.g_old_rec.setup_task_sequence;
290: End If;
291: If (p_rec.setup_task_status = hr_api.g_varchar2) then
292: p_rec.setup_task_status :=
293: per_stb_shd.g_old_rec.setup_task_status;
294: End If;
295: If (p_rec.setup_task_creation_date = hr_api.g_date) then
296: p_rec.setup_task_creation_date :=
297: per_stb_shd.g_old_rec.setup_task_creation_date;

Line 297: per_stb_shd.g_old_rec.setup_task_creation_date;

293: per_stb_shd.g_old_rec.setup_task_status;
294: End If;
295: If (p_rec.setup_task_creation_date = hr_api.g_date) then
296: p_rec.setup_task_creation_date :=
297: per_stb_shd.g_old_rec.setup_task_creation_date;
298: End If;
299: If (p_rec.setup_task_last_modified_date = hr_api.g_date) then
300: p_rec.setup_task_last_modified_date :=
301: per_stb_shd.g_old_rec.setup_task_last_modified_date;

Line 301: per_stb_shd.g_old_rec.setup_task_last_modified_date;

297: per_stb_shd.g_old_rec.setup_task_creation_date;
298: End If;
299: If (p_rec.setup_task_last_modified_date = hr_api.g_date) then
300: p_rec.setup_task_last_modified_date :=
301: per_stb_shd.g_old_rec.setup_task_last_modified_date;
302: End If;
303: If (p_rec.setup_task_type = hr_api.g_varchar2) then
304: p_rec.setup_task_type :=
305: per_stb_shd.g_old_rec.setup_task_type;

Line 305: per_stb_shd.g_old_rec.setup_task_type;

301: per_stb_shd.g_old_rec.setup_task_last_modified_date;
302: End If;
303: If (p_rec.setup_task_type = hr_api.g_varchar2) then
304: p_rec.setup_task_type :=
305: per_stb_shd.g_old_rec.setup_task_type;
306: End If;
307: If (p_rec.setup_task_action = hr_api.g_varchar2) then
308: p_rec.setup_task_action :=
309: per_stb_shd.g_old_rec.setup_task_action;

Line 309: per_stb_shd.g_old_rec.setup_task_action;

305: per_stb_shd.g_old_rec.setup_task_type;
306: End If;
307: If (p_rec.setup_task_action = hr_api.g_varchar2) then
308: p_rec.setup_task_action :=
309: per_stb_shd.g_old_rec.setup_task_action;
310: End If;
311: --
312: End convert_defs;
313: --

Line 319: ,p_rec in out nocopy per_stb_shd.g_rec_type

315: -- |---------------------------------< upd >----------------------------------|
316: -- ----------------------------------------------------------------------------
317: Procedure upd
318: (p_effective_date in date
319: ,p_rec in out nocopy per_stb_shd.g_rec_type
320: ) is
321: --
322: l_proc varchar2(72) := g_package||'upd';
323: --

Line 329: per_stb_shd.lck

325: hr_utility.set_location('Entering:'||l_proc, 5);
326: --
327: -- We must lock the row which we need to update.
328: --
329: per_stb_shd.lck
330: (p_rec.setup_task_code
331: ,p_rec.object_version_number
332: );
333: --

Line 384: l_rec per_stb_shd.g_rec_type;

380: ,p_setup_task_type in varchar2 default hr_api.g_varchar2
381: ,p_setup_task_action in varchar2 default hr_api.g_varchar2
382: ) is
383: --
384: l_rec per_stb_shd.g_rec_type;
385: l_proc varchar2(72) := g_package||'upd';
386: --
387: Begin
388: hr_utility.set_location('Entering:'||l_proc, 5);

Line 394: per_stb_shd.convert_args

390: -- Call conversion function to turn arguments into the
391: -- l_rec structure.
392: --
393: l_rec :=
394: per_stb_shd.convert_args
395: (p_setup_task_code
396: ,p_workbench_item_code
397: ,p_setup_task_sequence
398: ,p_setup_task_status