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.PSP_POA_DEL dependencies on PSP_POA_SHD

Line 52: (p_rec in psp_poa_shd.g_rec_type

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

Line 60: psp_poa_shd.g_api_dml := true; -- Set the api dml status

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

Line 67: psp_poa_shd.g_api_dml := false; -- Unset the api dml status

63: --
64: delete from psp_organization_accounts
65: where organization_account_id = p_rec.organization_account_id;
66: --
67: psp_poa_shd.g_api_dml := false; -- Unset the api dml status
68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: --
71: Exception

Line 74: psp_poa_shd.g_api_dml := false; -- Unset the api dml status

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

Line 75: psp_poa_shd.constraint_error

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

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

74: psp_poa_shd.g_api_dml := false; -- Unset the api dml status
75: psp_poa_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: psp_poa_shd.g_api_dml := false; -- Unset the api dml status
79: Raise;
80: End delete_dml;
81: --
82: -- ----------------------------------------------------------------------------

Line 114: Procedure pre_delete(p_rec in psp_poa_shd.g_rec_type) is

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in psp_poa_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin

Line 156: Procedure post_delete(p_rec in psp_poa_shd.g_rec_type) is

152: -- Internal Row Handler Use Only.
153: --
154: -- {End Of Comments}
155: -- -----------------------------------------------------------------------------
156: Procedure post_delete(p_rec in psp_poa_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

Line 168: => psp_poa_shd.g_old_rec.gl_code_combination_id

164: psp_poa_rkd.after_delete
165: (p_organization_account_id
166: => p_rec.organization_account_id
167: ,p_gl_code_combination_id_o
168: => psp_poa_shd.g_old_rec.gl_code_combination_id
169: ,p_project_id_o
170: => psp_poa_shd.g_old_rec.project_id
171: ,p_expenditure_organization_i_o
172: => psp_poa_shd.g_old_rec.expenditure_organization_id

Line 170: => psp_poa_shd.g_old_rec.project_id

166: => p_rec.organization_account_id
167: ,p_gl_code_combination_id_o
168: => psp_poa_shd.g_old_rec.gl_code_combination_id
169: ,p_project_id_o
170: => psp_poa_shd.g_old_rec.project_id
171: ,p_expenditure_organization_i_o
172: => psp_poa_shd.g_old_rec.expenditure_organization_id
173: ,p_expenditure_type_o
174: => psp_poa_shd.g_old_rec.expenditure_type

Line 172: => psp_poa_shd.g_old_rec.expenditure_organization_id

168: => psp_poa_shd.g_old_rec.gl_code_combination_id
169: ,p_project_id_o
170: => psp_poa_shd.g_old_rec.project_id
171: ,p_expenditure_organization_i_o
172: => psp_poa_shd.g_old_rec.expenditure_organization_id
173: ,p_expenditure_type_o
174: => psp_poa_shd.g_old_rec.expenditure_type
175: ,p_task_id_o
176: => psp_poa_shd.g_old_rec.task_id

Line 174: => psp_poa_shd.g_old_rec.expenditure_type

170: => psp_poa_shd.g_old_rec.project_id
171: ,p_expenditure_organization_i_o
172: => psp_poa_shd.g_old_rec.expenditure_organization_id
173: ,p_expenditure_type_o
174: => psp_poa_shd.g_old_rec.expenditure_type
175: ,p_task_id_o
176: => psp_poa_shd.g_old_rec.task_id
177: ,p_award_id_o
178: => psp_poa_shd.g_old_rec.award_id

Line 176: => psp_poa_shd.g_old_rec.task_id

172: => psp_poa_shd.g_old_rec.expenditure_organization_id
173: ,p_expenditure_type_o
174: => psp_poa_shd.g_old_rec.expenditure_type
175: ,p_task_id_o
176: => psp_poa_shd.g_old_rec.task_id
177: ,p_award_id_o
178: => psp_poa_shd.g_old_rec.award_id
179: ,p_comments_o
180: => psp_poa_shd.g_old_rec.comments

Line 178: => psp_poa_shd.g_old_rec.award_id

174: => psp_poa_shd.g_old_rec.expenditure_type
175: ,p_task_id_o
176: => psp_poa_shd.g_old_rec.task_id
177: ,p_award_id_o
178: => psp_poa_shd.g_old_rec.award_id
179: ,p_comments_o
180: => psp_poa_shd.g_old_rec.comments
181: ,p_attribute_category_o
182: => psp_poa_shd.g_old_rec.attribute_category

Line 180: => psp_poa_shd.g_old_rec.comments

176: => psp_poa_shd.g_old_rec.task_id
177: ,p_award_id_o
178: => psp_poa_shd.g_old_rec.award_id
179: ,p_comments_o
180: => psp_poa_shd.g_old_rec.comments
181: ,p_attribute_category_o
182: => psp_poa_shd.g_old_rec.attribute_category
183: ,p_attribute1_o
184: => psp_poa_shd.g_old_rec.attribute1

Line 182: => psp_poa_shd.g_old_rec.attribute_category

178: => psp_poa_shd.g_old_rec.award_id
179: ,p_comments_o
180: => psp_poa_shd.g_old_rec.comments
181: ,p_attribute_category_o
182: => psp_poa_shd.g_old_rec.attribute_category
183: ,p_attribute1_o
184: => psp_poa_shd.g_old_rec.attribute1
185: ,p_attribute2_o
186: => psp_poa_shd.g_old_rec.attribute2

Line 184: => psp_poa_shd.g_old_rec.attribute1

180: => psp_poa_shd.g_old_rec.comments
181: ,p_attribute_category_o
182: => psp_poa_shd.g_old_rec.attribute_category
183: ,p_attribute1_o
184: => psp_poa_shd.g_old_rec.attribute1
185: ,p_attribute2_o
186: => psp_poa_shd.g_old_rec.attribute2
187: ,p_attribute3_o
188: => psp_poa_shd.g_old_rec.attribute3

Line 186: => psp_poa_shd.g_old_rec.attribute2

182: => psp_poa_shd.g_old_rec.attribute_category
183: ,p_attribute1_o
184: => psp_poa_shd.g_old_rec.attribute1
185: ,p_attribute2_o
186: => psp_poa_shd.g_old_rec.attribute2
187: ,p_attribute3_o
188: => psp_poa_shd.g_old_rec.attribute3
189: ,p_attribute4_o
190: => psp_poa_shd.g_old_rec.attribute4

Line 188: => psp_poa_shd.g_old_rec.attribute3

184: => psp_poa_shd.g_old_rec.attribute1
185: ,p_attribute2_o
186: => psp_poa_shd.g_old_rec.attribute2
187: ,p_attribute3_o
188: => psp_poa_shd.g_old_rec.attribute3
189: ,p_attribute4_o
190: => psp_poa_shd.g_old_rec.attribute4
191: ,p_attribute5_o
192: => psp_poa_shd.g_old_rec.attribute5

Line 190: => psp_poa_shd.g_old_rec.attribute4

186: => psp_poa_shd.g_old_rec.attribute2
187: ,p_attribute3_o
188: => psp_poa_shd.g_old_rec.attribute3
189: ,p_attribute4_o
190: => psp_poa_shd.g_old_rec.attribute4
191: ,p_attribute5_o
192: => psp_poa_shd.g_old_rec.attribute5
193: ,p_attribute6_o
194: => psp_poa_shd.g_old_rec.attribute6

Line 192: => psp_poa_shd.g_old_rec.attribute5

188: => psp_poa_shd.g_old_rec.attribute3
189: ,p_attribute4_o
190: => psp_poa_shd.g_old_rec.attribute4
191: ,p_attribute5_o
192: => psp_poa_shd.g_old_rec.attribute5
193: ,p_attribute6_o
194: => psp_poa_shd.g_old_rec.attribute6
195: ,p_attribute7_o
196: => psp_poa_shd.g_old_rec.attribute7

Line 194: => psp_poa_shd.g_old_rec.attribute6

190: => psp_poa_shd.g_old_rec.attribute4
191: ,p_attribute5_o
192: => psp_poa_shd.g_old_rec.attribute5
193: ,p_attribute6_o
194: => psp_poa_shd.g_old_rec.attribute6
195: ,p_attribute7_o
196: => psp_poa_shd.g_old_rec.attribute7
197: ,p_attribute8_o
198: => psp_poa_shd.g_old_rec.attribute8

Line 196: => psp_poa_shd.g_old_rec.attribute7

192: => psp_poa_shd.g_old_rec.attribute5
193: ,p_attribute6_o
194: => psp_poa_shd.g_old_rec.attribute6
195: ,p_attribute7_o
196: => psp_poa_shd.g_old_rec.attribute7
197: ,p_attribute8_o
198: => psp_poa_shd.g_old_rec.attribute8
199: ,p_attribute9_o
200: => psp_poa_shd.g_old_rec.attribute9

Line 198: => psp_poa_shd.g_old_rec.attribute8

194: => psp_poa_shd.g_old_rec.attribute6
195: ,p_attribute7_o
196: => psp_poa_shd.g_old_rec.attribute7
197: ,p_attribute8_o
198: => psp_poa_shd.g_old_rec.attribute8
199: ,p_attribute9_o
200: => psp_poa_shd.g_old_rec.attribute9
201: ,p_attribute10_o
202: => psp_poa_shd.g_old_rec.attribute10

Line 200: => psp_poa_shd.g_old_rec.attribute9

196: => psp_poa_shd.g_old_rec.attribute7
197: ,p_attribute8_o
198: => psp_poa_shd.g_old_rec.attribute8
199: ,p_attribute9_o
200: => psp_poa_shd.g_old_rec.attribute9
201: ,p_attribute10_o
202: => psp_poa_shd.g_old_rec.attribute10
203: ,p_attribute11_o
204: => psp_poa_shd.g_old_rec.attribute11

Line 202: => psp_poa_shd.g_old_rec.attribute10

198: => psp_poa_shd.g_old_rec.attribute8
199: ,p_attribute9_o
200: => psp_poa_shd.g_old_rec.attribute9
201: ,p_attribute10_o
202: => psp_poa_shd.g_old_rec.attribute10
203: ,p_attribute11_o
204: => psp_poa_shd.g_old_rec.attribute11
205: ,p_attribute12_o
206: => psp_poa_shd.g_old_rec.attribute12

Line 204: => psp_poa_shd.g_old_rec.attribute11

200: => psp_poa_shd.g_old_rec.attribute9
201: ,p_attribute10_o
202: => psp_poa_shd.g_old_rec.attribute10
203: ,p_attribute11_o
204: => psp_poa_shd.g_old_rec.attribute11
205: ,p_attribute12_o
206: => psp_poa_shd.g_old_rec.attribute12
207: ,p_attribute13_o
208: => psp_poa_shd.g_old_rec.attribute13

Line 206: => psp_poa_shd.g_old_rec.attribute12

202: => psp_poa_shd.g_old_rec.attribute10
203: ,p_attribute11_o
204: => psp_poa_shd.g_old_rec.attribute11
205: ,p_attribute12_o
206: => psp_poa_shd.g_old_rec.attribute12
207: ,p_attribute13_o
208: => psp_poa_shd.g_old_rec.attribute13
209: ,p_attribute14_o
210: => psp_poa_shd.g_old_rec.attribute14

Line 208: => psp_poa_shd.g_old_rec.attribute13

204: => psp_poa_shd.g_old_rec.attribute11
205: ,p_attribute12_o
206: => psp_poa_shd.g_old_rec.attribute12
207: ,p_attribute13_o
208: => psp_poa_shd.g_old_rec.attribute13
209: ,p_attribute14_o
210: => psp_poa_shd.g_old_rec.attribute14
211: ,p_attribute15_o
212: => psp_poa_shd.g_old_rec.attribute15

Line 210: => psp_poa_shd.g_old_rec.attribute14

206: => psp_poa_shd.g_old_rec.attribute12
207: ,p_attribute13_o
208: => psp_poa_shd.g_old_rec.attribute13
209: ,p_attribute14_o
210: => psp_poa_shd.g_old_rec.attribute14
211: ,p_attribute15_o
212: => psp_poa_shd.g_old_rec.attribute15
213: ,p_set_of_books_id_o
214: => psp_poa_shd.g_old_rec.set_of_books_id

Line 212: => psp_poa_shd.g_old_rec.attribute15

208: => psp_poa_shd.g_old_rec.attribute13
209: ,p_attribute14_o
210: => psp_poa_shd.g_old_rec.attribute14
211: ,p_attribute15_o
212: => psp_poa_shd.g_old_rec.attribute15
213: ,p_set_of_books_id_o
214: => psp_poa_shd.g_old_rec.set_of_books_id
215: ,p_account_type_code_o
216: => psp_poa_shd.g_old_rec.account_type_code

Line 214: => psp_poa_shd.g_old_rec.set_of_books_id

210: => psp_poa_shd.g_old_rec.attribute14
211: ,p_attribute15_o
212: => psp_poa_shd.g_old_rec.attribute15
213: ,p_set_of_books_id_o
214: => psp_poa_shd.g_old_rec.set_of_books_id
215: ,p_account_type_code_o
216: => psp_poa_shd.g_old_rec.account_type_code
217: ,p_start_date_active_o
218: => psp_poa_shd.g_old_rec.start_date_active

Line 216: => psp_poa_shd.g_old_rec.account_type_code

212: => psp_poa_shd.g_old_rec.attribute15
213: ,p_set_of_books_id_o
214: => psp_poa_shd.g_old_rec.set_of_books_id
215: ,p_account_type_code_o
216: => psp_poa_shd.g_old_rec.account_type_code
217: ,p_start_date_active_o
218: => psp_poa_shd.g_old_rec.start_date_active
219: ,p_business_group_id_o
220: => psp_poa_shd.g_old_rec.business_group_id

Line 218: => psp_poa_shd.g_old_rec.start_date_active

214: => psp_poa_shd.g_old_rec.set_of_books_id
215: ,p_account_type_code_o
216: => psp_poa_shd.g_old_rec.account_type_code
217: ,p_start_date_active_o
218: => psp_poa_shd.g_old_rec.start_date_active
219: ,p_business_group_id_o
220: => psp_poa_shd.g_old_rec.business_group_id
221: ,p_end_date_active_o
222: => psp_poa_shd.g_old_rec.end_date_active

Line 220: => psp_poa_shd.g_old_rec.business_group_id

216: => psp_poa_shd.g_old_rec.account_type_code
217: ,p_start_date_active_o
218: => psp_poa_shd.g_old_rec.start_date_active
219: ,p_business_group_id_o
220: => psp_poa_shd.g_old_rec.business_group_id
221: ,p_end_date_active_o
222: => psp_poa_shd.g_old_rec.end_date_active
223: ,p_organization_id_o
224: => psp_poa_shd.g_old_rec.organization_id

Line 222: => psp_poa_shd.g_old_rec.end_date_active

218: => psp_poa_shd.g_old_rec.start_date_active
219: ,p_business_group_id_o
220: => psp_poa_shd.g_old_rec.business_group_id
221: ,p_end_date_active_o
222: => psp_poa_shd.g_old_rec.end_date_active
223: ,p_organization_id_o
224: => psp_poa_shd.g_old_rec.organization_id
225: ,p_poeta_start_date_o
226: => psp_poa_shd.g_old_rec.poeta_start_date

Line 224: => psp_poa_shd.g_old_rec.organization_id

220: => psp_poa_shd.g_old_rec.business_group_id
221: ,p_end_date_active_o
222: => psp_poa_shd.g_old_rec.end_date_active
223: ,p_organization_id_o
224: => psp_poa_shd.g_old_rec.organization_id
225: ,p_poeta_start_date_o
226: => psp_poa_shd.g_old_rec.poeta_start_date
227: ,p_poeta_end_date_o
228: => psp_poa_shd.g_old_rec.poeta_end_date

Line 226: => psp_poa_shd.g_old_rec.poeta_start_date

222: => psp_poa_shd.g_old_rec.end_date_active
223: ,p_organization_id_o
224: => psp_poa_shd.g_old_rec.organization_id
225: ,p_poeta_start_date_o
226: => psp_poa_shd.g_old_rec.poeta_start_date
227: ,p_poeta_end_date_o
228: => psp_poa_shd.g_old_rec.poeta_end_date
229: ,p_object_version_number_o
230: => psp_poa_shd.g_old_rec.object_version_number

Line 228: => psp_poa_shd.g_old_rec.poeta_end_date

224: => psp_poa_shd.g_old_rec.organization_id
225: ,p_poeta_start_date_o
226: => psp_poa_shd.g_old_rec.poeta_start_date
227: ,p_poeta_end_date_o
228: => psp_poa_shd.g_old_rec.poeta_end_date
229: ,p_object_version_number_o
230: => psp_poa_shd.g_old_rec.object_version_number
231: ,p_funding_source_code_o
232: => psp_poa_shd.g_old_rec.funding_source_code

Line 230: => psp_poa_shd.g_old_rec.object_version_number

226: => psp_poa_shd.g_old_rec.poeta_start_date
227: ,p_poeta_end_date_o
228: => psp_poa_shd.g_old_rec.poeta_end_date
229: ,p_object_version_number_o
230: => psp_poa_shd.g_old_rec.object_version_number
231: ,p_funding_source_code_o
232: => psp_poa_shd.g_old_rec.funding_source_code
233: );
234: --

Line 232: => psp_poa_shd.g_old_rec.funding_source_code

228: => psp_poa_shd.g_old_rec.poeta_end_date
229: ,p_object_version_number_o
230: => psp_poa_shd.g_old_rec.object_version_number
231: ,p_funding_source_code_o
232: => psp_poa_shd.g_old_rec.funding_source_code
233: );
234: --
235: exception
236: --

Line 252: (p_rec in psp_poa_shd.g_rec_type

248: -- ----------------------------------------------------------------------------
249: -- |---------------------------------< del >----------------------------------|
250: -- ----------------------------------------------------------------------------
251: Procedure del
252: (p_rec in psp_poa_shd.g_rec_type
253: ) is
254: --
255: l_proc varchar2(72) := g_package||'del';
256: --

Line 262: psp_poa_shd.lck

258: hr_utility.set_location('Entering:'||l_proc, 5);
259: --
260: -- We must lock the row which we need to delete.
261: --
262: psp_poa_shd.lck
263: (p_rec.organization_account_id
264: ,p_rec.object_version_number
265: );
266: --

Line 299: l_rec psp_poa_shd.g_rec_type;

295: (p_organization_account_id in number
296: ,p_object_version_number in number
297: ) is
298: --
299: l_rec psp_poa_shd.g_rec_type;
300: l_proc varchar2(72) := g_package||'del';
301: --
302: Begin
303: hr_utility.set_location('Entering:'||l_proc, 5);