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_UPD dependencies on PSP_POA_SHD

Line 55: (p_rec in out nocopy psp_poa_shd.g_rec_type

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

Line 66: psp_poa_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: psp_poa_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the psp_organization_accounts Row
69: --
70: update psp_organization_accounts

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

104: ,object_version_number = p_rec.object_version_number
105: ,funding_source_code = p_rec.funding_source_code
106: where organization_account_id = p_rec.organization_account_id;
107: --
108: psp_poa_shd.g_api_dml := false; -- Unset the api dml status
109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 10);
111: --
112: Exception

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

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

Line 116: psp_poa_shd.constraint_error

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

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

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

Line 121: psp_poa_shd.constraint_error

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

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

121: psp_poa_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: psp_poa_shd.g_api_dml := false; -- Unset the api dml status
126: psp_poa_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When Others Then
129: psp_poa_shd.g_api_dml := false; -- Unset the api dml status

Line 126: psp_poa_shd.constraint_error

122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: psp_poa_shd.g_api_dml := false; -- Unset the api dml status
126: psp_poa_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When Others Then
129: psp_poa_shd.g_api_dml := false; -- Unset the api dml status
130: Raise;

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

125: psp_poa_shd.g_api_dml := false; -- Unset the api dml status
126: psp_poa_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When Others Then
129: psp_poa_shd.g_api_dml := false; -- Unset the api dml status
130: Raise;
131: End update_dml;
132: --
133: -- ----------------------------------------------------------------------------

