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

Line 356: hr_utility.set_location('Look for ABV Formula - 1',10);

352: l_max_date_to date;
353:
354: begin
355:
356: hr_utility.set_location('Look for ABV Formula - 1',10);
357:
358: /* Look for ABV Formula */
359:
360: open c_get_ABV_formula(p_business_group_id);

Line 364: hr_utility.set_location('ABV Formula ID = '||l_ABV_formula_id,20);

360: open c_get_ABV_formula(p_business_group_id);
361:
362: fetch c_get_ABV_formula into l_ABV_formula_id;
363:
364: hr_utility.set_location('ABV Formula ID = '||l_ABV_formula_id,20);
365:
366: if (c_get_ABV_formula%notfound)
367:
368: then

Line 372: hr_utility.set_location('c_get_ABV_formula Not Found - 2',30);

368: then
369:
370: close c_get_ABV_formula;
371:
372: hr_utility.set_location('c_get_ABV_formula Not Found - 2',30);
373:
374: /* If the ABV formula does not exist, look for the template formula */
375:
376: open c_get_tmplt_ABV_formula;

Line 380: hr_utility.set_location('Template ABV Formula = '||l_ABV_formula_id,40);

376: open c_get_tmplt_ABV_formula;
377:
378: fetch c_get_tmplt_ABV_formula into l_ABV_formula_id;
379:
380: hr_utility.set_location('Template ABV Formula = '||l_ABV_formula_id,40);
381:
382: if (c_get_tmplt_ABV_formula%notfound)
383:
384: then

Line 388: hr_utility.set_location('c_get_tmpt_ABV_formula Not Found - 3',50);

384: then
385:
386: close c_get_tmplt_ABV_formula;
387:
388: hr_utility.set_location('c_get_tmpt_ABV_formula Not Found - 3',50);
389:
390: -- Set to null so that we can calculate values differently later
391:
392: l_ABV_formula_id := null;

Line 398: hr_utility.set_location('close c_get_tmpt_ABV_formula - 4',60);

394: else
395:
396: close c_get_tmplt_ABV_formula;
397:
398: hr_utility.set_location('close c_get_tmpt_ABV_formula - 4',60);
399:
400: end if;
401:
402: else

Line 406: hr_utility.set_location('close c_get_ABV_formula - 5',70);

402: else
403:
404: close c_get_ABV_formula;
405:
406: hr_utility.set_location('close c_get_ABV_formula - 5',70);
407:
408: end if;
409:
410:

Line 412: hr_utility.set_location('P_BUSINESS_GROUP_ID='||to_char(P_BUSINESS_GROUP_ID),80);

408: end if;
409:
410:
411:
412: hr_utility.set_location('P_BUSINESS_GROUP_ID='||to_char(P_BUSINESS_GROUP_ID),80);
413: hr_utility.set_location('P_TOP_ORGANIZATION_ID='||to_char(P_TOP_ORGANIZATION_ID),90);
414: hr_utility.set_location('P_ORGANIZATION_STRUCTURE_ID='||to_char(P_ORGANIZATION_STRUCTURE_ID),100);
415: hr_utility.set_location('P_REPORT_DATE_FROM='||to_char(P_REPORT_DATE_FROM,'DD-MON-YYYY'),110);
416: hr_utility.set_location('P_REPORT_DATE_TO='||to_char(P_REPORT_DATE_TO,'DD-MON-YYYY'),120);

Line 413: hr_utility.set_location('P_TOP_ORGANIZATION_ID='||to_char(P_TOP_ORGANIZATION_ID),90);

409:
410:
411:
412: hr_utility.set_location('P_BUSINESS_GROUP_ID='||to_char(P_BUSINESS_GROUP_ID),80);
413: hr_utility.set_location('P_TOP_ORGANIZATION_ID='||to_char(P_TOP_ORGANIZATION_ID),90);
414: hr_utility.set_location('P_ORGANIZATION_STRUCTURE_ID='||to_char(P_ORGANIZATION_STRUCTURE_ID),100);
415: hr_utility.set_location('P_REPORT_DATE_FROM='||to_char(P_REPORT_DATE_FROM,'DD-MON-YYYY'),110);
416: hr_utility.set_location('P_REPORT_DATE_TO='||to_char(P_REPORT_DATE_TO,'DD-MON-YYYY'),120);
417: hr_utility.set_location('P_REPORT_DATE='||to_char(P_REPORT_DATE,'DD-MON-YYYY'),130);

Line 414: hr_utility.set_location('P_ORGANIZATION_STRUCTURE_ID='||to_char(P_ORGANIZATION_STRUCTURE_ID),100);

410:
411:
412: hr_utility.set_location('P_BUSINESS_GROUP_ID='||to_char(P_BUSINESS_GROUP_ID),80);
413: hr_utility.set_location('P_TOP_ORGANIZATION_ID='||to_char(P_TOP_ORGANIZATION_ID),90);
414: hr_utility.set_location('P_ORGANIZATION_STRUCTURE_ID='||to_char(P_ORGANIZATION_STRUCTURE_ID),100);
415: hr_utility.set_location('P_REPORT_DATE_FROM='||to_char(P_REPORT_DATE_FROM,'DD-MON-YYYY'),110);
416: hr_utility.set_location('P_REPORT_DATE_TO='||to_char(P_REPORT_DATE_TO,'DD-MON-YYYY'),120);
417: hr_utility.set_location('P_REPORT_DATE='||to_char(P_REPORT_DATE,'DD-MON-YYYY'),130);
418: hr_utility.set_location('P_JOB_CATEGORY='||P_JOB_CATEGORY,140);

