APPS.PER_ZA_TRA_INS dependencies on PER_ZA_TRA_SHD

Line 53: Procedure insert_dml(p_rec in out nocopy per_za_tra_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_tra_shd.g_za_rec_type) is
54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin

Line 61: per_za_tra_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_tra_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: per_za_training
64: --
65: insert into per_za_training (

Line 91: per_za_tra_shd.g_api_dml := false; -- Unset the api dml status

87: p_rec.REGISTRATION_DATE,
88: p_rec.REGISTRATION_NUMBER
89: );
90: --
91: per_za_tra_shd.g_api_dml := false; -- Unset the api dml status
92: --
93: hr_utility.set_location(' Leaving:'||l_proc, 10);
94: Exception
95: When hr_api.check_integrity_violated Then

Line 97: per_za_tra_shd.g_api_dml := false; -- Unset the api dml status

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

Line 98: per_za_tra_shd.constraint_error

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

Line 102: per_za_tra_shd.g_api_dml := false; -- Unset the api dml status

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

Line 103: per_za_tra_shd.constraint_error

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

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

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

Line 108: per_za_tra_shd.constraint_error

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

Line 111: per_za_tra_shd.g_api_dml := false; -- Unset the api dml status

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

Line 147: Procedure post_insert(p_rec in per_za_tra_shd.g_za_rec_type) is

143: -- Internal Table Handler Use Only.
144: --
145: -- {End Of Comments}
146: -- ----------------------------------------------------------------------------
147: Procedure post_insert(p_rec in per_za_tra_shd.g_za_rec_type) is
148: --
149: l_proc varchar2(72) := g_package||'post_insert';
150: --
151: Begin

Line 162: p_rec in out nocopy per_za_tra_shd.g_za_rec_type,

158: -- |---------------------------------< ins >----------------------------------|
159: -- ----------------------------------------------------------------------------
160: Procedure ins
161: (
162: p_rec in out nocopy per_za_tra_shd.g_za_rec_type,
163: p_validate in boolean default false
164: ) is
165: --
166: l_proc varchar2(72) := g_package||'ins';

Line 223: l_rec per_za_tra_shd.g_za_rec_type;

219: P_NOTIONAL_HOURS IN NUMBER default null,
220: p_validate in boolean default false
221: ) is
222: --
223: l_rec per_za_tra_shd.g_za_rec_type;
224: l_proc varchar2(72) := g_package||'ins';
225: --
226: Begin
227: hr_utility.set_location('Entering:'||l_proc, 5);

Line 233: per_za_tra_shd.convert_args

229: -- Call conversion function to turn arguments into the
230: -- p_rec structure.
231: --
232: l_rec :=
233: per_za_tra_shd.convert_args
234: (
235: P_TRAINING_ID,
236: P_LEVEL_ID,
237: P_PERSON_ID,