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_GET_ELIG dependencies on PER_ASG_OBJ

Line 241: l_per_asg_obj per_asg_obj;

237: , x_return_message OUT NOCOPY VARCHAR2
238: ) IS
239:
240: l_proc VARCHAR2(50);
241: l_per_asg_obj per_asg_obj;
242:
243: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;
244: l_person_id per_all_people_f.person_id%TYPE;
245: l_party_id per_all_people_f.party_id%TYPE;

Line 273: l_per_asg_obj := per_asg_obj(NULL,NULL,NULL,NULL,NULL);

269:
270: BEGIN
271: l_proc := 'per_get_elig.get_per_asg_for_elig_obj_live';
272: hr_utility.set_location('Entering: '|| l_proc, 10);
273: l_per_asg_obj := per_asg_obj(NULL,NULL,NULL,NULL,NULL);
274: x_person_assignment := per_asg_varray(); -- initialize empty
275: x_return_status := '0';
276: x_return_message := '';
277:

Line 345: l_per_asg_obj.person_id := l_person_id;

341:
342: hr_utility.set_location('Eligible', 46);
343:
344: -- Capture details of eligibile object
345: l_per_asg_obj.person_id := l_person_id;
346: l_per_asg_obj.assignment_id := l_assignment_id;
347: l_per_asg_obj.party_id := l_party_id;
348: l_per_asg_obj.eff_start_date := l_asg_eff_st_dt;
349: l_per_asg_obj.eff_end_date := l_asg_eff_en_dt;

Line 346: l_per_asg_obj.assignment_id := l_assignment_id;

342: hr_utility.set_location('Eligible', 46);
343:
344: -- Capture details of eligibile object
345: l_per_asg_obj.person_id := l_person_id;
346: l_per_asg_obj.assignment_id := l_assignment_id;
347: l_per_asg_obj.party_id := l_party_id;
348: l_per_asg_obj.eff_start_date := l_asg_eff_st_dt;
349: l_per_asg_obj.eff_end_date := l_asg_eff_en_dt;
350:

Line 347: l_per_asg_obj.party_id := l_party_id;

343:
344: -- Capture details of eligibile object
345: l_per_asg_obj.person_id := l_person_id;
346: l_per_asg_obj.assignment_id := l_assignment_id;
347: l_per_asg_obj.party_id := l_party_id;
348: l_per_asg_obj.eff_start_date := l_asg_eff_st_dt;
349: l_per_asg_obj.eff_end_date := l_asg_eff_en_dt;
350:
351: -- Save eligibile object into array

Line 348: l_per_asg_obj.eff_start_date := l_asg_eff_st_dt;

344: -- Capture details of eligibile object
345: l_per_asg_obj.person_id := l_person_id;
346: l_per_asg_obj.assignment_id := l_assignment_id;
347: l_per_asg_obj.party_id := l_party_id;
348: l_per_asg_obj.eff_start_date := l_asg_eff_st_dt;
349: l_per_asg_obj.eff_end_date := l_asg_eff_en_dt;
350:
351: -- Save eligibile object into array
352: x_person_assignment.EXTEND(1);

Line 349: l_per_asg_obj.eff_end_date := l_asg_eff_en_dt;

345: l_per_asg_obj.person_id := l_person_id;
346: l_per_asg_obj.assignment_id := l_assignment_id;
347: l_per_asg_obj.party_id := l_party_id;
348: l_per_asg_obj.eff_start_date := l_asg_eff_st_dt;
349: l_per_asg_obj.eff_end_date := l_asg_eff_en_dt;
350:
351: -- Save eligibile object into array
352: x_person_assignment.EXTEND(1);
353: x_person_assignment(x_person_assignment.COUNT) := l_per_asg_obj;

Line 353: x_person_assignment(x_person_assignment.COUNT) := l_per_asg_obj;

349: l_per_asg_obj.eff_end_date := l_asg_eff_en_dt;
350:
351: -- Save eligibile object into array
352: x_person_assignment.EXTEND(1);
353: x_person_assignment(x_person_assignment.COUNT) := l_per_asg_obj;
354: END IF;
355:
356: END LOOP; -- Loop for assignments for the person
357: CLOSE c_asg;

Line 392: l_per_asg_obj per_asg_obj;