Line 166: (p_rec in psp_poa_shd.g_rec_type

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

Line 210: (p_rec in psp_poa_shd.g_rec_type

206: --
207: -- {End Of Comments}
208: -- ----------------------------------------------------------------------------
209: Procedure post_update
210: (p_rec in psp_poa_shd.g_rec_type
211: ) is
212: --
213: l_proc varchar2(72) := g_package||'post_update';
214: --

Line 289: => psp_poa_shd.g_old_rec.gl_code_combination_id

285: => p_rec.object_version_number
286: ,p_funding_source_code
287: => p_rec.funding_source_code
288: ,p_gl_code_combination_id_o
289: => psp_poa_shd.g_old_rec.gl_code_combination_id
290: ,p_project_id_o
291: => psp_poa_shd.g_old_rec.project_id
292: ,p_expenditure_organization_i_o
293: => psp_poa_shd.g_old_rec.expenditure_organization_id

Line 291: => psp_poa_shd.g_old_rec.project_id

287: => p_rec.funding_source_code
288: ,p_gl_code_combination_id_o
289: => psp_poa_shd.g_old_rec.gl_code_combination_id
290: ,p_project_id_o
291: => psp_poa_shd.g_old_rec.project_id
292: ,p_expenditure_organization_i_o
293: => psp_poa_shd.g_old_rec.expenditure_organization_id
294: ,p_expenditure_type_o
295: => psp_poa_shd.g_old_rec.expenditure_type

Line 293: => psp_poa_shd.g_old_rec.expenditure_organization_id

289: => psp_poa_shd.g_old_rec.gl_code_combination_id
290: ,p_project_id_o
291: => psp_poa_shd.g_old_rec.project_id
292: ,p_expenditure_organization_i_o
293: => psp_poa_shd.g_old_rec.expenditure_organization_id
294: ,p_expenditure_type_o
295: => psp_poa_shd.g_old_rec.expenditure_type
296: ,p_task_id_o
297: => psp_poa_shd.g_old_rec.task_id

Line 295: => psp_poa_shd.g_old_rec.expenditure_type

291: => psp_poa_shd.g_old_rec.project_id
292: ,p_expenditure_organization_i_o
293: => psp_poa_shd.g_old_rec.expenditure_organization_id
294: ,p_expenditure_type_o
295: => psp_poa_shd.g_old_rec.expenditure_type
296: ,p_task_id_o
297: => psp_poa_shd.g_old_rec.task_id
298: ,p_award_id_o
299: => psp_poa_shd.g_old_rec.award_id

Line 297: => psp_poa_shd.g_old_rec.task_id

293: => psp_poa_shd.g_old_rec.expenditure_organization_id
294: ,p_expenditure_type_o
295: => psp_poa_shd.g_old_rec.expenditure_type
296: ,p_task_id_o
297: => psp_poa_shd.g_old_rec.task_id
298: ,p_award_id_o
299: => psp_poa_shd.g_old_rec.award_id
300: ,p_comments_o
301: => psp_poa_shd.g_old_rec.comments

Line 299: => psp_poa_shd.g_old_rec.award_id

295: => psp_poa_shd.g_old_rec.expenditure_type
296: ,p_task_id_o
297: => psp_poa_shd.g_old_rec.task_id
298: ,p_award_id_o
299: => psp_poa_shd.g_old_rec.award_id
300: ,p_comments_o
301: => psp_poa_shd.g_old_rec.comments
302: ,p_attribute_category_o
303: => psp_poa_shd.g_old_rec.attribute_category

Line 301: => psp_poa_shd.g_old_rec.comments

297: => psp_poa_shd.g_old_rec.task_id
298: ,p_award_id_o
299: => psp_poa_shd.g_old_rec.award_id
300: ,p_comments_o
301: => psp_poa_shd.g_old_rec.comments
302: ,p_attribute_category_o
303: => psp_poa_shd.g_old_rec.attribute_category
304: ,p_attribute1_o
305: => psp_poa_shd.g_old_rec.attribute1

Line 303: => psp_poa_shd.g_old_rec.attribute_category

299: => psp_poa_shd.g_old_rec.award_id
300: ,p_comments_o
301: => psp_poa_shd.g_old_rec.comments
302: ,p_attribute_category_o
303: => psp_poa_shd.g_old_rec.attribute_category
304: ,p_attribute1_o
305: => psp_poa_shd.g_old_rec.attribute1
306: ,p_attribute2_o
307: => psp_poa_shd.g_old_rec.attribute2

Line 305: => psp_poa_shd.g_old_rec.attribute1

301: => psp_poa_shd.g_old_rec.comments
302: ,p_attribute_category_o
303: => psp_poa_shd.g_old_rec.attribute_category
304: ,p_attribute1_o
305: => psp_poa_shd.g_old_rec.attribute1
306: ,p_attribute2_o
307: => psp_poa_shd.g_old_rec.attribute2
308: ,p_attribute3_o
309: => psp_poa_shd.g_old_rec.attribute3

Line 307: => psp_poa_shd.g_old_rec.attribute2

303: => psp_poa_shd.g_old_rec.attribute_category
304: ,p_attribute1_o
305: => psp_poa_shd.g_old_rec.attribute1
306: ,p_attribute2_o
307: => psp_poa_shd.g_old_rec.attribute2
308: ,p_attribute3_o
309: => psp_poa_shd.g_old_rec.attribute3
310: ,p_attribute4_o
311: => psp_poa_shd.g_old_rec.attribute4

Line 309: => psp_poa_shd.g_old_rec.attribute3

305: => psp_poa_shd.g_old_rec.attribute1
306: ,p_attribute2_o
307: => psp_poa_shd.g_old_rec.attribute2
308: ,p_attribute3_o
309: => psp_poa_shd.g_old_rec.attribute3
310: ,p_attribute4_o
311: => psp_poa_shd.g_old_rec.attribute4
312: ,p_attribute5_o
313: => psp_poa_shd.g_old_rec.attribute5

Line 311: => psp_poa_shd.g_old_rec.attribute4

307: => psp_poa_shd.g_old_rec.attribute2
308: ,p_attribute3_o
309: => psp_poa_shd.g_old_rec.attribute3
310: ,p_attribute4_o
311: => psp_poa_shd.g_old_rec.attribute4
312: ,p_attribute5_o
313: => psp_poa_shd.g_old_rec.attribute5
314: ,p_attribute6_o
315: => psp_poa_shd.g_old_rec.attribute6

Line 313: => psp_poa_shd.g_old_rec.attribute5

309: => psp_poa_shd.g_old_rec.attribute3
310: ,p_attribute4_o
311: => psp_poa_shd.g_old_rec.attribute4
312: ,p_attribute5_o
313: => psp_poa_shd.g_old_rec.attribute5
314: ,p_attribute6_o
315: => psp_poa_shd.g_old_rec.attribute6
316: ,p_attribute7_o
317: => psp_poa_shd.g_old_rec.attribute7

Line 315: => psp_poa_shd.g_old_rec.attribute6

311: => psp_poa_shd.g_old_rec.attribute4
312: ,p_attribute5_o
313: => psp_poa_shd.g_old_rec.attribute5
314: ,p_attribute6_o
315: => psp_poa_shd.g_old_rec.attribute6
316: ,p_attribute7_o
317: => psp_poa_shd.g_old_rec.attribute7
318: ,p_attribute8_o
319: => psp_poa_shd.g_old_rec.attribute8

Line 317: => psp_poa_shd.g_old_rec.attribute7

313: => psp_poa_shd.g_old_rec.attribute5
314: ,p_attribute6_o
315: => psp_poa_shd.g_old_rec.attribute6
316: ,p_attribute7_o
317: => psp_poa_shd.g_old_rec.attribute7
318: ,p_attribute8_o
319: => psp_poa_shd.g_old_rec.attribute8
320: ,p_attribute9_o
321: => psp_poa_shd.g_old_rec.attribute9

Line 319: => psp_poa_shd.g_old_rec.attribute8

315: => psp_poa_shd.g_old_rec.attribute6
316: ,p_attribute7_o
317: => psp_poa_shd.g_old_rec.attribute7
318: ,p_attribute8_o
319: => psp_poa_shd.g_old_rec.attribute8
320: ,p_attribute9_o
321: => psp_poa_shd.g_old_rec.attribute9
322: ,p_attribute10_o
323: => psp_poa_shd.g_old_rec.attribute10

Line 321: => psp_poa_shd.g_old_rec.attribute9

317: => psp_poa_shd.g_old_rec.attribute7
318: ,p_attribute8_o
319: => psp_poa_shd.g_old_rec.attribute8
320: ,p_attribute9_o
321: => psp_poa_shd.g_old_rec.attribute9
322: ,p_attribute10_o
323: => psp_poa_shd.g_old_rec.attribute10
324: ,p_attribute11_o
325: => psp_poa_shd.g_old_rec.attribute11

Line 323: => psp_poa_shd.g_old_rec.attribute10

319: => psp_poa_shd.g_old_rec.attribute8
320: ,p_attribute9_o
321: => psp_poa_shd.g_old_rec.attribute9
322: ,p_attribute10_o
323: => psp_poa_shd.g_old_rec.attribute10
324: ,p_attribute11_o
325: => psp_poa_shd.g_old_rec.attribute11
326: ,p_attribute12_o
327: => psp_poa_shd.g_old_rec.attribute12

Line 325: => psp_poa_shd.g_old_rec.attribute11

321: => psp_poa_shd.g_old_rec.attribute9
322: ,p_attribute10_o
323: => psp_poa_shd.g_old_rec.attribute10
324: ,p_attribute11_o
325: => psp_poa_shd.g_old_rec.attribute11
326: ,p_attribute12_o
327: => psp_poa_shd.g_old_rec.attribute12
328: ,p_attribute13_o
329: => psp_poa_shd.g_old_rec.attribute13

Line 327: => psp_poa_shd.g_old_rec.attribute12

323: => psp_poa_shd.g_old_rec.attribute10
324: ,p_attribute11_o
325: => psp_poa_shd.g_old_rec.attribute11
326: ,p_attribute12_o
327: => psp_poa_shd.g_old_rec.attribute12
328: ,p_attribute13_o
329: => psp_poa_shd.g_old_rec.attribute13
330: ,p_attribute14_o
331: => psp_poa_shd.g_old_rec.attribute14

Line 329: => psp_poa_shd.g_old_rec.attribute13

325: => psp_poa_shd.g_old_rec.attribute11
326: ,p_attribute12_o
327: => psp_poa_shd.g_old_rec.attribute12
328: ,p_attribute13_o
329: => psp_poa_shd.g_old_rec.attribute13
330: ,p_attribute14_o
331: => psp_poa_shd.g_old_rec.attribute14
332: ,p_attribute15_o
333: => psp_poa_shd.g_old_rec.attribute15

Line 331: => psp_poa_shd.g_old_rec.attribute14

327: => psp_poa_shd.g_old_rec.attribute12
328: ,p_attribute13_o
329: => psp_poa_shd.g_old_rec.attribute13
330: ,p_attribute14_o
331: => psp_poa_shd.g_old_rec.attribute14
332: ,p_attribute15_o
333: => psp_poa_shd.g_old_rec.attribute15
334: ,p_set_of_books_id_o
335: => psp_poa_shd.g_old_rec.set_of_books_id

Line 333: => psp_poa_shd.g_old_rec.attribute15

329: => psp_poa_shd.g_old_rec.attribute13
330: ,p_attribute14_o
331: => psp_poa_shd.g_old_rec.attribute14
332: ,p_attribute15_o
333: => psp_poa_shd.g_old_rec.attribute15
334: ,p_set_of_books_id_o
335: => psp_poa_shd.g_old_rec.set_of_books_id
336: ,p_account_type_code_o
337: => psp_poa_shd.g_old_rec.account_type_code

Line 335: => psp_poa_shd.g_old_rec.set_of_books_id

331: => psp_poa_shd.g_old_rec.attribute14
332: ,p_attribute15_o
333: => psp_poa_shd.g_old_rec.attribute15
334: ,p_set_of_books_id_o
335: => psp_poa_shd.g_old_rec.set_of_books_id
336: ,p_account_type_code_o
337: => psp_poa_shd.g_old_rec.account_type_code
338: ,p_start_date_active_o
339: => psp_poa_shd.g_old_rec.start_date_active

Line 337: => psp_poa_shd.g_old_rec.account_type_code

333: => psp_poa_shd.g_old_rec.attribute15
334: ,p_set_of_books_id_o
335: => psp_poa_shd.g_old_rec.set_of_books_id
336: ,p_account_type_code_o
337: => psp_poa_shd.g_old_rec.account_type_code
338: ,p_start_date_active_o
339: => psp_poa_shd.g_old_rec.start_date_active
340: ,p_business_group_id_o
341: => psp_poa_shd.g_old_rec.business_group_id

Line 339: => psp_poa_shd.g_old_rec.start_date_active

335: => psp_poa_shd.g_old_rec.set_of_books_id
336: ,p_account_type_code_o
337: => psp_poa_shd.g_old_rec.account_type_code
338: ,p_start_date_active_o
339: => psp_poa_shd.g_old_rec.start_date_active
340: ,p_business_group_id_o
341: => psp_poa_shd.g_old_rec.business_group_id
342: ,p_end_date_active_o
343: => psp_poa_shd.g_old_rec.end_date_active

Line 341: => psp_poa_shd.g_old_rec.business_group_id

337: => psp_poa_shd.g_old_rec.account_type_code
338: ,p_start_date_active_o
339: => psp_poa_shd.g_old_rec.start_date_active
340: ,p_business_group_id_o
341: => psp_poa_shd.g_old_rec.business_group_id
342: ,p_end_date_active_o
343: => psp_poa_shd.g_old_rec.end_date_active
344: ,p_organization_id_o
345: => psp_poa_shd.g_old_rec.organization_id

Line 343: => psp_poa_shd.g_old_rec.end_date_active

339: => psp_poa_shd.g_old_rec.start_date_active
340: ,p_business_group_id_o
341: => psp_poa_shd.g_old_rec.business_group_id
342: ,p_end_date_active_o
343: => psp_poa_shd.g_old_rec.end_date_active
344: ,p_organization_id_o
345: => psp_poa_shd.g_old_rec.organization_id
346: ,p_poeta_start_date_o
347: => psp_poa_shd.g_old_rec.poeta_start_date

Line 345: => psp_poa_shd.g_old_rec.organization_id

341: => psp_poa_shd.g_old_rec.business_group_id
342: ,p_end_date_active_o
343: => psp_poa_shd.g_old_rec.end_date_active
344: ,p_organization_id_o
345: => psp_poa_shd.g_old_rec.organization_id
346: ,p_poeta_start_date_o
347: => psp_poa_shd.g_old_rec.poeta_start_date
348: ,p_poeta_end_date_o
349: => psp_poa_shd.g_old_rec.poeta_end_date

Line 347: => psp_poa_shd.g_old_rec.poeta_start_date

343: => psp_poa_shd.g_old_rec.end_date_active
344: ,p_organization_id_o
345: => psp_poa_shd.g_old_rec.organization_id
346: ,p_poeta_start_date_o
347: => psp_poa_shd.g_old_rec.poeta_start_date
348: ,p_poeta_end_date_o
349: => psp_poa_shd.g_old_rec.poeta_end_date
350: ,p_object_version_number_o
351: => psp_poa_shd.g_old_rec.object_version_number

Line 349: => psp_poa_shd.g_old_rec.poeta_end_date

345: => psp_poa_shd.g_old_rec.organization_id
346: ,p_poeta_start_date_o
347: => psp_poa_shd.g_old_rec.poeta_start_date
348: ,p_poeta_end_date_o
349: => psp_poa_shd.g_old_rec.poeta_end_date
350: ,p_object_version_number_o
351: => psp_poa_shd.g_old_rec.object_version_number
352: ,p_funding_source_code_o
353: => psp_poa_shd.g_old_rec.funding_source_code

Line 351: => psp_poa_shd.g_old_rec.object_version_number

347: => psp_poa_shd.g_old_rec.poeta_start_date
348: ,p_poeta_end_date_o
349: => psp_poa_shd.g_old_rec.poeta_end_date
350: ,p_object_version_number_o
351: => psp_poa_shd.g_old_rec.object_version_number
352: ,p_funding_source_code_o
353: => psp_poa_shd.g_old_rec.funding_source_code
354: );
355: --

Line 353: => psp_poa_shd.g_old_rec.funding_source_code

349: => psp_poa_shd.g_old_rec.poeta_end_date
350: ,p_object_version_number_o
351: => psp_poa_shd.g_old_rec.object_version_number
352: ,p_funding_source_code_o
353: => psp_poa_shd.g_old_rec.funding_source_code
354: );
355: --
356: exception
357: --

