APPS.HR_TRANS_HISTORY_API dependencies on HR_API_TRANSACTION_STEPS

Line 588: INSERT INTO HR_API_TRANSACTION_STEPS

584:
585: l_cnt := TxStepTbl.STEP_HISTORY_ID.count;
586:
587: FOR i in 1.. l_cnt LOOP
588: INSERT INTO HR_API_TRANSACTION_STEPS
589: (
590: TRANSACTION_STEP_ID
591: ,TRANSACTION_ID
592: ,API_NAME

Line 977: FROM HR_API_TRANSACTION_STEPS

973: -- DELETE Steps and Values First.
974: DELETE HR_API_TRANSACTION_VALUES
975: WHERE TRANSACTION_STEP_ID in
976: ( SELECT TRANSACTION_STEP_ID
977: FROM HR_API_TRANSACTION_STEPS
978: WHERE TRANSACTION_ID = P_TRANSACTION_ID);
979:
980: DELETE HR_API_TRANSACTION_STEPS
981: WHERE TRANSACTION_ID = P_TRANSACTION_ID;

Line 980: DELETE HR_API_TRANSACTION_STEPS

976: ( SELECT TRANSACTION_STEP_ID
977: FROM HR_API_TRANSACTION_STEPS
978: WHERE TRANSACTION_ID = P_TRANSACTION_ID);
979:
980: DELETE HR_API_TRANSACTION_STEPS
981: WHERE TRANSACTION_ID = P_TRANSACTION_ID;
982:
983: -- Copy Steps from history to transaction tables.
984: RevertTransSteps

Line 1495: FROM hr_api_transaction_steps

1491: ,INFORMATION27
1492: ,INFORMATION28
1493: ,INFORMATION29
1494: ,INFORMATION30
1495: FROM hr_api_transaction_steps
1496: WHERE TRANSACTION_ID = P_TRANSACTION_ID;
1497:
1498: l_cnt integer;
1499: l_proc constant varchar2(100) := g_package || 'SaveTransStepHisroty';