388: , x_return_message OUT NOCOPY VARCHAR2
389: ) IS
390:
391: l_proc VARCHAR2(50);
392: l_per_asg_obj per_asg_obj;
393:
394: -- Cursor to fetch all the eligibile persons for the given object
395: CURSOR c_elig_per_asg ( cp_table_name IN VARCHAR2
396: , cp_column_name IN VARCHAR2

Line 442: l_per_asg_obj := per_asg_obj(NULL,NULL,NULL,NULL,NULL);

438:
439: BEGIN
440: l_proc := 'per_get_elig.get_per_asg_for_elig_obj_cache';
441: hr_utility.set_location('Entering: '|| l_proc, 10);
442: l_per_asg_obj := per_asg_obj(NULL,NULL,NULL,NULL,NULL);
443: x_person_assignment := per_asg_varray(); -- initialize empty
444: x_return_status := '0';
445: x_return_message := '';
446:

Line 458: FETCH c_elig_per_asg INTO l_per_asg_obj.person_id

454:
455: hr_utility.set_location(l_proc, 20);
456:
457: LOOP -- for result person assignments
458: FETCH c_elig_per_asg INTO l_per_asg_obj.person_id
459: ,l_per_asg_obj.assignment_id;
460: EXIT WHEN c_elig_per_asg%NOTFOUND;
461: hr_utility.set_location('PerId '||l_per_asg_obj.person_id||
462: ' AsgId '||l_per_asg_obj.assignment_id,23);

Line 459: ,l_per_asg_obj.assignment_id;

455: hr_utility.set_location(l_proc, 20);
456:
457: LOOP -- for result person assignments
458: FETCH c_elig_per_asg INTO l_per_asg_obj.person_id
459: ,l_per_asg_obj.assignment_id;
460: EXIT WHEN c_elig_per_asg%NOTFOUND;
461: hr_utility.set_location('PerId '||l_per_asg_obj.person_id||
462: ' AsgId '||l_per_asg_obj.assignment_id,23);
463:

Line 461: hr_utility.set_location('PerId '||l_per_asg_obj.person_id||

457: LOOP -- for result person assignments
458: FETCH c_elig_per_asg INTO l_per_asg_obj.person_id
459: ,l_per_asg_obj.assignment_id;
460: EXIT WHEN c_elig_per_asg%NOTFOUND;
461: hr_utility.set_location('PerId '||l_per_asg_obj.person_id||
462: ' AsgId '||l_per_asg_obj.assignment_id,23);
463:
464: hr_utility.set_location(l_proc, 22);
465:

Line 462: ' AsgId '||l_per_asg_obj.assignment_id,23);

458: FETCH c_elig_per_asg INTO l_per_asg_obj.person_id
459: ,l_per_asg_obj.assignment_id;
460: EXIT WHEN c_elig_per_asg%NOTFOUND;
461: hr_utility.set_location('PerId '||l_per_asg_obj.person_id||
462: ' AsgId '||l_per_asg_obj.assignment_id,23);
463:
464: hr_utility.set_location(l_proc, 22);
465:
466: -- Get party id

Line 467: OPEN c_party_id (l_per_asg_obj.person_id

463:
464: hr_utility.set_location(l_proc, 22);
465:
466: -- Get party id
467: OPEN c_party_id (l_per_asg_obj.person_id
468: ,p_effective_date
469: );
470: FETCH c_party_id INTO l_per_asg_obj.party_id;
471: CLOSE c_party_id;

Line 470: FETCH c_party_id INTO l_per_asg_obj.party_id;

466: -- Get party id
467: OPEN c_party_id (l_per_asg_obj.person_id
468: ,p_effective_date
469: );
470: FETCH c_party_id INTO l_per_asg_obj.party_id;
471: CLOSE c_party_id;
472:
473: hr_utility.set_location(l_proc, 24);
474:

Line 476: OPEN c_asg_eff_dates (l_per_asg_obj.person_id

472:
473: hr_utility.set_location(l_proc, 24);
474:
475: -- Get assignment dates
476: OPEN c_asg_eff_dates (l_per_asg_obj.person_id
477: ,l_per_asg_obj.assignment_id
478: ,p_effective_date
479: );
480: FETCH c_asg_eff_dates INTO l_per_asg_obj.eff_start_date

Line 477: ,l_per_asg_obj.assignment_id

473: hr_utility.set_location(l_proc, 24);
474:
475: -- Get assignment dates
476: OPEN c_asg_eff_dates (l_per_asg_obj.person_id
477: ,l_per_asg_obj.assignment_id
478: ,p_effective_date
479: );
480: FETCH c_asg_eff_dates INTO l_per_asg_obj.eff_start_date
481: ,l_per_asg_obj.eff_end_date;

Line 480: FETCH c_asg_eff_dates INTO l_per_asg_obj.eff_start_date

476: OPEN c_asg_eff_dates (l_per_asg_obj.person_id
477: ,l_per_asg_obj.assignment_id
478: ,p_effective_date
479: );
480: FETCH c_asg_eff_dates INTO l_per_asg_obj.eff_start_date
481: ,l_per_asg_obj.eff_end_date;
482: CLOSE c_asg_eff_dates;
483:
484: hr_utility.set_location(l_proc, 26);

Line 481: ,l_per_asg_obj.eff_end_date;

477: ,l_per_asg_obj.assignment_id
478: ,p_effective_date
479: );
480: FETCH c_asg_eff_dates INTO l_per_asg_obj.eff_start_date
481: ,l_per_asg_obj.eff_end_date;
482: CLOSE c_asg_eff_dates;
483:
484: hr_utility.set_location(l_proc, 26);
485:

Line 488: x_person_assignment(x_person_assignment.COUNT) := l_per_asg_obj;

484: hr_utility.set_location(l_proc, 26);
485:
486: -- Save person assignments into array
487: x_person_assignment.EXTEND(1);
488: x_person_assignment(x_person_assignment.COUNT) := l_per_asg_obj;
489:
490: END LOOP; -- for result person assignments
491: CLOSE c_elig_per_asg;
492: