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_ERD_BUS dependencies on HR_API

Line 55: hr_api.mandatory_arg_error

51: hr_utility.set_location('Entering:'|| l_proc, 10);
52: --
53: -- Ensure that all the mandatory parameter are not null
54: --
55: hr_api.mandatory_arg_error
56: (p_api_name => l_proc
57: ,p_argument => 'effort_report_detail_id'
58: ,p_argument_value => p_effort_report_detail_id
59: );

Line 82: hr_api.set_security_group_id

78: close csr_sec_grp;
79: --
80: -- Set the security_group_id in CLIENT_INFO
81: --
82: hr_api.set_security_group_id
83: (p_security_group_id => l_security_group_id
84: );
85: --
86: -- Set the sessions legislation context in HR_SESSION_DATA

Line 88: hr_api.set_legislation_context(l_legislation_code);

84: );
85: --
86: -- Set the sessions legislation context in HR_SESSION_DATA
87: --
88: hr_api.set_legislation_context(l_legislation_code);
89: end if;
90: --
91: hr_utility.set_location(' Leaving:'|| l_proc, 20);
92: --

Line 131: hr_api.mandatory_arg_error

127: hr_utility.set_location('Entering:'|| l_proc, 10);
128: --
129: -- Ensure that all the mandatory parameter are not null
130: --
131: hr_api.mandatory_arg_error
132: (p_api_name => l_proc
133: ,p_argument => 'effort_report_detail_id'
134: ,p_argument_value => p_effort_report_detail_id
135: );

Line 137: if ( nvl(psp_erd_bus.g_effort_report_detail_id, hr_api.g_number)

133: ,p_argument => 'effort_report_detail_id'
134: ,p_argument_value => p_effort_report_detail_id
135: );
136: --
137: if ( nvl(psp_erd_bus.g_effort_report_detail_id, hr_api.g_number)
138: = p_effort_report_detail_id) then
139: --
140: -- The legislation code has already been found with a previous
141: -- call to this function. Just return the value in the global

Line 213: nvl(psp_erd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

209: begin
210: hr_utility.set_location('Entering:'||l_proc,10);
211: --
212: if ((p_rec.effort_report_detail_id is not null) and (
213: nvl(psp_erd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute1, hr_api.g_varchar2) or
215: nvl(psp_erd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute2, hr_api.g_varchar2) or
217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 214: nvl(p_rec.attribute1, hr_api.g_varchar2) or

210: hr_utility.set_location('Entering:'||l_proc,10);
211: --
212: if ((p_rec.effort_report_detail_id is not null) and (
213: nvl(psp_erd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute1, hr_api.g_varchar2) or
215: nvl(psp_erd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute2, hr_api.g_varchar2) or
217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 215: nvl(psp_erd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

211: --
212: if ((p_rec.effort_report_detail_id is not null) and (
213: nvl(psp_erd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute1, hr_api.g_varchar2) or
215: nvl(psp_erd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute2, hr_api.g_varchar2) or
217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute3, hr_api.g_varchar2) or
219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 216: nvl(p_rec.attribute2, hr_api.g_varchar2) or

212: if ((p_rec.effort_report_detail_id is not null) and (
213: nvl(psp_erd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute1, hr_api.g_varchar2) or
215: nvl(psp_erd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute2, hr_api.g_varchar2) or
217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute3, hr_api.g_varchar2) or
219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

213: nvl(psp_erd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute1, hr_api.g_varchar2) or
215: nvl(psp_erd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute2, hr_api.g_varchar2) or
217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute3, hr_api.g_varchar2) or
219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute4, hr_api.g_varchar2) or
221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 218: nvl(p_rec.attribute3, hr_api.g_varchar2) or

214: nvl(p_rec.attribute1, hr_api.g_varchar2) or
215: nvl(psp_erd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute2, hr_api.g_varchar2) or
217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute3, hr_api.g_varchar2) or
219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute4, hr_api.g_varchar2) or
221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

215: nvl(psp_erd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute2, hr_api.g_varchar2) or
217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute3, hr_api.g_varchar2) or
219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute4, hr_api.g_varchar2) or
221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute5, hr_api.g_varchar2) or
223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 220: nvl(p_rec.attribute4, hr_api.g_varchar2) or

216: nvl(p_rec.attribute2, hr_api.g_varchar2) or
217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute3, hr_api.g_varchar2) or
219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute4, hr_api.g_varchar2) or
221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute5, hr_api.g_varchar2) or
223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute3, hr_api.g_varchar2) or
219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute4, hr_api.g_varchar2) or
221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute5, hr_api.g_varchar2) or
223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute6, hr_api.g_varchar2) or
225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 222: nvl(p_rec.attribute5, hr_api.g_varchar2) or