Line 415: hr_utility.set_location('P_REPORT_DATE_FROM='||to_char(P_REPORT_DATE_FROM,'DD-MON-YYYY'),110);

411:
412: hr_utility.set_location('P_BUSINESS_GROUP_ID='||to_char(P_BUSINESS_GROUP_ID),80);
413: hr_utility.set_location('P_TOP_ORGANIZATION_ID='||to_char(P_TOP_ORGANIZATION_ID),90);
414: hr_utility.set_location('P_ORGANIZATION_STRUCTURE_ID='||to_char(P_ORGANIZATION_STRUCTURE_ID),100);
415: hr_utility.set_location('P_REPORT_DATE_FROM='||to_char(P_REPORT_DATE_FROM,'DD-MON-YYYY'),110);
416: hr_utility.set_location('P_REPORT_DATE_TO='||to_char(P_REPORT_DATE_TO,'DD-MON-YYYY'),120);
417: hr_utility.set_location('P_REPORT_DATE='||to_char(P_REPORT_DATE,'DD-MON-YYYY'),130);
418: hr_utility.set_location('P_JOB_CATEGORY='||P_JOB_CATEGORY,140);
419: hr_utility.set_location('P_INCLUDE_TOP_ORG='||P_INCLUDE_TOP_ORG,150);

Line 416: hr_utility.set_location('P_REPORT_DATE_TO='||to_char(P_REPORT_DATE_TO,'DD-MON-YYYY'),120);

412: hr_utility.set_location('P_BUSINESS_GROUP_ID='||to_char(P_BUSINESS_GROUP_ID),80);
413: hr_utility.set_location('P_TOP_ORGANIZATION_ID='||to_char(P_TOP_ORGANIZATION_ID),90);
414: hr_utility.set_location('P_ORGANIZATION_STRUCTURE_ID='||to_char(P_ORGANIZATION_STRUCTURE_ID),100);
415: hr_utility.set_location('P_REPORT_DATE_FROM='||to_char(P_REPORT_DATE_FROM,'DD-MON-YYYY'),110);
416: hr_utility.set_location('P_REPORT_DATE_TO='||to_char(P_REPORT_DATE_TO,'DD-MON-YYYY'),120);
417: hr_utility.set_location('P_REPORT_DATE='||to_char(P_REPORT_DATE,'DD-MON-YYYY'),130);
418: hr_utility.set_location('P_JOB_CATEGORY='||P_JOB_CATEGORY,140);
419: hr_utility.set_location('P_INCLUDE_TOP_ORG='||P_INCLUDE_TOP_ORG,150);
420:

Line 417: hr_utility.set_location('P_REPORT_DATE='||to_char(P_REPORT_DATE,'DD-MON-YYYY'),130);

413: hr_utility.set_location('P_TOP_ORGANIZATION_ID='||to_char(P_TOP_ORGANIZATION_ID),90);
414: hr_utility.set_location('P_ORGANIZATION_STRUCTURE_ID='||to_char(P_ORGANIZATION_STRUCTURE_ID),100);
415: hr_utility.set_location('P_REPORT_DATE_FROM='||to_char(P_REPORT_DATE_FROM,'DD-MON-YYYY'),110);
416: hr_utility.set_location('P_REPORT_DATE_TO='||to_char(P_REPORT_DATE_TO,'DD-MON-YYYY'),120);
417: hr_utility.set_location('P_REPORT_DATE='||to_char(P_REPORT_DATE,'DD-MON-YYYY'),130);
418: hr_utility.set_location('P_JOB_CATEGORY='||P_JOB_CATEGORY,140);
419: hr_utility.set_location('P_INCLUDE_TOP_ORG='||P_INCLUDE_TOP_ORG,150);
420:
421: begin

Line 418: hr_utility.set_location('P_JOB_CATEGORY='||P_JOB_CATEGORY,140);

414: hr_utility.set_location('P_ORGANIZATION_STRUCTURE_ID='||to_char(P_ORGANIZATION_STRUCTURE_ID),100);
415: hr_utility.set_location('P_REPORT_DATE_FROM='||to_char(P_REPORT_DATE_FROM,'DD-MON-YYYY'),110);
416: hr_utility.set_location('P_REPORT_DATE_TO='||to_char(P_REPORT_DATE_TO,'DD-MON-YYYY'),120);
417: hr_utility.set_location('P_REPORT_DATE='||to_char(P_REPORT_DATE,'DD-MON-YYYY'),130);
418: hr_utility.set_location('P_JOB_CATEGORY='||P_JOB_CATEGORY,140);
419: hr_utility.set_location('P_INCLUDE_TOP_ORG='||P_INCLUDE_TOP_ORG,150);
420:
421: begin
422:

Line 419: hr_utility.set_location('P_INCLUDE_TOP_ORG='||P_INCLUDE_TOP_ORG,150);

