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 916: -- Delete pa_wf_ntf_performers

912:
913: 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;
914: EXIT WHEN l_wf_item_type_tbl.COUNT <= 0;
915:
916: -- Delete pa_wf_ntf_performers
917: BEGIN
918:
919: FORALL i IN l_wf_item_type_tbl.FIRST..l_wf_item_type_tbl.LAST
920: DELETE FROM PA_WF_NTF_PERFORMERS

Line 920: DELETE FROM PA_WF_NTF_PERFORMERS

916: -- Delete pa_wf_ntf_performers
917: BEGIN
918:
919: FORALL i IN l_wf_item_type_tbl.FIRST..l_wf_item_type_tbl.LAST
920: DELETE FROM PA_WF_NTF_PERFORMERS
921: WHERE item_key = l_wf_item_key_tbl(i)
922: AND item_type = l_wf_item_type_tbl(i)
923: AND wf_type_code = l_wf_type_code_tbl(i);
924:

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

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;
1006:
1007:

Line 1042: p_table_name => 'PA_WF_NTF_PERFORMERS',

1038:
1039: PA_PURGE_PUB.INSERT_PURGE_LOG
1040: (
1041: p_request_id => p_request_id ,
1042: p_table_name => 'PA_WF_NTF_PERFORMERS',
1043: p_rows_deleted => l_rows3,
1044: x_return_status => x_return_status ,
1045: x_msg_count => x_msg_count,
1046: x_msg_data => x_msg_data

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

1056: END IF;
1057:
1058:
1059: IF p_debug_mode = 'Y' THEN
1060: pa_debug.g_err_stage:= 'Successfully inserted Log details pertaining to PA_WF_NTF_PERFORMERS';
1061: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1062: pa_debug.g_err_stage:= 'Exiting PURGE_PROJ_WORKFLOW';
1063: pa_debug.write('PA_PURGE_PUB','PA_PURGE_PUB.PURGE_PROJ_WORKFLOW :' || pa_debug.g_err_stage,l_debug_level3);
1064: pa_debug.reset_curr_function;