DBA Data[Home] [Help]

APPS.FF_CON_INS dependencies on FF_CON_SHD

Line 53: Procedure insert_dml(p_rec in out nocopy ff_con_shd.g_rec_type) is

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

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

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

Line 78: ff_con_shd.g_api_dml := false; -- Unset the api dml status

74: p_rec.context,
75: p_rec.context_id
76: );
77: --
78: ff_con_shd.g_api_dml := false; -- Unset the api dml status
79: --
80: hr_utility.set_location(' Leaving:'||l_proc, 10);
81: Exception
82: When hr_api.check_integrity_violated Then

Line 84: ff_con_shd.g_api_dml := false; -- Unset the api dml status

80: hr_utility.set_location(' Leaving:'||l_proc, 10);
81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
84: ff_con_shd.g_api_dml := false; -- Unset the api dml status
85: ff_con_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated

Line 85: ff_con_shd.constraint_error

81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
84: ff_con_shd.g_api_dml := false; -- Unset the api dml status
85: ff_con_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: ff_con_shd.g_api_dml := false; -- Unset the api dml status

Line 89: ff_con_shd.g_api_dml := false; -- Unset the api dml status

85: ff_con_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: ff_con_shd.g_api_dml := false; -- Unset the api dml status
90: ff_con_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.unique_integrity_violated Then
93: -- Unique integrity has been violated

Line 90: ff_con_shd.constraint_error

86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: ff_con_shd.g_api_dml := false; -- Unset the api dml status
90: ff_con_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.unique_integrity_violated Then
93: -- Unique integrity has been violated
94: ff_con_shd.g_api_dml := false; -- Unset the api dml status

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

90: ff_con_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.unique_integrity_violated Then
93: -- Unique integrity has been violated
94: ff_con_shd.g_api_dml := false; -- Unset the api dml status
95: ff_con_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When Others Then
98: ff_con_shd.g_api_dml := false; -- Unset the api dml status

Line 95: ff_con_shd.constraint_error

91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.unique_integrity_violated Then
93: -- Unique integrity has been violated
94: ff_con_shd.g_api_dml := false; -- Unset the api dml status
95: ff_con_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When Others Then
98: ff_con_shd.g_api_dml := false; -- Unset the api dml status
99: Raise;

Line 98: ff_con_shd.g_api_dml := false; -- Unset the api dml status

94: ff_con_shd.g_api_dml := false; -- Unset the api dml status
95: ff_con_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When Others Then
98: ff_con_shd.g_api_dml := false; -- Unset the api dml status
99: Raise;
100: End insert_dml;
101: --
102: -- ----------------------------------------------------------------------------

Line 139: Procedure pre_insert(p_rec in out nocopy ff_con_shd.g_rec_type) is

135: -- Internal Row Handler Use Only.
136: --
137: -- {End Of Comments}
138: -- ----------------------------------------------------------------------------
139: Procedure pre_insert(p_rec in out nocopy ff_con_shd.g_rec_type) is
140: --
141: l_proc varchar2(72) := g_package||'pre_insert';
142: --
143: --

Line 185: Procedure post_insert(p_rec in ff_con_shd.g_rec_type) is

181: -- Internal Row Handler Use Only.
182: --
183: -- {End Of Comments}
184: -- ----------------------------------------------------------------------------
185: Procedure post_insert(p_rec in ff_con_shd.g_rec_type) is
186: --
187: l_proc varchar2(72) := g_package||'post_insert';
188: --
189: Begin

Line 200: p_rec in out nocopy ff_con_shd.g_rec_type

196: -- |---------------------------------< ins >----------------------------------|
197: -- ----------------------------------------------------------------------------
198: Procedure ins
199: (
200: p_rec in out nocopy ff_con_shd.g_rec_type
201: ) is
202: --
203: l_proc varchar2(72) := g_package||'ins';
204: --

Line 236: l_rec ff_con_shd.g_rec_type;

232: p_context in varchar2,
233: p_context_id in number
234: ) is
235: --
236: l_rec ff_con_shd.g_rec_type;
237: l_proc varchar2(72) := g_package||'ins';
238: --
239: Begin
240: hr_utility.set_location('Entering:'||l_proc, 5);

Line 246: ff_con_shd.convert_args

242: -- Call conversion function to turn arguments into the
243: -- p_rec structure.
244: --
245: l_rec :=
246: ff_con_shd.convert_args
247: (
248: p_archive_item_id,
249: p_sequence_no,
250: p_context,