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_DEL dependencies on PER_FDL_SHD

Line 54: (p_rec in per_fdl_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure delete_dml
54: (p_rec in per_fdl_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'delete_dml';
58: --

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

58: --
59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: --
62: per_fdl_shd.g_api_dml := true; -- Set the api dml status
63: --
64: -- Delete the per_fnd_doc_links row.
65: --
66: delete from per_fnd_doc_links

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

65: --
66: delete from per_fnd_doc_links
67: where fnd_doc_link_id = p_rec.fnd_doc_link_id;
68: --
69: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
70:
71: --
72: hr_utility.set_location(' Leaving:'||l_proc, 10);
73: --

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

73: --
74: Exception
75: When hr_api.child_integrity_violated then
76: -- Child integrity has been violated
77: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
78:
79: per_fdl_shd.constraint_error
80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When Others Then

Line 79: per_fdl_shd.constraint_error

75: When hr_api.child_integrity_violated then
76: -- Child integrity has been violated
77: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
78:
79: per_fdl_shd.constraint_error
80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When Others Then
82: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
83:

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

78:
79: per_fdl_shd.constraint_error
80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When Others Then
82: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
83:
84: Raise;
85: End delete_dml;
86:

Line 121: Procedure pre_delete(p_rec in per_fdl_shd.g_rec_type) is

117: -- Internal Row Handler Use Only.
118: --
119: -- {End Of Comments}
120: -- ----------------------------------------------------------------------------
121: Procedure pre_delete(p_rec in per_fdl_shd.g_rec_type) is
122: --
123: l_proc varchar2(72) := g_package||'pre_delete';
124: --
125: Begin

Line 165: Procedure post_delete(p_rec in per_fdl_shd.g_rec_type) is

161: --
162: -- {End Of Comments}
163: -- -----------------------------------------------------------------------------
164:
165: Procedure post_delete(p_rec in per_fdl_shd.g_rec_type) is
166: --
167: l_proc varchar2(72) := g_package||'post_delete';
168: --
169: Begin

Line 179: => per_fdl_shd.g_old_rec.entity_name

175: per_fdl_rkd.after_delete
176: (p_fnd_doc_link_id
177: => p_rec.fnd_doc_link_id
178: ,p_entity_name_o
179: => per_fdl_shd.g_old_rec.entity_name
180: ,p_sub_entity_name_o
181: => per_fdl_shd.g_old_rec.sub_entity_name
182: ,p_entity_doc_id_o
183: => per_fdl_shd.g_old_rec.entity_doc_id

Line 181: => per_fdl_shd.g_old_rec.sub_entity_name

177: => p_rec.fnd_doc_link_id
178: ,p_entity_name_o
179: => per_fdl_shd.g_old_rec.entity_name
180: ,p_sub_entity_name_o
181: => per_fdl_shd.g_old_rec.sub_entity_name
182: ,p_entity_doc_id_o
183: => per_fdl_shd.g_old_rec.entity_doc_id
184: ,p_fnd_doc_id_o
185: => per_fdl_shd.g_old_rec.fnd_doc_id

Line 183: => per_fdl_shd.g_old_rec.entity_doc_id

179: => per_fdl_shd.g_old_rec.entity_name
180: ,p_sub_entity_name_o
181: => per_fdl_shd.g_old_rec.sub_entity_name
182: ,p_entity_doc_id_o
183: => per_fdl_shd.g_old_rec.entity_doc_id
184: ,p_fnd_doc_id_o
185: => per_fdl_shd.g_old_rec.fnd_doc_id
186: ,p_person_id_o
187: => per_fdl_shd.g_old_rec.person_id

Line 185: => per_fdl_shd.g_old_rec.fnd_doc_id

181: => per_fdl_shd.g_old_rec.sub_entity_name
182: ,p_entity_doc_id_o
183: => per_fdl_shd.g_old_rec.entity_doc_id
184: ,p_fnd_doc_id_o
185: => per_fdl_shd.g_old_rec.fnd_doc_id
186: ,p_person_id_o
187: => per_fdl_shd.g_old_rec.person_id
188: ,p_assignment_id_o
189: => per_fdl_shd.g_old_rec.assignment_id

Line 187: => per_fdl_shd.g_old_rec.person_id

183: => per_fdl_shd.g_old_rec.entity_doc_id
184: ,p_fnd_doc_id_o
185: => per_fdl_shd.g_old_rec.fnd_doc_id
186: ,p_person_id_o
187: => per_fdl_shd.g_old_rec.person_id
188: ,p_assignment_id_o
189: => per_fdl_shd.g_old_rec.assignment_id
190: ,p_application_id_o
191: => per_fdl_shd.g_old_rec.application_id

Line 189: => per_fdl_shd.g_old_rec.assignment_id

185: => per_fdl_shd.g_old_rec.fnd_doc_id
186: ,p_person_id_o
187: => per_fdl_shd.g_old_rec.person_id
188: ,p_assignment_id_o
189: => per_fdl_shd.g_old_rec.assignment_id
190: ,p_application_id_o
191: => per_fdl_shd.g_old_rec.application_id
192: ,p_doc_upload_date_o
193: => per_fdl_shd.g_old_rec.doc_upload_date

Line 191: => per_fdl_shd.g_old_rec.application_id

187: => per_fdl_shd.g_old_rec.person_id
188: ,p_assignment_id_o
189: => per_fdl_shd.g_old_rec.assignment_id
190: ,p_application_id_o
191: => per_fdl_shd.g_old_rec.application_id
192: ,p_doc_upload_date_o
193: => per_fdl_shd.g_old_rec.doc_upload_date
194: ,p_transaction_type_o
195: => per_fdl_shd.g_old_rec.transaction_type

Line 193: => per_fdl_shd.g_old_rec.doc_upload_date

189: => per_fdl_shd.g_old_rec.assignment_id
190: ,p_application_id_o
191: => per_fdl_shd.g_old_rec.application_id
192: ,p_doc_upload_date_o
193: => per_fdl_shd.g_old_rec.doc_upload_date
194: ,p_transaction_type_o
195: => per_fdl_shd.g_old_rec.transaction_type
196: ,p_transaction_status_o
197: => per_fdl_shd.g_old_rec.transaction_status

Line 195: => per_fdl_shd.g_old_rec.transaction_type

191: => per_fdl_shd.g_old_rec.application_id
192: ,p_doc_upload_date_o
193: => per_fdl_shd.g_old_rec.doc_upload_date
194: ,p_transaction_type_o
195: => per_fdl_shd.g_old_rec.transaction_type
196: ,p_transaction_status_o
197: => per_fdl_shd.g_old_rec.transaction_status
198: ,p_status_o
199: => per_fdl_shd.g_old_rec.status

Line 197: => per_fdl_shd.g_old_rec.transaction_status

193: => per_fdl_shd.g_old_rec.doc_upload_date
194: ,p_transaction_type_o
195: => per_fdl_shd.g_old_rec.transaction_type
196: ,p_transaction_status_o
197: => per_fdl_shd.g_old_rec.transaction_status
198: ,p_status_o
199: => per_fdl_shd.g_old_rec.status
200: ,p_fdl_information_category_o
201: => per_fdl_shd.g_old_rec.fdl_information_category

Line 199: => per_fdl_shd.g_old_rec.status

195: => per_fdl_shd.g_old_rec.transaction_type
196: ,p_transaction_status_o
197: => per_fdl_shd.g_old_rec.transaction_status
198: ,p_status_o
199: => per_fdl_shd.g_old_rec.status
200: ,p_fdl_information_category_o
201: => per_fdl_shd.g_old_rec.fdl_information_category
202: ,p_fdl_information1_o
203: => per_fdl_shd.g_old_rec.fdl_information1

Line 201: => per_fdl_shd.g_old_rec.fdl_information_category

197: => per_fdl_shd.g_old_rec.transaction_status
198: ,p_status_o
199: => per_fdl_shd.g_old_rec.status
200: ,p_fdl_information_category_o
201: => per_fdl_shd.g_old_rec.fdl_information_category
202: ,p_fdl_information1_o
203: => per_fdl_shd.g_old_rec.fdl_information1
204: ,p_fdl_information2_o
205: => per_fdl_shd.g_old_rec.fdl_information2

Line 203: => per_fdl_shd.g_old_rec.fdl_information1

199: => per_fdl_shd.g_old_rec.status
200: ,p_fdl_information_category_o
201: => per_fdl_shd.g_old_rec.fdl_information_category
202: ,p_fdl_information1_o
203: => per_fdl_shd.g_old_rec.fdl_information1
204: ,p_fdl_information2_o
205: => per_fdl_shd.g_old_rec.fdl_information2
206: ,p_fdl_information3_o
207: => per_fdl_shd.g_old_rec.fdl_information3

Line 205: => per_fdl_shd.g_old_rec.fdl_information2

201: => per_fdl_shd.g_old_rec.fdl_information_category
202: ,p_fdl_information1_o
203: => per_fdl_shd.g_old_rec.fdl_information1
204: ,p_fdl_information2_o
205: => per_fdl_shd.g_old_rec.fdl_information2
206: ,p_fdl_information3_o
207: => per_fdl_shd.g_old_rec.fdl_information3
208: ,p_fdl_information4_o
209: => per_fdl_shd.g_old_rec.fdl_information4

Line 207: => per_fdl_shd.g_old_rec.fdl_information3

203: => per_fdl_shd.g_old_rec.fdl_information1
204: ,p_fdl_information2_o
205: => per_fdl_shd.g_old_rec.fdl_information2
206: ,p_fdl_information3_o
207: => per_fdl_shd.g_old_rec.fdl_information3
208: ,p_fdl_information4_o
209: => per_fdl_shd.g_old_rec.fdl_information4
210: ,p_fdl_information5_o
211: => per_fdl_shd.g_old_rec.fdl_information5

Line 209: => per_fdl_shd.g_old_rec.fdl_information4

205: => per_fdl_shd.g_old_rec.fdl_information2
206: ,p_fdl_information3_o
207: => per_fdl_shd.g_old_rec.fdl_information3
208: ,p_fdl_information4_o
209: => per_fdl_shd.g_old_rec.fdl_information4
210: ,p_fdl_information5_o
211: => per_fdl_shd.g_old_rec.fdl_information5
212: ,p_fdl_information6_o
213: => per_fdl_shd.g_old_rec.fdl_information6

Line 211: => per_fdl_shd.g_old_rec.fdl_information5

207: => per_fdl_shd.g_old_rec.fdl_information3
208: ,p_fdl_information4_o
209: => per_fdl_shd.g_old_rec.fdl_information4
210: ,p_fdl_information5_o
211: => per_fdl_shd.g_old_rec.fdl_information5
212: ,p_fdl_information6_o
213: => per_fdl_shd.g_old_rec.fdl_information6
214: ,p_fdl_information7_o
215: => per_fdl_shd.g_old_rec.fdl_information7

Line 213: => per_fdl_shd.g_old_rec.fdl_information6

209: => per_fdl_shd.g_old_rec.fdl_information4
210: ,p_fdl_information5_o
211: => per_fdl_shd.g_old_rec.fdl_information5
212: ,p_fdl_information6_o
213: => per_fdl_shd.g_old_rec.fdl_information6
214: ,p_fdl_information7_o
215: => per_fdl_shd.g_old_rec.fdl_information7
216: ,p_fdl_information8_o
217: => per_fdl_shd.g_old_rec.fdl_information8

Line 215: => per_fdl_shd.g_old_rec.fdl_information7

211: => per_fdl_shd.g_old_rec.fdl_information5
212: ,p_fdl_information6_o
213: => per_fdl_shd.g_old_rec.fdl_information6
214: ,p_fdl_information7_o
215: => per_fdl_shd.g_old_rec.fdl_information7
216: ,p_fdl_information8_o
217: => per_fdl_shd.g_old_rec.fdl_information8
218: ,p_fdl_information9_o
219: => per_fdl_shd.g_old_rec.fdl_information9

Line 217: => per_fdl_shd.g_old_rec.fdl_information8

213: => per_fdl_shd.g_old_rec.fdl_information6
214: ,p_fdl_information7_o
215: => per_fdl_shd.g_old_rec.fdl_information7
216: ,p_fdl_information8_o
217: => per_fdl_shd.g_old_rec.fdl_information8
218: ,p_fdl_information9_o
219: => per_fdl_shd.g_old_rec.fdl_information9
220: ,p_fdl_information10_o
221: => per_fdl_shd.g_old_rec.fdl_information10

Line 219: => per_fdl_shd.g_old_rec.fdl_information9

215: => per_fdl_shd.g_old_rec.fdl_information7
216: ,p_fdl_information8_o
217: => per_fdl_shd.g_old_rec.fdl_information8
218: ,p_fdl_information9_o
219: => per_fdl_shd.g_old_rec.fdl_information9
220: ,p_fdl_information10_o
221: => per_fdl_shd.g_old_rec.fdl_information10
222: ,p_object_version_number_o
223: => per_fdl_shd.g_old_rec.object_version_number

Line 221: => per_fdl_shd.g_old_rec.fdl_information10

217: => per_fdl_shd.g_old_rec.fdl_information8
218: ,p_fdl_information9_o
219: => per_fdl_shd.g_old_rec.fdl_information9
220: ,p_fdl_information10_o
221: => per_fdl_shd.g_old_rec.fdl_information10
222: ,p_object_version_number_o
223: => per_fdl_shd.g_old_rec.object_version_number
224: ); */
225: NULL;

Line 223: => per_fdl_shd.g_old_rec.object_version_number

219: => per_fdl_shd.g_old_rec.fdl_information9
220: ,p_fdl_information10_o
221: => per_fdl_shd.g_old_rec.fdl_information10
222: ,p_object_version_number_o
223: => per_fdl_shd.g_old_rec.object_version_number
224: ); */
225: NULL;
226: --
227: exception

Line 246: (p_rec in per_fdl_shd.g_rec_type

242: -- ----------------------------------------------------------------------------
243: -- |---------------------------------< del >----------------------------------|
244: -- ----------------------------------------------------------------------------
245: Procedure del
246: (p_rec in per_fdl_shd.g_rec_type
247: ) is
248: --
249: l_proc varchar2(72) := g_package||'del';
250: --

Line 256: per_fdl_shd.lck

252: hr_utility.set_location('Entering:'||l_proc, 5);
253: --
254: -- We must lock the row which we need to delete.
255: --
256: per_fdl_shd.lck
257: (p_rec.fnd_doc_link_id
258: ,p_rec.object_version_number
259: );
260: --

Line 294: l_rec per_fdl_shd.g_rec_type;

290: (p_fnd_doc_link_id in number
291: ,p_object_version_number in number
292: ) is
293: --
294: l_rec per_fdl_shd.g_rec_type;
295: l_proc varchar2(72) := g_package||'del';
296: --
297: Begin
298: hr_utility.set_location('Entering:'||l_proc, 5);