APPS.HR_SUIT_MATCH_UTIL_SS dependencies on PER_SUITMATCH_WORKOPPS

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

664: FETCH csr_suit_workopps into l_csr_workopp_tab(J);
665: END LOOP;
666: CLOSE csr_suit_workopps; -- close cursor variable
667:
668: --now populate the per_suitmatch_workopps with the suitable work opp, essential, desired match and meets
669: DELETE FROM per_suitmatch_workopps;
670: FOR I IN 1 ..l_csr_workopp_tab.count LOOP
671: BEGIN
672: -- get the essential and desired match

Line 669: DELETE FROM per_suitmatch_workopps;

665: END LOOP;
666: CLOSE csr_suit_workopps; -- close cursor variable
667:
668: --now populate the per_suitmatch_workopps with the suitable work opp, essential, desired match and meets
669: DELETE FROM per_suitmatch_workopps;
670: FOR I IN 1 ..l_csr_workopp_tab.count LOOP
671: BEGIN
672: -- get the essential and desired match
673: l_ess_match := null;

Line 713: insert into per_suitmatch_workopps (workopp_id,

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

Line 735: DELETE FROM per_suitmatch_workopps;

731: l_des_match_count integer;
732: l_total_des_count integer;
733:
734: BEGIN
735: DELETE FROM per_suitmatch_workopps;
736: FOR I IN 1 ..p_temp_tab.count LOOP
737: -- get the essential and desired match
738: IF (p_temp_tab(I).mandatory = 'ORG') THEN
739: get_ess_desired_match(p_temp_tab(I).min_step_value, -1, p_temp_tab(I).competence_id, -1, -1, -1,

Line 775: insert into per_suitmatch_workopps (workopp_id,

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

Line 788: DELETE FROM per_suitmatch_workopps;

784: p_temp_tab IN SSHR_SM_COMP_DETAILS_TAB_TYP
785: )
786: IS
787: BEGIN
788: DELETE FROM per_suitmatch_workopps;
789: FOR I IN 1 ..p_temp_tab.count LOOP
790: insert into per_suitmatch_workopps (workopp_id,
791: type)
792: values (to_number(p_temp_tab(I).competence_id)

Line 790: insert into per_suitmatch_workopps (workopp_id,

786: IS
787: BEGIN
788: DELETE FROM per_suitmatch_workopps;
789: FOR I IN 1 ..p_temp_tab.count LOOP
790: insert into per_suitmatch_workopps (workopp_id,
791: type)
792: values (to_number(p_temp_tab(I).competence_id)
793: ,p_temp_tab(I).mandatory);
794: END LOOP;