5207: log_message('Deleting Score cards for the plan');
5208: OPEN csr_sc_ids(p_plan_id);
5209: LOOP
5210: FETCH csr_sc_ids BULK COLLECT INTO l_sc_ids LIMIT 1000;
5211: --Delete any transactions from HR_API_Transactions and transaction steps
5212: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
5213: DELETE
5214: FROM hr_api_transaction_steps step
5215: WHERE step.transaction_id IN (SELECT trn.transaction_id
5212: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
5213: DELETE
5214: FROM hr_api_transaction_steps step
5215: WHERE step.transaction_id IN (SELECT trn.transaction_id
5216: FROM hr_api_transactions trn
5217: WHERE trn.transaction_ref_id =
5218: l_sc_ids(i)
5219: AND trn.transaction_ref_table =
5220: 'PER_PERSONAL_SCORECARDS');
5219: AND trn.transaction_ref_table =
5220: 'PER_PERSONAL_SCORECARDS');
5221: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
5222: DELETE
5223: FROM hr_api_transactions
5224: WHERE transaction_ref_id = l_sc_ids(i)
5225: AND transaction_ref_table = 'PER_PERSONAL_SCORECARDS';
5226: -- Delete all score card objectives
5227: FORALL i in l_sc_ids.FIRST .. l_sc_ids.LAST
6065: BEGIN
6066: DELETE
6067: FROM hr_api_transaction_steps step
6068: WHERE step.transaction_id IN (SELECT trn.transaction_id
6069: FROM hr_api_transactions trn
6070: WHERE trn.transaction_ref_id =
6071: p_scorecard_id
6072: AND trn.transaction_ref_table =
6073: 'PER_PERSONAL_SCORECARDS');
6071: p_scorecard_id
6072: AND trn.transaction_ref_table =
6073: 'PER_PERSONAL_SCORECARDS');
6074: DELETE
6075: FROM hr_api_transactions
6076: WHERE transaction_ref_id = p_scorecard_id
6077: AND transaction_ref_table = 'PER_PERSONAL_SCORECARDS';
6078: --
6079: DELETE