APPS.PAY_PEV_INS dependencies on PAY_PEV_SHD

Line 54: (p_rec in out nocopy pay_pev_shd.g_rec_type

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

Line 63: pay_pev_shd.g_api_dml := true; -- Set the api dml status

59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: p_rec.object_version_number := 1; -- Initialise the object version
62: --
63: pay_pev_shd.g_api_dml := true; -- Set the api dml status
64: --
65: -- Insert the row into: pay_process_events
66: --
67: insert into pay_process_events

Line 100: pay_pev_shd.g_api_dml := false; -- Unset the api dml status

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

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

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

Line 107: pay_pev_shd.constraint_error

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

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

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

Line 112: pay_pev_shd.constraint_error

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

Line 116: pay_pev_shd.g_api_dml := false; -- Unset the api dml status

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

Line 117: pay_pev_shd.constraint_error

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

Line 120: pay_pev_shd.g_api_dml := false; -- Unset the api dml status

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

Line 162: (p_rec in out nocopy pay_pev_shd.g_rec_type

158: --
159: -- {End Of Comments}
160: -- ----------------------------------------------------------------------------
161: Procedure pre_insert
162: (p_rec in out nocopy pay_pev_shd.g_rec_type
163: ) is
164: --
165: l_proc varchar2(72) := g_package||'pre_insert';
166: --

Line 215: (p_rec in pay_pev_shd.g_rec_type

211: --
212: -- {End Of Comments}
213: -- ----------------------------------------------------------------------------
214: Procedure post_insert
215: (p_rec in pay_pev_shd.g_rec_type
216: ) is
217: --
218: l_proc varchar2(72) := g_package||'post_insert';
219: --

Line 272: (p_rec in out nocopy pay_pev_shd.g_rec_type

268: -- ----------------------------------------------------------------------------
269: -- |---------------------------------< ins >----------------------------------|
270: -- ----------------------------------------------------------------------------
271: Procedure ins
272: (p_rec in out nocopy pay_pev_shd.g_rec_type
273: ) is
274: --
275: l_proc varchar2(72) := g_package||'ins';
276: --

Line 323: l_rec pay_pev_shd.g_rec_type;

319: ,p_retroactive_status in varchar2 default null
320: ,p_noted_value in varchar2 default null
321: ) is
322: --
323: l_rec pay_pev_shd.g_rec_type;
324: l_proc varchar2(72) := g_package||'ins';
325: --
326: Begin
327: hr_utility.set_location('Entering:'||l_proc, 5);

Line 333: pay_pev_shd.convert_args

329: -- Call conversion function to turn arguments into the
330: -- p_rec structure.
331: --
332: l_rec :=
333: pay_pev_shd.convert_args
334: (null
335: ,p_assignment_id
336: ,p_effective_date
337: ,p_change_type