Line 413: (p_rec in out nocopy psp_poa_shd.g_rec_type

409: --
410: -- {End Of Comments}
411: -- ----------------------------------------------------------------------------
412: Procedure convert_defs
413: (p_rec in out nocopy psp_poa_shd.g_rec_type
414: ) is
415: --
416: Begin
417: --

Line 425: psp_poa_shd.g_old_rec.gl_code_combination_id;

421: -- is being used then we must set to the 'current' argument value.
422: --
423: If (p_rec.gl_code_combination_id = hr_api.g_number) then
424: p_rec.gl_code_combination_id :=
425: psp_poa_shd.g_old_rec.gl_code_combination_id;
426: End If;
427: If (p_rec.project_id = hr_api.g_number) then
428: p_rec.project_id :=
429: psp_poa_shd.g_old_rec.project_id;

Line 429: psp_poa_shd.g_old_rec.project_id;

425: psp_poa_shd.g_old_rec.gl_code_combination_id;
426: End If;
427: If (p_rec.project_id = hr_api.g_number) then
428: p_rec.project_id :=
429: psp_poa_shd.g_old_rec.project_id;
430: End If;
431: If (p_rec.expenditure_organization_id = hr_api.g_number) then
432: p_rec.expenditure_organization_id :=
433: psp_poa_shd.g_old_rec.expenditure_organization_id;

Line 433: psp_poa_shd.g_old_rec.expenditure_organization_id;

429: psp_poa_shd.g_old_rec.project_id;
430: End If;
431: If (p_rec.expenditure_organization_id = hr_api.g_number) then
432: p_rec.expenditure_organization_id :=
433: psp_poa_shd.g_old_rec.expenditure_organization_id;
434: End If;
435: If (p_rec.expenditure_type = hr_api.g_varchar2) then
436: p_rec.expenditure_type :=
437: psp_poa_shd.g_old_rec.expenditure_type;

Line 437: psp_poa_shd.g_old_rec.expenditure_type;

433: psp_poa_shd.g_old_rec.expenditure_organization_id;
434: End If;
435: If (p_rec.expenditure_type = hr_api.g_varchar2) then
436: p_rec.expenditure_type :=
437: psp_poa_shd.g_old_rec.expenditure_type;
438: End If;
439: If (p_rec.task_id = hr_api.g_number) then
440: p_rec.task_id :=
441: psp_poa_shd.g_old_rec.task_id;

Line 441: psp_poa_shd.g_old_rec.task_id;

437: psp_poa_shd.g_old_rec.expenditure_type;
438: End If;
439: If (p_rec.task_id = hr_api.g_number) then
440: p_rec.task_id :=
441: psp_poa_shd.g_old_rec.task_id;
442: End If;
443: If (p_rec.award_id = hr_api.g_number) then
444: p_rec.award_id :=
445: psp_poa_shd.g_old_rec.award_id;

Line 445: psp_poa_shd.g_old_rec.award_id;

441: psp_poa_shd.g_old_rec.task_id;
442: End If;
443: If (p_rec.award_id = hr_api.g_number) then
444: p_rec.award_id :=
445: psp_poa_shd.g_old_rec.award_id;
446: End If;
447: If (p_rec.comments = hr_api.g_varchar2) then
448: p_rec.comments :=
449: psp_poa_shd.g_old_rec.comments;

Line 449: psp_poa_shd.g_old_rec.comments;

445: psp_poa_shd.g_old_rec.award_id;
446: End If;
447: If (p_rec.comments = hr_api.g_varchar2) then
448: p_rec.comments :=
449: psp_poa_shd.g_old_rec.comments;
450: End If;
451: If (p_rec.attribute_category = hr_api.g_varchar2) then
452: p_rec.attribute_category :=
453: psp_poa_shd.g_old_rec.attribute_category;

Line 453: psp_poa_shd.g_old_rec.attribute_category;

449: psp_poa_shd.g_old_rec.comments;
450: End If;
451: If (p_rec.attribute_category = hr_api.g_varchar2) then
452: p_rec.attribute_category :=
453: psp_poa_shd.g_old_rec.attribute_category;
454: End If;
455: If (p_rec.attribute1 = hr_api.g_varchar2) then
456: p_rec.attribute1 :=
457: psp_poa_shd.g_old_rec.attribute1;

Line 457: psp_poa_shd.g_old_rec.attribute1;

453: psp_poa_shd.g_old_rec.attribute_category;
454: End If;
455: If (p_rec.attribute1 = hr_api.g_varchar2) then
456: p_rec.attribute1 :=
457: psp_poa_shd.g_old_rec.attribute1;
458: End If;
459: If (p_rec.attribute2 = hr_api.g_varchar2) then
460: p_rec.attribute2 :=
461: psp_poa_shd.g_old_rec.attribute2;

Line 461: psp_poa_shd.g_old_rec.attribute2;

457: psp_poa_shd.g_old_rec.attribute1;
458: End If;
459: If (p_rec.attribute2 = hr_api.g_varchar2) then
460: p_rec.attribute2 :=
461: psp_poa_shd.g_old_rec.attribute2;
462: End If;
463: If (p_rec.attribute3 = hr_api.g_varchar2) then
464: p_rec.attribute3 :=
465: psp_poa_shd.g_old_rec.attribute3;

Line 465: psp_poa_shd.g_old_rec.attribute3;

461: psp_poa_shd.g_old_rec.attribute2;
462: End If;
463: If (p_rec.attribute3 = hr_api.g_varchar2) then
464: p_rec.attribute3 :=
465: psp_poa_shd.g_old_rec.attribute3;
466: End If;
467: If (p_rec.attribute4 = hr_api.g_varchar2) then
468: p_rec.attribute4 :=
469: psp_poa_shd.g_old_rec.attribute4;

Line 469: psp_poa_shd.g_old_rec.attribute4;

465: psp_poa_shd.g_old_rec.attribute3;
466: End If;
467: If (p_rec.attribute4 = hr_api.g_varchar2) then
468: p_rec.attribute4 :=
469: psp_poa_shd.g_old_rec.attribute4;
470: End If;
471: If (p_rec.attribute5 = hr_api.g_varchar2) then
472: p_rec.attribute5 :=
473: psp_poa_shd.g_old_rec.attribute5;

Line 473: psp_poa_shd.g_old_rec.attribute5;

469: psp_poa_shd.g_old_rec.attribute4;
470: End If;
471: If (p_rec.attribute5 = hr_api.g_varchar2) then
472: p_rec.attribute5 :=
473: psp_poa_shd.g_old_rec.attribute5;
474: End If;
475: If (p_rec.attribute6 = hr_api.g_varchar2) then
476: p_rec.attribute6 :=
477: psp_poa_shd.g_old_rec.attribute6;

Line 477: psp_poa_shd.g_old_rec.attribute6;

473: psp_poa_shd.g_old_rec.attribute5;
474: End If;
475: If (p_rec.attribute6 = hr_api.g_varchar2) then
476: p_rec.attribute6 :=
477: psp_poa_shd.g_old_rec.attribute6;
478: End If;
479: If (p_rec.attribute7 = hr_api.g_varchar2) then
480: p_rec.attribute7 :=
481: psp_poa_shd.g_old_rec.attribute7;

Line 481: psp_poa_shd.g_old_rec.attribute7;

477: psp_poa_shd.g_old_rec.attribute6;
478: End If;
479: If (p_rec.attribute7 = hr_api.g_varchar2) then
480: p_rec.attribute7 :=
481: psp_poa_shd.g_old_rec.attribute7;
482: End If;
483: If (p_rec.attribute8 = hr_api.g_varchar2) then
484: p_rec.attribute8 :=
485: psp_poa_shd.g_old_rec.attribute8;

Line 485: psp_poa_shd.g_old_rec.attribute8;

481: psp_poa_shd.g_old_rec.attribute7;
482: End If;
483: If (p_rec.attribute8 = hr_api.g_varchar2) then
484: p_rec.attribute8 :=
485: psp_poa_shd.g_old_rec.attribute8;
486: End If;
487: If (p_rec.attribute9 = hr_api.g_varchar2) then
488: p_rec.attribute9 :=
489: psp_poa_shd.g_old_rec.attribute9;

Line 489: psp_poa_shd.g_old_rec.attribute9;

485: psp_poa_shd.g_old_rec.attribute8;
486: End If;
487: If (p_rec.attribute9 = hr_api.g_varchar2) then
488: p_rec.attribute9 :=
489: psp_poa_shd.g_old_rec.attribute9;
490: End If;
491: If (p_rec.attribute10 = hr_api.g_varchar2) then
492: p_rec.attribute10 :=
493: psp_poa_shd.g_old_rec.attribute10;

Line 493: psp_poa_shd.g_old_rec.attribute10;

489: psp_poa_shd.g_old_rec.attribute9;
490: End If;
491: If (p_rec.attribute10 = hr_api.g_varchar2) then
492: p_rec.attribute10 :=
493: psp_poa_shd.g_old_rec.attribute10;
494: End If;
495: If (p_rec.attribute11 = hr_api.g_varchar2) then
496: p_rec.attribute11 :=
497: psp_poa_shd.g_old_rec.attribute11;

Line 497: psp_poa_shd.g_old_rec.attribute11;

493: psp_poa_shd.g_old_rec.attribute10;
494: End If;
495: If (p_rec.attribute11 = hr_api.g_varchar2) then
496: p_rec.attribute11 :=
497: psp_poa_shd.g_old_rec.attribute11;
498: End If;
499: If (p_rec.attribute12 = hr_api.g_varchar2) then
500: p_rec.attribute12 :=
501: psp_poa_shd.g_old_rec.attribute12;

Line 501: psp_poa_shd.g_old_rec.attribute12;

497: psp_poa_shd.g_old_rec.attribute11;
498: End If;
499: If (p_rec.attribute12 = hr_api.g_varchar2) then
500: p_rec.attribute12 :=
501: psp_poa_shd.g_old_rec.attribute12;
502: End If;
503: If (p_rec.attribute13 = hr_api.g_varchar2) then
504: p_rec.attribute13 :=
505: psp_poa_shd.g_old_rec.attribute13;

Line 505: psp_poa_shd.g_old_rec.attribute13;

501: psp_poa_shd.g_old_rec.attribute12;
502: End If;
503: If (p_rec.attribute13 = hr_api.g_varchar2) then
504: p_rec.attribute13 :=
505: psp_poa_shd.g_old_rec.attribute13;
506: End If;
507: If (p_rec.attribute14 = hr_api.g_varchar2) then
508: p_rec.attribute14 :=
509: psp_poa_shd.g_old_rec.attribute14;

Line 509: psp_poa_shd.g_old_rec.attribute14;

505: psp_poa_shd.g_old_rec.attribute13;
506: End If;
507: If (p_rec.attribute14 = hr_api.g_varchar2) then
508: p_rec.attribute14 :=
509: psp_poa_shd.g_old_rec.attribute14;
510: End If;
511: If (p_rec.attribute15 = hr_api.g_varchar2) then
512: p_rec.attribute15 :=
513: psp_poa_shd.g_old_rec.attribute15;

Line 513: psp_poa_shd.g_old_rec.attribute15;

509: psp_poa_shd.g_old_rec.attribute14;
510: End If;
511: If (p_rec.attribute15 = hr_api.g_varchar2) then
512: p_rec.attribute15 :=
513: psp_poa_shd.g_old_rec.attribute15;
514: End If;
515: If (p_rec.set_of_books_id = hr_api.g_number) then
516: p_rec.set_of_books_id :=
517: psp_poa_shd.g_old_rec.set_of_books_id;

Line 517: psp_poa_shd.g_old_rec.set_of_books_id;

513: psp_poa_shd.g_old_rec.attribute15;
514: End If;
515: If (p_rec.set_of_books_id = hr_api.g_number) then
516: p_rec.set_of_books_id :=
517: psp_poa_shd.g_old_rec.set_of_books_id;
518: End If;
519: If (p_rec.account_type_code = hr_api.g_varchar2) then
520: p_rec.account_type_code :=
521: psp_poa_shd.g_old_rec.account_type_code;

Line 521: psp_poa_shd.g_old_rec.account_type_code;

517: psp_poa_shd.g_old_rec.set_of_books_id;
518: End If;
519: If (p_rec.account_type_code = hr_api.g_varchar2) then
520: p_rec.account_type_code :=
521: psp_poa_shd.g_old_rec.account_type_code;
522: End If;
523: If (p_rec.start_date_active = hr_api.g_date) then
524: p_rec.start_date_active :=
525: psp_poa_shd.g_old_rec.start_date_active;

Line 525: psp_poa_shd.g_old_rec.start_date_active;

521: psp_poa_shd.g_old_rec.account_type_code;
522: End If;
523: If (p_rec.start_date_active = hr_api.g_date) then
524: p_rec.start_date_active :=
525: psp_poa_shd.g_old_rec.start_date_active;
526: End If;
527: If (p_rec.business_group_id = hr_api.g_number) then
528: p_rec.business_group_id :=
529: psp_poa_shd.g_old_rec.business_group_id;

Line 529: psp_poa_shd.g_old_rec.business_group_id;

525: psp_poa_shd.g_old_rec.start_date_active;
526: End If;
527: If (p_rec.business_group_id = hr_api.g_number) then
528: p_rec.business_group_id :=
529: psp_poa_shd.g_old_rec.business_group_id;
530: End If;
531: If (p_rec.end_date_active = hr_api.g_date) then
532: p_rec.end_date_active :=
533: psp_poa_shd.g_old_rec.end_date_active;

Line 533: psp_poa_shd.g_old_rec.end_date_active;

529: psp_poa_shd.g_old_rec.business_group_id;
530: End If;
531: If (p_rec.end_date_active = hr_api.g_date) then
532: p_rec.end_date_active :=
533: psp_poa_shd.g_old_rec.end_date_active;
534: End If;
535: If (p_rec.organization_id = hr_api.g_number) then
536: p_rec.organization_id :=
537: psp_poa_shd.g_old_rec.organization_id;

Line 537: psp_poa_shd.g_old_rec.organization_id;

533: psp_poa_shd.g_old_rec.end_date_active;
534: End If;
535: If (p_rec.organization_id = hr_api.g_number) then
536: p_rec.organization_id :=
537: psp_poa_shd.g_old_rec.organization_id;
538: End If;
539: If (p_rec.poeta_start_date = hr_api.g_date) then
540: p_rec.poeta_start_date :=
541: psp_poa_shd.g_old_rec.poeta_start_date;

Line 541: psp_poa_shd.g_old_rec.poeta_start_date;

537: psp_poa_shd.g_old_rec.organization_id;
538: End If;
539: If (p_rec.poeta_start_date = hr_api.g_date) then
540: p_rec.poeta_start_date :=
541: psp_poa_shd.g_old_rec.poeta_start_date;
542: End If;
543: If (p_rec.poeta_end_date = hr_api.g_date) then
544: p_rec.poeta_end_date :=
545: psp_poa_shd.g_old_rec.poeta_end_date;

Line 545: psp_poa_shd.g_old_rec.poeta_end_date;

541: psp_poa_shd.g_old_rec.poeta_start_date;
542: End If;
543: If (p_rec.poeta_end_date = hr_api.g_date) then
544: p_rec.poeta_end_date :=
545: psp_poa_shd.g_old_rec.poeta_end_date;
546: End If;
547: If (p_rec.funding_source_code = hr_api.g_varchar2) then
548: p_rec.funding_source_code :=
549: psp_poa_shd.g_old_rec.funding_source_code;

Line 549: psp_poa_shd.g_old_rec.funding_source_code;

545: psp_poa_shd.g_old_rec.poeta_end_date;
546: End If;
547: If (p_rec.funding_source_code = hr_api.g_varchar2) then
548: p_rec.funding_source_code :=
549: psp_poa_shd.g_old_rec.funding_source_code;
550: End If;
551: --
552: End convert_defs;
553: --

Line 558: (p_rec in out nocopy psp_poa_shd.g_rec_type

554: -- ----------------------------------------------------------------------------
555: -- |---------------------------------< upd >----------------------------------|
556: -- ----------------------------------------------------------------------------
557: Procedure upd
558: (p_rec in out nocopy psp_poa_shd.g_rec_type
559: ) is
560: --
561: l_proc varchar2(72) := g_package||'upd';
562: --

Line 568: psp_poa_shd.lck

564: hr_utility.set_location('Entering:'||l_proc, 5);
565: --
566: -- We must lock the row which we need to update.
567: --
568: psp_poa_shd.lck
569: (p_rec.organization_account_id
570: ,p_rec.object_version_number
571: );
572: --

Line 645: l_rec psp_poa_shd.g_rec_type;

641: ,p_poeta_end_date in date default hr_api.g_date
642: ,p_funding_source_code in varchar2 default hr_api.g_varchar2
643: ) is
644: --
645: l_rec psp_poa_shd.g_rec_type;
646: l_proc varchar2(72) := g_package||'upd';
647: --
648: Begin
649: hr_utility.set_location('Entering:'||l_proc, 5);

Line 655: psp_poa_shd.convert_args

651: -- Call conversion function to turn arguments into the
652: -- l_rec structure.
653: --
654: l_rec :=
655: psp_poa_shd.convert_args
656: (p_organization_account_id
657: ,p_gl_code_combination_id
658: ,p_project_id
659: ,p_expenditure_organization_id