415: hr_utility.set_location('P_REPORT_DATE_FROM='||to_char(P_REPORT_DATE_FROM,'DD-MON-YYYY'),110);
416: hr_utility.set_location('P_REPORT_DATE_TO='||to_char(P_REPORT_DATE_TO,'DD-MON-YYYY'),120);
417: hr_utility.set_location('P_REPORT_DATE='||to_char(P_REPORT_DATE,'DD-MON-YYYY'),130);
418: hr_utility.set_location('P_JOB_CATEGORY='||P_JOB_CATEGORY,140);
419: hr_utility.set_location('P_INCLUDE_TOP_ORG='||P_INCLUDE_TOP_ORG,150);
420:
421: begin
422:
423: select min(posv.org_structure_version_id)

Line 430: hr_utility.set_location('min_org_structure_version_id='||l_min_org_structure_version_id,160);

426: where posv.organization_structure_id = P_ORGANIZATION_STRUCTURE_ID
427: and P_REPORT_DATE_FROM between posv.date_from
428: and nvl(posv.date_to,to_date('31/12/4712','DD/MM/YYYY'));
429:
430: hr_utility.set_location('min_org_structure_version_id='||l_min_org_structure_version_id,160);
431:
432: select greatest(posv.date_from,P_REPORT_DATE_FROM),
433: least(nvl(posv.date_to,P_REPORT_DATE_TO),P_REPORT_DATE_TO)
434: into l_min_date_from,l_min_date_to

Line 438: hr_utility.set_location('l_min_date_from='||l_min_date_from,170);

434: into l_min_date_from,l_min_date_to
435: from per_org_structure_versions posv
436: where posv.org_structure_version_id = l_min_org_structure_version_id;
437:
438: hr_utility.set_location('l_min_date_from='||l_min_date_from,170);
439: hr_utility.set_location('l_min_date_to='||l_min_date_to,180);
440:
441: select max(posv.org_structure_version_id)
442: into l_max_org_structure_version_id

Line 439: hr_utility.set_location('l_min_date_to='||l_min_date_to,180);

435: from per_org_structure_versions posv
436: where posv.org_structure_version_id = l_min_org_structure_version_id;
437:
438: hr_utility.set_location('l_min_date_from='||l_min_date_from,170);
439: hr_utility.set_location('l_min_date_to='||l_min_date_to,180);
440:
441: select max(posv.org_structure_version_id)
442: into l_max_org_structure_version_id
443: from per_org_structure_versions posv

Line 448: hr_utility.set_location('max_org_structure_version_id='||l_max_org_structure_version_id,190);

444: where posv.organization_structure_id = P_ORGANIZATION_STRUCTURE_ID
445: and P_REPORT_DATE_TO between posv.date_from
446: and nvl(posv.date_to,to_date('31/12/4712','DD/MM/YYYY'));
447:
448: hr_utility.set_location('max_org_structure_version_id='||l_max_org_structure_version_id,190);
449:
450: select least(nvl(posv.date_to,P_REPORT_DATE_TO),P_REPORT_DATE_TO),
451: greatest(posv.date_from,P_REPORT_DATE_FROM)
452: into l_max_date_to,l_max_date_from

Line 461: hr_utility.set_location('l_max_date_from='||l_max_date_from,200);

