[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
939: , p_error_text => SUBSTRB(SQLERRM,1,240));
940: EXIT; -- 5201806 : exit the loop after discussion with Anders.
941: END;
942:
943: -- Delete pa_wf_process_details
944: BEGIN
945:
946: FORALL i IN l_wf_item_type_tbl.FIRST..l_wf_item_type_tbl.LAST
947: DELETE FROM pa_wf_process_details
943: -- Delete pa_wf_process_details
944: BEGIN
945:
946: FORALL i IN l_wf_item_type_tbl.FIRST..l_wf_item_type_tbl.LAST
947: DELETE FROM pa_wf_process_details
948: WHERE item_key=l_wf_item_key_tbl(i)
949: AND item_type = l_wf_item_type_tbl(i)
950: AND wf_type_code = l_wf_type_code_tbl(i) ;
951:
997:
998: IF p_debug_mode = 'Y' THEN
999: pa_debug.g_err_stage:= 'No. of rows deleted from pa_wf_processes ' || l_rows1 ;
1000: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1001: pa_debug.g_err_stage:= 'No. of rows deleted from pa_wf_process_details ' || l_rows2 ;
1002: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1003: pa_debug.g_err_stage:= 'No. of rows deleted from pa_wf_ntf_performers ' || l_rows3 ;
1004: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1005: END IF;
1023:
1024: PA_PURGE_PUB.INSERT_PURGE_LOG
1025: (
1026: p_request_id => p_request_id ,
1027: p_table_name => 'PA_WF_PROCESS_DETAILS',
1028: p_rows_deleted => l_rows2,
1029: x_return_status => x_return_status ,
1030: x_msg_count => x_msg_count,
1031: x_msg_data => x_msg_data