[Home] [Help]
836: --
837: -- PROCEDURE
838: -- PURGE_PROJ_WORKFLOW
839: -- PURPOSE
840: -- This API purges unused denormalized workflow data from 3 tables pa_wf_processes , pa_wf_process_details
841: -- and pa_wf_ntf_performers
842: --
843: --
844: -- Parameter Name In/Out Data Type Null? Default Value Description
958: , p_error_text => SUBSTRB(SQLERRM,1,240));
959: EXIT; -- 5201806 : exit the loop after discussion with Anders.
960: END;
961:
962: -- Delete pa_wf_process_details
963: BEGIN
964:
965: FORALL i IN l_wf_item_type_tbl.FIRST..l_wf_item_type_tbl.LAST
966: DELETE FROM pa_wf_process_details
962: -- Delete pa_wf_process_details
963: BEGIN
964:
965: FORALL i IN l_wf_item_type_tbl.FIRST..l_wf_item_type_tbl.LAST
966: DELETE FROM pa_wf_process_details
967: WHERE item_key=l_wf_item_key_tbl(i)
968: AND item_type = l_wf_item_type_tbl(i)
969: AND wf_type_code = l_wf_type_code_tbl(i) ;
970:
1016:
1017: IF p_debug_mode = 'Y' THEN
1018: pa_debug.g_err_stage:= 'No. of rows deleted from pa_wf_processes ' || l_rows1 ;
1019: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1020: pa_debug.g_err_stage:= 'No. of rows deleted from pa_wf_process_details ' || l_rows2 ;
1021: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1022: pa_debug.g_err_stage:= 'No. of rows deleted from pa_wf_ntf_performers ' || l_rows3 ;
1023: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1024: END IF;
1042:
1043: PA_PURGE_PUB.INSERT_PURGE_LOG
1044: (
1045: p_request_id => p_request_id ,
1046: p_table_name => 'PA_WF_PROCESS_DETAILS',
1047: p_rows_deleted => l_rows2,
1048: x_return_status => x_return_status ,
1049: x_msg_count => x_msg_count,
1050: x_msg_data => x_msg_data