457: when NO_DATA_FOUND then
458: raise;
459: end;
460:
461: hr_utility.set_location('l_max_date_from='||l_max_date_from,200);
462: hr_utility.set_location('l_max_date_to='||l_max_date_to,210);
463:
464: for all_organizations_rec in get_all_organizations
465: (P_ORGANIZATION_STRUCTURE_ID

Line 462: hr_utility.set_location('l_max_date_to='||l_max_date_to,210);

458: raise;
459: end;
460:
461: hr_utility.set_location('l_max_date_from='||l_max_date_from,200);
462: hr_utility.set_location('l_max_date_to='||l_max_date_to,210);
463:
464: for all_organizations_rec in get_all_organizations
465: (P_ORGANIZATION_STRUCTURE_ID
466: ,P_TOP_ORGANIZATION_ID

Line 480: hr_utility.set_location('all_organizations_rec.organization_id='||all_organizations_rec.organization_id,220);

476: HQOrgData(all_organizations_rec.organization_id).nonrev_nh := 0;
477: HQOrgData(all_organizations_rec.organization_id).rev_term := 0;
478: HQOrgData(all_organizations_rec.organization_id).nonrev_term := 0;
479:
480: hr_utility.set_location('all_organizations_rec.organization_id='||all_organizations_rec.organization_id,220);
481: hr_utility.set_location('rev_start_val='||HQOrgData(all_organizations_rec.organization_id).rev_start_val,230);
482: hr_utility.set_location('rev_end_val='||HQOrgData(all_organizations_rec.organization_id).rev_end_val,240);
483: hr_utility.set_location('nonrev_start_val='||HQOrgData(all_organizations_rec.organization_id).nonrev_start_val,250);
484: hr_utility.set_location('nonrev_end_val='||HQOrgData(all_organizations_rec.organization_id).nonrev_end_val,260);

Line 481: hr_utility.set_location('rev_start_val='||HQOrgData(all_organizations_rec.organization_id).rev_start_val,230);

477: HQOrgData(all_organizations_rec.organization_id).rev_term := 0;
478: HQOrgData(all_organizations_rec.organization_id).nonrev_term := 0;
479:
480: hr_utility.set_location('all_organizations_rec.organization_id='||all_organizations_rec.organization_id,220);
481: hr_utility.set_location('rev_start_val='||HQOrgData(all_organizations_rec.organization_id).rev_start_val,230);
482: hr_utility.set_location('rev_end_val='||HQOrgData(all_organizations_rec.organization_id).rev_end_val,240);
483: hr_utility.set_location('nonrev_start_val='||HQOrgData(all_organizations_rec.organization_id).nonrev_start_val,250);
484: hr_utility.set_location('nonrev_end_val='||HQOrgData(all_organizations_rec.organization_id).nonrev_end_val,260);
485:

Line 482: hr_utility.set_location('rev_end_val='||HQOrgData(all_organizations_rec.organization_id).rev_end_val,240);

478: HQOrgData(all_organizations_rec.organization_id).nonrev_term := 0;
479:
480: hr_utility.set_location('all_organizations_rec.organization_id='||all_organizations_rec.organization_id,220);
481: hr_utility.set_location('rev_start_val='||HQOrgData(all_organizations_rec.organization_id).rev_start_val,230);
482: hr_utility.set_location('rev_end_val='||HQOrgData(all_organizations_rec.organization_id).rev_end_val,240);
483: hr_utility.set_location('nonrev_start_val='||HQOrgData(all_organizations_rec.organization_id).nonrev_start_val,250);
484: hr_utility.set_location('nonrev_end_val='||HQOrgData(all_organizations_rec.organization_id).nonrev_end_val,260);
485:
486: end loop;

Line 483: hr_utility.set_location('nonrev_start_val='||HQOrgData(all_organizations_rec.organization_id).nonrev_start_val,250);

479:
480: hr_utility.set_location('all_organizations_rec.organization_id='||all_organizations_rec.organization_id,220);
481: hr_utility.set_location('rev_start_val='||HQOrgData(all_organizations_rec.organization_id).rev_start_val,230);
482: hr_utility.set_location('rev_end_val='||HQOrgData(all_organizations_rec.organization_id).rev_end_val,240);
483: hr_utility.set_location('nonrev_start_val='||HQOrgData(all_organizations_rec.organization_id).nonrev_start_val,250);
484: hr_utility.set_location('nonrev_end_val='||HQOrgData(all_organizations_rec.organization_id).nonrev_end_val,260);
485:
486: end loop;
487:

Line 484: hr_utility.set_location('nonrev_end_val='||HQOrgData(all_organizations_rec.organization_id).nonrev_end_val,260);

480: hr_utility.set_location('all_organizations_rec.organization_id='||all_organizations_rec.organization_id,220);
481: hr_utility.set_location('rev_start_val='||HQOrgData(all_organizations_rec.organization_id).rev_start_val,230);
482: hr_utility.set_location('rev_end_val='||HQOrgData(all_organizations_rec.organization_id).rev_end_val,240);
483: hr_utility.set_location('nonrev_start_val='||HQOrgData(all_organizations_rec.organization_id).nonrev_start_val,250);
484: hr_utility.set_location('nonrev_end_val='||HQOrgData(all_organizations_rec.organization_id).nonrev_end_val,260);
485:
486: end loop;
487:
488:

Line 496: hr_utility.set_location('org_str_ele.organization_id1='||org_str_ele.organization_id1,270);

492: )
493:
494: loop -- get_org_structure_element
495:
496: hr_utility.set_location('org_str_ele.organization_id1='||org_str_ele.organization_id1,270);
497:
498: l_rev_start_val :=0;
499: l_nonrev_start_val :=0;
500:

Line 508: hr_utility.set_location('start_orgs_rec.organization_id2='||start_orgs_rec.organization_id2,280);

504: ,P_ROLL_UP)
505:
506: loop -- get_organizations
507:
508: hr_utility.set_location('start_orgs_rec.organization_id2='||start_orgs_rec.organization_id2,280);
509:
510: for asg_start_rec in get_assignment_start_end
511: (l_min_date_from
512: ,start_orgs_rec.organization_id2

Line 517: hr_utility.set_location('asg_start_rec.assignment_id='||asg_start_rec.assignment_id,290);

513: ,P_BUSINESS_GROUP_ID
514: )
515: loop -- get_assignment_start_end
516:
517: hr_utility.set_location('asg_start_rec.assignment_id='||asg_start_rec.assignment_id,290);
518:
519:
520: l_jobcatg := NULL;
521: l_abv := NULL;

Line 530: hr_utility.set_location('l_abv='||l_abv,300);

