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_ENV_UPD dependencies on PER_ENV_SHD

Line 55: (p_rec in out nocopy per_env_shd.g_rec_type

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

Line 86: per_env_shd.constraint_error

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

Line 91: per_env_shd.constraint_error

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

Line 96: per_env_shd.constraint_error

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

Line 136: (p_rec in per_env_shd.g_rec_type

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

Line 181: ,p_rec in per_env_shd.g_rec_type

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

Line 198: ,p_calendar_entry_id_o => per_env_shd.g_old_rec.calendar_entry_id

194: ,p_override_type => p_rec.override_type
195: ,p_parent_entry_value_id => p_rec.parent_entry_value_id
196: ,p_usage_flag => p_rec.usage_flag
197: ,p_object_version_number => p_rec.object_version_number
198: ,p_calendar_entry_id_o => per_env_shd.g_old_rec.calendar_entry_id
199: ,p_hierarchy_node_id_o => per_env_shd.g_old_rec.hierarchy_node_id
200: ,p_value_o => per_env_shd.g_old_rec.value
201: ,p_org_structure_element_id_o => per_env_shd.g_old_rec.org_structure_element_id
202: ,p_organization_id_o => per_env_shd.g_old_rec.organization_id

Line 199: ,p_hierarchy_node_id_o => per_env_shd.g_old_rec.hierarchy_node_id

195: ,p_parent_entry_value_id => p_rec.parent_entry_value_id
196: ,p_usage_flag => p_rec.usage_flag
197: ,p_object_version_number => p_rec.object_version_number
198: ,p_calendar_entry_id_o => per_env_shd.g_old_rec.calendar_entry_id
199: ,p_hierarchy_node_id_o => per_env_shd.g_old_rec.hierarchy_node_id
200: ,p_value_o => per_env_shd.g_old_rec.value
201: ,p_org_structure_element_id_o => per_env_shd.g_old_rec.org_structure_element_id
202: ,p_organization_id_o => per_env_shd.g_old_rec.organization_id
203: ,p_override_name_o => per_env_shd.g_old_rec.override_name

Line 200: ,p_value_o => per_env_shd.g_old_rec.value

196: ,p_usage_flag => p_rec.usage_flag
197: ,p_object_version_number => p_rec.object_version_number
198: ,p_calendar_entry_id_o => per_env_shd.g_old_rec.calendar_entry_id
199: ,p_hierarchy_node_id_o => per_env_shd.g_old_rec.hierarchy_node_id
200: ,p_value_o => per_env_shd.g_old_rec.value
201: ,p_org_structure_element_id_o => per_env_shd.g_old_rec.org_structure_element_id
202: ,p_organization_id_o => per_env_shd.g_old_rec.organization_id
203: ,p_override_name_o => per_env_shd.g_old_rec.override_name
204: ,p_override_type_o => per_env_shd.g_old_rec.override_type

Line 201: ,p_org_structure_element_id_o => per_env_shd.g_old_rec.org_structure_element_id

197: ,p_object_version_number => p_rec.object_version_number
198: ,p_calendar_entry_id_o => per_env_shd.g_old_rec.calendar_entry_id
199: ,p_hierarchy_node_id_o => per_env_shd.g_old_rec.hierarchy_node_id
200: ,p_value_o => per_env_shd.g_old_rec.value
201: ,p_org_structure_element_id_o => per_env_shd.g_old_rec.org_structure_element_id
202: ,p_organization_id_o => per_env_shd.g_old_rec.organization_id
203: ,p_override_name_o => per_env_shd.g_old_rec.override_name
204: ,p_override_type_o => per_env_shd.g_old_rec.override_type
205: ,p_parent_entry_value_id_o => per_env_shd.g_old_rec.parent_entry_value_id

Line 202: ,p_organization_id_o => per_env_shd.g_old_rec.organization_id

198: ,p_calendar_entry_id_o => per_env_shd.g_old_rec.calendar_entry_id
199: ,p_hierarchy_node_id_o => per_env_shd.g_old_rec.hierarchy_node_id
200: ,p_value_o => per_env_shd.g_old_rec.value
201: ,p_org_structure_element_id_o => per_env_shd.g_old_rec.org_structure_element_id
202: ,p_organization_id_o => per_env_shd.g_old_rec.organization_id
203: ,p_override_name_o => per_env_shd.g_old_rec.override_name
204: ,p_override_type_o => per_env_shd.g_old_rec.override_type
205: ,p_parent_entry_value_id_o => per_env_shd.g_old_rec.parent_entry_value_id
206: ,p_usage_flag_o => per_env_shd.g_old_rec.usage_flag

Line 203: ,p_override_name_o => per_env_shd.g_old_rec.override_name

199: ,p_hierarchy_node_id_o => per_env_shd.g_old_rec.hierarchy_node_id
200: ,p_value_o => per_env_shd.g_old_rec.value
201: ,p_org_structure_element_id_o => per_env_shd.g_old_rec.org_structure_element_id
202: ,p_organization_id_o => per_env_shd.g_old_rec.organization_id
203: ,p_override_name_o => per_env_shd.g_old_rec.override_name
204: ,p_override_type_o => per_env_shd.g_old_rec.override_type
205: ,p_parent_entry_value_id_o => per_env_shd.g_old_rec.parent_entry_value_id
206: ,p_usage_flag_o => per_env_shd.g_old_rec.usage_flag
207: ,p_object_version_number_o => per_env_shd.g_old_rec.object_version_number

Line 204: ,p_override_type_o => per_env_shd.g_old_rec.override_type

200: ,p_value_o => per_env_shd.g_old_rec.value
201: ,p_org_structure_element_id_o => per_env_shd.g_old_rec.org_structure_element_id
202: ,p_organization_id_o => per_env_shd.g_old_rec.organization_id
203: ,p_override_name_o => per_env_shd.g_old_rec.override_name
204: ,p_override_type_o => per_env_shd.g_old_rec.override_type
205: ,p_parent_entry_value_id_o => per_env_shd.g_old_rec.parent_entry_value_id
206: ,p_usage_flag_o => per_env_shd.g_old_rec.usage_flag
207: ,p_object_version_number_o => per_env_shd.g_old_rec.object_version_number
208: );

Line 205: ,p_parent_entry_value_id_o => per_env_shd.g_old_rec.parent_entry_value_id

201: ,p_org_structure_element_id_o => per_env_shd.g_old_rec.org_structure_element_id
202: ,p_organization_id_o => per_env_shd.g_old_rec.organization_id
203: ,p_override_name_o => per_env_shd.g_old_rec.override_name
204: ,p_override_type_o => per_env_shd.g_old_rec.override_type
205: ,p_parent_entry_value_id_o => per_env_shd.g_old_rec.parent_entry_value_id
206: ,p_usage_flag_o => per_env_shd.g_old_rec.usage_flag
207: ,p_object_version_number_o => per_env_shd.g_old_rec.object_version_number
208: );
209: --

