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 534: g_wsp_priority_tab(g_wsp_index).legal_entity_id := fnd_number.canonical_to_number(rec_legal_entity.organization_id);

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

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

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

Line 555: 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;

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

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

553: --g_wsp_skills_pri_num := g_wsp_skills_pri_num + 1;
554: if g_wsp_skills_priority_num.exists(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)) then
555: 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;
556: else
557: g_wsp_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)).skills_priority_num := 1;
558: end if;
559:
560: g_wsp_pri_final_tab(l_index).legal_entity_id := fnd_number.canonical_to_number(rec_legal_entity2.organization_id);
561: g_wsp_pri_final_tab(l_index).skills_priority_id := p_user_row_id;

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

556: else
557: g_wsp_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity2.organization_id)).skills_priority_num := 1;
558: end if;
559:
560: g_wsp_pri_final_tab(l_index).legal_entity_id := fnd_number.canonical_to_number(rec_legal_entity2.organization_id);
561: g_wsp_pri_final_tab(l_index).skills_priority_id := p_user_row_id;
562: 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;
563: g_wsp_pri_final_tab(l_index).skills_priority_name := l_skills_priority_name;
564: g_wsp_pri_final_tab(l_index).year := to_char(p_effective_date,'YYYY');

Line 562: 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;

558: end if;
559:
560: g_wsp_pri_final_tab(l_index).legal_entity_id := fnd_number.canonical_to_number(rec_legal_entity2.organization_id);
561: g_wsp_pri_final_tab(l_index).skills_priority_id := p_user_row_id;
562: 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;
563: g_wsp_pri_final_tab(l_index).skills_priority_name := l_skills_priority_name;
564: g_wsp_pri_final_tab(l_index).year := to_char(p_effective_date,'YYYY');
565: g_wsp_pri_final_tab(l_index).Level_1 := 0;
566: g_wsp_pri_final_tab(l_index).Level_2 := 0;

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

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

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

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

Line 630: 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;

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

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

628: --g_atr_skills_pri_num := g_atr_skills_pri_num + 1;
629: if g_atr_skills_priority_num.exists(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)) then
630: 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;
631: else
632: g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num := 1;
633: end if;
634: g_atr_pri_final_tab(l_index).legal_entity_id := fnd_number.canonical_to_number(rec_legal_entity3.organization_id);
635: g_atr_pri_final_tab(l_index).skills_priority_id := p_user_row_id;
636: 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 634: g_atr_pri_final_tab(l_index).legal_entity_id := fnd_number.canonical_to_number(rec_legal_entity3.organization_id);

630: 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;
631: else
632: g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num := 1;
633: end if;
634: g_atr_pri_final_tab(l_index).legal_entity_id := fnd_number.canonical_to_number(rec_legal_entity3.organization_id);
635: g_atr_pri_final_tab(l_index).skills_priority_id := p_user_row_id;
636: 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;
637: g_atr_pri_final_tab(l_index).skills_priority_name := l_skills_priority_name;
638: g_atr_pri_final_tab(l_index).year := to_char(p_effective_date,'YYYY');

Line 636: 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;

632: g_atr_skills_priority_num(fnd_number.canonical_to_number(rec_legal_entity3.organization_id)).skills_priority_num := 1;
633: end if;
634: g_atr_pri_final_tab(l_index).legal_entity_id := fnd_number.canonical_to_number(rec_legal_entity3.organization_id);
635: g_atr_pri_final_tab(l_index).skills_priority_id := p_user_row_id;
636: 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;
637: g_atr_pri_final_tab(l_index).skills_priority_name := l_skills_priority_name;
638: g_atr_pri_final_tab(l_index).year := to_char(p_effective_date,'YYYY');
639: g_atr_pri_final_tab(l_index).Level_1 := 0;
640: g_atr_pri_final_tab(l_index).Level_2 := 0;

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

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

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

2669: end if;
2670:
2671:
2672: -- set the plan and training year start and end dates
2673: g_plan_year := fnd_number.canonical_to_number(l_tmp_char);
2674:
2675: g_wsp_start_date := to_date('01-04-'||(g_plan_year-1) , 'DD-MM-YYYY');
2676: g_wsp_end_date := to_date('31-03-'||g_plan_year , 'DD-MM-YYYY');
2677:

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

2809: g_legal_entity_id := to_number(l_legal_entity_id); -- Type cast to number
2810: end if;
2811:
2812: -- set the plan and training year start and end dates
2813: g_plan_year := fnd_number.canonical_to_number(l_tmp_char);
2814:
2815: g_wsp_start_date := to_date('01-04-'||(g_plan_year-1) , 'DD-MM-YYYY');
2816: g_wsp_end_date := to_date('31-03-'||g_plan_year , 'DD-MM-YYYY');
2817: