APPS.PQH_SS_HISTORY dependencies on PQH_SS_APPROVAL_HISTORY

Line 166: insert into pqh_ss_approval_history (

162: p_orig_system in varchar2 default null,
163: p_orig_system_id in number default null) is
164:
165: begin
166: insert into pqh_ss_approval_history (
167: approval_history_id ,
168: transaction_history_id ,
169: transaction_effective_date ,
170: action ,

Line 537: from pqh_ss_approval_history

533: where transaction_history_id = c_txn_id ;
534: --
535: cursor c_th_appr_h (c_txn_id in number) is
536: select nvl(max(approval_history_id),0)+1 approval_history_id
537: from pqh_ss_approval_history
538: where transaction_history_id = c_txn_id
539: and approval_history_id > 0 ;
540: --
541: cursor c_th_step (c_txn_id in number) is

Line 636: update pqh_ss_approval_history

632: p_orig_system in varchar2 default null,
633: p_orig_system_id in number default null) is
634:
635: begin
636: update pqh_ss_approval_history
637: set transaction_effective_date = p_transaction_effective_date ,
638: user_name = p_user_name,
639: orig_system = p_orig_system,
640: orig_system_id = p_orig_system_id

Line 759: select null from pqh_ss_approval_history

755: l_c VARCHAR2(30) ;
756: l_new_history BOOLEAN := TRUE;
757:
758: cursor c_ov_apr_h (v_transactionId in number)is
759: select null from pqh_ss_approval_history
760: where transaction_history_id = v_transactionId
761: and approval_history_id = 0;
762: --
763: cursor c_ov_txn (c_txn_id in number) is