Line 206: ,p_usage_flag_o => per_env_shd.g_old_rec.usage_flag

202: ,p_organization_id_o => per_env_shd.g_old_rec.organization_id
203: ,p_override_name_o => per_env_shd.g_old_rec.override_name
204: ,p_override_type_o => per_env_shd.g_old_rec.override_type
205: ,p_parent_entry_value_id_o => per_env_shd.g_old_rec.parent_entry_value_id
206: ,p_usage_flag_o => per_env_shd.g_old_rec.usage_flag
207: ,p_object_version_number_o => per_env_shd.g_old_rec.object_version_number
208: );
209: --
210: exception

Line 207: ,p_object_version_number_o => per_env_shd.g_old_rec.object_version_number

203: ,p_override_name_o => per_env_shd.g_old_rec.override_name
204: ,p_override_type_o => per_env_shd.g_old_rec.override_type
205: ,p_parent_entry_value_id_o => per_env_shd.g_old_rec.parent_entry_value_id
206: ,p_usage_flag_o => per_env_shd.g_old_rec.usage_flag
207: ,p_object_version_number_o => per_env_shd.g_old_rec.object_version_number
208: );
209: --
210: exception
211: --

Line 267: (p_rec in out nocopy per_env_shd.g_rec_type

263: --
264: -- {End Of Comments}
265: -- ----------------------------------------------------------------------------
266: Procedure convert_defs
267: (p_rec in out nocopy per_env_shd.g_rec_type
268: ) is
269: --
270: Begin
271: --

Line 279: per_env_shd.g_old_rec.calendar_entry_id;

275: -- is being used then we must set to the 'current' argument value.
276: --
277: If (p_rec.calendar_entry_id = hr_api.g_number) then
278: p_rec.calendar_entry_id :=
279: per_env_shd.g_old_rec.calendar_entry_id;
280: End If;
281: If (p_rec.hierarchy_node_id = hr_api.g_number) then
282: p_rec.hierarchy_node_id :=
283: per_env_shd.g_old_rec.hierarchy_node_id;

Line 283: per_env_shd.g_old_rec.hierarchy_node_id;

279: per_env_shd.g_old_rec.calendar_entry_id;
280: End If;
281: If (p_rec.hierarchy_node_id = hr_api.g_number) then
282: p_rec.hierarchy_node_id :=
283: per_env_shd.g_old_rec.hierarchy_node_id;
284: End If;
285: If (p_rec.value = hr_api.g_varchar2) then
286: p_rec.value :=
287: per_env_shd.g_old_rec.value;

Line 287: per_env_shd.g_old_rec.value;

283: per_env_shd.g_old_rec.hierarchy_node_id;
284: End If;
285: If (p_rec.value = hr_api.g_varchar2) then
286: p_rec.value :=
287: per_env_shd.g_old_rec.value;
288: End If;
289: If (p_rec.org_structure_element_id = hr_api.g_number) then
290: p_rec.org_structure_element_id :=
291: per_env_shd.g_old_rec.org_structure_element_id;

Line 291: per_env_shd.g_old_rec.org_structure_element_id;

287: per_env_shd.g_old_rec.value;
288: End If;
289: If (p_rec.org_structure_element_id = hr_api.g_number) then
290: p_rec.org_structure_element_id :=
291: per_env_shd.g_old_rec.org_structure_element_id;
292: End If;
293: If (p_rec.organization_id = hr_api.g_number) then
294: p_rec.organization_id :=
295: per_env_shd.g_old_rec.organization_id;

Line 295: per_env_shd.g_old_rec.organization_id;

291: per_env_shd.g_old_rec.org_structure_element_id;
292: End If;
293: If (p_rec.organization_id = hr_api.g_number) then
294: p_rec.organization_id :=
295: per_env_shd.g_old_rec.organization_id;
296: End If;
297: If (p_rec.override_name = hr_api.g_varchar2) then
298: p_rec.override_name :=
299: per_env_shd.g_old_rec.override_name;

Line 299: per_env_shd.g_old_rec.override_name;

295: per_env_shd.g_old_rec.organization_id;
296: End If;
297: If (p_rec.override_name = hr_api.g_varchar2) then
298: p_rec.override_name :=
299: per_env_shd.g_old_rec.override_name;
300: End If;
301: If (p_rec.override_type = hr_api.g_varchar2) then
302: p_rec.override_type :=
303: per_env_shd.g_old_rec.override_type;

Line 303: per_env_shd.g_old_rec.override_type;

299: per_env_shd.g_old_rec.override_name;
300: End If;
301: If (p_rec.override_type = hr_api.g_varchar2) then
302: p_rec.override_type :=
303: per_env_shd.g_old_rec.override_type;
304: End If;
305: If (p_rec.parent_entry_value_id = hr_api.g_number) then
306: p_rec.parent_entry_value_id :=
307: per_env_shd.g_old_rec.parent_entry_value_id;

Line 307: per_env_shd.g_old_rec.parent_entry_value_id;

303: per_env_shd.g_old_rec.override_type;
304: End If;
305: If (p_rec.parent_entry_value_id = hr_api.g_number) then
306: p_rec.parent_entry_value_id :=
307: per_env_shd.g_old_rec.parent_entry_value_id;
308: End If;
309: If (p_rec.usage_flag = hr_api.g_varchar2) then
310: p_rec.usage_flag :=
311: per_env_shd.g_old_rec.usage_flag;

Line 311: per_env_shd.g_old_rec.usage_flag;

307: per_env_shd.g_old_rec.parent_entry_value_id;
308: End If;
309: If (p_rec.usage_flag = hr_api.g_varchar2) then
310: p_rec.usage_flag :=
311: per_env_shd.g_old_rec.usage_flag;
312: End If;
313: --
314: End convert_defs;
315: --

Line 321: ,p_rec in out nocopy per_env_shd.g_rec_type

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

Line 331: per_env_shd.lck

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

Line 383: l_rec per_env_shd.g_rec_type;

379: ,p_parent_entry_value_id in number default hr_api.g_number
380: ,p_usage_flag in varchar2 default hr_api.g_varchar2
381: ) is
382: --
383: l_rec per_env_shd.g_rec_type;
384: l_proc varchar2(72) := g_package||'upd';
385: --
386: Begin
387: hr_utility.set_location('Entering:'||l_proc, 5);

Line 393: per_env_shd.convert_args

389: -- Call conversion function to turn arguments into the
390: -- l_rec structure.
391: --
392: l_rec :=
393: per_env_shd.convert_args
394: (p_cal_entry_value_id
395: ,hr_api.g_number
396: ,hr_api.g_number
397: ,hr_api.g_varchar2