845: l_old_mainap_id := Get_Old_Main_Appraiser_Id(p_appraisal_id);
846:
847: -- in case of appraisal delete or reject we are going to change the
848: -- Learning Path Status to Cancelled.
849: hr_util_misc_ss.check_ota_installed(810, l_ota_installed);
850: if(l_ota_installed = 'Y') then
851: update_learning_path(p_appraisal_id, p_appraisal_system_status);
852: end if;
853: --
1315:
1316: --
1317: -- in case of appraisal delete or reject we are going to change the
1318: -- Learning Path Status to Cancelled.
1319: hr_util_misc_ss.check_ota_installed(810, l_ota_installed);
1320: if(l_ota_installed = 'Y') then
1321: update_learning_path(p_appraisal_id, 'DELETED');
1322: end if;
1323: