APPS.FF_FCU_INS dependencies on FF_FCU_SHD

Line 79: (p_rec in out nocopy ff_fcu_shd.g_rec_type

75: --
76: -- {End Of Comments}
77: -- ----------------------------------------------------------------------------
78: Procedure insert_dml
79: (p_rec in out nocopy ff_fcu_shd.g_rec_type
80: ) is
81: --
82: l_proc varchar2(72) := g_package||'insert_dml';
83: --

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

84: Begin
85: hr_utility.set_location('Entering:'||l_proc, 5);
86: p_rec.object_version_number := 1; -- Initialise the object version
87: --
88: ff_fcu_shd.g_api_dml := true; -- Set the api dml status
89: --
90: -- Insert the row into: ff_function_context_usages
91: --
92: insert into ff_function_context_usages

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

101: ,p_rec.context_id
102: ,p_rec.object_version_number
103: );
104: --
105: ff_fcu_shd.g_api_dml := false; -- Unset the api dml status
106: --
107: hr_utility.set_location(' Leaving:'||l_proc, 10);
108: Exception
109: When hr_api.check_integrity_violated Then

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

107: hr_utility.set_location(' Leaving:'||l_proc, 10);
108: Exception
109: When hr_api.check_integrity_violated Then
110: -- A check constraint has been violated
111: ff_fcu_shd.g_api_dml := false; -- Unset the api dml status
112: ff_fcu_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.parent_integrity_violated Then
115: -- Parent integrity has been violated

Line 112: ff_fcu_shd.constraint_error

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

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

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

Line 117: ff_fcu_shd.constraint_error

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

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

117: ff_fcu_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: ff_fcu_shd.g_api_dml := false; -- Unset the api dml status
122: ff_fcu_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When Others Then
125: ff_fcu_shd.g_api_dml := false; -- Unset the api dml status

Line 122: ff_fcu_shd.constraint_error

118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: ff_fcu_shd.g_api_dml := false; -- Unset the api dml status
122: ff_fcu_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When Others Then
125: ff_fcu_shd.g_api_dml := false; -- Unset the api dml status
126: Raise;

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

121: ff_fcu_shd.g_api_dml := false; -- Unset the api dml status
122: ff_fcu_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When Others Then
125: ff_fcu_shd.g_api_dml := false; -- Unset the api dml status
126: Raise;
127: End insert_dml;
128: --
129: -- ----------------------------------------------------------------------------

Line 167: (p_rec in out nocopy ff_fcu_shd.g_rec_type

163: --
164: -- {End Of Comments}
165: -- ----------------------------------------------------------------------------
166: Procedure pre_insert
167: (p_rec in out nocopy ff_fcu_shd.g_rec_type
168: ) is
169: --
170: -- Cursor C_Sel1 is select ff_function_context_usages_s.nextval from sys.dual;
171: Cursor C_Sel1 is

Line 265: (p_rec in ff_fcu_shd.g_rec_type

261: --
262: -- {End Of Comments}
263: -- ----------------------------------------------------------------------------
264: Procedure post_insert
265: (p_rec in ff_fcu_shd.g_rec_type
266: ) is
267: --
268: l_proc varchar2(72) := g_package||'post_insert';
269: --

Line 298: (p_rec in out nocopy ff_fcu_shd.g_rec_type

294: -- ----------------------------------------------------------------------------
295: -- |---------------------------------< ins >----------------------------------|
296: -- ----------------------------------------------------------------------------
297: Procedure ins
298: (p_rec in out nocopy ff_fcu_shd.g_rec_type
299: ) is
300: --
301: l_proc varchar2(72) := g_package||'ins';
302: --

Line 345: l_rec ff_fcu_shd.g_rec_type;

341: ,p_sequence_number out nocopy number
342: ,p_object_version_number out nocopy number
343: ) is
344: --
345: l_rec ff_fcu_shd.g_rec_type;
346: l_proc varchar2(72) := g_package||'ins';
347: --
348: Begin
349: hr_utility.set_location('Entering:'||l_proc, 5);

Line 356: ff_fcu_shd.convert_args

352: -- Call conversion function to turn arguments into the
353: -- p_rec structure.
354: --
355: l_rec :=
356: ff_fcu_shd.convert_args
357: (p_function_id
358: ,null
359: ,p_context_id
360: ,null