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.PQH_RLS_INS dependencies on HR_UTILITY

Line 60: hr_utility.set_location('Entering:'||l_proc,5);

56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
59: Begin
60: hr_utility.set_location('Entering:'||l_proc,5);
61: p_rec.object_version_number := 1; -- Initialise the object version
62: --
63: --
64: --

Line 148: hr_utility.set_location(' Leaving:'||l_proc,10);

144: );
145: --
146: --
147: --
148: hr_utility.set_location(' Leaving:'||l_proc,10);
149: Exception
150: When hr_api.check_integrity_violated Then
151: -- A check constraint has been violated
152: --

Line 216: hr_utility.set_location('Entering:'||l_proc,5);

212: --
213: Cursor C_Sel1 is select pqh_roles_s.nextval from sys.dual;
214: --
215: Begin
216: hr_utility.set_location('Entering:'||l_proc,5);
217: --
218: --
219: -- Select the next sequence number
220: --

Line 225: hr_utility.set_location(' Leaving:'||l_proc,10);

221: Open C_Sel1;
222: Fetch C_Sel1 Into p_rec.role_id;
223: Close C_Sel1;
224: --
225: hr_utility.set_location(' Leaving:'||l_proc,10);
226: End pre_insert;
227: --
228: -- ----------------------------------------------------------------------------
229: -- |-----------------------------< post_insert >------------------------------|

Line 268: hr_utility.set_location('Entering:'||l_proc,5);

264: --
265: l_proc varchar2(72) := g_package||'post_insert';
266: --
267: Begin
268: hr_utility.set_location('Entering:'||l_proc,5);
269: begin
270: --
271: pqh_rls_rki.after_insert
272: (p_effective_date => p_effective_date

Line 312: hr_utility.set_location('Before calling WF_SYNC:'||l_proc, 5);

308: ,p_information29 => p_rec.information29
309: ,p_information30 => p_rec.information30
310: );
311: --
312: hr_utility.set_location('Before calling WF_SYNC:'||l_proc, 5);
313: if p_rec.enable_flag = 'Y' then
314: declare
315: l_plist wf_parameter_list_t;
316: begin

Line 317: hr_utility.set_location('Before calling WF_SYNC parameters:'||l_proc, 5);

313: if p_rec.enable_flag = 'Y' then
314: declare
315: l_plist wf_parameter_list_t;
316: begin
317: hr_utility.set_location('Before calling WF_SYNC parameters:'||l_proc, 5);
318: WF_EVENT.AddParameterToList('USER_NAME','PQH_ROLE:'|| p_rec.role_id, l_plist);
319: WF_EVENT.AddParameterToList('DISPLAYNAME',p_rec.role_name, l_plist);
320: WF_EVENT.AddParameterToList('DESCRIPTION',p_rec.role_name, l_plist);
321: WF_EVENT.AddParameterToList('orclWorkFlowNotificationPref', 'QUERY', l_plist);

Line 329: hr_utility.set_location('Before calling WF_SYNC package role:'|| p_rec.role_id, 5);

325: WF_EVENT.AddParameterToList('ExpirationDate',to_char(null),l_plist);
326: WF_EVENT.AddParameterToList('StartDate',to_char(p_effective_date,wf_engine.date_format),l_plist);
327: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);
328:
329: hr_utility.set_location('Before calling WF_SYNC package role:'|| p_rec.role_id, 5);
330: WF_LOCAL_SYNCH.propagate_role(p_orig_system => 'PQH_ROLE',
331: p_orig_system_id => p_rec.role_id,
332: p_attributes => l_plist,
333: p_start_date => p_effective_date);

Line 334: hr_utility.set_location('After calling WF_SYNC package:'||l_proc, 5);

330: WF_LOCAL_SYNCH.propagate_role(p_orig_system => 'PQH_ROLE',
331: p_orig_system_id => p_rec.role_id,
332: p_attributes => l_plist,
333: p_start_date => p_effective_date);
334: hr_utility.set_location('After calling WF_SYNC package:'||l_proc, 5);
335: end;
336: end if;
337:
338: hr_utility.set_location('After calling WF_SYNC:'||l_proc, 5);

Line 338: hr_utility.set_location('After calling WF_SYNC:'||l_proc, 5);

334: hr_utility.set_location('After calling WF_SYNC package:'||l_proc, 5);
335: end;
336: end if;
337:
338: hr_utility.set_location('After calling WF_SYNC:'||l_proc, 5);
339:
340: exception
341: --
342: when hr_api.cannot_find_prog_unit then

Line 350: hr_utility.set_location(' Leaving:'||l_proc, 10);

346: ,p_hook_type => 'AI');
347: --
348: end;
349: --
350: hr_utility.set_location(' Leaving:'||l_proc, 10);
351: End post_insert;
352: --
353: -- ----------------------------------------------------------------------------
354: -- |---------------------------------< ins >----------------------------------|

Line 364: hr_utility.set_location('Entering:'||l_proc,5);

360: --
361: l_proc varchar2(72) := g_package||'ins';
362: --
363: Begin
364: hr_utility.set_location('Entering:'||l_proc,5);
365: --
366: -- Call the supporting insert validate operations
367: --
368: pqh_rls_bus.insert_validate

Line 388: hr_utility.set_location('Leaving:'||l_proc,20);

384: (p_effective_date
385: ,p_rec
386: );
387: --
388: hr_utility.set_location('Leaving:'||l_proc,20);
389: end ins;
390: --
391: -- ----------------------------------------------------------------------------
392: -- |---------------------------------< ins >----------------------------------|

Line 441: hr_utility.set_location('Entering:'||l_proc,5);

437: l_rec pqh_rls_shd.g_rec_type;
438: l_proc varchar2(72) := g_package||'ins';
439: --
440: Begin
441: hr_utility.set_location('Entering:'||l_proc,5);
442: --
443: -- Call conversion function to turn arguments into the
444: -- structure.
445: --

Line 501: hr_utility.set_location(' Leaving:'||l_proc,10);

497: --
498: p_role_id := l_rec.role_id;
499: p_object_version_number := l_rec.object_version_number;
500: --
501: hr_utility.set_location(' Leaving:'||l_proc,10);
502: End ins;
503: --
504: end pqh_rls_ins;