526: , p_assignment_id => asg_start_rec.assignment_id
527: , p_effective_date => asg_start_rec.effective_start_date
528: , p_session_date => trunc(sysdate) );
529:
530: hr_utility.set_location('l_abv='||l_abv,300);
531:
532:
533: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
534: (asg_start_rec.job_id

Line 556: hr_utility.set_location('org_str_ele.organization_id1='||org_str_ele.organization_id1,310);

552: HQOrgData(org_str_ele.organization_id1).rev_start_val+ l_rev_start_val;
553: HQOrgData(org_str_ele.organization_id1).nonrev_start_val :=
554: HQOrgData(org_str_ele.organization_id1).nonrev_start_val+l_nonrev_start_val;
555:
556: hr_utility.set_location('org_str_ele.organization_id1='||org_str_ele.organization_id1,310);
557: hr_utility.set_location('rev_start_val='||HQOrgData(org_str_ele.organization_id1).rev_start_val,320);
558: hr_utility.set_location('nonrev_start_val='||HQOrgData(org_str_ele.organization_id1).nonrev_start_val,330);
559:
560: end loop; -- get_org_structure_element

Line 557: hr_utility.set_location('rev_start_val='||HQOrgData(org_str_ele.organization_id1).rev_start_val,320);

553: HQOrgData(org_str_ele.organization_id1).nonrev_start_val :=
554: HQOrgData(org_str_ele.organization_id1).nonrev_start_val+l_nonrev_start_val;
555:
556: hr_utility.set_location('org_str_ele.organization_id1='||org_str_ele.organization_id1,310);
557: hr_utility.set_location('rev_start_val='||HQOrgData(org_str_ele.organization_id1).rev_start_val,320);
558: hr_utility.set_location('nonrev_start_val='||HQOrgData(org_str_ele.organization_id1).nonrev_start_val,330);
559:
560: end loop; -- get_org_structure_element
561:

Line 558: hr_utility.set_location('nonrev_start_val='||HQOrgData(org_str_ele.organization_id1).nonrev_start_val,330);

554: HQOrgData(org_str_ele.organization_id1).nonrev_start_val+l_nonrev_start_val;
555:
556: hr_utility.set_location('org_str_ele.organization_id1='||org_str_ele.organization_id1,310);
557: hr_utility.set_location('rev_start_val='||HQOrgData(org_str_ele.organization_id1).rev_start_val,320);
558: hr_utility.set_location('nonrev_start_val='||HQOrgData(org_str_ele.organization_id1).nonrev_start_val,330);
559:
560: end loop; -- get_org_structure_element
561:
562: hr_utility.set_location('100',340);

Line 562: hr_utility.set_location('100',340);

558: hr_utility.set_location('nonrev_start_val='||HQOrgData(org_str_ele.organization_id1).nonrev_start_val,330);
559:
560: end loop; -- get_org_structure_element
561:
562: hr_utility.set_location('100',340);
563:
564: for org_str_ele in get_org_structure_element
565: (l_max_org_structure_version_id
566: ,P_TOP_ORGANIZATION_ID

Line 571: hr_utility.set_location('end.org_str_ele.organization_id1='||org_str_ele.organization_id1,350);

567: )
568:
569: loop -- get_org_structure_element
570:
571: hr_utility.set_location('end.org_str_ele.organization_id1='||org_str_ele.organization_id1,350);
572:
573: l_rev_end_val :=0;
574: l_nonrev_end_val :=0;
575:

Line 583: hr_utility.set_location('end_orgs_rec.organization_id2='||end_orgs_rec.organization_id2,360);

579: ,P_ROLL_UP)
580:
581: loop -- get_organizations
582:
583: hr_utility.set_location('end_orgs_rec.organization_id2='||end_orgs_rec.organization_id2,360);
584:
585: for asg_end_rec in get_assignment_start_end
586: (l_max_date_to
587: ,end_orgs_rec.organization_id2

Line 592: hr_utility.set_location('asg_end_rec.assignment_id='||asg_end_rec.assignment_id,370);

588: ,P_BUSINESS_GROUP_ID
589: )
590: loop -- get_assignment_start_end
591:
592: hr_utility.set_location('asg_end_rec.assignment_id='||asg_end_rec.assignment_id,370);
593:
594:
595: l_jobcatg := NULL;
596: l_abv := NULL;

Line 606: hr_utility.set_location('l_abv='||l_abv,380);

602: , p_effective_date => asg_end_rec.effective_start_date
603: , p_session_date => trunc(sysdate) );
604:
605:
606: hr_utility.set_location('l_abv='||l_abv,380);
607:
608: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
609: (asg_end_rec.job_id
610: ,p_job_category);

Line 630: hr_utility.set_location('org_str_ele.organization_id1='||org_str_ele.organization_id1,390);

626: HQOrgData(org_str_ele.organization_id1).rev_end_val+ l_rev_end_val;
627: HQOrgData(org_str_ele.organization_id1).nonrev_end_val :=
628: HQOrgData(org_str_ele.organization_id1).nonrev_end_val+l_nonrev_end_val;
629:
630: hr_utility.set_location('org_str_ele.organization_id1='||org_str_ele.organization_id1,390);
631: hr_utility.set_location('rev_end_val='||HQOrgData(org_str_ele.organization_id1).rev_end_val,400);
632: hr_utility.set_location('nonrev_end_val='||HQOrgData(org_str_ele.organization_id1).nonrev_end_val,410);
633:
634: end loop; -- get_org_structure_element

Line 631: hr_utility.set_location('rev_end_val='||HQOrgData(org_str_ele.organization_id1).rev_end_val,400);

