APPS.PA_PURGE_PUB dependencies on PJI_SYSTEM_DEBUG_MSG

Line 1655: -- PJI_SYSTEM_DEBUG_MSG

1651: , p_procedure_name => 'PURGE_PJI_DEBUG'
1652: , p_error_text => SUBSTRB(SQLERRM,1,240));
1653: END;
1654:
1655: -- PJI_SYSTEM_DEBUG_MSG
1656: BEGIN
1657: LOOP
1658: DELETE FROM PJI_SYSTEM_DEBUG_MSG WHERE ROWNUM <= p_commit_size;
1659: EXIT WHEN sql%rowcount < p_commit_size;

Line 1658: DELETE FROM PJI_SYSTEM_DEBUG_MSG WHERE ROWNUM <= p_commit_size;

1654:
1655: -- PJI_SYSTEM_DEBUG_MSG
1656: BEGIN
1657: LOOP
1658: DELETE FROM PJI_SYSTEM_DEBUG_MSG WHERE ROWNUM <= p_commit_size;
1659: EXIT WHEN sql%rowcount < p_commit_size;
1660:
1661: l_rows3 := l_rows3 + nvl(sql%rowcount,0);
1662: COMMIT; -- Clear rollback segment

Line 1684: pa_debug.g_err_stage:= 'No. of rows deleted from PJI_SYSTEM_DEBUG_MSG ' || l_rows3 ;

1680: pa_debug.g_err_stage:= 'No. of rows deleted from PJI_FM_EXTR_PLAN_LINES_DEBUG ' || l_rows1 ;
1681: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1682: pa_debug.g_err_stage:= 'No. of rows deleted from PJI_FM_XBS_ACCUM_TMP1_DEBUG ' || l_rows2 ;
1683: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1684: pa_debug.g_err_stage:= 'No. of rows deleted from PJI_SYSTEM_DEBUG_MSG ' || l_rows3 ;
1685: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1686: END IF;
1687:
1688: PA_PURGE_PUB.INSERT_PURGE_LOG

Line 1719: p_table_name => 'PJI_SYSTEM_DEBUG_MSG',

1715:
1716: PA_PURGE_PUB.INSERT_PURGE_LOG
1717: (
1718: p_request_id => p_request_id ,
1719: p_table_name => 'PJI_SYSTEM_DEBUG_MSG',
1720: p_rows_deleted => l_rows3,
1721: x_return_status => x_return_status ,
1722: x_msg_count => x_msg_count,
1723: x_msg_data => x_msg_data