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_SSD_UPD dependencies on PER_SSD_SHD

Line 55: (p_rec in out nocopy per_ssd_shd.g_rec_type

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

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

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

85: ,max_successors = p_rec.max_successors
86: ,object_version_number = p_rec.object_version_number
87: where successee_detail_id = p_rec.successee_detail_id;
88: --
89: per_ssd_shd.g_api_dml := false; -- Unset the api dml status
90: --
91: hr_utility.set_location(' Leaving:'||l_proc, 10);
92: --
93: Exception

Line 96: per_ssd_shd.g_api_dml := false; -- Unset the api dml status

92: --
93: Exception
94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: per_ssd_shd.g_api_dml := false; -- Unset the api dml status
97: per_ssd_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated

Line 97: per_ssd_shd.constraint_error

93: Exception
94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: per_ssd_shd.g_api_dml := false; -- Unset the api dml status
97: per_ssd_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated
101: per_ssd_shd.g_api_dml := false; -- Unset the api dml status

Line 101: per_ssd_shd.g_api_dml := false; -- Unset the api dml status

97: per_ssd_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated
101: per_ssd_shd.g_api_dml := false; -- Unset the api dml status
102: per_ssd_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated

Line 102: per_ssd_shd.constraint_error

98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated
101: per_ssd_shd.g_api_dml := false; -- Unset the api dml status
102: per_ssd_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: per_ssd_shd.g_api_dml := false; -- Unset the api dml status

Line 106: per_ssd_shd.g_api_dml := false; -- Unset the api dml status

102: per_ssd_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: per_ssd_shd.g_api_dml := false; -- Unset the api dml status
107: per_ssd_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then
110: per_ssd_shd.g_api_dml := false; -- Unset the api dml status

Line 107: per_ssd_shd.constraint_error

103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: per_ssd_shd.g_api_dml := false; -- Unset the api dml status
107: per_ssd_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then
110: per_ssd_shd.g_api_dml := false; -- Unset the api dml status
111: Raise;

Line 110: per_ssd_shd.g_api_dml := false; -- Unset the api dml status

106: per_ssd_shd.g_api_dml := false; -- Unset the api dml status
107: per_ssd_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then
110: per_ssd_shd.g_api_dml := false; -- Unset the api dml status
111: Raise;
112: End update_dml;
113: --
114: -- ----------------------------------------------------------------------------

Line 147: (p_rec in per_ssd_shd.g_rec_type

143: --
144: -- {End Of Comments}
145: -- ----------------------------------------------------------------------------
146: Procedure pre_update
147: (p_rec in per_ssd_shd.g_rec_type
148: ) is
149: --
150: l_proc varchar2(72) := g_package||'pre_update';
151: --

Line 192: ,p_rec in per_ssd_shd.g_rec_type

188: -- {End Of Comments}
189: -- ----------------------------------------------------------------------------
190: Procedure post_update
191: (p_effective_date in date
192: ,p_rec in per_ssd_shd.g_rec_type
193: ) is
194: --
195: l_proc varchar2(72) := g_package||'post_update';
196: --

Line 234: => per_ssd_shd.g_old_rec.business_group_id

230: => p_rec.max_successors
231: ,p_object_version_number
232: => p_rec.object_version_number
233: ,p_business_group_id_o
234: => per_ssd_shd.g_old_rec.business_group_id
235: ,p_successee_type_o
236: => per_ssd_shd.g_old_rec.successee_type
237: ,p_successee_id_o
238: => per_ssd_shd.g_old_rec.successee_id

Line 236: => per_ssd_shd.g_old_rec.successee_type

232: => p_rec.object_version_number
233: ,p_business_group_id_o
234: => per_ssd_shd.g_old_rec.business_group_id
235: ,p_successee_type_o
236: => per_ssd_shd.g_old_rec.successee_type
237: ,p_successee_id_o
238: => per_ssd_shd.g_old_rec.successee_id
239: ,p_display_permissions_o
240: => per_ssd_shd.g_old_rec.display_permissions

Line 238: => per_ssd_shd.g_old_rec.successee_id

234: => per_ssd_shd.g_old_rec.business_group_id
235: ,p_successee_type_o
236: => per_ssd_shd.g_old_rec.successee_type
237: ,p_successee_id_o
238: => per_ssd_shd.g_old_rec.successee_id
239: ,p_display_permissions_o
240: => per_ssd_shd.g_old_rec.display_permissions
241: ,p_max_plans_o
242: => per_ssd_shd.g_old_rec.max_plans

Line 240: => per_ssd_shd.g_old_rec.display_permissions

236: => per_ssd_shd.g_old_rec.successee_type
237: ,p_successee_id_o
238: => per_ssd_shd.g_old_rec.successee_id
239: ,p_display_permissions_o
240: => per_ssd_shd.g_old_rec.display_permissions
241: ,p_max_plans_o
242: => per_ssd_shd.g_old_rec.max_plans
243: ,p_allow_npws_o
244: => per_ssd_shd.g_old_rec.allow_npws

Line 242: => per_ssd_shd.g_old_rec.max_plans

238: => per_ssd_shd.g_old_rec.successee_id
239: ,p_display_permissions_o
240: => per_ssd_shd.g_old_rec.display_permissions
241: ,p_max_plans_o
242: => per_ssd_shd.g_old_rec.max_plans
243: ,p_allow_npws_o
244: => per_ssd_shd.g_old_rec.allow_npws
245: ,p_allow_applicants_o
246: => per_ssd_shd.g_old_rec.allow_applicants

Line 244: => per_ssd_shd.g_old_rec.allow_npws

240: => per_ssd_shd.g_old_rec.display_permissions
241: ,p_max_plans_o
242: => per_ssd_shd.g_old_rec.max_plans
243: ,p_allow_npws_o
244: => per_ssd_shd.g_old_rec.allow_npws
245: ,p_allow_applicants_o
246: => per_ssd_shd.g_old_rec.allow_applicants
247: ,p_allow_override_search_o
248: => per_ssd_shd.g_old_rec.allow_override_search

Line 246: => per_ssd_shd.g_old_rec.allow_applicants

242: => per_ssd_shd.g_old_rec.max_plans
243: ,p_allow_npws_o
244: => per_ssd_shd.g_old_rec.allow_npws
245: ,p_allow_applicants_o
246: => per_ssd_shd.g_old_rec.allow_applicants
247: ,p_allow_override_search_o
248: => per_ssd_shd.g_old_rec.allow_override_search
249: ,p_key_entity_o
250: => per_ssd_shd.g_old_rec.key_entity

Line 248: => per_ssd_shd.g_old_rec.allow_override_search

244: => per_ssd_shd.g_old_rec.allow_npws
245: ,p_allow_applicants_o
246: => per_ssd_shd.g_old_rec.allow_applicants
247: ,p_allow_override_search_o
248: => per_ssd_shd.g_old_rec.allow_override_search
249: ,p_key_entity_o
250: => per_ssd_shd.g_old_rec.key_entity
251: ,p_risk_of_loss_o
252: => per_ssd_shd.g_old_rec.risk_of_loss

Line 250: => per_ssd_shd.g_old_rec.key_entity

246: => per_ssd_shd.g_old_rec.allow_applicants
247: ,p_allow_override_search_o
248: => per_ssd_shd.g_old_rec.allow_override_search
249: ,p_key_entity_o
250: => per_ssd_shd.g_old_rec.key_entity
251: ,p_risk_of_loss_o
252: => per_ssd_shd.g_old_rec.risk_of_loss
253: ,p_impact_of_loss_o
254: => per_ssd_shd.g_old_rec.impact_of_loss

Line 252: => per_ssd_shd.g_old_rec.risk_of_loss

248: => per_ssd_shd.g_old_rec.allow_override_search
249: ,p_key_entity_o
250: => per_ssd_shd.g_old_rec.key_entity
251: ,p_risk_of_loss_o
252: => per_ssd_shd.g_old_rec.risk_of_loss
253: ,p_impact_of_loss_o
254: => per_ssd_shd.g_old_rec.impact_of_loss
255: ,p_plan_readiness_rule_o
256: => per_ssd_shd.g_old_rec.plan_readiness_rule

Line 254: => per_ssd_shd.g_old_rec.impact_of_loss

250: => per_ssd_shd.g_old_rec.key_entity
251: ,p_risk_of_loss_o
252: => per_ssd_shd.g_old_rec.risk_of_loss
253: ,p_impact_of_loss_o
254: => per_ssd_shd.g_old_rec.impact_of_loss
255: ,p_plan_readiness_rule_o
256: => per_ssd_shd.g_old_rec.plan_readiness_rule
257: ,p_max_successors_o
258: => per_ssd_shd.g_old_rec.max_successors

Line 256: => per_ssd_shd.g_old_rec.plan_readiness_rule

252: => per_ssd_shd.g_old_rec.risk_of_loss
253: ,p_impact_of_loss_o
254: => per_ssd_shd.g_old_rec.impact_of_loss
255: ,p_plan_readiness_rule_o
256: => per_ssd_shd.g_old_rec.plan_readiness_rule
257: ,p_max_successors_o
258: => per_ssd_shd.g_old_rec.max_successors
259: ,p_object_version_number_o
260: => per_ssd_shd.g_old_rec.object_version_number

Line 258: => per_ssd_shd.g_old_rec.max_successors

254: => per_ssd_shd.g_old_rec.impact_of_loss
255: ,p_plan_readiness_rule_o
256: => per_ssd_shd.g_old_rec.plan_readiness_rule
257: ,p_max_successors_o
258: => per_ssd_shd.g_old_rec.max_successors
259: ,p_object_version_number_o
260: => per_ssd_shd.g_old_rec.object_version_number
261: );
262: --

Line 260: => per_ssd_shd.g_old_rec.object_version_number

256: => per_ssd_shd.g_old_rec.plan_readiness_rule
257: ,p_max_successors_o
258: => per_ssd_shd.g_old_rec.max_successors
259: ,p_object_version_number_o
260: => per_ssd_shd.g_old_rec.object_version_number
261: );
262: --
263: exception
264: --

