eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_FDL_INS dependencies on PER_FDL_SHD

Line 80: (p_rec in out nocopy per_fdl_shd.g_rec_type

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

Line 89: per_fdl_shd.g_api_dml := true; -- Set the api dml status

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

Line 146: per_fdl_shd.g_api_dml := false; -- Unset the api dml status

142: ,p_rec.fdl_information10
143: ,p_rec.object_version_number
144: );
145: --
146: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
147:
148: --
149: hr_utility.set_location(' Leaving:'||l_proc, 10);
150: Exception

Line 153: per_fdl_shd.g_api_dml := false; -- Unset the api dml status

149: hr_utility.set_location(' Leaving:'||l_proc, 10);
150: Exception
151: When hr_api.check_integrity_violated Then
152: -- A check constraint has been violated
153: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
154:
155: per_fdl_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When hr_api.parent_integrity_violated Then

Line 155: per_fdl_shd.constraint_error

151: When hr_api.check_integrity_violated Then
152: -- A check constraint has been violated
153: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
154:
155: per_fdl_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When hr_api.parent_integrity_violated Then
158: -- Parent integrity has been violated
159: per_fdl_shd.g_api_dml := false; -- Unset the api dml status

Line 159: per_fdl_shd.g_api_dml := false; -- Unset the api dml status

155: per_fdl_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When hr_api.parent_integrity_violated Then
158: -- Parent integrity has been violated
159: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
160:
161: per_fdl_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When hr_api.unique_integrity_violated Then

Line 161: per_fdl_shd.constraint_error

157: When hr_api.parent_integrity_violated Then
158: -- Parent integrity has been violated
159: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
160:
161: per_fdl_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When hr_api.unique_integrity_violated Then
164: -- Unique integrity has been violated
165: per_fdl_shd.g_api_dml := false; -- Unset the api dml status

Line 165: per_fdl_shd.g_api_dml := false; -- Unset the api dml status

161: per_fdl_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When hr_api.unique_integrity_violated Then
164: -- Unique integrity has been violated
165: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
166:
167: per_fdl_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When Others Then

Line 167: per_fdl_shd.constraint_error

163: When hr_api.unique_integrity_violated Then
164: -- Unique integrity has been violated
165: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
166:
167: per_fdl_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When Others Then
170: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
171:

Line 170: per_fdl_shd.g_api_dml := false; -- Unset the api dml status

166:
167: per_fdl_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When Others Then
170: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
171:
172: Raise;
173: End insert_dml;
174:

Line 214: (p_rec in out nocopy per_fdl_shd.g_rec_type

210: --
211: -- {End Of Comments}
212: -- ----------------------------------------------------------------------------
213: Procedure pre_insert
214: (p_rec in out nocopy per_fdl_shd.g_rec_type
215: ) is
216: --
217: Cursor C_Sel1 is select per_fnd_doc_links_s.nextval from sys.dual;
218: --

Line 303: (p_rec in per_fdl_shd.g_rec_type

299: --
300: -- {End Of Comments}
301: -- ----------------------------------------------------------------------------
302: Procedure post_insert
303: (p_rec in per_fdl_shd.g_rec_type
304: ) is
305: --
306: l_proc varchar2(72) := g_package||'post_insert';
307: --

Line 385: (p_rec in out nocopy per_fdl_shd.g_rec_type

381: -- ----------------------------------------------------------------------------
382: -- |---------------------------------< ins >----------------------------------|
383: -- ----------------------------------------------------------------------------
384: Procedure ins
385: (p_rec in out nocopy per_fdl_shd.g_rec_type
386: ) is
387: --
388: l_proc varchar2(72) := g_package||'ins';
389: --

Line 452: l_rec per_fdl_shd.g_rec_type;

448: ,p_fnd_doc_link_id out nocopy number
449: ,p_object_version_number out nocopy number
450: ) is
451: --
452: l_rec per_fdl_shd.g_rec_type;
453: l_proc varchar2(72) := g_package||'ins';
454: --
455: Begin
456: hr_utility.set_location('Entering:'||l_proc, 5);

Line 462: per_fdl_shd.convert_args

458: -- Call conversion function to turn arguments into the
459: -- p_rec structure.
460: --
461: l_rec :=
462: per_fdl_shd.convert_args
463: (null
464: ,p_entity_name
465: ,p_sub_entity_name
466: ,p_entity_doc_id