[Home] [Help]
257: p_last_update_date in date,
258: p_last_updated_by in number,
259: p_last_update_login in number) is
260: begin
261: insert into pqh_ss_value_history
262: (transaction_value_id ,
263: step_history_id ,
264: approval_history_id ,
265: datatype ,
716: p_last_update_date in date,
717: p_last_updated_by in number,
718: p_last_update_login in number) is
719: begin
720: update pqh_ss_value_history
721: set value = p_value
722: where transaction_value_id = p_transaction_value_id
723: and step_history_id = p_step_history_id
724: and approval_history_id = p_approval_history_id
981: BEGIN
982: --
983: hr_utility.set_location('Entering: copy_value to history -'||p_txnId, 5);
984: --
985: delete from pqh_ss_value_history
986: where approval_history_id = -1
987: and step_history_id in (
988: select step_history_id from pqh_ss_step_history
989: where transaction_history_id = p_txnId
1059: p_last_update_login => r_supStep.last_update_login);
1060:
1061: hr_utility.set_location('insert step history done', 65);
1062:
1063: insert into pqh_ss_value_history (
1064: transaction_value_id ,
1065: step_history_id ,
1066: approval_history_id ,
1067: datatype ,
1294: creation_date,
1295: last_update_date,
1296: last_updated_by,
1297: last_update_login
1298: from pqh_ss_value_history vh
1299: where vh.approval_history_id = -1
1300: and vh.step_history_id = r_supStep_h.step_history_id;
1301:
1302: end loop; -- c_vf_supStep_h