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_ZA_WSP_ARCHIVE_PKG dependencies on FND_NUMBER

Line 535: g_wsp_priority_tab(g_wsp_index).legal_entity_id := fnd_number.canonical_to_number(rec_legal_entity.organization_id);

531: g_wsp_index := g_wsp_index + 1;
532: g_wsp_priority_tab(g_wsp_index).skills_priority_id := p_user_row_id;
533: g_wsp_priority_tab(g_wsp_index).skills_priority_name := l_skills_priority_name;
534: g_wsp_priority_tab(g_wsp_index).trng_event_id := p_trng_event_id;
535: g_wsp_priority_tab(g_wsp_index).legal_entity_id := fnd_number.canonical_to_number(rec_legal_entity.organization_id);
536: g_wsp_priority_tab(g_wsp_index).level_number := l_level_num;
537: g_wsp_priority_tab(g_wsp_index).saqa_id := l_saqa_id;
538: g_wsp_priority_tab(g_wsp_index).year := to_char(p_effective_date,'YYYY');
539:

Line 555: if g_wsp_skills_priority_num.exists(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)) then

551: hr_utility.set_location('Record exists',20);
552: else
553: hr_utility.set_location('New Record in g_wsp_pri_final_tab',20);
554: --g_wsp_skills_pri_num := g_wsp_skills_pri_num + 1;
555: if g_wsp_skills_priority_num.exists(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)) then
556: g_wsp_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)).skills_priority_num := g_wsp_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)).skills_priority_num + 1;
557: else
558: g_wsp_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)).skills_priority_num := 1;
559: end if;

Line 556: g_wsp_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)).skills_priority_num := g_wsp_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)).skills_priority_num + 1;

552: else
553: hr_utility.set_location('New Record in g_wsp_pri_final_tab',20);
554: --g_wsp_skills_pri_num := g_wsp_skills_pri_num + 1;
555: if g_wsp_skills_priority_num.exists(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)) then
556: g_wsp_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)).skills_priority_num := g_wsp_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)).skills_priority_num + 1;
557: else
558: g_wsp_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)).skills_priority_num := 1;
559: end if;
560:

Line 558: g_wsp_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)).skills_priority_num := 1;

554: --g_wsp_skills_pri_num := g_wsp_skills_pri_num + 1;
555: if g_wsp_skills_priority_num.exists(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)) then
556: g_wsp_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)).skills_priority_num := g_wsp_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)).skills_priority_num + 1;
557: else
558: g_wsp_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)).skills_priority_num := 1;
559: end if;
560:
561: g_wsp_pri_final_tab(l_index).legal_entity_id := fnd_number.canonical_to_number(rec_legal_entity2.organization_id);
562: g_wsp_pri_final_tab(l_index).skills_priority_id := p_user_row_id;

Line 561: g_wsp_pri_final_tab(l_index).legal_entity_id := fnd_number.canonical_to_number(rec_legal_entity2.organization_id);

557: else
558: g_wsp_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)).skills_priority_num := 1;
559: end if;
560:
561: g_wsp_pri_final_tab(l_index).legal_entity_id := fnd_number.canonical_to_number(rec_legal_entity2.organization_id);
562: g_wsp_pri_final_tab(l_index).skills_priority_id := p_user_row_id;
563: g_wsp_pri_final_tab(l_index).skills_priority_num := g_wsp_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)).skills_priority_num;
564: g_wsp_pri_final_tab(l_index).skills_priority_name := l_skills_priority_name;
565: g_wsp_pri_final_tab(l_index).year := to_char(p_effective_date,'YYYY');

Line 563: g_wsp_pri_final_tab(l_index).skills_priority_num := g_wsp_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)).skills_priority_num;

559: end if;
560:
561: g_wsp_pri_final_tab(l_index).legal_entity_id := fnd_number.canonical_to_number(rec_legal_entity2.organization_id);
562: g_wsp_pri_final_tab(l_index).skills_priority_id := p_user_row_id;
563: g_wsp_pri_final_tab(l_index).skills_priority_num := g_wsp_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)).skills_priority_num;
564: g_wsp_pri_final_tab(l_index).skills_priority_name := l_skills_priority_name;
565: g_wsp_pri_final_tab(l_index).year := to_char(p_effective_date,'YYYY');
566: g_wsp_pri_final_tab(l_index).Level_1 := 0;
567: g_wsp_pri_final_tab(l_index).Level_2 := 0;

Line 582: hr_utility.set_location('rec_legal_entity2.organization_id: '||fnd_number.canonical_to_number(rec_legal_entity2.organization_id),20);

578: hr_utility.set_location(' skills_priority_num : '||g_wsp_skills_pri_num,20) ;
579: hr_utility.set_location(' skills_priority_name: '||l_skills_priority_name,20);
580: hr_utility.set_location(' l_index : '||l_index,20);
581: hr_utility.set_location('g_wsp_pri_final_tab(l_index).legal_entity_id : '||g_wsp_pri_final_tab(l_index).legal_entity_id,20);
582: hr_utility.set_location('rec_legal_entity2.organization_id: '||fnd_number.canonical_to_number(rec_legal_entity2.organization_id),20);
583: --
584: end if;
585: end loop;
586: elsif (p_user_row_id is not null AND instr(p_lookup_type,'ATR') > 0) then

