-----------------------------------------------reset PI
insert into psprcsrqst select * from psprcsrqst@db where PRCSINSTANCE = 88888888
insert into PSPRCSPARMS select * from PSPRCSPARMS@db WHERE PRCSINSTANCE = 88888888
update PSPRCSPARMS set PARMLIST='...', ORIGPARMLIST='...' WHERE PRCSINSTANCE = 88888888
UPDATE PS_AERUNCONTROL SET ae_run_data = to_clob('INTFAPAM MAIN Notify INTFAPAM PrcNtfy Step05 ') where PROCESS_INSTANCE=88888888
UPDATE PS_AERUNCONTROL SET ae_run_data = to_clob('INTFAPAM MAIN Notify INTFAPAM PrcNtfy Step06 ') where PROCESS_INSTANCE=88888888
insert into PSPRCSQUE select * from PSPRCSQUE@db where PRCSINSTANCE =88888888
insert into PS_CDM_file_LIST select * from PS_CDM_file_LIST@db where PRCSINSTANCE =88888888
insert into ps_cdm_list select * from ps_cdm_list@db where PRCSINSTANCE =88888888
------------------------------------------------- reassign output folder/content ID
update PS_CDM_file_LIST set CONTENTID=4071614, filename='AP_CRDT_MEMO.pdf', file_size=3570, CDM_FILE_TYPE='PDF'
where PRCSINSTANCE =88888888 and CDM_FILE_TYPE='LOG'
update ps_cdm_list set PRCSOUTPUTDIR='...',OUTPUTDIR='...' where PRCSINSTANCE =88888888
update psprcsrqst set CONTENTID=4071614 where PRCSINSTANCE =88888888
------------------------------------------------- stuck in Posting
update psprcsrqst set DISTSTATUS=4, CONTENTID=4144646 where PRCSINSTANCE = 88888888
update PSPRCSQUE set DISTSTATUS=4 where PRCSINSTANCE = 88888888
insert into PS_CDM_file_list
select 88888888,CONTENTID,'AMPS1000_4648811.log',CDM_FILE_TYPE, 166249,sysdate-1
from PS_CDM_file_list where PRCSINSTANCE =88888888
insert into PS_CDM_list
select 88888888,CONTENTID,PRCSNAME,PRCSTYPE,'XXXXXXXX/log_output/AE_AMPS1000_88888888',
CONTENT_DESCR,OUTDESTFORMAT,RQSTDTTM,ENDDTTM,EXPIRATION_DATE,4,DISTNODENAME,OUTPUTDIR,0,ADMIN_FILENAME,GENPRCSTYPE,
0,FILENAME,PSRF_FOLDER_NAME,PRCSBURSTRPT,MSGNODENAME,CDM_APPROVAL_FLAG,QRYXFORMFILETYPE
from PS_CDM_list where PRCSINSTANCE = 4687995