627: HQOrgData(org_str_ele.organization_id1).nonrev_end_val :=
628: HQOrgData(org_str_ele.organization_id1).nonrev_end_val+l_nonrev_end_val;
629:
630: hr_utility.set_location('org_str_ele.organization_id1='||org_str_ele.organization_id1,390);
631: hr_utility.set_location('rev_end_val='||HQOrgData(org_str_ele.organization_id1).rev_end_val,400);
632: hr_utility.set_location('nonrev_end_val='||HQOrgData(org_str_ele.organization_id1).nonrev_end_val,410);
633:
634: end loop; -- get_org_structure_element
635:

Line 632: hr_utility.set_location('nonrev_end_val='||HQOrgData(org_str_ele.organization_id1).nonrev_end_val,410);

628: HQOrgData(org_str_ele.organization_id1).nonrev_end_val+l_nonrev_end_val;
629:
630: hr_utility.set_location('org_str_ele.organization_id1='||org_str_ele.organization_id1,390);
631: hr_utility.set_location('rev_end_val='||HQOrgData(org_str_ele.organization_id1).rev_end_val,400);
632: hr_utility.set_location('nonrev_end_val='||HQOrgData(org_str_ele.organization_id1).nonrev_end_val,410);
633:
634: end loop; -- get_org_structure_element
635:
636: -- Start of New Hires and Terminations Count

Line 644: hr_utility.set_location('org_structure_version_rec.date_from ='||org_structure_version_rec.date_from,420);

640: ,P_REPORT_DATE_FROM
641: ,P_REPORT_DATE_TO)
642: loop
643:
644: hr_utility.set_location('org_structure_version_rec.date_from ='||org_structure_version_rec.date_from,420);
645: hr_utility.set_location('org_structure_version_rec.date_to ='||org_structure_version_rec.date_to,430);
646: if P_REPORT_DATE_FROM > org_structure_version_rec.date_from then
647: P_DATE_FROM := P_REPORT_DATE_FROM;
648: else

Line 645: hr_utility.set_location('org_structure_version_rec.date_to ='||org_structure_version_rec.date_to,430);

641: ,P_REPORT_DATE_TO)
642: loop
643:
644: hr_utility.set_location('org_structure_version_rec.date_from ='||org_structure_version_rec.date_from,420);
645: hr_utility.set_location('org_structure_version_rec.date_to ='||org_structure_version_rec.date_to,430);
646: if P_REPORT_DATE_FROM > org_structure_version_rec.date_from then
647: P_DATE_FROM := P_REPORT_DATE_FROM;
648: else
649: P_DATE_FROM :=org_structure_version_rec.date_from;

Line 652: hr_utility.set_location('P_DATE_FROM='||P_DATE_FROM,440);

648: else
649: P_DATE_FROM :=org_structure_version_rec.date_from;
650: end if;
651:
652: hr_utility.set_location('P_DATE_FROM='||P_DATE_FROM,440);
653:
654: if P_REPORT_DATE_TO < org_structure_version_rec.date_to then
655: P_DATE_TO := P_REPORT_DATE_TO;
656: else

Line 660: hr_utility.set_location('P_DATE_TO='||P_DATE_TO,450);

656: else
657: P_DATE_TO := org_structure_version_rec.date_to;
658: end if;
659:
660: hr_utility.set_location('P_DATE_TO='||P_DATE_TO,450);
661:
662: for org_structure_element_rec in get_org_structure_element
663: (org_structure_version_rec.org_structure_version_id
664: ,P_TOP_ORGANIZATION_ID)

Line 668: hr_utility.set_location('org_structure_version_rec.org_structure_version_id='||org_structure_version_rec.org_structure_version_id,460);

664: ,P_TOP_ORGANIZATION_ID)
665: loop
666:
667:
668: hr_utility.set_location('org_structure_version_rec.org_structure_version_id='||org_structure_version_rec.org_structure_version_id,460);
669: hr_utility.set_location('org_structure_element_rec.organization_id1='||org_structure_element_rec.organization_id1,470);
670:
671:
672: for org_rec in get_organizations

Line 669: hr_utility.set_location('org_structure_element_rec.organization_id1='||org_structure_element_rec.organization_id1,470);

