APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on HR_API_TRANSACTIONS

Line 6931: --Delete any transactions from HR_API_Transactions and transaction steps

6927: LOOP
6928: FETCH csr_sc_ids
6929: BULK COLLECT INTO l_sc_ids LIMIT 1000;
6930:
6931: --Delete any transactions from HR_API_Transactions and transaction steps
6932: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
6933: DELETE FROM hr_api_transaction_steps step
6934: WHERE step.transaction_id IN (
6935: SELECT trn.transaction_id

Line 6936: FROM hr_api_transactions trn

6932: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
6933: DELETE FROM hr_api_transaction_steps step
6934: WHERE step.transaction_id IN (
6935: SELECT trn.transaction_id
6936: FROM hr_api_transactions trn
6937: WHERE trn.transaction_ref_id = l_sc_ids (i)
6938: AND trn.transaction_ref_table = 'PER_PERSONAL_SCORECARDS');
6939: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
6940: DELETE FROM hr_api_transactions

Line 6940: DELETE FROM hr_api_transactions

6936: FROM hr_api_transactions trn
6937: WHERE trn.transaction_ref_id = l_sc_ids (i)
6938: AND trn.transaction_ref_table = 'PER_PERSONAL_SCORECARDS');
6939: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
6940: DELETE FROM hr_api_transactions
6941: WHERE transaction_ref_id = l_sc_ids (i) AND transaction_ref_table = 'PER_PERSONAL_SCORECARDS';
6942: -- Delete all score card objectives
6943: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
6944: DELETE FROM per_objectives

Line 8030: FROM hr_api_transactions trn

8026: BEGIN
8027: DELETE FROM hr_api_transaction_steps step
8028: WHERE step.transaction_id IN (
8029: SELECT trn.transaction_id
8030: FROM hr_api_transactions trn
8031: WHERE trn.transaction_ref_id = p_scorecard_id
8032: AND trn.transaction_ref_table = 'PER_PERSONAL_SCORECARDS');
8033:
8034: DELETE FROM hr_api_transactions

Line 8034: DELETE FROM hr_api_transactions

8030: FROM hr_api_transactions trn
8031: WHERE trn.transaction_ref_id = p_scorecard_id
8032: AND trn.transaction_ref_table = 'PER_PERSONAL_SCORECARDS');
8033:
8034: DELETE FROM hr_api_transactions
8035: WHERE transaction_ref_id = p_scorecard_id AND transaction_ref_table = 'PER_PERSONAL_SCORECARDS';
8036:
8037: --
8038: DELETE FROM per_objectives