229: end if;
230: CLOSE csr_prev_prop_details;
231: -- This condition is added to delete the proposed proposals in case it is not yet done from
232: -- the OA layer. schowdhu - 01-Dec-2008
233: if( HR_MAINTAIN_PROPOSAL_API.g_deleted_from_oa = 'N')
234: then
235: hr_utility.set_location('Within delete from OA',90);
236: -- now delete all the inactivated proposed proposals. Bug#7386307 by schowdhu
237: for a in get_all_proposed_proposals loop
234: then
235: hr_utility.set_location('Within delete from OA',90);
236: -- now delete all the inactivated proposed proposals. Bug#7386307 by schowdhu
237: for a in get_all_proposed_proposals loop
238: hr_maintain_proposal_api.delete_salary_proposal
239: (p_pay_proposal_id => a.pay_proposal_id
240: ,p_business_group_id => a.business_group_id
241: ,p_object_version_number => a.object_version_number
242: ,p_salary_warning => l_del_warn);