665: loop
666:
667:
668: hr_utility.set_location('org_structure_version_rec.org_structure_version_id='||org_structure_version_rec.org_structure_version_id,460);
669: hr_utility.set_location('org_structure_element_rec.organization_id1='||org_structure_element_rec.organization_id1,470);
670:
671:
672: for org_rec in get_organizations
673: ( org_structure_version_rec.org_structure_version_id

Line 682: hr_utility.set_location('org_rec.organization_id2='||org_rec.organization_id2,480);

678: loop
679:
680: -- Start of New Hires Story
681:
682: hr_utility.set_location('org_rec.organization_id2='||org_rec.organization_id2,480);
683:
684: for asg_rec in get_assignment_start_end
685: ( P_DATE_TO
686: , org_rec.organization_id2

Line 694: hr_utility.set_location('asg_rec.assignment_id='||asg_rec.assignment_id,490);

690:
691: l_jobcatg := NULL;
692: l_abv := NULL;
693:
694: hr_utility.set_location('asg_rec.assignment_id='||asg_rec.assignment_id,490);
695: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
696: ( p_ABV_formula_id => l_ABV_formula_id
697: , p_ABV => p_budget
698: , p_assignment_id => asg_rec.assignment_id

Line 717: hr_utility.set_location('Movement Category 2 = '||l_movement_category,500);

713: ,p_assignment_type => asg_rec.assignment_type
714: ,p_movement_category => l_movement_category
715: );
716:
717: hr_utility.set_location('Movement Category 2 = '||l_movement_category,500);
718:
719: if l_movement_category = 'NEW_HIRE'
720: then
721: if l_jobcatg = 'Y'

Line 731: hr_utility.set_location('organization_id1 = '||org_structure_element_rec.organization_id1,510);

727: end if;
728:
729: end loop; -- get_assignment_start_end
730:
731: hr_utility.set_location('organization_id1 = '||org_structure_element_rec.organization_id1,510);
732:
733: HQOrgData(org_structure_element_rec.organization_id1).rev_nh :=
734: HQOrgData(org_structure_element_rec.organization_id1).rev_nh + nvl(l_rev_nh,0);
735: HQOrgData(org_structure_element_rec.organization_id1).nonrev_nh :=

Line 748: hr_utility.set_location('org_rec.organization_id2='||org_rec.organization_id2,520);

744: l_rev_term :=0;
745: l_nonrev_term :=0;
746:
747:
748: hr_utility.set_location('org_rec.organization_id2='||org_rec.organization_id2,520);
749:
750: for term_rec in get_terminations
751: ( P_DATE_FROM
752: , P_DATE_TO

Line 758: hr_utility.set_location('Organization ID2 = '||org_rec.organization_id2,530);

754: , P_BUSINESS_GROUP_ID)
755:
756: loop -- get_terminations
757:
758: hr_utility.set_location('Organization ID2 = '||org_rec.organization_id2,530);
759:
760: l_jobcatg := NULL;
761: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
762: (term_rec.job_id

Line 765: hr_utility.set_location('Job Categ = '||l_jobcatg,540);

761: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
762: (term_rec.job_id
763: ,p_job_category);
764:
765: hr_utility.set_location('Job Categ = '||l_jobcatg,540);
766:
767: if l_jobcatg = 'Y'
768: then
769: l_rev_term := l_rev_term + 1;

Line 771: hr_utility.set_location('Rev Terms = '||l_rev_term,550);

767: if l_jobcatg = 'Y'
768: then
769: l_rev_term := l_rev_term + 1;
770:
771: hr_utility.set_location('Rev Terms = '||l_rev_term,550);
772:
773: else
774: l_nonrev_term := l_nonrev_term + 1;
775: hr_utility.set_location('NONRev Terms = '||l_nonrev_term,560);

Line 775: hr_utility.set_location('NONRev Terms = '||l_nonrev_term,560);

771: hr_utility.set_location('Rev Terms = '||l_rev_term,550);
772:
773: else
774: l_nonrev_term := l_nonrev_term + 1;
775: hr_utility.set_location('NONRev Terms = '||l_nonrev_term,560);
776: end if;
777:
778: end loop; -- get_terminations
779:

Line 780: hr_utility.set_location('Rev Terms1 = '||l_rev_term,570);

776: end if;
777:
778: end loop; -- get_terminations
779:
780: hr_utility.set_location('Rev Terms1 = '||l_rev_term,570);
781: hr_utility.set_location('NONRev Terms1 = '||l_nonrev_term,580);
782:
783: HQOrgData(org_structure_element_rec.organization_id1).rev_term :=
784: HQOrgData(org_structure_element_rec.organization_id1).rev_term + nvl(l_rev_term,0);

Line 781: hr_utility.set_location('NONRev Terms1 = '||l_nonrev_term,580);

777:
778: end loop; -- get_terminations
779:
780: hr_utility.set_location('Rev Terms1 = '||l_rev_term,570);
781: hr_utility.set_location('NONRev Terms1 = '||l_nonrev_term,580);
782:
783: HQOrgData(org_structure_element_rec.organization_id1).rev_term :=
784: HQOrgData(org_structure_element_rec.organization_id1).rev_term + nvl(l_rev_term,0);
785: HQOrgData(org_structure_element_rec.organization_id1).nonrev_term :=

Line 810: hr_utility.set_location('asg_start_rec.assignment_id='||asg_start_rec.assignment_id,590);

806: ,P_BUSINESS_GROUP_ID
807: )
808: loop -- get_assignment_start_end
809:
810: hr_utility.set_location('asg_start_rec.assignment_id='||asg_start_rec.assignment_id,590);
811:
812: l_jobcatg := NULL;
813: l_abv := NULL;
814:

Line 822: hr_utility.set_location('l_abv='||l_abv,600);

818: , p_assignment_id => asg_start_rec.assignment_id
819: , p_effective_date => asg_start_rec.effective_start_date
820: , p_session_date => trunc(sysdate) );
821:
822: hr_utility.set_location('l_abv='||l_abv,600);
823:
824:
825: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
826: (asg_start_rec.job_id

Line 856: hr_utility.set_location('asg_end_rec.assignment_id='||asg_end_rec.assignment_id,610);

852: ,P_BUSINESS_GROUP_ID
853: )
854: loop -- get_assignment_start_end
855:
856: hr_utility.set_location('asg_end_rec.assignment_id='||asg_end_rec.assignment_id,610);
857:
858: l_jobcatg := NULL;
859: l_abv := NULL;
860:

Line 868: hr_utility.set_location('l_abv='||l_abv,620);

864: , p_assignment_id => asg_end_rec.assignment_id
865: , p_effective_date => asg_end_rec.effective_start_date
866: , p_session_date => trunc(sysdate) );
867:
868: hr_utility.set_location('l_abv='||l_abv,620);
869:
870:
871: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
872: (asg_end_rec.job_id

Line 903: hr_utility.set_location('asg_rec.assignment_id='||asg_rec.assignment_id,630);

899:
900: l_jobcatg := NULL;
901: l_abv := NULL;
902:
903: hr_utility.set_location('asg_rec.assignment_id='||asg_rec.assignment_id,630);
904:
905: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
906: ( p_ABV_formula_id => l_ABV_formula_id
907: , p_ABV => p_budget

Line 927: hr_utility.set_location('Movement Category 2 = '||l_movement_category,640);

923: ,p_assignment_type => asg_rec.assignment_type
924: ,p_movement_category => l_movement_category
925: );
926:
927: hr_utility.set_location('Movement Category 2 = '||l_movement_category,640);
928:
929: if l_movement_category = 'NEW_HIRE'
930: then
931: if l_jobcatg = 'Y'

Line 965: hr_utility.set_location('Job Categ = '||l_jobcatg,650);

961: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
962: (term_rec.job_id
963: ,p_job_category);
964:
965: hr_utility.set_location('Job Categ = '||l_jobcatg,650);
966:
967: if l_jobcatg = 'Y'
968: then
969: l_rev_term := l_rev_term + 1;

Line 971: hr_utility.set_location('Rev Terms = '||l_rev_term,660);

967: if l_jobcatg = 'Y'
968: then
969: l_rev_term := l_rev_term + 1;
970:
971: hr_utility.set_location('Rev Terms = '||l_rev_term,660);
972:
973: else
974: l_nonrev_term := l_nonrev_term + 1;
975: hr_utility.set_location('NONRev Terms = '||l_nonrev_term,670);

Line 975: hr_utility.set_location('NONRev Terms = '||l_nonrev_term,670);

971: hr_utility.set_location('Rev Terms = '||l_rev_term,660);
972:
973: else
974: l_nonrev_term := l_nonrev_term + 1;
975: hr_utility.set_location('NONRev Terms = '||l_nonrev_term,670);
976: end if;
977:
978: end loop; -- get_terminations
979:

Line 980: hr_utility.set_location('Rev Terms1 = '||l_rev_term,680);

976: end if;
977:
978: end loop; -- get_terminations
979:
980: hr_utility.set_location('Rev Terms1 = '||l_rev_term,680);
981: hr_utility.set_location('NONRev Terms1 = '||l_nonrev_term,690);
982:
983: HQOrgData(P_TOP_ORGANIZATION_ID).rev_term :=
984: HQOrgData(P_TOP_ORGANIZATION_ID).rev_term + nvl(l_rev_term,0);

Line 981: hr_utility.set_location('NONRev Terms1 = '||l_nonrev_term,690);

977:
978: end loop; -- get_terminations
979:
980: hr_utility.set_location('Rev Terms1 = '||l_rev_term,680);
981: hr_utility.set_location('NONRev Terms1 = '||l_nonrev_term,690);
982:
983: HQOrgData(P_TOP_ORGANIZATION_ID).rev_term :=
984: HQOrgData(P_TOP_ORGANIZATION_ID).rev_term + nvl(l_rev_term,0);
985: HQOrgData(P_TOP_ORGANIZATION_ID).nonrev_term :=

Line 1026: hr_utility.set_location('Org='||all_organizations_rec.organization_id||

1022: + HQOrgData(all_organizations_rec.organization_id).nonrev_nh;
1023: l_nonrev_term := l_nonrev_term
1024: + HQOrgData(all_organizations_rec.organization_id).nonrev_term;
1025:
1026: hr_utility.set_location('Org='||all_organizations_rec.organization_id||
1027: '*RS='||HQOrgData(all_organizations_rec.organization_id).rev_start_val||
1028: '*RE='||HQOrgData(all_organizations_rec.organization_id).rev_end_val||
1029: '*RNC='||to_char(HQOrgData(all_organizations_rec.organization_id).rev_end_val
1030: -HQOrgData(all_organizations_rec.organization_id).rev_start_val)||

Line 1038: hr_utility.set_location('--------'||

1034: -HQOrgData(all_organizations_rec.organization_id).rev_start_val
1035: -HQOrgData(all_organizations_rec.organization_id).rev_nh
1036: +HQOrgData(all_organizations_rec.organization_id).rev_term),700);
1037:
1038: hr_utility.set_location('--------'||
1039: '*NS='||HQOrgData(all_organizations_rec.organization_id).nonrev_start_val||
1040: '*NE='||HQOrgData(all_organizations_rec.organization_id).nonrev_end_val||
1041: '*NNC='||(HQOrgData(all_organizations_rec.organization_id).nonrev_end_val
1042: -HQOrgData(all_organizations_rec.organization_id).nonrev_start_val)||