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_ZA_LSA_UPD dependencies on PER_ZA_LSA_SHD

Line 54: Procedure update_dml(p_rec in out nocopy per_za_lsa_shd.g_za_rec_type) is

50: -- Internal Table Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy per_za_lsa_shd.g_za_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 64: per_za_lsa_shd.g_api_dml := true; -- Set the api dml status

60: --
61: -- Increment the object version
62: --
63: --
64: per_za_lsa_shd.g_api_dml := true; -- Set the api dml status
65: --
66: -- Update the per_za_assessments Row
67: --
68: update per_za_learnership_agreements

Line 87: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status

83: actual_end_date = p_rec.actual_end_date,
84: agreement_hard_copy_id = p_rec.agreement_hard_copy_id
85: where agreement_id = p_rec.agreement_id;
86: --
87: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 10);
90: --
91: Exception

Line 94: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status

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

Line 95: per_za_lsa_shd.constraint_error

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

Line 99: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status

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

Line 100: per_za_lsa_shd.constraint_error

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

Line 104: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status

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

Line 105: per_za_lsa_shd.constraint_error

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

Line 108: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status

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

Line 144: Procedure pre_update(p_rec in per_za_lsa_shd.g_za_rec_type) is

140: -- Internal Table Handler Use Only.
141: --
142: -- {End Of Comments}
143: -- ----------------------------------------------------------------------------
144: Procedure pre_update(p_rec in per_za_lsa_shd.g_za_rec_type) is
145: --
146: l_proc varchar2(72) := g_package||'pre_update';
147: --
148: Begin

Line 186: Procedure post_update(p_rec in per_za_lsa_shd.g_za_rec_type) is

182: -- Internal Table Handler Use Only.
183: --
184: -- {End Of Comments}
185: -- ----------------------------------------------------------------------------
186: Procedure post_update(p_rec in per_za_lsa_shd.g_za_rec_type) is
187: --
188: l_proc varchar2(72) := g_package||'post_update';
189: --
190: Begin

Line 201: p_rec in out nocopy per_za_lsa_shd.g_za_rec_type,

197: -- |---------------------------------< upd >----------------------------------|
198: -- ----------------------------------------------------------------------------
199: Procedure upd
200: (
201: p_rec in out nocopy per_za_lsa_shd.g_za_rec_type,
202: p_validate in boolean default false
203: ) is
204: --
205: l_proc varchar2(72) := g_package||'upd';

Line 221: per_za_lsa_shd.lck

217: End If;
218: --
219: -- We must lock the row which we need to update.
220: --
221: per_za_lsa_shd.lck
222: (
223: p_rec.agreement_id,
224: p_rec.person_id
225: );

Line 286: l_rec per_za_lsa_shd.g_za_rec_type;

282: p_reason_for_termination in varchar2 default null,
283: p_actual_end_date in date default null,
284: p_agreement_hard_copy_id in number default null) IS
285: --
286: l_rec per_za_lsa_shd.g_za_rec_type;
287: l_proc varchar2(72) := g_package||'upd';
288: --
289: Begin
290: hr_utility.set_location('Entering:'||l_proc, 5);

Line 296: per_za_lsa_shd.convert_args

292: -- Call conversion function to turn arguments into the
293: -- l_rec structure.
294: --
295: l_rec :=
296: per_za_lsa_shd.convert_args
297: (
298: p_agreement_id,
299: p_person_id,
300: p_name,