DBA Data[Home] [Help]

APPS.FF_FCU_UPD dependencies on FF_FCU_SHD

Line 55: (p_rec in out nocopy ff_fcu_shd.g_rec_type

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

Line 66: ff_fcu_shd.g_api_dml := true; -- Set the api dml status

62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: ff_fcu_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the ff_function_context_usages Row
69: --
70: update ff_function_context_usages

Line 79: ff_fcu_shd.g_api_dml := false; -- Unset the api dml status

75: ,object_version_number = p_rec.object_version_number
76: where function_id = p_rec.function_id
77: and sequence_number = p_rec.sequence_number;
78: --
79: ff_fcu_shd.g_api_dml := false; -- Unset the api dml status
80: --
81: hr_utility.set_location(' Leaving:'||l_proc, 10);
82: --
83: Exception

Line 86: ff_fcu_shd.g_api_dml := false; -- Unset the api dml status

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

Line 87: ff_fcu_shd.constraint_error

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

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

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

Line 92: ff_fcu_shd.constraint_error

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

Line 96: ff_fcu_shd.g_api_dml := false; -- Unset the api dml status

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

Line 97: ff_fcu_shd.constraint_error

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

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

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

Line 137: (p_rec in ff_fcu_shd.g_rec_type

133: --
134: -- {End Of Comments}
135: -- ----------------------------------------------------------------------------
136: Procedure pre_update
137: (p_rec in ff_fcu_shd.g_rec_type
138: ) is
139: --
140: l_proc varchar2(72) := g_package||'pre_update';
141: --

Line 181: (p_rec in ff_fcu_shd.g_rec_type

177: --
178: -- {End Of Comments}
179: -- ----------------------------------------------------------------------------
180: Procedure post_update
181: (p_rec in ff_fcu_shd.g_rec_type
182: ) is
183: --
184: l_proc varchar2(72) := g_package||'post_update';
185: --

Line 200: => ff_fcu_shd.g_old_rec.context_id

196: => p_rec.context_id
197: ,p_object_version_number
198: => p_rec.object_version_number
199: ,p_context_id_o
200: => ff_fcu_shd.g_old_rec.context_id
201: ,p_object_version_number_o
202: => ff_fcu_shd.g_old_rec.object_version_number
203: );
204: --

Line 202: => ff_fcu_shd.g_old_rec.object_version_number

198: => p_rec.object_version_number
199: ,p_context_id_o
200: => ff_fcu_shd.g_old_rec.context_id
201: ,p_object_version_number_o
202: => ff_fcu_shd.g_old_rec.object_version_number
203: );
204: --
205: exception
206: --

Line 262: (p_rec in out nocopy ff_fcu_shd.g_rec_type

258: --
259: -- {End Of Comments}
260: -- ----------------------------------------------------------------------------
261: Procedure convert_defs
262: (p_rec in out nocopy ff_fcu_shd.g_rec_type
263: ) is
264: --
265: Begin
266: --

Line 274: ff_fcu_shd.g_old_rec.context_id;

270: -- is being used then we must set to the 'current' argument value.
271: --
272: If (p_rec.context_id = hr_api.g_number) then
273: p_rec.context_id :=
274: ff_fcu_shd.g_old_rec.context_id;
275: End If;
276: --
277: End convert_defs;
278: --

Line 283: (p_rec in out nocopy ff_fcu_shd.g_rec_type

279: -- ----------------------------------------------------------------------------
280: -- |---------------------------------< upd >----------------------------------|
281: -- ----------------------------------------------------------------------------
282: Procedure upd
283: (p_rec in out nocopy ff_fcu_shd.g_rec_type
284: ) is
285: --
286: l_proc varchar2(72) := g_package||'upd';
287: --

Line 293: ff_fcu_shd.lck

289: hr_utility.set_location('Entering:'||l_proc, 5);
290: --
291: -- We must lock the row which we need to update.
292: --
293: ff_fcu_shd.lck
294: (p_rec.function_id
295: ,p_rec.sequence_number
296: ,p_rec.object_version_number
297: );

Line 341: l_rec ff_fcu_shd.g_rec_type;

337: ,p_object_version_number in out nocopy number
338: ,p_context_id in number default hr_api.g_number
339: ) is
340: --
341: l_rec ff_fcu_shd.g_rec_type;
342: l_proc varchar2(72) := g_package||'upd';
343: --
344: Begin
345: hr_utility.set_location('Entering:'||l_proc, 5);

Line 351: ff_fcu_shd.convert_args

347: -- Call conversion function to turn arguments into the
348: -- l_rec structure.
349: --
350: l_rec :=
351: ff_fcu_shd.convert_args
352: (p_function_id
353: ,p_sequence_number
354: ,p_context_id
355: ,p_object_version_number