APPS.PER_ZA_LSA_INS dependencies on PER_ZA_LSA_SHD

Line 53: Procedure insert_dml(p_rec in out nocopy per_za_lsa_shd.g_za_rec_type) is

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

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

57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59:
60: --
61: per_za_lsa_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: per_za_assessments
64: --
65: insert into per_za_learnership_agreements(

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

97: p_rec.ACTUAL_END_DATE,
98: p_rec.AGREEMENT_HARD_COPY_ID
99: );
100: --
101: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
102: --
103: hr_utility.set_location(' Leaving:'||l_proc, 10);
104: Exception
105: When hr_api.check_integrity_violated Then

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

103: hr_utility.set_location(' Leaving:'||l_proc, 10);
104: Exception
105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
107: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
108: per_za_lsa_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated

Line 108: per_za_lsa_shd.constraint_error

104: Exception
105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
107: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
108: per_za_lsa_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status

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

108: per_za_lsa_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
113: per_za_lsa_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated

Line 113: per_za_lsa_shd.constraint_error

109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
113: per_za_lsa_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status

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

113: per_za_lsa_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
118: per_za_lsa_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status

Line 118: per_za_lsa_shd.constraint_error

114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
118: per_za_lsa_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
122: Raise;

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

117: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
118: per_za_lsa_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
122: Raise;
123: End insert_dml;
124:
125: -- ----------------------------------------------------------------------------

Line 157: Procedure post_insert(p_rec in per_za_lsa_shd.g_za_rec_type) is

153: -- Internal Table Handler Use Only.
154: --
155: -- {End Of Comments}
156: -- ----------------------------------------------------------------------------
157: Procedure post_insert(p_rec in per_za_lsa_shd.g_za_rec_type) is
158: --
159: l_proc varchar2(72) := g_package||'post_insert';
160: --
161: Begin

Line 172: p_rec in out nocopy per_za_lsa_shd.g_za_rec_type,

168: -- |---------------------------------< ins >----------------------------------|
169: -- ----------------------------------------------------------------------------
170: Procedure ins
171: (
172: p_rec in out nocopy per_za_lsa_shd.g_za_rec_type,
173: p_validate in boolean default false
174: ) is
175: --
176: l_proc varchar2(72) := g_package||'ins';

Line 236: l_rec per_za_lsa_shd.g_za_rec_type;

232: p_reason_for_termination in varchar2 default null,
233: p_actual_end_date in date default null,
234: p_agreement_hard_copy_id in number default null) IS
235: --
236: l_rec per_za_lsa_shd.g_za_rec_type;
237: l_proc varchar2(72) := g_package||'ins';
238: --
239: Begin
240: hr_utility.set_location('Entering:'||l_proc, 5);

Line 246: per_za_lsa_shd.convert_args

242: -- Call conversion function to turn arguments into the
243: -- p_rec structure.
244: --
245: l_rec :=
246: per_za_lsa_shd.convert_args
247: (
248: p_agreement_id,
249: p_person_id,
250: p_name,