APPS.HR_WPM_MASS_APR_PUSH dependencies on HR_API

Line 1446: FROM hr_api_transactions t

1442: CURSOR csr_pend_trans(p_plan_id IN NUMBER) IS
1443: SELECT 'x'
1444: FROM DUAL
1445: WHERE EXISTS (SELECT 'x'
1446: FROM hr_api_transactions t
1447: ,per_personal_scorecards sc
1448: WHERE t.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
1449: AND t.transaction_ref_id = sc.scorecard_id
1450: AND sc.plan_id = p_plan_id);

Line 1577: FROM hr_api_transactions

1573: --
1574: CURSOR c_trx (p_sc_card_id number)
1575: is
1576: SELECT transaction_id
1577: FROM hr_api_transactions
1578: WHERE transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
1579: AND transaction_ref_id = p_sc_card_id;
1580: l_sc_ovn number;
1581: l_trx_id number;

Line 1672: delete from hr_api_transaction_steps

1668: fetch c_trx into l_trx_id;
1669: close c_trx;
1670: if l_trx_id is not null then
1671: begin
1672: delete from hr_api_transaction_steps
1673: where transaction_id = l_trx_id;
1674: exception
1675: when others then
1676: null;

Line 1680: delete from hr_api_transactions

1676: null;
1677: end;
1678: --
1679: begin
1680: delete from hr_api_transactions
1681: where transaction_id = l_trx_id;
1682: exception
1683: when others then
1684: null;