APPS.PQH_FYN_INS dependencies on PQH_FYN_SHD

Line 47: Procedure insert_dml(p_rec in out nocopy pqh_fyn_shd.g_rec_type) is

43: -- Internal Row Handler Use Only.
44: --
45: -- {End Of Comments}
46: -- ----------------------------------------------------------------------------
47: Procedure insert_dml(p_rec in out nocopy pqh_fyn_shd.g_rec_type) is
48: --
49: l_proc varchar2(72) := g_package||'insert_dml';
50:
51: l_count number(9) := 0;

Line 134: pqh_fyn_shd.constraint_error

130: hr_utility.set_location(' Leaving:'||l_proc, 20);
131: Exception
132: When hr_api.check_integrity_violated Then
133: -- A check constraint has been violated
134: pqh_fyn_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: pqh_fyn_shd.constraint_error

Line 138: pqh_fyn_shd.constraint_error

134: pqh_fyn_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: pqh_fyn_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: pqh_fyn_shd.constraint_error

Line 142: pqh_fyn_shd.constraint_error

138: pqh_fyn_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: pqh_fyn_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When Others Then
145: Raise;
146: End insert_dml;

Line 185: Procedure pre_insert(p_rec in out nocopy pqh_fyn_shd.g_rec_type) is

181: -- Internal Row Handler Use Only.
182: --
183: -- {End Of Comments}
184: -- ----------------------------------------------------------------------------
185: Procedure pre_insert(p_rec in out nocopy pqh_fyn_shd.g_rec_type) is
186: --
187: l_proc varchar2(72) := g_package||'pre_insert';
188: --
189: Cursor C_Sel1 is select pqh_fyi_notify_s.nextval from sys.dual;

Line 237: p_effective_date in date,p_rec in pqh_fyn_shd.g_rec_type) is

233: --
234: -- {End Of Comments}
235: -- ----------------------------------------------------------------------------
236: Procedure post_insert(
237: p_effective_date in date,p_rec in pqh_fyn_shd.g_rec_type) is
238: --
239: l_proc varchar2(72) := g_package||'post_insert';
240: --
241: Begin

Line 285: p_rec in out nocopy pqh_fyn_shd.g_rec_type

281: -- ----------------------------------------------------------------------------
282: Procedure ins
283: (
284: p_effective_date in date,
285: p_rec in out nocopy pqh_fyn_shd.g_rec_type
286: ) is
287: --
288: l_proc varchar2(72) := g_package||'ins';
289: --

Line 329: l_rec pqh_fyn_shd.g_rec_type;

325: p_status in varchar2 default null,
326: p_object_version_number out nocopy number
327: ) is
328: --
329: l_rec pqh_fyn_shd.g_rec_type;
330: l_proc varchar2(72) := g_package||'ins';
331: --
332: Begin
333: hr_utility.set_location('Entering:'||l_proc, 5);

Line 339: pqh_fyn_shd.convert_args

335: -- Call conversion function to turn arguments into the
336: -- p_rec structure.
337: --
338: l_rec :=
339: pqh_fyn_shd.convert_args
340: (
341: null,
342: p_transaction_category_id,
343: p_transaction_id,