Line 320: (p_rec in out nocopy per_ssd_shd.g_rec_type

316: --
317: -- {End Of Comments}
318: -- ----------------------------------------------------------------------------
319: Procedure convert_defs
320: (p_rec in out nocopy per_ssd_shd.g_rec_type
321: ) is
322: --
323: Begin
324: --

Line 332: per_ssd_shd.g_old_rec.business_group_id;

328: -- is being used then we must set to the 'current' argument value.
329: --
330: If (p_rec.business_group_id = hr_api.g_number) then
331: p_rec.business_group_id :=
332: per_ssd_shd.g_old_rec.business_group_id;
333: End If;
334: If (p_rec.successee_type = hr_api.g_varchar2) then
335: p_rec.successee_type :=
336: per_ssd_shd.g_old_rec.successee_type;

Line 336: per_ssd_shd.g_old_rec.successee_type;

332: per_ssd_shd.g_old_rec.business_group_id;
333: End If;
334: If (p_rec.successee_type = hr_api.g_varchar2) then
335: p_rec.successee_type :=
336: per_ssd_shd.g_old_rec.successee_type;
337: End If;
338: If (p_rec.successee_id = hr_api.g_number) then
339: p_rec.successee_id :=
340: per_ssd_shd.g_old_rec.successee_id;

Line 340: per_ssd_shd.g_old_rec.successee_id;

336: per_ssd_shd.g_old_rec.successee_type;
337: End If;
338: If (p_rec.successee_id = hr_api.g_number) then
339: p_rec.successee_id :=
340: per_ssd_shd.g_old_rec.successee_id;
341: End If;
342: If (p_rec.display_permissions = hr_api.g_varchar2) then
343: p_rec.display_permissions :=
344: per_ssd_shd.g_old_rec.display_permissions;

Line 344: per_ssd_shd.g_old_rec.display_permissions;

340: per_ssd_shd.g_old_rec.successee_id;
341: End If;
342: If (p_rec.display_permissions = hr_api.g_varchar2) then
343: p_rec.display_permissions :=
344: per_ssd_shd.g_old_rec.display_permissions;
345: End If;
346: If (p_rec.max_plans = hr_api.g_number) then
347: p_rec.max_plans :=
348: per_ssd_shd.g_old_rec.max_plans;

Line 348: per_ssd_shd.g_old_rec.max_plans;

344: per_ssd_shd.g_old_rec.display_permissions;
345: End If;
346: If (p_rec.max_plans = hr_api.g_number) then
347: p_rec.max_plans :=
348: per_ssd_shd.g_old_rec.max_plans;
349: End If;
350: If (p_rec.allow_npws = hr_api.g_varchar2) then
351: p_rec.allow_npws :=
352: per_ssd_shd.g_old_rec.allow_npws;

Line 352: per_ssd_shd.g_old_rec.allow_npws;

348: per_ssd_shd.g_old_rec.max_plans;
349: End If;
350: If (p_rec.allow_npws = hr_api.g_varchar2) then
351: p_rec.allow_npws :=
352: per_ssd_shd.g_old_rec.allow_npws;
353: End If;
354: If (p_rec.allow_applicants = hr_api.g_varchar2) then
355: p_rec.allow_applicants :=
356: per_ssd_shd.g_old_rec.allow_applicants;

Line 356: per_ssd_shd.g_old_rec.allow_applicants;

352: per_ssd_shd.g_old_rec.allow_npws;
353: End If;
354: If (p_rec.allow_applicants = hr_api.g_varchar2) then
355: p_rec.allow_applicants :=
356: per_ssd_shd.g_old_rec.allow_applicants;
357: End If;
358: If (p_rec.allow_override_search = hr_api.g_varchar2) then
359: p_rec.allow_override_search :=
360: per_ssd_shd.g_old_rec.allow_override_search;

Line 360: per_ssd_shd.g_old_rec.allow_override_search;

356: per_ssd_shd.g_old_rec.allow_applicants;
357: End If;
358: If (p_rec.allow_override_search = hr_api.g_varchar2) then
359: p_rec.allow_override_search :=
360: per_ssd_shd.g_old_rec.allow_override_search;
361: End If;
362: If (p_rec.key_entity = hr_api.g_varchar2) then
363: p_rec.key_entity :=
364: per_ssd_shd.g_old_rec.key_entity;

Line 364: per_ssd_shd.g_old_rec.key_entity;

360: per_ssd_shd.g_old_rec.allow_override_search;
361: End If;
362: If (p_rec.key_entity = hr_api.g_varchar2) then
363: p_rec.key_entity :=
364: per_ssd_shd.g_old_rec.key_entity;
365: End If;
366: If (p_rec.risk_of_loss = hr_api.g_varchar2) then
367: p_rec.risk_of_loss :=
368: per_ssd_shd.g_old_rec.risk_of_loss;

Line 368: per_ssd_shd.g_old_rec.risk_of_loss;

364: per_ssd_shd.g_old_rec.key_entity;
365: End If;
366: If (p_rec.risk_of_loss = hr_api.g_varchar2) then
367: p_rec.risk_of_loss :=
368: per_ssd_shd.g_old_rec.risk_of_loss;
369: End If;
370: If (p_rec.impact_of_loss = hr_api.g_varchar2) then
371: p_rec.impact_of_loss :=
372: per_ssd_shd.g_old_rec.impact_of_loss;

Line 372: per_ssd_shd.g_old_rec.impact_of_loss;

368: per_ssd_shd.g_old_rec.risk_of_loss;
369: End If;
370: If (p_rec.impact_of_loss = hr_api.g_varchar2) then
371: p_rec.impact_of_loss :=
372: per_ssd_shd.g_old_rec.impact_of_loss;
373: End If;
374: If (p_rec.plan_readiness_rule = hr_api.g_varchar2) then
375: p_rec.plan_readiness_rule :=
376: per_ssd_shd.g_old_rec.plan_readiness_rule;

Line 376: per_ssd_shd.g_old_rec.plan_readiness_rule;

372: per_ssd_shd.g_old_rec.impact_of_loss;
373: End If;
374: If (p_rec.plan_readiness_rule = hr_api.g_varchar2) then
375: p_rec.plan_readiness_rule :=
376: per_ssd_shd.g_old_rec.plan_readiness_rule;
377: End If;
378: If (p_rec.max_successors = hr_api.g_number) then
379: p_rec.max_successors :=
380: per_ssd_shd.g_old_rec.max_successors;

Line 380: per_ssd_shd.g_old_rec.max_successors;

376: per_ssd_shd.g_old_rec.plan_readiness_rule;
377: End If;
378: If (p_rec.max_successors = hr_api.g_number) then
379: p_rec.max_successors :=
380: per_ssd_shd.g_old_rec.max_successors;
381: End If;
382: --
383: End convert_defs;
384: --

Line 390: ,p_rec in out nocopy per_ssd_shd.g_rec_type

386: -- |---------------------------------< upd >----------------------------------|
387: -- ----------------------------------------------------------------------------
388: Procedure upd
389: (p_effective_date in date
390: ,p_rec in out nocopy per_ssd_shd.g_rec_type
391: ) is
392: --
393: l_proc varchar2(72) := g_package||'upd';
394: --

Line 400: per_ssd_shd.lck

396: hr_utility.set_location('Entering:'||l_proc, 5);
397: --
398: -- We must lock the row which we need to update.
399: --
400: per_ssd_shd.lck
401: (p_rec.successee_detail_id
402: ,p_rec.object_version_number
403: );
404: --

Line 461: l_rec per_ssd_shd.g_rec_type;

457: ,p_plan_readiness_rule in varchar2 default hr_api.g_varchar2
458: ,p_max_successors in number default hr_api.g_number
459: ) is
460: --
461: l_rec per_ssd_shd.g_rec_type;
462: l_proc varchar2(72) := g_package||'upd';
463: --
464: Begin
465: hr_utility.set_location('Entering:'||l_proc, 5);

Line 471: per_ssd_shd.convert_args

467: -- Call conversion function to turn arguments into the
468: -- l_rec structure.
469: --
470: l_rec :=
471: per_ssd_shd.convert_args
472: (p_successee_detail_id
473: ,p_business_group_id
474: ,p_successee_type
475: ,p_successee_id