DBA Data[Home] [Help]

APPS.HR_TRANS_HISTORY_API dependencies on HR_API_TRANSACTION_VALUES

Line 771: INSERT INTO hr_api_transaction_values

767: CLOSE cur_trans_value;
768:
769: l_cnt := TxValueTbl.transaction_value_id.count;
770: For i in 1.. l_cnt Loop
771: INSERT INTO hr_api_transaction_values
772: (
773: TRANSACTION_VALUE_ID
774: ,TRANSACTION_STEP_ID
775: ,DATATYPE

Line 974: DELETE HR_API_TRANSACTION_VALUES

970: -- end special handling
971:
972:
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);

Line 1364: from hr_api_transaction_values

1360: creation_date ,
1361: last_update_date ,
1362: last_updated_by ,
1363: last_update_login
1364: from hr_api_transaction_values
1365: where transaction_step_id = P_TRANSACTION_STEP_ID;
1366:
1367: l_cnt integer;
1368: l_proc constant varchar2(100) := g_package || ' SaveTransValueHisroty';