APPS.PA_PURGE_PUB dependencies on PA_WF_NTF_PERFORMERS

Line 841: -- and pa_wf_ntf_performers

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
845: -- ------------- ------ ---------- ------ ------------- ---------------------------------

Line 903: from pa_wf_ntf_performers ntf

899: WHERE pwp.wf_type_code = 'ASSIGNMENT_APPROVAL'
900: and pwp.item_type = 'PAWFAAP'
901: and not exists
902: (select 'Y'
903: from pa_wf_ntf_performers ntf
904: where ntf.wf_type_code = 'ASSIGNMENT_APPROVAL'
905: and ntf.item_type = pwp.item_type
906: and ntf.item_key = pwp.item_key)
907: AND pwp.item_key NOT IN

Line 934: -- Delete pa_wf_ntf_performers

930:
931: FETCH c_purge_wf_details BULK COLLECT INTO l_wf_item_type_tbl,l_wf_item_key_tbl,l_wf_type_code_tbl LIMIT p_commit_size;
932: EXIT WHEN l_wf_item_type_tbl.COUNT <= 0;
933:
934: -- Delete pa_wf_ntf_performers
935: BEGIN
936:
937: FORALL i IN l_wf_item_type_tbl.FIRST..l_wf_item_type_tbl.LAST
938: DELETE FROM PA_WF_NTF_PERFORMERS

Line 938: DELETE FROM PA_WF_NTF_PERFORMERS

934: -- Delete pa_wf_ntf_performers
935: BEGIN
936:
937: FORALL i IN l_wf_item_type_tbl.FIRST..l_wf_item_type_tbl.LAST
938: DELETE FROM PA_WF_NTF_PERFORMERS
939: WHERE item_key = l_wf_item_key_tbl(i)
940: AND item_type = l_wf_item_type_tbl(i) ;
941: --bug#10238573
942: -- AND wf_type_code = l_wf_type_code_tbl(i);

Line 1022: pa_debug.g_err_stage:= 'No. of rows deleted from pa_wf_ntf_performers ' || l_rows3 ;

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;
1025:
1026:

Line 1061: p_table_name => 'PA_WF_NTF_PERFORMERS',

1057:
1058: PA_PURGE_PUB.INSERT_PURGE_LOG
1059: (
1060: p_request_id => p_request_id ,
1061: p_table_name => 'PA_WF_NTF_PERFORMERS',
1062: p_rows_deleted => l_rows3,
1063: x_return_status => x_return_status ,
1064: x_msg_count => x_msg_count,
1065: x_msg_data => x_msg_data

Line 1079: pa_debug.g_err_stage:= 'Successfully inserted Log details pertaining to PA_WF_NTF_PERFORMERS';

1075: END IF;
1076:
1077:
1078: IF p_debug_mode = 'Y' THEN
1079: pa_debug.g_err_stage:= 'Successfully inserted Log details pertaining to PA_WF_NTF_PERFORMERS';
1080: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1081: pa_debug.g_err_stage:= 'Exiting PURGE_PROJ_WORKFLOW';
1082: pa_debug.write('PA_PURGE_PUB','PA_PURGE_PUB.PURGE_PROJ_WORKFLOW :' || pa_debug.g_err_stage,l_debug_level3);
1083: pa_debug.reset_curr_function;