Line 630: if g_atr_skills_priority_num.exists(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)) then

626: hr_utility.set_location('record exists',30);
627: else
628: hr_utility.set_location('New Record in g_atr_pri_final_tab',30);
629: --g_atr_skills_pri_num := g_atr_skills_pri_num + 1;
630: if g_atr_skills_priority_num.exists(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)) then
631: g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num := g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num + 1;
632: else
633: g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num := 1;
634: end if;

Line 631: g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num := g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num + 1;

627: else
628: hr_utility.set_location('New Record in g_atr_pri_final_tab',30);
629: --g_atr_skills_pri_num := g_atr_skills_pri_num + 1;
630: if g_atr_skills_priority_num.exists(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)) then
631: g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num := g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num + 1;
632: else
633: g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num := 1;
634: end if;
635: g_atr_pri_final_tab(l_index).legal_entity_id := fnd_number.canonical_to_number(rec_legal_entity3.organization_id);

Line 633: g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num := 1;

629: --g_atr_skills_pri_num := g_atr_skills_pri_num + 1;
630: if g_atr_skills_priority_num.exists(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)) then
631: g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num := g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num + 1;
632: else
633: g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num := 1;
634: end if;
635: g_atr_pri_final_tab(l_index).legal_entity_id := fnd_number.canonical_to_number(rec_legal_entity3.organization_id);
636: g_atr_pri_final_tab(l_index).skills_priority_id := p_user_row_id;
637: g_atr_pri_final_tab(l_index).skills_priority_num := g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num;

Line 635: g_atr_pri_final_tab(l_index).legal_entity_id := fnd_number.canonical_to_number(rec_legal_entity3.organization_id);

631: g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num := g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num + 1;
632: else
633: g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num := 1;
634: end if;
635: g_atr_pri_final_tab(l_index).legal_entity_id := fnd_number.canonical_to_number(rec_legal_entity3.organization_id);
636: g_atr_pri_final_tab(l_index).skills_priority_id := p_user_row_id;
637: g_atr_pri_final_tab(l_index).skills_priority_num := g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num;
638: g_atr_pri_final_tab(l_index).skills_priority_name := l_skills_priority_name;
639: g_atr_pri_final_tab(l_index).year := to_char(p_effective_date,'YYYY');

Line 637: g_atr_pri_final_tab(l_index).skills_priority_num := g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num;

633: g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num := 1;
634: end if;
635: g_atr_pri_final_tab(l_index).legal_entity_id := fnd_number.canonical_to_number(rec_legal_entity3.organization_id);
636: g_atr_pri_final_tab(l_index).skills_priority_id := p_user_row_id;
637: g_atr_pri_final_tab(l_index).skills_priority_num := g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num;
638: g_atr_pri_final_tab(l_index).skills_priority_name := l_skills_priority_name;
639: g_atr_pri_final_tab(l_index).year := to_char(p_effective_date,'YYYY');
640: g_atr_pri_final_tab(l_index).Level_1 := 0;
641: g_atr_pri_final_tab(l_index).Level_2 := 0;

Line 2088: g_plan_year := fnd_number.canonical_to_number(l_tmp_char);

2084: end if;
2085:
2086:
2087: -- set the plan and training year start and end dates
2088: g_plan_year := fnd_number.canonical_to_number(l_tmp_char);
2089:
2090: g_wsp_start_date := to_date('01-04-'||(g_plan_year-1) , 'DD-MM-YYYY');
2091: g_wsp_end_date := to_date('31-03-'||g_plan_year , 'DD-MM-YYYY');
2092:

Line 2679: g_plan_year := fnd_number.canonical_to_number(l_tmp_char);

2675: end if;
2676:
2677:
2678: -- set the plan and training year start and end dates
2679: g_plan_year := fnd_number.canonical_to_number(l_tmp_char);
2680:
2681: g_wsp_start_date := to_date('01-04-'||(g_plan_year-1) , 'DD-MM-YYYY');
2682: g_wsp_end_date := to_date('31-03-'||g_plan_year , 'DD-MM-YYYY');
2683:

Line 2819: g_plan_year := fnd_number.canonical_to_number(l_tmp_char);

2815: g_legal_entity_id := to_number(l_legal_entity_id); -- Type cast to number
2816: end if;
2817:
2818: -- set the plan and training year start and end dates
2819: g_plan_year := fnd_number.canonical_to_number(l_tmp_char);
2820:
2821: g_wsp_start_date := to_date('01-04-'||(g_plan_year-1) , 'DD-MM-YYYY');
2822: g_wsp_end_date := to_date('31-03-'||g_plan_year , 'DD-MM-YYYY');
2823: