APPS.PA_PURGE_PUB dependencies on PA_WF_PROCESSES

Line 840: -- This API purges unused denormalized workflow data from 3 tables pa_wf_processes , pa_wf_process_details

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

Line 887: FROM pa_wf_processes a

883: l_local_error_flag VARCHAR2(1) :='N'; -- 5201806
884:
885: CURSOR c_purge_wf_details IS
886: SELECT a.item_type, a.item_key, a.wf_type_code
887: FROM pa_wf_processes a
888: WHERE
889: a.item_type in ('PACANDID','PACOPR','PARADVWF','PARAPTEM','PARFIGEN','PAROVCNT','PAWFGPF','PAYPRJNT','PARMATRX','PAXWFHRU')
890: AND a.item_key NOT IN
891: (SELECT wi.item_key

Line 898: FROM pa_wf_processes pwp

894: )
895: --bug#10238573 start
896: UNION
897: SELECT item_type, item_key, wf_type_code
898: FROM pa_wf_processes pwp
899: WHERE pwp.wf_type_code = 'ASSIGNMENT_APPROVAL'
900: and pwp.item_type = 'PAWFAAP'
901: and not exists
902: (select 'Y'

Line 989: -- Delete pa_wf_processes

985: , p_error_text => SUBSTRB(SQLERRM,1,240));
986: EXIT; -- 5201806 : exit the loop after discussion with Anders.
987: END;
988:
989: -- Delete pa_wf_processes
990: BEGIN
991: FORALL i IN l_wf_item_type_tbl.FIRST..l_wf_item_type_tbl.LAST
992: DELETE FROM pa_wf_processes
993: WHERE item_key=l_wf_item_key_tbl(i)

Line 992: DELETE FROM pa_wf_processes

988:
989: -- Delete pa_wf_processes
990: BEGIN
991: FORALL i IN l_wf_item_type_tbl.FIRST..l_wf_item_type_tbl.LAST
992: DELETE FROM pa_wf_processes
993: WHERE item_key=l_wf_item_key_tbl(i)
994: AND item_type = l_wf_item_type_tbl(i)
995: AND wf_type_code = l_wf_type_code_tbl(i);
996:

Line 1018: pa_debug.g_err_stage:= 'No. of rows deleted from pa_wf_processes ' || l_rows1 ;

1014: END LOOP;
1015: CLOSE c_purge_wf_details;
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 ;

Line 1030: p_table_name => 'PA_WF_PROCESSES' ,

1026:
1027: PA_PURGE_PUB.INSERT_PURGE_LOG
1028: (
1029: p_request_id => p_request_id ,
1030: p_table_name => 'PA_WF_PROCESSES' ,
1031: p_rows_deleted => l_rows1 ,
1032: x_return_status => x_return_status ,
1033: x_msg_count => x_msg_count,
1034: x_msg_data => x_msg_data