218: nvl(p_rec.attribute3, hr_api.g_varchar2) or
219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute4, hr_api.g_varchar2) or
221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute5, hr_api.g_varchar2) or
223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute6, hr_api.g_varchar2) or
225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute4, hr_api.g_varchar2) or
221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute5, hr_api.g_varchar2) or
223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute6, hr_api.g_varchar2) or
225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute7, hr_api.g_varchar2) or
227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 224: nvl(p_rec.attribute6, hr_api.g_varchar2) or

220: nvl(p_rec.attribute4, hr_api.g_varchar2) or
221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute5, hr_api.g_varchar2) or
223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute6, hr_api.g_varchar2) or
225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute7, hr_api.g_varchar2) or
227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute5, hr_api.g_varchar2) or
223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute6, hr_api.g_varchar2) or
225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute7, hr_api.g_varchar2) or
227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute8, hr_api.g_varchar2) or
229: nvl(psp_erd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 226: nvl(p_rec.attribute7, hr_api.g_varchar2) or

222: nvl(p_rec.attribute5, hr_api.g_varchar2) or
223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute6, hr_api.g_varchar2) or
225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute7, hr_api.g_varchar2) or
227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute8, hr_api.g_varchar2) or
229: nvl(psp_erd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute6, hr_api.g_varchar2) or
225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute7, hr_api.g_varchar2) or
227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute8, hr_api.g_varchar2) or
229: nvl(psp_erd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute9, hr_api.g_varchar2) or
231: nvl(psp_erd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 228: nvl(p_rec.attribute8, hr_api.g_varchar2) or

224: nvl(p_rec.attribute6, hr_api.g_varchar2) or
225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute7, hr_api.g_varchar2) or
227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute8, hr_api.g_varchar2) or
229: nvl(psp_erd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute9, hr_api.g_varchar2) or
231: nvl(psp_erd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute10, hr_api.g_varchar2) ))

Line 229: nvl(psp_erd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute7, hr_api.g_varchar2) or
227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute8, hr_api.g_varchar2) or
229: nvl(psp_erd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute9, hr_api.g_varchar2) or
231: nvl(psp_erd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute10, hr_api.g_varchar2) ))
233: or (p_rec.effort_report_detail_id is null) then

Line 230: nvl(p_rec.attribute9, hr_api.g_varchar2) or

226: nvl(p_rec.attribute7, hr_api.g_varchar2) or
227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute8, hr_api.g_varchar2) or
229: nvl(psp_erd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute9, hr_api.g_varchar2) or
231: nvl(psp_erd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute10, hr_api.g_varchar2) ))
233: or (p_rec.effort_report_detail_id is null) then
234: --

Line 231: nvl(psp_erd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute8, hr_api.g_varchar2) or
229: nvl(psp_erd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute9, hr_api.g_varchar2) or
231: nvl(psp_erd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute10, hr_api.g_varchar2) ))
233: or (p_rec.effort_report_detail_id is null) then
234: --
235: -- Only execute the validation if absolutely necessary:

Line 232: nvl(p_rec.attribute10, hr_api.g_varchar2) ))

228: nvl(p_rec.attribute8, hr_api.g_varchar2) or
229: nvl(psp_erd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute9, hr_api.g_varchar2) or
231: nvl(psp_erd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute10, hr_api.g_varchar2) ))
233: or (p_rec.effort_report_detail_id is null) then
234: --
235: -- Only execute the validation if absolutely necessary:
236: -- a) During update, the structure column value or any