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_SUIT_MATCH_UTIL_SS dependencies on PER_SUITMATCH_WORKOPPS

Line 663: --now populate the per_suitmatch_workopps with the suitable work opp, essential, desired match and meets

659: FETCH csr_suit_workopps into l_csr_workopp_tab(J);
660: END LOOP;
661: CLOSE csr_suit_workopps; -- close cursor variable
662:
663: --now populate the per_suitmatch_workopps with the suitable work opp, essential, desired match and meets
664: --truncate the table before inserting
665: execute immediate 'truncate table '||getTableSchema||'.per_suitmatch_workopps';
666: FOR I IN 1 ..l_csr_workopp_tab.count LOOP
667: BEGIN

Line 665: execute immediate 'truncate table '||getTableSchema||'.per_suitmatch_workopps';

661: CLOSE csr_suit_workopps; -- close cursor variable
662:
663: --now populate the per_suitmatch_workopps with the suitable work opp, essential, desired match and meets
664: --truncate the table before inserting
665: execute immediate 'truncate table '||getTableSchema||'.per_suitmatch_workopps';
666: FOR I IN 1 ..l_csr_workopp_tab.count LOOP
667: BEGIN
668: -- get the essential and desired match
669: l_ess_match := null;

Line 709: insert into per_suitmatch_workopps (workopp_id,

705: l_des_match := l_des_match_count || '/' || l_total_des_count;
706: l_meets := compare_counts(l_ess_match_count, l_total_ess_count,
707: l_des_match_count, l_total_des_count);
708: END IF;
709: insert into per_suitmatch_workopps (workopp_id,
710: type, ess_match, des_match, meets)
711: values (to_number(l_csr_workopp_tab(I).workopp_id)
712: ,l_csr_workopp_tab(I).type, l_ess_match, l_des_match, l_meets);
713: END;

Line 732: execute immediate 'truncate table '||getTableSchema||'.per_suitmatch_workopps';

728: l_total_des_count integer;
729:
730: BEGIN
731: --truncate the table before inserting
732: execute immediate 'truncate table '||getTableSchema||'.per_suitmatch_workopps';
733: FOR I IN 1 ..p_temp_tab.count LOOP
734: -- get the essential and desired match
735: IF (p_temp_tab(I).mandatory = 'ORG') THEN
736: get_ess_desired_match(p_temp_tab(I).min_step_value, -1, p_temp_tab(I).competence_id, -1, -1, -1,

Line 772: insert into per_suitmatch_workopps (workopp_id,

768: l_des_match := l_des_match_count || '/' || l_total_des_count;
769: l_meets := compare_counts(l_ess_match_count, l_total_ess_count,
770: l_des_match_count, l_total_des_count);
771: END IF;
772: insert into per_suitmatch_workopps (workopp_id,
773: type, ess_match, des_match, meets)
774: values (to_number(p_temp_tab(I).competence_id)
775: ,p_temp_tab(I).mandatory, l_ess_match, l_des_match, l_meets);
776: END LOOP;

Line 786: execute immediate 'truncate table '||getTableSchema||'.per_suitmatch_workopps';

782: )
783: IS
784: BEGIN
785: --truncate the table before inserting
786: execute immediate 'truncate table '||getTableSchema||'.per_suitmatch_workopps';
787: FOR I IN 1 ..p_temp_tab.count LOOP
788: insert into per_suitmatch_workopps (workopp_id,
789: type)
790: values (to_number(p_temp_tab(I).competence_id)

Line 788: insert into per_suitmatch_workopps (workopp_id,

784: BEGIN
785: --truncate the table before inserting
786: execute immediate 'truncate table '||getTableSchema||'.per_suitmatch_workopps';
787: FOR I IN 1 ..p_temp_tab.count LOOP
788: insert into per_suitmatch_workopps (workopp_id,
789: type)
790: values (to_number(p_temp_tab(I).competence_id)
791: ,p_temp_tab(I).mandatory);
792: END LOOP;