APPS.HR_SUIT_MATCH_UTIL_SS dependencies on SSHR_SM_COMP_DETAILS_TAB_TYP

Line 578: p_temp_tab IN SSHR_SM_COMP_DETAILS_TAB_TYP

574: END get_ess_desired_match;
575:
576:
577: PROCEDURE populate_comp_temp_table (
578: p_temp_tab IN SSHR_SM_COMP_DETAILS_TAB_TYP
579: )
580: IS
581: BEGIN
582: --truncate the table before inserting

Line 595: p_temp_tab IN SSHR_SM_COMP_DETAILS_TAB_TYP

591: commit;
592: END populate_comp_temp_table;
593:
594: PROCEDURE populate_per_temp_table (
595: p_temp_tab IN SSHR_SM_COMP_DETAILS_TAB_TYP
596: )
597: IS
598: --cursor to get the suitable work opp ids
599: CURSOR csr_suit_workopps(p_person_id in number) IS

Line 719: p_temp_tab IN SSHR_SM_COMP_DETAILS_TAB_TYP

715: commit;
716: END populate_per_temp_table;
717:
718: PROCEDURE populate_workopp_temp_table (
719: p_temp_tab IN SSHR_SM_COMP_DETAILS_TAB_TYP
720: )IS
721:
722: l_ess_match varchar2(30);
723: l_des_match varchar2(30);

Line 781: p_temp_tab IN SSHR_SM_COMP_DETAILS_TAB_TYP

777: commit;
778: END populate_workopp_temp_table;
779:
780: PROCEDURE insert_workopp_temp_table (
781: p_temp_tab IN SSHR_SM_COMP_DETAILS_TAB_TYP
782: )
783: IS
784: BEGIN
785: --truncate the table before inserting