APPS.HR_TRANS_HISTORY_API dependencies on PQH_SS_VALUE_HISTORY

Line 740: FROM PQH_SS_VALUE_HISTORY

736: ,creation_date
737: ,last_update_date
738: ,last_updated_by
739: ,last_update_login
740: FROM PQH_SS_VALUE_HISTORY
741: Where step_history_id in
742: ( SELECT STEP_HISTORY_ID
743: FROM PQH_SS_STEP_HISTORY
744: WHERE TRANSACTION_HISTORY_ID = P_TRANSACTION_ID

Line 838: FROM PQH_SS_STEP_HISTORY step, PQH_SS_VALUE_HISTORY val

834:
835:
836: CURSOR origValUpgTrans IS
837: SELECT TRANSACTION_VALUE_ID, VALUE, ORIGINAL_VALUE
838: FROM PQH_SS_STEP_HISTORY step, PQH_SS_VALUE_HISTORY val
839: WHERE step.TRANSACTION_HISTORY_ID = P_TRANSACTION_ID
840: and step.step_history_id = val.step_history_id
841: and step.approval_history_id = val.approval_history_id
842: and val.approval_history_id = -1;

Line 846: FROM PQH_SS_STEP_HISTORY step, PQH_SS_VALUE_HISTORY val

842: and val.approval_history_id = -1;
843:
844: CURSOR PsuedoValUpgTrans IS
845: SELECT 1
846: FROM PQH_SS_STEP_HISTORY step, PQH_SS_VALUE_HISTORY val
847: WHERE step.TRANSACTION_HISTORY_ID = P_TRANSACTION_ID
848: and step.step_history_id = val.step_history_id
849: and step.approval_history_id = val.approval_history_id
850: and val.approval_history_id = 0

Line 880: UPDATE pqh_ss_value_history

876: IF PsuedoValUpgTrans%NOTFOUND THEN
877: /* Copy values stored for approval_history_id = -1
878: to values stored for approval_history_id = 0 */
879: FOR t in origValUpgTrans LOOP
880: UPDATE pqh_ss_value_history
881: SET VALUE = t.VALUE, ORIGINAL_VALUE = t.ORIGINAL_VALUE
882: WHERE TRANSACTION_VALUE_ID = t.TRANSACTION_VALUE_ID
883: AND APPROVAL_HISTORY_ID = 0;
884: END LOOP;

Line 1042: DELETE pqh_ss_value_history

1038: WHERE TRANSACTION_HISTORY_ID = P_TRANSACTION_ID
1039: and approval_history_id = l_seq_id;
1040:
1041: -- TODO: Delete Value History
1042: DELETE pqh_ss_value_history
1043: WHERE approval_history_id = l_seq_id
1044: and step_history_id in (
1045: SELECT step_history_id
1046: FROM pqh_ss_step_history

Line 1391: INSERT into pqh_ss_value_history (

1387: l_cnt := TxValueTbl.transaction_value_id.count;
1388:
1389: For i in 1 .. l_cnt LOOP
1390:
1391: INSERT into pqh_ss_value_history (
1392: transaction_value_id
1393: ,step_history_id
1394: ,approval_history_id
1395: ,datatype